maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Nokia N900 (https://talk.maemo.org/forumdisplay.php?f=44)
-   -   Please Help. N900 died :-(. How can I access contacts on my Backup? (https://talk.maemo.org/showthread.php?t=79245)

huntr77 2011-10-28 19:13

Re: Please Help. N900 died :-(. How can I access contacts on my Backup?
 
Quote:

Originally Posted by TiagoTiago (Post 1115226)
Isn't that Unix time?

Thank you! Just the information I was after...

lma 2011-10-28 19:48

Re: Please Help. N900 died :-(. How can I access contacts on my Backup?
 
Quote:

Originally Posted by STE (Post 1111769)
However, the file is readable with a textviewer (some kind of structured data with tags BEGIN:VCARD and END:VCARD. Inbetween I find my conatcs. Thanks god! It's not the most elegant way, but it works.

That's standard vCard format, you should be able to import the file as-is into most addressbook programs.

Quote:

Originally Posted by huntr77 (Post 1115217)
Using SQLite Manager i've found the 'Compontents' table. I can't figure out how to conver the DateStart and DateEnd records into normal dates though.

How did you do that? i.e. what would this date translate to: 1096326000?

See http://www.sqlite.org/lang_datefunc.html, particularly the 'unixepoch' examples.


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

vBulletin® Version 3.8.8