maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Maemo 5 / Fremantle (https://talk.maemo.org/forumdisplay.php?f=40)
-   -   Help Exporting SMS from N900. (https://talk.maemo.org/showthread.php?t=51239)

SouthSideTommyD 2010-02-26 22:36

Export SMS from N900 ???
 
I am trying to figure out a way to export or save my conversations in a txt or html format - I like to keep logs of my conversations and my N900 is starting to slow down from having so many threads ...
Any ideas how to export or save the files to my computer will be greatly appreciated !!!

jvesiluoma 2010-02-26 23:10

Re: Export SMS from N900 ???
 
Hi,

Maybe this helps.

Note: Make backups first. I will not take any responsibility if you brick your device. It's your own responsibility.


1. Open terminal

2. give following command:
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html

3. xxxxxxxxxxxx in above command is the phone number of the contact. For example you want to save conversations with the person that phone number is 1234567890 the command would be:
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='1234567890' order by start_time DESC;" > output.html

Now you should have output.html file that has conversation in HTML format. Now you just need to transfer that file to your computer via USB for example.


You can see additional output modes by giving following command in terminal and replacing -html with something else like -csv or -column for example.
sqlite3 --help


Hope it helps.


Regards,
Jarkko

donsaibot 2010-04-01 10:18

Re: Export SMS from N900 ???
 
Hi,

does it work with Chat also?

assetburned 2010-04-03 16:45

Re: Export SMS from N900 ???
 
Hmm wondering why it isn't possible to download the SMS via Bluetooth.
I would like to use tools like BluephoneElite :-/

avazkhan 2010-04-21 04:58

Re: Export SMS from N900 ???
 
Quote:

Originally Posted by jvesiluoma (Post 548338)
Hi,

Maybe this helps.

Note: Make backups first. I will not take any responsibility if you brick your device. It's your own responsibility.


1. Open terminal

2. give following command:
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html

3. xxxxxxxxxxxx in above command is the phone number of the contact. For example you want to save conversations with the person that phone number is 1234567890 the command would be:
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='1234567890' order by start_time DESC;" > output.html

Now you should have output.html file that has conversation in HTML format. Now you just need to transfer that file to your computer via USB for example.


You can see additional output modes by giving following command in terminal and replacing -html with something else like -csv or -column for example.
sqlite3 --help


Hope it helps.


Regards,
Jarkko

Hi, Jarkko!

I did it; I'm unable to find the output.html file :D

Pls help me to find it.

Regards,

tirtawn 2010-04-21 05:16

Re: Export SMS from N900 ???
 
Quote:

Originally Posted by avazkhan (Post 620417)
Hi, Jarkko!

I did it; I'm unable to find the output.html file :D

Pls help me to find it.

Regards,

Never know this command, but I will assume the command works, you need to type at the end

sqlite ....... > /home/user/output.html

then for sure you could find the output.html under /home/user :)

ali.harmouch 2010-04-21 05:48

Re: Export SMS from N900 ???
 
Sorry I did the above but i received this in X Terminal:" sh: sqlite:not found"
please help

avazkhan 2010-04-21 05:53

Re: Export SMS from N900 ???
 
Dear Ali,

You have to concern about white spaces.

Specially I think you have typed "sqlite" while it is "sqlite3".

fhofer 2010-04-21 05:56

Re: Export SMS from N900 ???
 
there is an app in extras that will export the database to csv format. I believe it is called glogarchive.

avazkhan 2010-04-21 06:01

Re: Export SMS from N900 ???
 
Dear tirtawn;

I found it in file:///home/user!

thanks

ali.harmouch 2010-04-28 07:38

Help Exporting SMS from N900.
 
how can I export my sms from the N900 to my laptop? I tried the PC suite but nothing shown.

fhofer 2010-04-28 07:57

Re: Computer messages backup
 
Try application "glogarchive". It should be in Extras. It will allow you to export the SMS&call database into a CSV file -- can be then copied to your PC and processed, e.g., in Excel.

ali.harmouch 2010-04-28 08:56

Re: Computer messages backup
 
Quote:

Originally Posted by fhofer (Post 631068)
Try application "glogarchive". It should be in Extras. It will allow you to export the SMS&call database into a CSV file -- can be then copied to your PC and processed, e.g., in Excel.

Sorry i don't know any thing about programming and i read in extras devil that do not install any thing from extras devil if I don;t know about command lines and programming.
Please advice

un-named_user 2010-04-28 09:19

Re: Computer messages backup
 
Quote:

Originally Posted by ali.harmouch (Post 631118)
Sorry i don't know any thing about programming and i read in extras devil that do not install any thing from extras devil if I don;t know about command lines and programming.
Please advice

There are actually 3 repositories on Maemo.org from which software/applications can be downloaded.

1. Extras (end user/newbie friendly)
2. Extras-testing (on its way to be to end user/newbie friendly)
3. Extras-devel (BIG FAT NO NO unless you are ready to deal with problems that may arise... Basically not newbie friendly)

However, the software "Glogarchive" is In Extras. So you can go ahead and try it.

BTW If you are running the latest firmware, Extras will be enabled by default. So you'll be able to see it in the list of downloadable applications in the App Manager.

chemist 2010-04-28 15:59

Re: Computer messages backup
 
easy way for backup:
use the shipped with backup tool and copy the files after backup to your local machine. I rsync my device every now and then after I ran a backup from contacts and the backup tool

sed8me 2010-04-29 06:58

Re: Export SMS from N900 ???
 
Hey guys,
this is heaps useful, I was wondering if there was a way to enter the date/time stamp for each event ?
I see event type and event id, what is the command for date time PLEASE :D

ali.harmouch 2010-04-29 10:33

Re: Computer messages backup
 
Quote:

Originally Posted by fhofer (Post 631068)
Try application "glogarchive". It should be in Extras. It will allow you to export the SMS&call database into a CSV file -- can be then copied to your PC and processed, e.g., in Excel.

thank you. I installed glogarchive but i dont know how to use it
can you help me please?

andrewfblack 2010-04-29 12:01

Re: Help Exporting SMS from N900.
 
Merged 2 threads on exporting sms from n900

ali.harmouch 2010-04-30 08:25

Re: Computer messages backup
 
Quote:

Originally Posted by fhofer (Post 631068)
Try application "glogarchive". It should be in Extras. It will allow you to export the SMS&call database into a CSV file -- can be then copied to your PC and processed, e.g., in Excel.

I don't know how to use the application.
can you help me by summary please.

fhofer 2010-04-30 14:27

Re: Computer messages backup
 
Quote:

Originally Posted by ali.harmouch (Post 634650)
I don't know how to use the application.
can you help me by summary please.

I guess the simplest workflow would be:
1. run glogarchive
2. click "Switch to Live-Database"
3. click "Export to CSV-file", file is saved under /home/User/MyDocs
4. connect the N900 to your PC in USB mode
5. using your PC, you can find the file in the root of the mounted N900 USB drive. The file has csv extension.
6. you can open the file directly in Excel or in OpenOffice (or any other program that can open it) or you can copy the file to your computer.

ali.harmouch 2010-04-30 16:43

Re: Computer messages backup
 
Quote:

Originally Posted by fhofer (Post 635076)
I guess the simplest workflow would be:
1. run glogarchive
2. click "Switch to Live-Database"
3. click "Export to CSV-file", file is saved under /home/User/MyDocs
4. connect the N900 to your PC in USB mode
5. using your PC, you can find the file in the root of the mounted N900 USB drive. The file has csv extension.
6. you can open the file directly in Excel or in OpenOffice (or any other program that can open it) or you can copy the file to your computer.

I did. it is good.
now how can I merge 2 files and import it again from the pc excel sheet to my n900.
I want to merge 2 messages backup in 1 and import it again to my n900. please help

hoppa123 2010-05-01 08:28

Re: Help Exporting SMS from N900.
 
"find / -name output.html" and then voila ! :)

ali.harmouch 2010-05-01 08:42

Re: Help Exporting SMS from N900.
 
Quote:

Originally Posted by hoppa123 (Post 635881)
"find / -name output.html" and then voila ! :)

merci beaucoup . oh lala:)
sorry can you give me more details?
Regards

fhofer 2010-05-01 10:24

Re: Computer messages backup
 
Quote:

Originally Posted by ali.harmouch (Post 635195)
I did. it is good.
now how can I merge 2 files and import it again from the pc excel sheet to my n900.
I want to merge 2 messages backup in 1 and import it again to my n900. please help

I am afraid that glogarchive is currently not capable of doing that. Maybe you can contact the author to add a feature to covert a csv back to N900 DB. But generally, having lots of messages in the phone is not that great idea, it makes the phone slow.

BabylonV2000 2010-05-04 10:52

Re: Help Exporting SMS from N900.
 
Is there a way to convert the sms in csv_file in the PC Suite SMS format ?
So that we could import them in other Nokia phone.
Thanks for your answer.

fhofer 2010-05-05 10:32

Re: Help Exporting SMS from N900.
 
Quote:

Originally Posted by BabylonV2000 (Post 642220)
Is there a way to convert the sms in csv_file in the PC Suite SMS format ?
So that we could import them in other Nokia phone.
Thanks for your answer.

I am afraid that this is not possible -- at least there is no easy way that I am aware of. Maybe try transferring messages to another phone via Settings --> Transfer&sync, it could do, but I have never tried it.

SR90 2010-05-09 12:13

Re: Help Exporting SMS from N900.
 
does anyone know how to export sms to pc and import it back to n900 ?

The Transfer&sync via setting does not allow transfer/sync of sms (just contacts and calender entries )

I would appreciate anyone's help regarding this matter . :)

missmetal 2010-08-02 02:16

Re: Export SMS from N900 ???
 
Quote:

Originally Posted by jvesiluoma (Post 548338)
Hi,

Maybe this helps.

Note: Make backups first. I will not take any responsibility if you brick your device. It's your own responsibility.


1. Open terminal

2. give following command:
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html

3. xxxxxxxxxxxx in above command is the phone number of the contact. For example you want to save conversations with the person that phone number is 1234567890 the command would be:
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='1234567890' order by start_time DESC;" > output.html

Now you should have output.html file that has conversation in HTML format. Now you just need to transfer that file to your computer via USB for example.


You can see additional output modes by giving following command in terminal and replacing -html with something else like -csv or -column for example.
sqlite3 --help


Hope it helps.


Regards,
Jarkko

Hi Jarkko

This is awesome, any chance you can tell me how to organise it by date with a given phone number? The dates are pretty important for me.

Thanks
MM

ossipena 2010-08-02 04:04

Re: Help Exporting SMS from N900.
 
the times are in unix time
http://en.wikipedia.org/wiki/Unix_time

don't remember in which columns though...

missmetal 2010-08-03 18:23

Re: Help Exporting SMS from N900.
 
Ok, how would one export the entire conversation between a number and myself using this command or some other? Any ideas?

DaSilva 2010-12-06 14:48

Re: Help Exporting SMS from N900.
 
Would be nice to use this command together with timestamps...

ankursinghal 2010-12-28 13:50

Re: Help Exporting SMS from N900.
 
Hi i ran the command in the terminal of my N900 but its giving me some error
"SQL error: no such table: Events"


help...!!!!!!

nicolai 2010-12-28 14:15

Re: Help Exporting SMS from N900.
 
Quote:

Originally Posted by ankursinghal (Post 906005)
Hi i ran the command in the terminal of my N900 but its giving me some error
"SQL error: no such table: Events"


help...!!!!!!

which command?

Nicolai

ankursinghal 2010-12-29 09:22

Re: Help Exporting SMS from N900.
 
i ran this command

sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html

have replaced xxxxxxxxxxxx with a phone number

and got the error
"SQL error: no such table: Events"

nicolai 2010-12-30 11:03

Re: Help Exporting SMS from N900.
 
there are two events db-files depending on your Firmware version.
try el-v1.db instead of el.db:
sqlite3 -html /home/user/.rtcom-eventlogger/el-v1.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html


All times are GMT. The time now is 05:14.

vBulletin® Version 3.8.8