Woot! Thanks... that did it. While I was add it I made a "backup and
restore database" feature in my setup. It would be nice if we could
export a database to a "web2py" format. A gzipped file of all databases
in one sweep. It could then be restored quickly as well.
Best Regards,
Jason Brower
On Wed, 2010-09-01 at 06:39 -0700, mdipierro wrote:
> It works but not via appadmin.
>
> If you want to import data from two tables which reference eahc other
> you must to:
>
> id_map={}
> db.table.import_from_csv_file(csvfile1,id_map=id_map)
> db.table.import_from_csv_file(csvfile2,id_map=id_map)
>
> passing the same id_map makes sures the relative references are fixed.
>
> On Sep 1, 5:48 am, Jason Brower <[email protected]> wrote:
> > I have 3 tables to make a many to many relationship.
> > I can export the two. But the linking table for the many to many keeps
> > giving me an error of "undefined record" meaning it's trying to
> > reference to something that doesnt exist. These datbases are clean when
> > I start. and I am doing a direct export and import with the csv feature.
> > Am I missing something or do we have some kind of bug.
> > Best Regards,
> > Jason Brower
