Page 3 of 4 12 3 4
Reply
Thread Tools
ali.harmouch is offline ali.harmouch
2010-04-30 , 16:43
Posts: 104 | Thanked: 2 times | Joined on Feb 2010
#21
Originally Posted by fhofer View Post
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 is offline hoppa123
2010-05-01 , 08:28
Posts: 33 | Thanked: 10 times | Joined on Feb 2010
#22
"find / -name output.html" and then voila !
 
ali.harmouch is offline ali.harmouch
2010-05-01 , 08:42
Posts: 104 | Thanked: 2 times | Joined on Feb 2010
#23
Originally Posted by hoppa123 View Post
"find / -name output.html" and then voila !
merci beaucoup . oh lala
sorry can you give me more details?
Regards
 
fhofer is offline fhofer
2010-05-01 , 10:24
Posts: 66 | Thanked: 30 times | Joined on Feb 2010
#24
Originally Posted by ali.harmouch View Post
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 is offline BabylonV2000
2010-05-04 , 10:52
Posts: 16 | Thanked: 8 times | Joined on Jan 2010
#25
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 is offline fhofer
2010-05-05 , 10:32
Posts: 66 | Thanked: 30 times | Joined on Feb 2010
#26
Originally Posted by BabylonV2000 View Post
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 is offline SR90
2010-05-09 , 12:13
Posts: 276 | Thanked: 109 times | Joined on Dec 2009 @ Vancouver,Canada / Dubai,UAE
#27
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 is offline missmetal
2010-08-02 , 02:16
Posts: 4 | Thanked: 0 times | Joined on May 2010
#28
Originally Posted by jvesiluoma View Post
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's Avatar
ossipena is offline ossipena
2010-08-02 , 04:04
Posts: 3,159 | Thanked: 2,023 times | Joined on Feb 2008 @ Finland
#29
the times are in unix time
http://en.wikipedia.org/wiki/Unix_time

don't remember in which columns though...
__________________
Want to know something?
K.I.S.S. approach:
wiki category:beginners. Browse it through and you'll be much wiser!
If the link doesn't help, just use
Google Custom Search
 
missmetal is offline missmetal
2010-08-03 , 18:23
Posts: 4 | Thanked: 0 times | Joined on May 2010
#30
Ok, how would one export the entire conversation between a number and myself using this command or some other? Any ideas?
 
Reply
Page 3 of 4 12 3 4

« Previous Thread | Next Thread »

 
Forum Jump


All times are GMT. The time now is 02:13.

Contact Us - Home - Archive - Top