Import Vcf Contacts - Revision history

Niebert: /* Mac OS X Addressbook */

2009-08-11T18:02:22Z

‎Mac OS X Addressbook

Glenn: catspec Category:PIM

2009-07-19T16:18:13Z

catspec Category:PIM

Glenn: catchg

2009-07-19T09:21:40Z

catchg

Takke: /* Exporting */

2009-03-25T11:56:43Z

‎Exporting

Vasco: Removed my (now obsolete) contribution

2009-03-10T13:47:06Z

Removed my (now obsolete) contribution

Christz: Added "Import on Om 2008.12".

2009-03-07T11:30:38Z

Added "Import on Om 2008.12".

Loic: need transformation to please the qtopia addressbook program

2009-02-10T11:36:54Z

need transformation to please the qtopia addressbook program

Lucky: /* Exporting old contacts to VCard format */

2009-01-10T00:05:45Z

‎Exporting old contacts to VCard format

Monkeypanic: /* Export raw config (including contacts) with Qtopia */ fixed formatting

2008-12-23T01:32:34Z

‎Export raw config (including contacts) with Qtopia: fixed formatting

Antisol: added note for later versions of QT Extended

2008-12-08T10:37:55Z

added note for later versions of QT Extended

@@ Line 77: / Line 77: @@
 === Mac OS X Addressbook ===
 To export VCF:
-# Set the vCard Format to 2.1 in the config dialog
+# Set the vCard Format to 2.1 in the ''vCard'' config dialog in <tt>Adressbook-/-Preferences</tt>
-# Select all contacts and say "export vcard"
+# Set charset to be utf-8  in the ''vCard'' config dialog in <tt>Adressbook-/-Preferences</tt>
 # Despite having selected the charset to be utf-8 you may need to do:

← Older revision		Revision as of 16:18, 19 July 2009
Line 390:		Line 390:
	Thanks to [[Import_Sim_Contacts]] for the original Python Script.		Thanks to [[Import_Sim_Contacts]] for the original Python Script.

−	[[Category:~~Add-on data~~]]	+	[[Category:PIM]]

← Older revision		Revision as of 09:21, 19 July 2009
Line 390:		Line 390:
	Thanks to [[Import_Sim_Contacts]] for the original Python Script.		Thanks to [[Import_Sim_Contacts]] for the original Python Script.

−	[[Category:~~Advanced End User~~]]	+	[[Category:Add-on data]]

@@ Line 205: / Line 205: @@
 <pre>/home/root/Applications/Qtopia/qtopia_db.sqlite</pre>
-Exporting to VCF can be done via qtmail's 'send all' function (which only supports sms, bluetooth).
+Exporting to VCF can be done via qtmail's 'send all' function (which only supports sms, e-mail, bluetooth).
 You can export all your contacts (with each contact's phone numbers on the same line) with this SQL query. This works because the contactphonenumbers table has limited phone_type values. We can't do the same left outer join query for the emails because there can be an unlimited count of emails per contacts.

@@ Line 205: / Line 205: @@
 <pre>/home/root/Applications/Qtopia/qtopia_db.sqlite</pre>
-Exporting to VCF can be done via qtmail's 'send all' function (which only supports sms, bluetooth). Exporting all the contacts to a VCF file has yet to be documented. Here is [http://lists.openmoko.org/pipermail/community/2008-October/033588.html Vasco Névoa's contribution] to export to a tab-delimited file:
+Exporting to VCF can be done via qtmail's 'send all' function (which only supports sms, bluetooth).
-<pre>
-sqlite3 ~/Applications/Qtopia/qtopia_db.sqlite \
-'Select distinct nickname, title, firstname, middlename, lastname, suffix, \
-profession, b_webpage, company, office, department, jobtitle, default_email, \
-phone_number, h_webpage, spouse, gender, birthday, anniversary from contacts, \
-contactphonenumbers where contacts.recid=contactphonenumbers.recid;'\
-| sed 's/|/\t/g' > addressbook.txt
-</pre>
-Vasco says:
+You can export all your contacts (with each contact's phone numbers on the same line) with this SQL query. This works because the contactphonenumbers table has limited phone_type values. We can't do the same left outer join query for the emails because there can be an unlimited count of emails per contacts.
-<pre>
-Each contact that has more than one phone number will appear multiple
-times because I haven't yet come up with a clean way to show the "join"
-between the "contacts" and "contactphonenumbers" tables, so for now it
-just duplicates the whole line, with the only difference being the phone
-number. Also, this still does not take care of contacts with multiple email
-addresses, so it is just a work in progress (but better than nothing if you're
-in a jam).
-−
-Anyone versed in SQL will be able to hack this into a full VCF file
-generator... or you can just go the Python or Perl way (but I prefer to use
-the nice tools already in place - SQL is pretty powerful if you know how).
-</pre>
-−
-−
 You can export all your contact's phone numbers on the same line with this SQL query. This works because the contactphonenumbers table has limited phone_type values. We can't do the same left outer join query for the emails because there can be an unlimited count of emails per contacts.
 <pre>
 Select distinct nickname, title, firstname, middlename, lastname, suffix,

@@ Line 86: / Line 86: @@
 <code>
 iconv -f latin1 -t utf-8 vCards.vcf | sed 's/CHARSET=LATIN1://g' > all.vcf
 </code>

@@ Line 41: / Line 41: @@
 * Right click and export to Vcf format (or use the Tools menu, Actions for AddressBooks) (If gray, you did not select an addressbook.)
 * Select destination folder
 === Outlook / ActiveSync to VCF ===

@@ Line 6: / Line 6: @@
 # On nokia phones use the Nokia phone manager {{Citation needed}}
 # On windows mobile phones you could use active sync to sync with Outlook and then use a Outlook VCF export plugin below
 # On LG phones the backup function to memory card creates one file with multiple VCards

@@ Line 300: / Line 300: @@
 == Export raw config (including contacts) with Qtopia ==
+<pre>
 scp root@192.168.0.202:~/Applications/Qtopia/qtopia_db.sqlite /tmp/
 sqlite3 /tmp/qtopia_db.sqlite .dump
 Then you can grep the output for your contacts.

← Older revision		Revision as of 10:37, 8 December 2008
Line 126:		Line 126:

	To import your address book from VCard format (ASU/<=Qtopia 4.3.2-080808 snapshot):		To import your address book from VCard format (ASU/<=Qtopia 4.3.2-080808 snapshot):
		+
		+	'''''Note: On later versions of QT Extended, replace /opt/Qtopia with /opt/Trolltech/Qtopia in the instructions below'''''

	<pre>		<pre>