It's a good idea... I think that rather than sharing our experiences in the import process, we could share our modules for that. If the modules happen to be coded in Python, they are easy to understand and more effective than reading a blog.

Hi Gary,

I'm working on something that you may like to review as a possible foundation for your proposal.

http://martinhbramwell.github.io/GData_OpenERP_Data_Pump/

The first basic idea is to have a growing library of Python plugins, such as ResUsers.py that understand :

1. How to read data from a dedicated sheet in a Google Spreadsheet workbook (such as OpenErpGDataModel) )
2. How to interact with the corresponding ORM model's API methods.

So far these "plugins" are dedicated to direct data loading, but that's just a consequence of the stage of development. Methods can be added to make them do anything that one can do, on a model, via XML-RPC.

The second basic idea is to have a dispatcher within a dispatcher, which get their instructions from a control sheet, such as this one : OpenErpGDataController, and loop through each method of each model.

Please let me know your opinion, and feel free to interrogate if you want further details.

2013/04/26

If you read two bits of code you'll understand just how trivial the project is:

In gDataTools.py the loop :

for row, task in enumerate(namesTasks):

In OErpModel.py the loop :

for idx, parm in enumerate(self.task_parms):