[web2py] Re: Error upload file csv database

2019-10-16 Thread Kimus
well, the importation automatically dont fixed the keys, i don't understand why end the importantion manual dont work because my code not use the common functions or methods the web2py like SQLFORM or FORM, so the relation is forced like ex propriedade = db(db.PropriedadeRural.id == request.

[web2py] Re: Error upload file csv database

2019-10-15 Thread Massimo Di Pierro
Do you have the original database. If you do you should export it from the web2py shell with db.export_to_csv_file and reimport it with db.import_from_csv_file. This is documented in the manual. The import will automatically fix your keys. If you use postgres you can use pgdump and pgrestore.