Creating an iDempiere Demo System for your Customers

The purpose of this page is to help you create a demo iDempiere system that is easy to deploy.

Sample Data

There are times when you need demo a system that has real data in it. Here is a script that will both change the client name and details as well as change the Business Partner and contact names with sample data. Here is the script. Here are the things to consider:

Ensure you only run this script against a text environment (NOT PRODUCTION!)
Update the functions at the beginning of the script to change the 'ChangeMe' details to reflect your desired sample company name.
Delete the SQL lines at the bottom of the file if you do not wish to update BP and User names.
Here is the spreadsheet that I used to create the sample data. There are times you need more than 10K names. It will not be hard to update the sheet to include more boys and girls names. Just google popular names, and you will get 1000's. You can also google popular last names as well to get more than 100.

Using AWS

Create an AWS ubuntu instance
Install iDempiere
Create a new client with sample data or update GardenWorld as you wish. I recommend creating a new client to give you more control.
Re-run the /opt/idempiere-server/console-setup.sh and update the "Application Server Host Name:" prompt to be 0.0.0.0. This will prevent you from needing to change it on future machines. NOTE: be aware that doing so also opens iDempiere Monitor to everyone - not just localhost. This is a security risk if you have port 8443 open to the public.
Add a startup script(s) to make sure the machine is correct every time is launched or rebooted by adding "@reboot /path/to/script/somescript.sh" to your cron list.
1. Update /etc/hosts file with current hostname using: sudo sed -i '/127.0.0.1 ip-/c\127.0.0.1 '"$HOSTNAME" /etc/hosts
2. Update AWS' DNS service (Route 53) to know the IP/Name of your newly created instance.
3. Execute a SQL script to update the sample data to represent more customer specific details (i.e. like company name, product names, etc...)
4. Reboot to test startup scripts
In the AWS Console, right-click on your newly AWS instance and create an image (AMI). Save this AMI with the name "iDempiere Demo Template YYYYMMDD".
Any time someone wants a demo system, you simply fire up a new instance of the "iDempiere Demo Template YYYYMMDD" image. This can be done via the AWS console, or it can be automated via awcli command line tools. See CLI Example Here.