[Solved] Commhist-import for transferring conversations to N9 - maemo.org

Active Topics

Sailfish OS for the Motorola Moto G7 Power (XT1955-5) - (ocean) (3)
to SailfishOS by edp17 - 2 hrs, 10 mins ago
The N900 is now 15 years old! (6)
to Nokia N900 by Macros - 1 day, 6 hrs ago
F(x)tec Pro1x (QWERTY) for sale (0)
to Buy & Sell by aln00000 - 1 day, 18 hrs ago
n770 youtube video (0)
to General by nmdv - 5 days, 18 hrs ago
more...

Thread Tools

	ejasmudar	2011-12-24 , 08:12
	Posts: 800 \| Thanked: 957 times \| Joined on Sep 2010 @ India	#1

I just got my N9 and need to transfer my complete conversations and call logs from N900 to N9. Thankfully, Msameer has developed a small utility for harmattan that does this, (http://talk.maemo.org/showthread.php?t=79686) but it only imports SMS messages.

He has indicated how this utility can be modified to import everything, but it needs to be compiled after that. I'm running windows on my laptop and am not able to compile the utility. Can anybody please help me by compiling the attached file or by showing me how I can do it from windows. (I unfortunately do not have access to any Linux systems apart from my N9/N900)

Please Help

Note: the source is at: https://gitorious.org/n900-comhist-i...comhist-import

Attached Files

n900-comhist-import-everything.zip (8.7 KB, 128 views)

__________________
My Device History:Nokia 3510 > SE T230 > Nokia 6600 > HP2210 > SE p910i > SE p990i > N95 > I-mate 9502 > itouch > Nokia N900 > ? N9

Thanks to Nokia IdeasProject Got my baby, my sweet N9!!!
.
.
And now it might just be an expensive brick :C (water damage, sob)

My apps for N900:
Conversation Modder

My apps for N9:
LockScreenQuotes
USbS

If you feel I have helped you, don't forget to press Thanks!

Last edited by ejasmudar; 2011-12-28 at 07:05.

Quote & Reply |

The Following 2 Users Say Thank You to ejasmudar For This Useful Post:
mrsellout, MSameer

	nicolai	2011-12-24 , 21:46
	Posts: 1,637 \| Thanked: 4,424 times \| Joined on Apr 2009 @ Germany	#2

untested.
I just compiled the source with scratchbox.

hope this works.

nicolai

Attached Files

n900-comhist-import_0.2-1_armel.deb (19.9 KB, 130 views)

Quote & Reply |

The Following 2 Users Say Thank You to nicolai For This Useful Post:
ejasmudar, mrsellout

	ejasmudar	2011-12-25 , 11:55
	Posts: 800 \| Thanked: 957 times \| Joined on Sep 2010 @ India	#3

Yay, nicolai to the rescue!!

Yes thanks it worked. Installed it and it transferred all my sms and IM conversations. (Not call logs, wonder why...)
The only problem is that IM conversations were ordered wrong. First outgoing and ten incoming IMs grouped together. Hmmm.... would it be possible to reorder them based on time?

__________________
My Device History:Nokia 3510 > SE T230 > Nokia 6600 > HP2210 > SE p910i > SE p990i > N95 > I-mate 9502 > itouch > Nokia N900 > ? N9

Thanks to Nokia IdeasProject Got my baby, my sweet N9!!!
.
.
And now it might just be an expensive brick :C (water damage, sob)

My apps for N900:
Conversation Modder

My apps for N9:
LockScreenQuotes
USbS

If you feel I have helped you, don't forget to press Thanks!

Quote & Reply |

	nicolai	2011-12-26 , 12:16
	Posts: 1,637 \| Thanked: 4,424 times \| Joined on Apr 2009 @ Germany	#4

I don't know why, but for outgoing messages the
n900 eventlogger has odd "event-end time" entries.
For outgoing messages start and end-time should be the
same. But on my N900 the end-time is few seconds
before start-time.
Anyway, can you try this version and report back
if it works.

Attached Files

n900-comhist-import_0.2-1_armel.deb (19.9 KB, 1223 views)

Quote & Reply |

The Following 6 Users Say Thank You to nicolai For This Useful Post:
ejasmudar, jcharpak, mike_shenoda, miqu, mrsellout, slipkornsaad

	ejasmudar	2011-12-26 , 20:14
	Posts: 800 \| Thanked: 957 times \| Joined on Sep 2010 @ India	#5

Thats a lot, nicolai! It works perfectly now. All conversations have been transferred to my N9!

Damn, I wish I could donate to you, but paypal needs credit card :/ Let me see if I can send you some donations any other way...

__________________
My Device History:Nokia 3510 > SE T230 > Nokia 6600 > HP2210 > SE p910i > SE p990i > N95 > I-mate 9502 > itouch > Nokia N900 > ? N9

Thanks to Nokia IdeasProject Got my baby, my sweet N9!!!
.
.
And now it might just be an expensive brick :C (water damage, sob)

My apps for N900:
Conversation Modder

My apps for N9:
LockScreenQuotes
USbS

If you feel I have helped you, don't forget to press Thanks!

Quote & Reply |

JanMalte	2012-01-03 , 21:14
Posts: 28 \| Thanked: 2 times \| Joined on Feb 2010 @ Mannheim	#6

How did you managed to import your sms?
I tried the compiled version but got several errors like these: http://pastebin.com/w19u8vLK

First error from device. I'm using the tool over ssh as user

"GDBus.Errorrg.freedesktop.DBus.Error.AccessDeni ed: Rejected send message, 2 matched rules; type="method_call", sender=":1.101" (uid=29999 pid=2407 comm="./importn900commhist el-v1.db ") interface="org.freedesktop.Tracker1.Steroids" member="Query" error name="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1276 comm="/usr/lib/tracker/tracker-store "))"
QTrackerDirectSelectResult: QSparqlError(9, "GDBus.Errorrg.freedesktop.DBus.Error.AccessDeni ed: Rejected send message, 2 matched rules; type="method_call", sender=":1.101" (uid=29999 pid=2407 comm="./importn900commhist el-v1.db ") interface="org.freedesktop.Tracker1.Steroids" member="Query" error name="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1276 comm="/usr/lib/tracker/tracker-store "))", 4) "SELECT ?channel nie:subject(?channel) nie:generator(?channel) nie:identifier(?channel) nie:title(?channel) ?_lastDate ( SELECT COUNT(?_total_messages_1) WHERE { ?_total_messages_1 nmo:communicationChannel ?channel . ?_total_messages_1 nmo:isDeleted false . }) ( SELECT COUNT(?_total_unread_messages_1) WHERE { ?_total_unread_messages_1 nmo:communicationChannel ?channel . ?_total_unread_messages_1 nmo:isRead false . ?_total_unread_messages_1 nmo:isDeleted false . }) ( SELECT COUNT(?_total_sent_messages_1) WHERE { ?_total_sent_messages_1 nmo:communicationChannel ?channel . ?_total_sent_messages_1 nmo:isSent true . ?_total_sent_messages_1 nmo:isDeleted false . }) ?_lastMessage (SELECT GROUP_CONCAT(fn:string-join((tracker:id(?contact), nco:nameGiven(?contact), nco:nameFamily(?contact), "\u001d", ?nicknames), "\u001e"), "\u001c") WHERE { SELECT ?contact (SELECT GROUP_CONCAT(fn:string-join((?addr, ?nickname), "\u001f"), "\u001e") WHERE { ?contact nco:hasAffiliation [ nco:hasIMAddress ?addr ] . ?addr nco:imNickname ?nickname . }) AS ?nicknames WHERE { { ?part nco:hasIMAddress ?address . ?contact nco:hasAffiliation [ nco:hasIMAddress ?address ] . } UNION { ?part nco:hasPhoneNumber [ maemo:localPhoneNumber ?number ] . ?contact nco:hasAffiliation [ nco:hasPhoneNumber [ maemo:localPhoneNumber ?number ] ] . }} }) AS ?contacts rdf:nil fn:string-join((nmo:messageSubject(?_lastMessage),nielainT extContent(?_lastMessage)),"\u001e") nfo:fileName(nmo:fromVCard(?_lastMessage)) rdfs:label(nmo:fromVCard(?_lastMessage)) rdf:type(?_lastMessage) AS ?_type nmo:deliveryStatus(?_lastMessage) AS ?_deliveryStatus ?_lastModified nmo:sentDate(?_lastMessage)WHERE { { SELECT ?channel ?_lastDate ?_lastModified ?part ( SELECT ?_message WHERE { ?_message nmo:communicationChannel ?channel . ?_message nmo:isDeleted false . ?_message nmo:sentDate ?messageSentDate . } ORDER BY DESC(?messageSentDate) DESC(tracker:id(?_message)) LIMIT 1) AS ?_lastMessage WHERE { GRAPH <commhistory:message-channels> { ?channel a nmo:CommunicationChannel . } ?channel nmo:lastMessageDate ?_lastDate . ?channel nie:contentLastModified ?_lastModified . ?channel nmo:hasParticipant ?part . } }}ORDER BY DESC(?_lastDate)"
QTrackerDirectUpdateResult: QSparqlError(-1, "", 0) "INSERT OR REPLACE { GRAPH <commhistory:message-channels> { <conversation:12> a nmo:CommunicationChannel } <conversation:12> nie:subject "/org/freedesktop/Telepathy/Account/ring/tel/ring" ; nie:identifier "0" ; nie:title "" ; nmo:hasParticipant [rdf:type nco:Contact; nco:hasIMAddress <telepathy:/org/freedesktop/Telepathy/Account/ring/tel/ring!Nokia>] ; nie:generator "Nokia" ; nmo:lastMessageDate "1970-01-01T00:00:00Z"^^xsd:dateTime ; nie:contentLastModified "2012-01-03T21:13:46Z"^^xsd:dateTime . } INSERT SILENT {<telepathy:/org/freedesktop/Telepathy/Account/ring/tel/ring!Nokia> a nco:IMAddress ; nco:imID "Nokia"}"
I have 3972 events!

Quote & Reply |

JanMalte	2012-01-03 , 21:19
Posts: 28 \| Thanked: 2 times \| Joined on Feb 2010 @ Mannheim	#7

Just ignore what i have just posted. I used the deb file and everything went fine. Thanks for your work.

1.) Just install the deb file posted above
3.) Make a backup on your N900
4.) Copy the el-v1.db from the packed backup file to /home/user on you N9
5.) Run the code below on your N9

Code:

 /usr/bin/n900-comhist-import el-v1.db

Quote & Reply |

Active Topics

Sailfish OS for the Motorola Moto G7 Power (XT1955-5) - (ocean) (3)

The N900 is now 15 years old! (6)

F(x)tec Pro1x (QWERTY) for sale (0)

n770 youtube video (0)