Reply
Thread Tools
Posts: 22 | Thanked: 18 times | Joined on Oct 2012
#1
Dear forum, having an Xperia X and running SailfishX on it, I am still wondering for what would be an easy way to get my old contacts, out of a contacts.db file.

There is this question: https://together.jolla.com/question/...to-do-with-it/

I still did not manage to make it work. Is there any workaround to export the contacts as vcf files, from the db file? Then, import.

Thank you for any hints, Nikos
 

The Following 2 Users Say Thank You to Nikos Alexandris For This Useful Post:
Posts: 498 | Thanked: 836 times | Joined on Jun 2012 @ Finland
#2
Originally Posted by Nikos Alexandris View Post
Dear forum, having an Xperia X and running SailfishX on it, I am still wondering for what would be an easy way to get my old contacts, out of a contacts.db file.

There is this question: https://together.jolla.com/question/...to-do-with-it/

I still did not manage to make it work. Is there any workaround to export the contacts as vcf files, from the db file? Then, import.

Thank you for any hints, Nikos
If you are ok with using google, could you not sync them with your google account and them re-sync and import them to your new device?
__________________
- "Only two things are infinite, the universe and human stupidity, and I'm not sure about the universe."
- Albert Einstein
 

The Following 2 Users Say Thank You to Boxeri For This Useful Post:
Posts: 22 | Thanked: 18 times | Joined on Oct 2012
#3
Originally Posted by Boxeri View Post
If you are ok with using google, could you not sync them with your google account and them re-sync and import them to your new device?
Thanks. I am not using Google services. There is an old account. I'd prefer not to use it though.

However, you mean I can import/upload the db file in Google's contact-whatever the service is?

I really have only this db file. It's from a Jolla 1.

Worst case, to avoid going manually over all contacts: shouldn't it be scriptable to read the db, export as csv, format properly then as vcf?
 

The Following 2 Users Say Thank You to Nikos Alexandris For This Useful Post:
Posts: 177 | Thanked: 427 times | Joined on Sep 2017
#4
From reading the link it's an sqlite database so you can do with that as you please, including opening it using the sqlite command on a computer and exporting to CSV.

Edit: Had a look - this file handles way more than just contacts as its name suggests! What part(s) are you trying to keep?

Last edited by suicidal_orange; 2017-11-04 at 22:13.
 

The Following 3 Users Say Thank You to suicidal_orange For This Useful Post:
Posts: 233 | Thanked: 532 times | Joined on Sep 2011
#5
The easiest option is to create a backup from your old device and restore it in the new one.

Another option is to unzip the backup file and extract /People/data/all.vcf which then can be imported into the new device.

contacts.db lives in /home/nemo/.local/share/system/Contacts/qtcontacts-sqlite directory but I suspect it will not run directly in another device.
 

The Following 3 Users Say Thank You to pagis For This Useful Post:
Posts: 22 | Thanked: 18 times | Joined on Oct 2012
#6
Originally Posted by suicidal_orange View Post
From reading the link it's an sqlite database so you can do with that as you please, including opening it using the sqlite command on a computer and exporting to CSV.

Edit: Had a look - this file handles way more than just contacts as its name suggests! What part(s) are you trying to keep?
Yes, I have seen the file myself and it's more than just contacts. Ideally, I would love to transfer the contacts as they are. I have SMSes and the communication history already transferred successfully.
 

The Following 2 Users Say Thank You to Nikos Alexandris For This Useful Post:
Posts: 22 | Thanked: 18 times | Joined on Oct 2012
#7
Originally Posted by pagis View Post
The easiest option is to create a backup from your old device and restore it in the new one.

Another option is to unzip the backup file and extract /People/data/all.vcf which then can be imported into the new device.

contacts.db lives in /home/nemo/.local/share/system/Contacts/qtcontacts-sqlite directory but I suspect it will not run directly in another device.
The "backup" way does not apply in my case. I have had only this *emergency* copy of the db and the rest of the files in the same directory.
 

The Following 2 Users Say Thank You to Nikos Alexandris For This Useful Post:
Posts: 177 | Thanked: 427 times | Joined on Sep 2017
#8
So just names, numbers and e-mail addresses? That shouldn't be too hard to get out using some sql, though converting to vcf looks messy. I'll have a play tomorrow...
 

The Following 3 Users Say Thank You to suicidal_orange For This Useful Post:
pichlo's Avatar
Posts: 6,445 | Thanked: 20,981 times | Joined on Sep 2012 @ UK
#9
Originally Posted by pagis View Post
contacts.db lives in /home/nemo/.local/share/system/Contacts/qtcontacts-sqlite directory but I suspect it will not run directly in another device.
I do not know about another device but I have definitely restored my contacts using instructions here after a factory reset, having nothing but the contacts.db file.

The key might be to copy the file whilst the services that would otherwise use it are not running. Which means in Recovery Mode. Then reboot and you are in the game.

As I said, I have not tried it between devices but I find it hard to believe that it would be much different.
__________________
Русский военный корабль, иди нахуй!
 

The Following 2 Users Say Thank You to pichlo For This Useful Post:
Posts: 65 | Thanked: 110 times | Joined on Jun 2015 @ Berlin
#10
Originally Posted by pichlo View Post
As I said, I have not tried it between devices but I find it hard to believe that it would be much different.
well, making a backup file and importing it, didn't work from Jolla1 to JollaC, both updated recently, so running 2.1.3.7

It really worked flawlessly from nokia to nokia symbian, just lay both phone side by side, push the button and voilá new phone old contacts...

should be possible to keep one's data across sailfish phone without having to use google, shouldn't it!
 

The Following 5 Users Say Thank You to alfredquack For This Useful Post:
Reply

Tags
contacts, sailfish, sqlite

Thread Tools

 
Forum Jump


All times are GMT. The time now is 10:44.