View Single Post
Posts: 539 | Thanked: 165 times | Joined on Feb 2010 @ Berlin, Germany
#52
Well, a simple "sqlite3 -csv <databasename> 'select * from items' > <exportfile> " would do the job, I guess. Of course, databasename and exportfile have to be replaced with current values.

This is just a shoot in the dark as I didn't check the order of the values in the exported file. This command exports the data ion the same order the columns in the db-schema are defined, beginning with uid, listname, category,.... In case the order has to be rearranged the statement must be adapted, that would also be no problem.