Notices

Oh yes, I forgot one more - which seems more complicated and must be a blocker for those which have messages not all written in Latin characters.

While on holidays, I've received several messages with Greek characters (see below for an example - the specific one is a advertisement from the local telco).
When I've received and later they appear fine, but after exporting - importing with the tools here they become somehow unrecognisable and cannot be displayed any more. If you try to view them you get an empty screen and the CPU applet goes to red.

Dear Friends Finally i could do it of transferring all the SMSs (Sent and Inbox) from my E90 to N900. I followed the below steps

1. Installed PC Suit 7.1 version
2. Connected E90 Phone and took backup of E90
3. Converted the SMS Inbox and Sent items into a CSV file format
4. Restored backup of E90 to N900. This restored only the contacts and calender. For SMS it said the file format of N900 doesnt match with that of E90
5. From this blog i got the utility smsimporter
6. copy all inbox and sent items in single file say name it as sms.csv.
7. default delimiter is , (comma). change this delimiter to ; (semi-colon)
8. When you convert file from E90 the first 2 fields doesnt get missed, where you have to also do the delimeter eg sms,deliver, in case of inbox SMS. This should appear as sms;deliver; after you change the delimeter. In case of sent sms it should appear as sms;submit;
9. Connect N900 device and in the device chose Mass Storage mode
10. open the device folder where you would see the folders like ".docuements", ".images" etc named folder
11. copy file smsimporter and sms.csv (combined inbox and sent sms file)
12. Diconnect the phone from the PC
13. selet xTerminal module from the phone
14. type command cp MyDocs/smsimporter MyDocs/sms.csv . (dot should be there at the end of the command) and press enter
15. In above statement, please follow the cases of MyDocs spelling
16. type command ls -l and press enter. This command will list the files. Here you should be able to see the files which you had copied
17. type command chmod +x ./smsimporter and press enter
18. type command run-standalone.sh ./smsimporter sms.csv and press enter
19. Above command will start importing the SMS, which will give the imported sms displays.
20 Press exit on the command prompt and go to the conversation module. There you should be able to see all the imported SMS.
21 if you have not imported contacts, then in conversation the Sent to & received from numbers will appear. And if you have already imported the contacts, the Sent to and received from name will appear.

Finally i think this should work for all

Hmm... Messages in the wrong order (Sort by Message ID instead of storage time), unable to delete some SMS messages after the import, some messages are not shown after the import or the conversation application hung up or blocks because of greek charakters.

What about writing a own SMS application?

N900 SMS Archiv

Only to store and keep your old SMS messages on the Device. Only to import, view and search. Without the possibility to send or receive a message. (it could easily be possible to import SMS Messages from the N900 datebase to the SMS Archive Application, but not the other way)

Could someone like the Idea?

@Helmut. Maybe this is close to what you are describing:

https://garage.maemo.org/projects/glogarchive/

http://talk.maemo.org/showthread.php?t=37907

It's at extras-testing at the moment.

Hi

Could anyone show me an exactly example of how a csv file of exported sms from a nokia cell looks like?

Because I have to do the same importing sms from a samsung cell...so i guess i have to manually create the csv file i order to use it with the tool of this blog (Samsung PC studio does not export to csv..)

Thanks a lot!

Taken from a (very) old N90, through the latest PC Suite software:

Number has been edited for privacy.. Original message body:
List delimiter was changed to the pipe | to account for multiple cases of colon and semicolon being used in many of the 2000+ sms's I was importing -- yes, that N90 has been with me and in full use for a long time.

I used the 0.2.2 version posted a few pages back to do this.. It seemed to include all the patches for the several issues people had been reporting, checks for which delimiter is being used, adds the message token so you can remove each individual message from Conversations, etc, etc..

But, since I was importing so many messages, I did run a few tests of my own and found I had to edit my merged csv file to remove all the double-quotes "" in any message body (that the PC Suite software creates whenever a single quote is found) since smsimporter was leaving them in.. In other words, the above test message (deliberately using a semi-colon and a word in quotes) would need to have its csv version converted to the following:

This would be very easy to do in the actual smsimporter code, but it was even easier for me to just use a regexp substitute rule through VIm -- though, if like me you have a good few msgs to import, you might want to do this on a PC and spare the N900 the hassle.

Great community work, everyone.. To all who contributed to this very elegant and fairly easy to use solution, my heartfelt thanks.

Thanx!

I tried with a test file and everything did go well!

Now I've tried with the good one, the file with all the messages, and the conversation program crashed. I can't open it anymore, "internal error" and the application closes.

I don't know why, but how can i reinstall the standard conversation application? or maybe only delete all the sms...

Please tell me 'cause I'm without sms-application right now.. hm..

I tried it, it succeede after a few tries, but now I cannot open any sms, as the conversations program crashes immediately when I try to open it

How do I delete all sms databases on n900?

I tried to reflash the firmware using nokia updater but the problem remains.

I had the same problem...

The database is stored in home/user/.rtcom-eventlogger/el.db

You can delete the file and a new one will be created..

Now I succeeded importing some sms, but I can't open some messages, while others open without any problem. Any idea?

thanks theswiss! you saved my day

but after numerous tries I cannot get the smsimporter to import the messages without the conversation program crashing down. so I'm calling it quits for now