db.export_to_csv_file and type mismatch

[goome]

hello there is some way to export all the data (that have some type mismatch from modles/db definitions and real values present) and then reload cleaned?

i tried with db.export_to_csv_file but give me error :

ValueError: invalid literal for long() 

in fact, there are alues that should be double (o decimal) and that instedad are string (ex.: '27.0' for 27.0)

This cause runtime error

Any tips?

[Dave S]

You  may need to use the DB's export tools, rather than the ones in web2py. 

Are you using sqlite?  There are mentions in the the forum archives that sqlite is "looser" in enforcing value typing than MySQL or PostGREs.  But exporting from sqlite  only requires that you open its shell, make sure the options are set right (like ',' as the separator for delimiter-separated values (CSV, for short)).  Options are accessed with the dot-commands (.help to start with), and then either .dump or a SELECT statement.

Some of the non-SQL DBs may allow mixing types, but I don't know how to dump those.  Their tools should have some documentation, though.

/dps



 

[Ron Chatterjee]

There is a extract tool in script folder. I couldn't get it to work but if you do, please share:-)