I was experimenting on bulk download/upload. I have simple table (Languages), which I first fill with a couple of records. Then I download them -- seems nice.
The problem I get, is that when Uploaded (actually the same stuff), id values are stored in some strange column "Key Name", but not in "id". and I get TypeError: int() argument must be a string or a number, not 'NoneType' And I can't see the uploaded records in appadmin. screenshots, csv and bulkloader.yaml: http://ftp.akl.lt/users/jurgis/etc/db_migrate_web2py-gae/ By the way GAE has "ID" name (not "id") if I change "__key__" to "id" in bulkuploader.yaml, I get extra column "id" -- which is clearly different from GAE "ID", as GAE "ID" then are inserted independently as if I would not have them. ===== Another Idea ========= maybe Web2Py could have "Backup"/"Restore" feature per DB, alongside with "Export"/"Import" per table. As I need to keep my id's unchanged when migrating (as I have hierarchical/nested/recursive relation in one table, and also some foreign keys) On Aug 16, 6:43 am, howesc <how...@umich.edu> wrote: > take a look at the bulk loader from > google:http://code.google.com/appengine/docs/python/tools/uploadingdata.html > > i think it takes a CSV format, so if you can get your data from sqlite > in proper CSV format you should be able to upload via bulk loader. > > good luck! > > christian > > On Aug 15, 8:33 am, Jurgis Pralgauskis <jurgis.pralgaus...@gmail.com> > wrote: > > > > > Hello, > > what's the best way to import my currently sqlite db to GAE? > > > I think for each table: > > 1) export CSV on nonGAE, > > 2) then paste it into some form in GAE environment and adapt > > import_from_csv_file... ? > > > but maybe there are other/better/ready recipies?
