problem solved - my error. There was a second reference field that had a broken reference in it.
On Mar 7, 5:43 pm, Philip <[email protected]> wrote: > I am importing data into an existing web2py application. The tables > are connected - I'll pretend for the moment that they are the owners > and dogs tables from the web2py book. I used the shell and typed in > the following commands (based on an example previously posted by > Massimo): > > map = {} > db.owners.import_from_csv_file(open('<path>/owners.csv','r'),map) > db.dogs.import_from_csv_file(open('<path>/dogs.csv','r'),map) > > The owners appeared correctly in the table, but when I tried to view > the dogs (through the admin database interface), I got an error that > the references were broken. I had manually ensured that all dogs in > the dogs table had references to owners that were in the owners table > (i.e. no broken references in the data I uploaded), so the failure > occurred on the translation of ids on the upload. > > Any ideas what I am doing wrong? Has anyone successfully used the > this feature of the import_from_csv_file? > > Thanks in advance for any ideas.
