Menu

Synchronize Column Error & others...>>

2007-02-01
2013-03-08
  • Igor Almeida

    Igor Almeida - 2007-02-01

    Hi,

    I'm trying to follow JasperReport integration references which actually use Compiere references (Compiere_with_JasperReport.pdf). When I tried to add the column JasperReport in "Table and Column", I filled and saved the register, but when I hit "Synchronize Column" button it keeps loading forever. >[ After that, all I can do is close Adempiere abruptly.

    Anyway, I tried to add a field in "Window, Tab & Column", but in the "Column" field the column "JasperReport" that I supposedly created before didn't appear. So, I couldn't choose it and obviously I couldn't complete this step.

    Could anyone help me?
    Thanks in advance,

    Igor Almeida

     
    • Teo Sarca

      Teo Sarca - 2007-02-01

      Hi,

      Which version Adempiere do you use ? Is from trunk ?

      Best regards,
      Teo Sarca

       
    • Alejandro Falcone

      Hi Igor,

      If the "Synchronize Column" process not finish ok, then the column don't be created, so after you don't have the column to be added into the "Window,Tab & Column".

      Please take a look into the log for any error or what's happend when you run the process.

      What Adempiere version and DB are you using?

      You can take a look into http://adempiere.com/wiki/index.php/ADempiere/Compiere_JasperReports_Integration_HowTo too.

      Regards,

      Alejandro

       
    • Igor Almeida

      Igor Almeida - 2007-02-01

      OS: Linux/Kurumin (based on Debian)
      Adempiere Version: 3.1.3
      DB: PostgreSQL8.1

      I'm already using the wiki reference. About creating the column, when I make a SQL Query in table "ad_column" I receive as result the JasperReport register. But, it doesn't appear in the  field "column" at the mentioned form anyway.

      For this JasperReport integration, do I need to build Adempiere from source? Before those steps?

      I'm in need of a solution to generate Reports made in iReport.

      Igor Almeida

       
      • Trifon (An ADempiere founder)

        Hi,

        >For this JasperReport integration, do I need to build Adempiere from source? Before those steps?

        Yes.
        JasperReports integration will be available in 3.1.4 binary version.

        Kind regards,
        Trifon

         
    • Igor Almeida

      Igor Almeida - 2007-02-01

      When will 3.1.4 version be available? Will I be able to make my own reports using iReport and easily use it on Adempiere?

      I need it so much!

      Igor Almeida

       
      • Alejandro Falcone

        Hi Igor,

        I believe we will have the 3.1.4 version in some few days.

        If you is enable to build ADempiere from source, then you can download the sources from trunk and then you will have the integration done after build. Please remember to run the sql scripts too (under _Project-ID-ADempiere\sqls_3.1.3\).

        Regards,

        Alejandro

         
    • Igor Almeida

      Igor Almeida - 2007-02-01

      Please, could anyone give a suggestion about it? I have to finish a work 'till friday.

      Thanks,

      Igor Almeida

       
    • Igor Almeida

      Igor Almeida - 2007-02-01

      OK. Reminding the first message of this topic, what is the cause of "Synchronize Column" error? Will Adempiere 3.1.4 solve it?

      About build from source, could you please list all folders I'm gonna need to build Adempiere? I accessed the link http://adempiere.svn.sourceforge.net/viewvc/adempiere/ to check SVN Repository, and it just has so many files, and they sometimes look the same.

      You mentioned "trunk" folder. Do I need to download it full? including all the files/folders listed below? What is important from this list?

      SVN REPOSITORY: /TRUNK (32 folders and 3 files)

      JasperReports/
      JasperReportsTools/
      JasperReportsWebApp/
      _Project-ID-ADempiere/
      _Project-ID-AdempiereJasper/
      base/
      client/
      data/
      db/
      dbPort/
      derby/
      doc/
      extend/
      install/
      interfaces/
      jboss/
      launch/
      lib/
      looks/
      migration/
      nbproject/
      packages/
      print/
      serverApps/
      serverRoot/
      sqlj/
      tools/
      utils/
      utils_dev/
      webCM/
      webStore/
      .classpath
      .project
      license.html

       
    • Alejandro Falcone

      Hi Igor,

      Yes, you need download all files and folders. I suggest you use a SVN client (such as TortoiseSVN as example).
      You can take a look into https://sourceforge.net/svn/?group_id=176962

      Best regards,

      Alejandro

       
    • Igor Almeida

      Igor Almeida - 2007-02-01

      I can only put all those files in a Adempiere project in Eclipse and build or do I need to set something else?

       
      • Alejandro Falcone

        Hi Igor,

        You should build the application out of Eclipse.

        After download all files, copy the myDevEnvTemplate.[bat|sh] file (into the utils_dev directory) as myDevEnv.[bat|sh] and edit the file in order to set the parameters (Java_Home, Adempiere_Source, Adempiere_Home and Adempiere_Install as you need).

        After this, you need to start full build: utils_dev/RUN_build.[bat|sh].
        Once the build finish, please verify the build successful; you would see something as:

        complete:

        BUILD SUCCESSFUL
        Total time: xx minutes x seconds

        If the build was successful then you have the new Adempiere version.

        Best regards,

        Alejandro

         
    • Igor Almeida

      Igor Almeida - 2007-02-02

      Do I place all those listed files and folder in a unique project called "trunk"?

       
    • Igor Almeida

      Igor Almeida - 2007-02-05

      Build successful! [finally some good news].

      And now? How could I enjoy JasperReport functionality? Where are the main improvements?

       
    • Igor Almeida

      Igor Almeida - 2007-02-05

      After build it successfully 3.1.4 version, I received this error starting Adempiere Client:

      Exception in thread "main" java.lang.NullPointerException
              at org.compiere.util.Splash$CImage.getPreferredSize(Splash.java:213)
              at java.awt.GridBagLayout.GetLayoutInfo(GridBagLayout.java:911)
              at java.awt.GridBagLayout.getLayoutInfo(GridBagLayout.java:816)
              at java.awt.GridBagLayout.preferredLayoutSize(GridBagLayout.java:636)
              at java.awt.Container.preferredSize(Container.java:1558)
              at java.awt.Container.getPreferredSize(Container.java:1543)
              at java.awt.BorderLayout.preferredLayoutSize(BorderLayout.java:680)
              at java.awt.Container.preferredSize(Container.java:1558)
              at java.awt.Container.getPreferredSize(Container.java:1543)
              at java.awt.Window.pack(Window.java:478)
              at org.compiere.util.Splash.display(Splash.java:161)
              at org.compiere.util.Splash.<init>(Splash.java:87)
              at org.compiere.util.Splash.getSplash(Splash.java:62)
              at org.compiere.util.Splash.getSplash(Splash.java:51)
              at org.compiere.Adempiere.main(Adempiere.java:538)

      Ideas?

       
      • Teo Sarca

        Teo Sarca - 2007-02-05

        Hello,

        > Exception in thread "main" java.lang.NullPointerException
        > at org.compiere.util.Splash$CImage.getPreferredSize(Splash.java:213)
        ...looks like some images are missing in client/src/org/compiere/images

        Are you sure you checked out whole trunk ?

        About your previous question:
        > You mentioned "trunk" folder. Do I need to download it full? including all the files/folders listed below? What is important from this list?

        All is important. Please download all.

        Best regards,
        Teo Sarca

         
    • Igor Almeida

      Igor Almeida - 2007-02-05

      I downloaded them all. I spent a whole day.

      And the build was successful. Doesn't it mean that I have every file?

      Originally, my folder 'trunk' had:
      Size: 307,8 MB (322.788.017)
      Number of files: 9998 (1225 sub-folders)

      After build:
      Size: 825,5 MB (865.643.341)
      Number of files: 26861 (2362 sub-folders)

      Is that right?

       
    • Igor Almeida

      Igor Almeida - 2007-02-05

      Directory client/src/org/compiere/images:

      Size: 1,8 MB (1.917.396)
      Number of files: 772 (8 sub-folders)

      Is it ok?

       
    • Alejandro Falcone

      Hi Igor,

      After build please run the RUN_Setup.[bat|sh] script.

      Regards,

      Alejandro

       
    • Igor Almeida

      Igor Almeida - 2007-02-05

      Done.

       
    • Igor Almeida

      Igor Almeida - 2007-02-05

      And now? [sorry for a new post just for this]

       
    • Igor Almeida

      Igor Almeida - 2007-02-05

      Thanks for your help Alejandro, but I'm still getting that Image error! >[

      Any ideas?

       
    • Igor Almeida

      Igor Almeida - 2007-02-08

      Please. I really need help with it. Could anyone that have build Adempiere 3.1.4 from source upload a functional "Adempiere 3.1.4.tar.gz" and send me the link?

      is_almeida@yahoo.com.br.. I'm in need of JasperReport Integration.

      Really really need it! =S

       
    • Alejandro Falcone

      Hi Igor,

      You can download ADempiere 3.1.4 (yesterday was released) under download page:
      http://sourceforge.net/project/showfiles.php?group_id=176962

      Regards,

      Alejandro

       

Log in to post a comment.