Notices


Reply
Thread Tools
Posts: 21 | Thanked: 15 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: 460 | Thanked: 665 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 God knows how MUCH I hate my Lumia work phone. And not even God knows why and how Micro$oft made something as terrible as Windows Phone OS

- Sailing happily with Jolla, Having fun with N9, Madly frustrated with Lumia and feeling bad for N900 that is so seldom turned on.

- "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: 21 | Thanked: 15 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: 61 | Thanked: 150 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: 169 | Thanked: 329 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: 21 | Thanked: 15 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: 21 | Thanked: 15 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: 61 | Thanked: 150 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: 4,930 | Thanked: 14,757 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.
__________________
In particle accelerators atoms are indeed not only touching each others. But banging together in a massive explosive orgasm.
-- nieldk in a TMO post
 

The Following 2 Users Say Thank You to pichlo For This Useful Post:
Posts: 57 | Thanked: 89 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 19:47.