View Single Post
Posts: 9 | Thanked: 1 time | Joined on Apr 2010
#142
Hi guys,

thanks a lot for everyone who contributed to this thread. I successfully imported 2000+ messages from my N95 and here are some of the things worth mentioning:

1- Which delimiter to use: I used the "|" letter (shift + \). Mainly, pick something you think won't appear in any of your text messages.

2- which binary to use: I used Ziller's binary from post #104 in this thread.

3- sorting messages: I sorted the messages based on time, putting the oldest ones at the beginning of the file, and the most recent files towards the end. To do this, I first rearranged every line so that the time was in the beginning, then I sorted the lines, then I rearranged every line again so that the time is in the right place. I used macros in Emacs (an editor) to do this.

4- I deleted all the lines that started with "mms" (only had two).

5- For the encoding, I have some Arabic messages. I first renamed the .csv file to .txt and opened it in Mozilla Firefox on my computer. I went to the "View->Character Encoding" tab in the menu and selected "Unicode (UTF-8)". I was able to see the Arabic text just fine. This means that the file was already UTF8 encoded. Note that I never editted the file in Notepad, and Firefox won't change encoding for you, it will only allow you to see what encoding the file has. To change encoding, see Robb's post (the 4th post before mine).

6- If this is your first time doing this, skip this step. Having done this twice before with failed results (using older binaries), I had to delete my el.db file on the device. This file's path is /home/user/.rtcom-eventlogger/el.db I rebooted after deleting it.

7- I followed the instructions, copied sms.csv and the binary to my phone using Mass Storage mode, copied them one level up to /home/user from /home/user/My Docs, enabled the +x bit on the binary using chmod, and ran the binary.

Results:

It took a long time to finish mainly because it printed every message to the screen. But, I now have all my messages in the conversation app sorted correctly, with names from the address book appearing correctly. Arabic font is there and looks great. I can delete individual messages.

Thanks a lot everyone!

Now, Nokia, wouldn't you want people to say thanks to you too? Why don't you go ahead and release an update to PC Suite that saves us all this trouble
I deleted all the MMS messages from the .csv file (there were only two). I also have some Arabic text in my messages, but it turned out that the encoding was UTF8 to begin with. To verify that, I

Originally Posted by ziller View Post
I added matrim's uuid bit to gagravarr's patched code and it seems to import even large linked messages with no problems and I can delete and forward any message I want...

Just imported a few thousand text messages on a vanilla n900, all is okay. I've attached the source and the compiled binary.


edit: the conversations app is dying on me on some individual messages though... I'm blaming this mainly on the special characters in the .csv file, probably nothing to do with the importer.

Last edited by Hamzeh; 2010-04-01 at 13:05.
 

The Following User Says Thank You to Hamzeh For This Useful Post: