> I have data I need to import from several other programs and would like to do > this is a sequential manner. For instance: import partner name first to > create record, then contacts for each partner, then extra info, etc. > Right now I'm getting: "ERROR: duplicate key violates unique constraint" > when I try to import contacts to an existing partner. Being able to select > "Import as Insert" or "Import as Update" in the import window would be very > useful.
I have spent some time on this recently and have updated the Wiki with some information on importing. We have tried the CSV and direct SQL methods, both have issues due mainly to the complexity (power) of the Tiny system. IMHO, the best way to install data is using the RPC interface. We are currently building some scripts to upload much of our legacy system data from MySQl and CSV files directly in to the server. This allows us to load and process workflow actions on the loaded data, for example, we can load old invoice records then mark them as paid. Once we have some more of the XMLRPC done, we will add more to the Wiki. > Import partners through the "Partners/Partners" form. Go over to > "Partners/Partner Contacts" form and import the contacts from there. > The field called "Name" used during the Partner import becomes > "Partner" > in the contacts import. This gets the imported contacts connected to > the correct partner. The Import is context sensitive; when you access the same fields from different areas, the labels will change depending on the way the fields are related. SM _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
