Notices


Reply
Thread Tools
epage's Avatar
Posts: 1,684 | Thanked: 1,562 times | Joined on Jun 2008 @ Austin, TX
#51
Originally Posted by x-lette View Post
I could give you a hand in preparing a simple command for extracting data from an existing old database to a csv file. But actualkly I just don't have a clue how the old db is structured and if there are differences between the old scheme and the new one, apart from naming convention.
The only difference was fixing the typo. I'm not too sure what the schema is either. Feel free to post what you've got for others who are concerned about loss of data.
__________________
770, n810, n900, Ideapad S10-3t
TheOneRing, DialCentral, Gonvert, Quicknote, Multilist, ejpi, nQa, Waters of Shiloah
Programming Blog
 
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.
 
silvermountain's Avatar
Posts: 1,359 | Thanked: 717 times | Joined on May 2009 @ ...standing right behind you...
#53
Three enhancement/feature request for my favorite to-do app:

1) Instead of typing in a date being able to pick it from a calendar (a la Seqretary),

2) Having multi-tiered tasks, and

3) A new icon

Thanks for all the great apps you develop and support.
__________________
.N810 experience: Since 6/2009
My Twenty Favorite OS2008 Applications:
AutoScan, Diablo5 Theme, Dialcentral, DragLock, EmelFM2, FlipClock, gPodder, Headphoned, Knots 2, Maemo Mapper, mPlayer, openNTPD, OpenSSH, Panucci, Personal Launcher, QuickNote, Seqretary, SlideLock, Telescope, YellowNotes
 

The Following User Says Thank You to silvermountain For This Useful Post:
Posts: 30 | Thanked: 7 times | Joined on Nov 2010 @ Rhode Island
#54
Hello there,

I had a quick questions about Multilist. I've been using MaraTick for a long time on my BBerry, but now I upgraded to the n900 and Multilist looks like it will be a great replacement, since MaraTick is BBerry only. I have hundreds of items in MaraTick and I've exported them and created a .csv file. I can't figure out how to import it into Multilist! I see the import button, of course, but I can't get the file selector to see my export file. Is there some special extension or location that will get this to work?

Thanks in advance.
 
epage's Avatar
Posts: 1,684 | Thanked: 1,562 times | Joined on Jun 2008 @ Austin, TX
#55
Originally Posted by DrKlaw View Post
Hello there,

I had a quick questions about Multilist. I've been using MaraTick for a long time on my BBerry, but now I upgraded to the n900 and Multilist looks like it will be a great replacement, since MaraTick is BBerry only. I have hundreds of items in MaraTick and I've exported them and created a .csv file. I can't figure out how to import it into Multilist! I see the import button, of course, but I can't get the file selector to see my export file. Is there some special extension or location that will get this to work?

Thanks in advance.
The problem with CSVs is that they are very generic but don't have a good way of specifying what schema they are. Multilist is designed to be able to import CSVs it has exported but that is it.

It should show csv files in the browser. I'm assuming instead that they problem is you can't find the right folder? I was lazy and am not using a user-friendly import/export dialog. I just now filed myself a bug to fix this. A work around is to hit Ctrl+h in the import/export dialog, click the left side's "Nokia n900" and the "Documents" etc folders are actually ".documents" (the "." prefix means hidden, Ctrl+h shows hidden).

I'm leaving for Meego Conference soon but if you could give me the a description of the columns (usually the first line of the csv) I try to fix the dialogs and add support for that version of csvs.
__________________
770, n810, n900, Ideapad S10-3t
TheOneRing, DialCentral, Gonvert, Quicknote, Multilist, ejpi, nQa, Waters of Shiloah
Programming Blog
 
epage's Avatar
Posts: 1,684 | Thanked: 1,562 times | Joined on Jun 2008 @ Austin, TX
#56
Originally Posted by DrKlaw View Post
Hello there,

I had a quick questions about Multilist. I've been using MaraTick for a long time on my BBerry, but now I upgraded to the n900 and Multilist looks like it will be a great replacement, since MaraTick is BBerry only. I have hundreds of items in MaraTick and I've exported them and created a .csv file. I can't figure out how to import it into Multilist! I see the import button, of course, but I can't get the file selector to see my export file. Is there some special extension or location that will get this to work?

Thanks in advance.
At the time I updated multilist for n900's there weren't so many list programs. I've not been too active on adding really cool features or making it nice, I've been too busy with other applications. I'm willing to try to add things as people need them but I recommend checking out some of the others (I know there are more I just can't remember their names).

I wish there was some kind of wiki database where programmers/users could enter in features/pros/cons of an application and link applications as similar so you could get side-by-side comparisons of them and make discovering related apps easier.
__________________
770, n810, n900, Ideapad S10-3t
TheOneRing, DialCentral, Gonvert, Quicknote, Multilist, ejpi, nQa, Waters of Shiloah
Programming Blog
 

The Following 2 Users Say Thank You to epage For This Useful Post:
Posts: 30 | Thanked: 7 times | Joined on Nov 2010 @ Rhode Island
#57
Thanks for the reply!

I figured it out. It wasn't that the folder was hidden. I was expecting to see the files listed with the folders and simply select that. Once I realized that I had to type the filename into the text field labeled "Location" and use the folder navigation controls to simply select the folder, I got it to work.

Thanks again.
 
Posts: 539 | Thanked: 165 times | Joined on Feb 2010 @ Berlin, Germany
#58
Am I the only one who's multilist won't start anymore? When started in xterm it says:
Code:
ValueError: insecure string pickle
EDIT: I could sweare, before upgrade to PR1.3 it worked.
 
epage's Avatar
Posts: 1,684 | Thanked: 1,562 times | Joined on Jun 2008 @ Austin, TX
#59
Originally Posted by x-lette View Post
Am I the only one who's multilist won't start anymore? When started in xterm it says:
Code:
ValueError: insecure string pickle
EDIT: I could sweare, before upgrade to PR1.3 it worked.
I've not upgraded yet to PR1.3. I just double checked and I don't seem to be using pickle anywhere.

Was there any kind of callstack associated with it so I can see where that error is coming from?
__________________
770, n810, n900, Ideapad S10-3t
TheOneRing, DialCentral, Gonvert, Quicknote, Multilist, ejpi, nQa, Waters of Shiloah
Programming Blog
 
Posts: 539 | Thanked: 165 times | Joined on Feb 2010 @ Berlin, Germany
#60
Originally Posted by epage View Post
I've not upgraded yet to PR1.3. I just double checked and I don't seem to be using pickle anywhere.

Was there any kind of callstack associated with it so I can see where that error is coming from?
Yes, I just didn't want to type it on my PC as I didn't post from N900 directly. Will append the complete output next time I'm online with N900.

Short version (multilist v 0.3.11-2) (from bottom):
shelve.py, line 113
libspeichern.py, line 114
libselection.py, line 143
.
.
.
 
Reply


 
Forum Jump


All times are GMT. The time now is 00:19.