Hi Victor, I reviewed and fixed some bugs in the migration scripts:
1 - In Oracle TO_TIMESTAMP is not valid, please use TO_DATE, the date format is also different
2 - The ad_process must be inserted before the ad_menu to avoid foreign key error
3 - Please don't use schema prefix "adempiere." - people can have installation with another schema
Now one question:
What's the goal of the section updating ad_process_access ?
a) Is it intended to update created permissions for the new process ('Setup Web POS' -> 53002) ??
If this is the intention - then you need to do insert's instead of update's - because they are not created by default.
OR
b) Is it intended to update the previous permission records for the process ('Update Role Menu' -> 52003)?
Or is this a typo error writing 52003 instead of 53002?
Cordially,
Carlos Ruiz
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank a lot your comment you are in right, I review with more detail when will commit sql script.
Dear community!
Now is possible to Setup Posterita POS from Adempiere with exist client, the reason to create this process is because before only can setup a Posterita POS create a new client
you need create a new user and role (ie POS) next you need run Setup Web POS process and fill all the parameter, this process setup the necessary to a POS from exist client.
Hi Victor, I've a problem with the SetupWebPOS process: when it looks at the charge table at line 266 the query asks for isDefault='Y', but there is no such column in my schema (I imported the dump of v330 and applied all the migration script of 330-trunk folder). I don't know if is my mistake or there is a missing alter table on the migration scripts.
Also I think there is a bug at line 283, maybe you should remove the statement
com.setC_Charge_ID( chargeIds[0]);
because is redundant and if the test "if(chargeIds.length<1)" is true this will lead to an error.
One final question, is the Web POS already configured for Gardenworld? I tried to login with different users, the only one that works is SuperUser but after loggin in the menu is empty.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=332830
Originator: YES
Revision: 3655
http://adempiere.svn.sourceforge.net/adempiere/?rev=3655&view=rev
Revision: 3656
http://adempiere.svn.sourceforge.net/adempiere/?rev=3656&view=rev
kind regards
Victor Perez
www.e-evolution.com
Logged In: YES
user_id=1180760
Originator: NO
Hi Victor, I reviewed and fixed some bugs in the migration scripts:
1 - In Oracle TO_TIMESTAMP is not valid, please use TO_DATE, the date format is also different
2 - The ad_process must be inserted before the ad_menu to avoid foreign key error
3 - Please don't use schema prefix "adempiere." - people can have installation with another schema
Now one question:
What's the goal of the section updating ad_process_access ?
a) Is it intended to update created permissions for the new process ('Setup Web POS' -> 53002) ??
If this is the intention - then you need to do insert's instead of update's - because they are not created by default.
OR
b) Is it intended to update the previous permission records for the process ('Update Role Menu' -> 52003)?
Or is this a typo error writing 52003 instead of 53002?
Cordially,
Carlos Ruiz
Logged In: YES
user_id=332830
Originator: YES
Hi Carlos!
Thank a lot your comment you are in right, I review with more detail when will commit sql script.
Dear community!
Now is possible to Setup Posterita POS from Adempiere with exist client, the reason to create this process is because before only can setup a Posterita POS create a new client
you need create a new user and role (ie POS) next you need run Setup Web POS process and fill all the parameter, this process setup the necessary to a POS from exist client.
http://adempiere.svn.sourceforge.net/viewvc/adempiere?view=rev&revision=3669
kind regards
Victor Perez
www.e-evolution.com
Logged In: YES
user_id=1405608
Originator: NO
Hi Victor, I've a problem with the SetupWebPOS process: when it looks at the charge table at line 266 the query asks for isDefault='Y', but there is no such column in my schema (I imported the dump of v330 and applied all the migration script of 330-trunk folder). I don't know if is my mistake or there is a missing alter table on the migration scripts.
Also I think there is a bug at line 283, maybe you should remove the statement
com.setC_Charge_ID( chargeIds[0]);
because is redundant and if the test "if(chargeIds.length<1)" is true this will lead to an error.
One final question, is the Web POS already configured for Gardenworld? I tried to login with different users, the only one that works is SuperUser but after loggin in the menu is empty.
Logged In: YES
user_id=332830
Originator: YES
Hi genied!
I sorry , i had pending a commit , now should are work
Committed revision 3685.
http://adempiere.svn.sourceforge.net/viewvc/adempiere?view=rev&revision=3685
>>is the Web POS already configured for Gardenworld?
No current do not is configure, it is the reason because i created this process ;-)
kind regars
Victor Perez
www.e-evolution.com
Logged In: YES
user_id=867558
Originator: NO
Same note - for review and pending status by committer or maintainer