I have several classes of records that I want to add to an OpenERP system that are currently held in other PostgreSQL tables.
The first is a list of customers with address and contacts. I think I see where to add these in the various res_partner tables. The second is are externally generated invoices and their line items. These presumably go in account_invoice, account_invoice_line, account_invoice_tax and account_invoice_line_tax. Finally there are the bank transactions which get downloaded from the bank as OFX records and put into a table. I presume these go in the account_bank_statement and account_bank_statement_line tables. When I am loading these tables manually there are some columns that look like housekeeping columns, such as id, create_uid, create_date, write_date, write_uid. id can be defaulted and it will be completed from its sequence, and I presume that if I am adding the record then create_uid = write_uid = the id of a record in res_users and that create_date = write_date = now(). There are then some fields whose contents are fairly obvious from the data I am entering, and some that I do not know yet. So for instance in the account_bank_statement_line table there is a reconcile_id field, which I guess I leave null and will then be completed by the reconcilliation process. Is the above correct, or have I missed anything. I am assuming from things like section 3.6 of the user manual where it talks about an automatic import procedure that adding such records myself with external code is an sensible thing for me to do. David _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
