Active Topics
-
Nokia FW servers dead (129)
to MeeGo / Harmattan by tvandorffy - 12 hrs, 27 mins ago -
Maemo.org user login (5)
to General by Maemish - 13 hrs, 40 mins ago -
How to force MMS to use cellular network for data? (3)
to SailfishOS by pichlo - 15 hrs, 16 mins ago -
Crash/poweroff after entering SIM PIN (7)
to Nokia N9 / N950 by pichlo - 15 hrs, 29 mins ago -
Phone Camera Competition May 2021: "spring is here" (3)
to General by robthebold - 3 days, 4 hrs ago -
Not clickbait "NOKIA STILL MAKING PHONES, BUT FOR INDUSTRIAL USES" (3)
to Competitors by biketool - 4 days, 9 hrs ago -
Phone Camera Competition April 2021: "Funny & Foolish" (38)
to General by peterleinchen - 4 days, 19 hrs ago -
A Palm OS thread ... and a thank you to the community (24)
to Alternatives by meemorph - 5 days, 14 hrs ago -
MeeGo v1.2.0.1x for Netbook (0)
to MeeGo / Harmattan by teroyk - 5 days, 14 hrs ago - more...
 |
|
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:
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.
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.,
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.
|
|
2010-08-08
, 16:45
|
|
Posts: 376 |
Thanked: 511 times |
Joined on Aug 2009
@ Greece
|
#3
|
GlogArchive does this.
|
|
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.
Forget my post above.
|
|
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.
|
|
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.
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.
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.