Reply
Thread Tools
soulja is offline soulja
2010-08-08 , 11:52
Posts: 7 | Thanked: 0 times | Joined on Feb 2010
#1
Ive been on symbian software for many years and backed up sms by dragging them from the pc suite viewer.

Ive had the n900 since january now and to certain individuals, I have accumalated thousands of texts. Many of which are important and which I would prefer to archive on my computer.

As far as I am aware, that the sms feature is not available on nokia/ovi suite. I would prefer to back them on the computer with a half decent UI for reading them however that doesnt seem possible from what ive read. Is there any way to back them up?

The reason I ask is when I click on these individuals to send a text, it takes a while to load it up as there are many texts stored under the name.

Any help or suggestions would be greatly appreciated.
 
dchky's Avatar
dchky is offline dchky
2010-08-08 , 16:35
Posts: 549 | Thanked: 298 times | Joined on Jun 2010 @ Australian in the Philippines
#2
I would perhaps be inclined to do a backup and then copy the backup file to another location. (off the phone) Even if you kill your N900 you can still unzip the backup and use sqlite to get at your messages.

If you want to export ALL your messages as a CSV file, that's pretty easy to do on the N900 itself - then you can look at it in a spreadsheet.

On the N900 as root:

Code:
N900:~# sqlite3 /home/user/.rtcom-eventlogger/el-v1.db
SQLite version 3.6.14
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .mode csv
sqlite> .output SMSeses
sqlite> select * from Events;
sqlite> .quit
N900:~# cat SMSeses
Blah, blah, blah, etc.,
Hope this helps. You don't need to use SMSeses as your file name : )

There are probably some creative uses of SQL you can use to format your output so that you can split your friends in to separate files and whatnot.
Last edited by dchky; 2010-08-08 at 16:40.
 
v13 is offline v13
2010-08-08 , 16:45
Posts: 376 | Thanked: 511 times | Joined on Aug 2009 @ Greece
#3
GlogArchive does this.
 
dchky's Avatar
dchky is offline dchky
2010-08-08 , 16:48
Posts: 549 | Thanked: 298 times | Joined on Jun 2010 @ Australian in the Philippines
#4
Er, what v13 said - that works better : )

Forget my post above.
 
soulja is offline soulja
2010-08-08 , 17:28
Posts: 7 | Thanked: 0 times | Joined on Feb 2010
#5
Thanks alot for your help, I will look at it tonight when I get on my laptop.
 
soulja is offline soulja
2010-08-20 , 11:35
Posts: 7 | Thanked: 0 times | Joined on Feb 2010
#6
Hi

It installed fine, opened up fine the first time but I didnt quite get to grasps how to use it. However whenever I open it again now, it opens shows it loading and just turns off.

Also the sms convo to one particular user has a red '!' on it and keeps deleting texts.

Any help will be very much appreciated.
 
Reply

« Previous Thread | Next Thread »

 
Forum Jump


All times are GMT. The time now is 17:36.

Contact Us - Home - Archive - Top