how to make data that download from google-app-engine readable..

Question

i use this to download all data from my google app: i follow this article: http://code.google.com/intl/en/appengine/docs/python/tools/uploadingdata.html#Creating_Exporter_Classes

and download data use this:

bulkloader.py --dump  --url=http://zjm1126.appspot.com/remote_api --filename=b.csv

but the data is :

so how to make the data readable ?

thanks

updated

i download a sqlite view ，and saw this :

this is not readable , why ?

this is the b.csv http://omploader.org/vNGQwcw/b.csv

Answer 1

As Steven Ourada says, it looks like the file is in SQLite format, so you'll need to use SQLite to read it. SQLite is basically a normal SQL database which uses regular files (like the one you've downloaded) to store the data.

Answer 2

You seem to use a wrong command for the download. Your --dump command generates a file whic is indeed in SQLite 3 format but there's not much use of it for you since App Engine's Datastore is not a regular database - in Datastore the data is not spread out into predefined columns of a table. The data is saved in rows like in any database but the columns in the dump file look more or less like this:

• Column 1: Unique ID of the row
• Column 2: All the data regarding the row in a serialized form (binary Protocol Buffers format)

So your download command should look more something like this:

appcfg.py download_data --config_file=your_loader.py --filename=b.csv --kind=DbModelName <app-directory>