I have several questions, but first of all I would like to thank you guys for developing such a powerful product.
My first question is: > When Importing Contacts via CSV file how should the Address field be formated > to make a relation link with > an existing address? > > > When importing Contacts you just have one field "Address" what exactly fits > in there? In the Address CSV Import you have fields such as: "Street", "Street2", "City", "State", etc.. The reason I ask is that no matter how I formated the Address it would not find the relation to an existing address. NOTE: Trying to use "Address:id" as a field with the corresponding Address id number did not work either. It just told me that "Address:id" field was unknown. So After spending numerous days and hours trying to format my CSV files so that they could be imported I found myself importing my Contacts (about 4000 of them) without Address relation. I must say that the Partner name (as long as it was spelled right) had no problem. I wasn't about to go through 4000 Contacts and manually link them to 2600 existing addresses. So I found a way to use psql commands and import into the res_partner_job table. First I backed up the entire database. Then I backed up the res_partner_job table into a CSV file. I edited the file to include the Address IDs on all the rows that had no relation, and even added rows of relations that had not been entered at all. Created a temp table identical to res_partner_job. Uploaded the newly edited CSV file. Then I used UPDATE to update all rows with their newly corresponding Address IDs from the temp table to res_partner_job. Then I used INSERT to insert all entries from temp table to res_partner_job ExCEPT those that already existed (ie. temp.id = res_partner_job.id). It worked beatifully. But now I cannot create any new contact jobs entries. It gives me an "Integrety Error" that "the duplicate key violates the unique key restraint for res_partner_job_pkey". My Second question is: How do I fix this? Thanks again for such wonderful software. And Thanks in advance for your help. JCORREA920 ------------------------ _________________ Ubuntu 8.04 LTS Server~OpenERP 5.0 ~PostgreSQL 8.3.6~phpPGAdmin 4.1.3 ~PHP 5.2.4 -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=36709#36709 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
