Step #09 : Demonstrate Google Spreadsheet to OpenERP data pump

Description

Welcome to the final step in this series.

If you have followed through from the beginning you will have a cloud-based platform with three valuable tools:

• a SSH terminal server accessible by HTTPS
• a Salt Stack master
• the Google spreadsheet to OpenERP data pump.

Our last task is to understand how to use the data pump to control OpenERP instances.

There should be no need for further documentation of it here; the web site covers the whole thing in detail.  

Here's the video:

Tasks performed

1. Update the "creds" page of the controller spreadsheet with IP address or domain name of the target OpenERP installation
2. On the same page, also provide a name for the database to use, and the super user password of the OpenERP installation
3. To test connectivity, run the pump, specifying the controller spreadsheet's ID key with the -k switch.  This first run should show that a connection was achieved, but no tasks run.
4. There are eight possible subtask executions per task row.  A pair of bit maps control which of the eight are executed. If a row has 5 action steps and only the 4th should be executed. Using binary arithmetic the settings should be: complete 23, incomplete 8, length 31. Any error in that will be seen in the "Chk" column (P).
5. To create the new OpenERP data base, we want to run the second action step in the first row.  We'll also run the chkTask action.  It simply reports that the indicated Model Class is available and has a method called chkTask.  There are two action steps in total, so the length is 3. 
6. Run the pump, with the same command as before.
7. Examine OpenERP to see if the database "demoVideo" was actually created.
8. Log in to the "demoVideo" database in OpenERP.
9. I never found a way to set the "Technical Features" check-box for the administrator via XMLRPC.  So this is an unfortunate, one-time, manual step.  A workaround is to restore a database backup, with similar default settings already done.
10. We repeat the preceding steps for adding some national regions and languages.
11. The remainder of the video attempts to point out how all the various parts of the pump work together.

An overview of all the steps is available here:

Handbook for the DevOps for OpenERP Video Playlist