maemo.org - Talk - HOWTO: Importing SMS messages from Nokia phones to N900

maemo.org - Talk (https://talk.maemo.org/index.php)

- Applications (https://talk.maemo.org/forumdisplay.php?f=41)

- - HOWTO: Importing SMS messages from Nokia phones to N900 (https://talk.maemo.org/showthread.php?t=37354)

Re: HOWTO: Importing SMS messages from Nokia phones to N900

Can any one tell me the format of the cvs file. I am switching from a Sony Ericsson P1i to the n900. I have an app to export the messages. But I do not know if the cvs file is in the right format.

Thanks

Re: HOWTO: Importing SMS messages from Nokia phones to N900

To export from my SE v600 I used Wammu and it's “XML format”.

Re: HOWTO: Importing SMS messages from Nokia phones to N900

Quote:

Originally Posted by corsac (Post 449933)

To export from my SE v600 I used Wammu and it's “XML format”.

I tried Wammu to export my messages, but it could not read them from my phone. I found an other tool that lets me export the messages to Open Office, now I only need the correct format for the cvs file.

Re: HOWTO: Importing SMS messages from Nokia phones to N900

Yes, the tool posted here doesn't support the Wammu XML format. I coded a tool which does, but I'm waiting for an answer from the bug report about the SMS ordering before doing anything else.

Re: HOWTO: Importing SMS messages from Nokia phones to N900

Hi rmoravcik,

If interested I could sent you a csv file (with only two SMSs) that gives a segmentation fault for debugging.
The file has been created by PC suite reading a Nokia phone.

PM me with an email where to sent it if you like.

Thanks.

EDIT: scratch that complete comment. I've fount the 0.2.1 version of the importer witch works as advertised :)

Re: HOWTO: Importing SMS messages from Nokia phones to N900

Hi matrim, Hi corsac,

Is it possible to share the bin of the update you did to the smsimporter?

Re: HOWTO: Importing SMS messages from Nokia phones to N900

Quote:

Originally Posted by mike_shenoda (Post 432576)

so i wanna no how to merge both inbox.csv and sent.scv thx

if you have them in the N900, open xterm, navigate to the folder with those files and do:

Code:

cat inbox.csv > allSMS.csv

cat sent.csv >> allSMS.csv

this will result in one file i.e. the allSMS.csv.

Hope it helps

Re: HOWTO: Importing SMS messages from Nokia phones to N900

Quote:

Originally Posted by pienk (Post 449909)

Can any one tell me the format of the cvs file. I am switching from a Sony Ericsson P1i to the n900. I have an app to export the messages. But I do not know if the cvs file is in the right format.

sms;deliver;"completenumber";"";"";"2009.12.16 18:49";"";"This is an incoming sms sent from somebody else"
sms;submit;"";"completenumber";"";"2009.12.16 08:38";"";"Outgoing text contents sent to somebody else"

At least it worked for me that way

Re: HOWTO: Importing SMS messages from Nokia phones to N900

When I first tried this program, it segfaulted for me. Checking through the other posts, I spotted the issues with long messages and delimter. Applying this patch and re-compiling allowed the import to work just fine!

Quote:

--- smsimporter.c.orig 2009-12-18 13:41:10.000000000 +0000
+++ smsimporter.c 2010-01-12 16:42:18.000000000 +0000
@@ -113,10 +113,11 @@
}

while (fgets(buf, 512, fd)) {
- char *tmp, *delimiter, *event_type_id, *local_name, *remote_uid, *group_uid, *free_text;
+ char *tmp, *event_type_id, *local_name, *remote_uid, *group_uid, *free_text;
+ char delimiter[2];
const char *remote_name, *remote_ebook_uid;
int year = 0, month = 0, day = 0, hour = 0, min = 0, date_items = 0;
- char text[161];
+ char text[1561]; // up to 10 linked messages
struct tm date;
unsigned int i = 0, skip = 0;
MessageStruct *message;
@@ -237,7 +238,8 @@
if (!number)
continue;

- if (!strcmp (number, remote_uid)) {
+ //if (!strcmp (number, remote_uid)) {
+ if (g_str_has_suffix (number, group_uid)) {
remote_ebook_uid = e_contact_get_const (E_CONTACT (c->data), E_CONTACT_UID);
if (remote_ebook_uid) {
remote_name = e_contact_get_const (E_CONTACT (c->data), E_CONTACT_FULL_NAME);

I've posted my fixed build (binary and source) at http://gagravarr.org/code/smstools-0.2.1.tar.gz, for anyone else hitting the same issue. Hopefully the original author can add this patch in shortly :)

Re: HOWTO: Importing SMS messages from Nokia phones to N900

Is anyone able to delete the imported messages once they appear on the N900? Mine was causing problems wouldnt delete & then backup app wouldn't work after I imported.

Reflashed now I am scared to re-import...:o