how to duplicate or copy a client

[Martin Jordana]

Hi,

 Im new whit idempiere

I've set up a server, created a DB, set up a client, organizations COA, clients, productos and others

before starting to input transactions data I would like to create a test duplicate for the client and setup in order to have a test/learning client where to mess around and a production client in the same server

Been looking around but coudn't figure out how to. Is my approach correct or should I do something else? If it is correct how o where can i find guidance?

thanks

martin

[Luis Amesty]

Hello Martin

The most recommended is to have a Production Database and a Development Database.

This way you can develop the changes in the Development Database and when you have them cleaned, you pass them to Production through the use of pack-out pack-in.

For example you can call one idempiere4.1pro and the other idempiere4.1dev

If you work in an Eclipse environment you can define several Run_Time.

If you work in Normal environment, you must run setup.sh every time you change the database.

or

You can also do it very easily by editing the Idempiere Configuration file

idempiere.properties  (Example)

ValidateConnectionOnStartup=xyzN

AutoNew=xyzN

Connection=xyzCConnection[name\=localhost{localhost-idempiere4.1pro-adempiere},AppsHost\=localhost,WebPort\=8080,SSLPort\=8443,type\=PostgreSQL,DBhost\=localhost,DBport\=5434,DBname\=idempiere4.1pro,BQ\=false,FW\=false,FWhost\=,FWport\=0,UID\=adempiere,PWD\=adempiere]

UITheme=xyzAdempiere Theme

AutoCommit=xyzY

ShowAcct=xyzY

There you can change the data, that setup.sh places on file, with any editor.

I hope it helps you

regards

Luis Amesty

[Anozi Mada]

I'm not sure with the other but I personally will just create another instance of idempiere with different port and duplicate the database. Make sure to disable mail server in the copied database so you don't get email from test server, unless you want to actually test the mail server.

Regards,
Anozi Mada

[Luis Amesty]

Hi Anozi

Do you have experience with two instances or more on a production server. ?

I make this question in order to have separate clients with separate Databases on a same server.

Thanks 

Luis Amesty   

[Anozi Mada]

Yes, it's a bit tricky back then in ADempiere (requiring changing jboss configuration after every setup) but you can do that in iDempiere without additional step now. Just make sure you use different port.

[Martin Jordana]

Thanks for the tips, 

Finally I implemeted 2 sesions with diferent databases, in the same server

And I'm using pack-out and pack-in to trasfer upgrades

but I'm afraid that to copy a entire client masterdata (CAO, parthners, products, ect) it's adding one by one table and data to the packout. and i'm afraid of not including something just by error or by ignorance (most probably in my case) 

Is there any 2pack scrip or other solution more like 1 step proceses/more foolproof to achieve this

I'll prefer not to copy the entire DB, because it will include all the clients and not just 1 in particular 

regards

Martin

[KSR Krishna]

Hi,

I have created a new iDempiere server and planning to move a client (instead of using initial client setup process) from old server to new server.
Please let me know if you did find a way to copy entire client master data (COA, partners, products, etc. ) 

regards,

Krishna.

[Carlos Antonio Ruiz Gomez]

Hi, I added this to core recently:

http://wiki.idempiere.org/en/NF6.2_Copy_Client

Regards,

Carlos Ruiz

El 19/12/18 a las 19:43, KSR Krishna escribió: