Thread
:
[Announce] Multilist
View Single Post
x-lette
2010-05-08 , 20:25
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.
Quote & Reply
|
x-lette
View Public Profile
Send a private message to x-lette
Find all posts by x-lette