I created a new database table using pgAdmin III,
then I created a New ADempiere Table in the window 'Application Dictionary -> Table And Column'
but, the action "create columns from db" didn't work for me, it didn't create anything in tab 'Columns'
In the Terminal, there was some message, but I had my PC rebooted, and this message didn't appear again (sorry, but I couldn’t copy the message).
when I press 'create collumns from db', a window appears:
"create a dictionary columns of table not existing as a Column but in the database.
if you have added columns in the database to this table, this procedure creates the columns records in the dictionary. Please be aware, that the may deleted, if the entity types is not set to user."
so I select 'other extensions' and press 'ok'
but nothing happens, not an error, no column generated...
ADempiere 3.1.4 with Postgres and Suse 10.2
Thanks...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I created the related elements (Window Element, in Application Dictionary) of the columns db table, with the same names,
and I tried to 'create columns from db', but nothing happened, again...
Thanks,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
i try it without creating element first, and it works. But i'was using compiere with fyracle with this sql :
create table XX_Material(xx_material_id numeric(10,0) not null,
matnr integer,
colornr integer,
name varchar(100),
nameshort varchar(100),
AD_Client_ID numeric(10,0) not null,
AD_Org_ID numeric(10,0) not null,
IsActive char(1) default 'Y',
created date default current_timestamp,
createdby numeric(10,0) not null,
updated date default current_timestamp,
updatedby numeric(10,0) not null);
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
In the console where I started the ADempiere Client appeared;
-----------> RecordInfo.addLine: U->XX [11]
java.lang.NumberFormatException: For input string: "U"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.<init>(Unknown Source)
at org.compiere.apps.RecordInfo.addLine(RecordInfo.java:309)
at org.compiere.apps.RecordInfo.dynInit(RecordInfo.java:186)
at org.compiere.apps.RecordInfo.<init>(RecordInfo.java:51)
at org.compiere.apps.StatusBar.mouseClicked(StatusBar.java:227)
at org.compiere.apps.StatusBar_mouseAdapter.mouseClicked(StatusBar.java:256)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I can't be exactly sure with your problem but I'm thinking that you can have some dictionary error.
I think it must be related with column entity type that is being treated as an ID instead as a List. Maybe is a reproducible error, haven't tested yet.
I think you can workaround this error deleting all records in table AD_ChangeLog (obviously in case you don't need the info stored there).
But I think it can be a bug, just that I don't know how to reproduce it.
If you try with a clean installation, it will be good if you provide step by step test case to reproduce the failure.
do you get any warnings/errors? Did you save the new ADempiere table before you pressed the button? And some general infos (ADempiere version/DB/Java and maybe SQL editor) would be useful. It shouldn't be a general problem because this core functionality is used thousands of times by the community so I guess you are just missing a step..
Best regards,
Karsten
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am using Adempiere 3, Oracle 10g xe, Java 1.5.
I am running the SQL command through "Run SQL command line". I am being able to create a table and then I press the button "Create collumns from DB".
Then I go to column option and create a new collumns and press the "Synchronize collumn" as this is not automatically generated.
I am also not able to get "Table Translation" and "Column Translation" Tabs.
I would also like to have your advice on the following:
I am not getting all modules access even though I login as SysAdmin ?
How do i assign rights to Add/Modify / Delete all menu options ?
If I want to add in Invoice Window , an additional field called Subsidiary Company Code ,and I also want to create a separate table for subsidiary company master with two field subsidiary company code & Name.
Thanking u once AGAIN.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
>I am running the SQL command through "Run SQL command line".
Are you sure that the table is created correctly? Maybe you need to commit the changes first. Can you insert new data into your table via sql? I would suggest to use a sql editor..
I use the Oracle SQL Developer (it's free but you have to register), you can find it here: http://www.oracle.com/technology/products/database/sql_developer/index.html
Regards,
Karsten
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can u help me in following this step.
Do I really need to make changes in the code?
AS of now when I try to search for org.compiere.util.GenerateModel I do not get any result.
Thanks once again for your prompt reply.
Regards,
George.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
RA layer request failed
svn: PROPFIND request failed on '/svnroot/adempiere'
svn: PROPFIND of '/svnroot/adempiere': could not connect to server (https://adempiere.svn.sourceforge.net)
Thanking u once AGAIN.
Regards,
George.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm using the same url and it works for me - but I'm using tortoise and not subclipse (but I know that many developers are using subclipse so this shouldn't be a general problem). Maybe sourceforge had a problem - sometimes my connection times out. So I would suggest to try again or choose a different plugin.
Hope that helps..
Regards,
Karsten
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have tried it many times but never succedded. I dont know what's wrong with it. I have mailed u the screenshots with the Subject as "Unable TO get SOurce Code" Can please just have a look at it and let me know if I am going wrong somewhere.
my mailid is george.maliakal@tces.co.in
Is it possible for you to send me the code of PosteritaAdempiere in a Zip format
Thanking you
george
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I didn't receive the screenshots (yet) can you send them to kt(at)schaeffer-ag(dot)de? And can you check that you can reach the url just by testing it with your browser?
Regards,
Karsten
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sucess at last
The problem was that I was accessing the Internet through a Proxy Server.
Due to this I was getting PROPFIND Error.
A PROPFIND error indicates that you are accessing internet through a Proxy Server.
The Proxy Server Usually blocks various protocols by default such as :
PROPFIND, REPORT, MERGE, MKACTIVITY, CHECKOUT.
As of now when I am accessing through a direct net connection I am able to get the source code.
Regards,
George.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As per the help ,http://www.adempiere.com/wiki/index.php/NewWindow
I understand that unless one creates PO class for XX_Material , I will not be able to add / modify , delete records for my XX_Material table
I created a window , and fields within the window , without creating a PO class I am still able to add / modify / delete the record in table through my window
What I want to do now is My Windows does have three fields
i.e. Qty , Rate & Value I wish to calculate Value = Qty * Rate Please guide how to do the same in adempiere
This calculation is just for an example , however I need to do lot of complex businss logic calculations in real life so please provide help / assitance with that perspective.
Best Regards,
George
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
>I will not be able to add / modify , delete records for my XX_Material table
no - generally you should be able to do this without but sometimes there can be problems without the X_* classes (I know this is vague ...).
Hi,
I'm trying to create a new window following the steps;
http://www.adempiere.com/wiki/index.php/NewWindow
I created a new database table using pgAdmin III,
then I created a New ADempiere Table in the window 'Application Dictionary -> Table And Column'
but, the action "create columns from db" didn't work for me, it didn't create anything in tab 'Columns'
In the Terminal, there was some message, but I had my PC rebooted, and this message didn't appear again (sorry, but I couldn’t copy the message).
when I press 'create collumns from db', a window appears:
"create a dictionary columns of table not existing as a Column but in the database.
if you have added columns in the database to this table, this procedure creates the columns records in the dictionary. Please be aware, that the may deleted, if the entity types is not set to user."
so I select 'other extensions' and press 'ok'
but nothing happens, not an error, no column generated...
ADempiere 3.1.4 with Postgres and Suse 10.2
Thanks...
CMIIW, I think you should create element first....
Hi,
I created the related elements (Window Element, in Application Dictionary) of the columns db table, with the same names,
and I tried to 'create columns from db', but nothing happened, again...
Thanks,
i try it without creating element first, and it works. But i'was using compiere with fyracle with this sql :
create table XX_Material(xx_material_id numeric(10,0) not null,
matnr integer,
colornr integer,
name varchar(100),
nameshort varchar(100),
AD_Client_ID numeric(10,0) not null,
AD_Org_ID numeric(10,0) not null,
IsActive char(1) default 'Y',
created date default current_timestamp,
createdby numeric(10,0) not null,
updated date default current_timestamp,
updatedby numeric(10,0) not null);
Hi Pandjie,
Thanks a lot,
I'll update my adempiere to Adempiere 3.1.5 and I'll try again...
[]'s
Could it be a bug using ADempiere with postgres?
> Could it be a bug using ADempiere with postgres?
> In the Terminal, there was some message, but I had my PC rebooted,
> and this message didn't appear again (sorry, but I couldn’t copy the message).
Alberjoe, the easy way is if you put here the output on the console log.
Regards,
Carlos Ruiz - globalqss
http://globalqss.com
In the console where I started the ADempiere Client appeared;
-----------> RecordInfo.addLine: U->XX [11]
java.lang.NumberFormatException: For input string: "U"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.<init>(Unknown Source)
at org.compiere.apps.RecordInfo.addLine(RecordInfo.java:309)
at org.compiere.apps.RecordInfo.dynInit(RecordInfo.java:186)
at org.compiere.apps.RecordInfo.<init>(RecordInfo.java:51)
at org.compiere.apps.StatusBar.mouseClicked(StatusBar.java:227)
at org.compiere.apps.StatusBar_mouseAdapter.mouseClicked(StatusBar.java:256)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
Hi Alberjoe, definitely it's better with log.
I can't be exactly sure with your problem but I'm thinking that you can have some dictionary error.
I think it must be related with column entity type that is being treated as an ID instead as a List. Maybe is a reproducible error, haven't tested yet.
I think you can workaround this error deleting all records in table AD_ChangeLog (obviously in case you don't need the info stored there).
But I think it can be a bug, just that I don't know how to reproduce it.
If you try with a clean installation, it will be good if you provide step by step test case to reproduce the failure.
Regards,
Carlos Ruiz - globalqss
http://globalqss.com
I have followed the following step for creating a window:
http://www.adempiere.com/wiki/index.php/NewWindow
I have succeded in creating a table through SQL and even created a new table in Adempiere named XX_Material.
After completion of the above step. When I press the button "Create Columns from DB", as this is the next step,
It does not proceed to the next step:
Can anyone PLEASE HELP Me Out by giving a detailed procedure as how to proceed ahead in this matter.
I would also like to know how to customize i.e, add or remove fields from an existing Window or Table
Hi George,
do you get any warnings/errors? Did you save the new ADempiere table before you pressed the button? And some general infos (ADempiere version/DB/Java and maybe SQL editor) would be useful. It shouldn't be a general problem because this core functionality is used thousands of times by the community so I guess you are just missing a step..
Best regards,
Karsten
Thank You for your reply.
I am using Adempiere 3, Oracle 10g xe, Java 1.5.
I am running the SQL command through "Run SQL command line". I am being able to create a table and then I press the button "Create collumns from DB".
Then I go to column option and create a new collumns and press the "Synchronize collumn" as this is not automatically generated.
I am also not able to get "Table Translation" and "Column Translation" Tabs.
I would also like to have your advice on the following:
I am not getting all modules access even though I login as SysAdmin ?
How do i assign rights to Add/Modify / Delete all menu options ?
If I want to add in Invoice Window , an additional field called Subsidiary Company Code ,and I also want to create a separate table for subsidiary company master with two field subsidiary company code & Name.
Thanking u once AGAIN.
Hi,
>I am running the SQL command through "Run SQL command line".
Are you sure that the table is created correctly? Maybe you need to commit the changes first. Can you insert new data into your table via sql? I would suggest to use a sql editor..
I use the Oracle SQL Developer (it's free but you have to register), you can find it here:
http://www.oracle.com/technology/products/database/sql_developer/index.html
Regards,
Karsten
Thanks Karsten that was great... It Worked!
As of now I am able to successfully able to create the table and even view the automatically created Columns.
Now the next step would be to Generate Model i.e.
Use the class org.compiere.util.GenerateModel to generate a PO-class for new created tables. It should create a class X_XX_Material.java.
http://www.adempiere.com/wiki/index.php/NewWindow#Generate_Model
Can u help me in following this step.
Do I really need to make changes in the code?
AS of now when I try to search for org.compiere.util.GenerateModel I do not get any result.
Thanks once again for your prompt reply.
Regards,
George.
Hi George,
the class org.compiere.util.GenerateModel is renamed to org.adempiere.util.GenerateModel starting from version 3.3 and above. Do you use eclipse?
Regards,
Karsten
Hi Krasten,
thanks for your Reply
As of now I am trying to get the source code for adempiere by following instruction from the below given site. I am doing so through "Eclipse" via " SVN Repository "
http://www.adempiere.com/wiki/index.php/Create_your_ADempiere_development_environment#Download_ADempiere_sources
However when i type in the URL
https://adempiere.svn.sourceforge.net/svnroot/adempiere
The Subclipse operation progess and after sometimes gives the following Error
RA layer request failed
svn: PROPFIND request failed on '/svnroot/adempiere'
svn: PROPFIND of '/svnroot/adempiere': could not connect to server (https://adempiere.svn.sourceforge.net)
Thanking u once AGAIN.
Regards,
George.
Hi George,
I'm using the same url and it works for me - but I'm using tortoise and not subclipse (but I know that many developers are using subclipse so this shouldn't be a general problem). Maybe sourceforge had a problem - sometimes my connection times out. So I would suggest to try again or choose a different plugin.
Hope that helps..
Regards,
Karsten
Hi,
I get those errors sometimes too! Just rerun the update on the same project again to finish the download.
Regards, DAniel
Hi Karsten,
I have tried it many times but never succedded. I dont know what's wrong with it. I have mailed u the screenshots with the Subject as "Unable TO get SOurce Code" Can please just have a look at it and let me know if I am going wrong somewhere.
my mailid is george.maliakal@tces.co.in
Is it possible for you to send me the code of PosteritaAdempiere in a Zip format
Thanking you
george
Hi George,
I didn't receive the screenshots (yet) can you send them to kt(at)schaeffer-ag(dot)de? And can you check that you can reach the url just by testing it with your browser?
Regards,
Karsten
Hi Karsten,
I have sent you the mail on the id which you have mentioned above. Hope u have received it this time.
Regards,
George.
Hi Karsten,
If possible send me the reply on george.maliakal@tces.co.in as well as maliakal.george@gmail.com
Thank You. Waiting for your mail
Regards,
George
Sucess at last
The problem was that I was accessing the Internet through a Proxy Server.
Due to this I was getting PROPFIND Error.
A PROPFIND error indicates that you are accessing internet through a Proxy Server.
The Proxy Server Usually blocks various protocols by default such as :
PROPFIND, REPORT, MERGE, MKACTIVITY, CHECKOUT.
As of now when I am accessing through a direct net connection I am able to get the source code.
Regards,
George.
As per the help ,http://www.adempiere.com/wiki/index.php/NewWindow
I understand that unless one creates PO class for XX_Material , I will not be able to add / modify , delete records for my XX_Material table
I created a window , and fields within the window , without creating a PO class I am still able to add / modify / delete the record in table through my window
What I want to do now is My Windows does have three fields
i.e. Qty , Rate & Value I wish to calculate Value = Qty * Rate Please guide how to do the same in adempiere
This calculation is just for an example , however I need to do lot of complex businss logic calculations in real life so please provide help / assitance with that perspective.
Best Regards,
George
Hi,
>I will not be able to add / modify , delete records for my XX_Material table
no - generally you should be able to do this without but sometimes there can be problems without the X_* classes (I know this is vague ...).
For the calculations see here: http://www.adempiere.com/wiki/index.php/DevGuide_When_to_use
If you need/want to see the result immediately for every change of a field you'll use callouts.
Regards,
Karsten