Importing Windows Mobile contacts - Revision history

114.79.55.81: /* Updated script with more fields */

2010-12-07T10:11:47Z

Updated script with more fields

← Older revision		Revision as of 10:11, 7 December 2010
Line 124:		Line 124:
	The mapping is arbitrary, adjust to each need/usage.		The mapping is arbitrary, adjust to each need/usage.

	Replace (pay attention to the ~~star~~ and end of the row) above with this code below.		Replace (pay attention to the start and end of the row) above with this code below.

	<source lang="python">		<source lang="python">

imported_>amigadave: use

2010-12-06T10:17:11Z

use <source>

← Older revision		Revision as of 10:17, 6 December 2010
Line 3:		Line 3:
	To import data, we need a backup file created by the approach mentioned in [[Importing data]], the script mentioned in the end of this page and a [[Nokia N900\|N900]] (or another Maemo5 device). Power users don't need to follow this precisely, others do:		To import data, we need a backup file created by the approach mentioned in [[Importing data]], the script mentioned in the end of this page and a [[Nokia N900\|N900]] (or another Maemo5 device). Power users don't need to follow this precisely, others do:

	# connect N900 to PC using mass storage mode; from PC, create a directory "datatransfer" on the "flash disk device" - and copy the script (pimbackup2vcf.py) and backup file (e.g. PIMBackup_20091220.pib) to the directory. Unmount and disconnect.		# connect N900 to PC using mass storage mode; from PC, create a directory "datatransfer" on the "flash disk device" - and copy the script (<code>pimbackup2vcf.py</code>) and backup file (e.g. PIMBackup_20091220.pib) to the directory. Unmount and disconnect.
	# on N900, run xterm		# on N900, run xterm
	# <pre>cd /home/user/MyDocs/datatransfer; python pimbackup2vcf.py PIMBackup_20091220.pib contacts.vcf</pre>		# <pre>cd /home/user/MyDocs/datatransfer; python pimbackup2vcf.py PIMBackup_20091220.pib contacts.vcf</pre>
Line 11:		Line 11:
	== pimbackup2vcf.py ==		== pimbackup2vcf.py ==

	<~~pre~~>		<source lang="python">
	#!/usr/bin/python2.5		#!/usr/bin/python2.5
	# -- coding: utf-8 --		# -- coding: utf-8 --
Line 112:		Line 112:

	os.remove(TMPFILENAME)		os.remove(TMPFILENAME)
	</~~pre~~>		</source>

	== Extending the script ==		== Extending the script ==
Line 126:		Line 126:
	Replace (pay attention to the star and end of the row) above with this code below.		Replace (pay attention to the star and end of the row) above with this code below.

	<~~pre~~>		<source lang="python">
	def csvline2vcf(row):		def csvline2vcf(row):
	rv=""		rv=""
Line 160:		Line 160:

	return rv		return rv
	</~~pre~~>		</source>

	== Note ==		== Note ==
	If on the Windows Mobile (WM 6.5.3) the address has a hard return character, the resulting vcf will have broken address field (hard return instead of one row). User might want to review this using text editor first prior to importing.		If on the Windows Mobile (WM 6.5.3) the address has a hard return character, the resulting vcf will have broken address field (hard return instead of one row). User might want to review this using text editor first prior to importing.

imported_>anagarika: /* Extending the script */

2010-12-06T04:46:21Z

Extending the script

@@ Line 118: / Line 118: @@
 The script would, with little modifications, import contacts data from generally any csv file. The csv file has to contain initial line with columns' titles. Data contained in the output VCF file is defined in the '''csvline2vcf(row)''' function - which converts a csv line to a vcf record string.
 [[Category:Power users]]
 [[Category:HowTo]]

imported_>amigadave: Category:HowTo

2010-03-18T08:17:15Z

Category:HowTo

← Older revision		Revision as of 08:17, 18 March 2010
Line 1:		Line 1:
	== Import how to ==		== Import how to ==

	To import data, we need a backup file created by the approach mentioned in [[Importing data]], the script mentioned in the end of this page and a N900 (or another Maemo5 device). ~~Powerusers~~ don't need to follow this precisely, others do:		To import data, we need a backup file created by the approach mentioned in [[Importing data]], the script mentioned in the end of this page and a [[Nokia N900\|N900]] (or another Maemo5 device). Power users don't need to follow this precisely, others do:

	# connect N900 to PC using mass storage mode; from PC, create a directory "datatransfer" on the "flash disk device" - and copy the script (pimbackup2vcf.py) and backup file (e.g. PIMBackup_20091220.pib) to the directory. Unmount and disconnect.		# connect N900 to PC using mass storage mode; from PC, create a directory "datatransfer" on the "flash disk device" - and copy the script (pimbackup2vcf.py) and backup file (e.g. PIMBackup_20091220.pib) to the directory. Unmount and disconnect.
Line 119:		Line 119:

	[[Category:Power users]]		[[Category:Power users]]
			[[Category:HowTo]]

128.97.245.52: /* pimbackup2vcf.py */

2010-02-05T03:04:05Z

pimbackup2vcf.py

← Older revision		Revision as of 03:04, 5 February 2010
Line 54:		Line 54:
	def csvline2vcf(row):		def csvline2vcf(row):
	rv=""		rv=""
	rv=~~rv+~~"BEGIN:VCARD"+'\n'		rv+="BEGIN:VCARD"+'\n'
	rv=~~rv+~~"VERSION:3.0"+'\n'		rv+="VERSION:3.0"+'\n'
	rv=addne(rv, "N:", csvf(row, "Name"))		rv=addne(rv, "N:", csvf(row, "Name"))
	rv=addne(rv, "FN:", csvf(row, "First Name")+" "+csvf(row, "Last Name"))		rv=addne(rv, "FN:", csvf(row, "First Name")+" "+csvf(row, "Last Name"))
Line 72:		Line 72:
	rv=addne(rv, "BDAY:", convdate(csvf(row, "Birthday")))		rv=addne(rv, "BDAY:", convdate(csvf(row, "Birthday")))
	rv=addne(rv, "X-ANNIVERSARY:", convdate(csvf(row, "Anniversary")))		rv=addne(rv, "X-ANNIVERSARY:", convdate(csvf(row, "Anniversary")))
	rv=~~rv+~~"END:VCARD"+'\n'+'\n'		rv+="END:VCARD"+'\n'+'\n'

	return rv		return rv
Line 87:		Line 87:
	zf=zipfile.ZipFile(sys.argv[1])		zf=zipfile.ZipFile(sys.argv[1])

	contactsFN=[fn for fn in zf.namelist() if ~~(fn.find(~~'contacts'~~)!=-1)~~][0]		contactsFN=[fn for fn in zf.namelist() if 'contacts' in fn][0]


Line 105:		Line 105:
	if lineNo==0:		if lineNo==0:
	csv_fields=row		csv_fields=row
	lineNo=~~lineNo+~~1		lineNo+=1
	else:		else:
	vcf.write(csvline2vcf(row))		vcf.write(csvline2vcf(row))

imported_>amigadave: add category

2010-02-04T13:30:18Z

add category

← Older revision		Revision as of 13:30, 4 February 2010
Line 117:		Line 117:

	The script would, with little modifications, import contacts data from generally any csv file. The csv file has to contain initial line with columns' titles. Data contained in the output VCF file is defined in the '''csvline2vcf(row)''' function - which converts a csv line to a vcf record string.		The script would, with little modifications, import contacts data from generally any csv file. The csv file has to contain initial line with columns' titles. Data contained in the output VCF file is defined in the '''csvline2vcf(row)''' function - which converts a csv line to a vcf record string.

			[[Category:Power users]]

imported_>andree: /* Import how to */ link to parent fixed

2009-12-13T09:35:01Z

Import how to: link to parent fixed

← Older revision		Revision as of 09:35, 13 December 2009
Line 1:		Line 1:
	== Import how to ==		== Import how to ==

	To import data, we need a backup file created by the approach mentioned in [[~~Data transfer~~]], the script mentioned in the end of this page and a N900 (or another Maemo5 device). Powerusers don't need to follow this precisely, others do:		To import data, we need a backup file created by the approach mentioned in [[Importing data]], the script mentioned in the end of this page and a N900 (or another Maemo5 device). Powerusers don't need to follow this precisely, others do:

	# connect N900 to PC using mass storage mode; from PC, create a directory "datatransfer" on the "flash disk device" - and copy the script (pimbackup2vcf.py) and backup file (e.g. PIMBackup_20091220.pib) to the directory. Unmount and disconnect.		# connect N900 to PC using mass storage mode; from PC, create a directory "datatransfer" on the "flash disk device" - and copy the script (pimbackup2vcf.py) and backup file (e.g. PIMBackup_20091220.pib) to the directory. Unmount and disconnect.
Line 8:		Line 8:
	# start addressbook app, from the menu choose ''Get contacts'' and ''Import contacts file'' in the following popup. Choose the contacts.vcf file in datatransfer directory.		# start addressbook app, from the menu choose ''Get contacts'' and ''Import contacts file'' in the following popup. Choose the contacts.vcf file in datatransfer directory.
	# You should have the contacts imported. :)		# You should have the contacts imported. :)


	== pimbackup2vcf.py ==		== pimbackup2vcf.py ==

imported_>andree: initial version of script + usage info

2009-12-13T09:34:20Z

initial version of script + usage info

New page

== Import how to ==

To import data, we need a backup file created by the approach mentioned in [[Data transfer]], the script mentioned in the end of this page and a N900 (or another Maemo5 device). Powerusers don't need to follow this precisely, others do:

# connect N900 to PC using mass storage mode; from PC, create a directory "datatransfer" on the "flash disk device" - and copy the script (pimbackup2vcf.py) and backup file (e.g. PIMBackup_20091220.pib) to the directory. Unmount and disconnect.
# on N900, run xterm
# <pre>cd /home/user/MyDocs/datatransfer; python pimbackup2vcf.py PIMBackup_20091220.pib contacts.vcf</pre>
# start addressbook app, from the menu choose ''Get contacts'' and ''Import contacts file'' in the following popup. Choose the contacts.vcf file in datatransfer directory.
# You should have the contacts imported. :)

== pimbackup2vcf.py ==

<pre>
#!/usr/bin/python2.5
# -*- coding: utf-8 -*-

import zipfile
import csv
import sys,os
import codecs

def unicode_csv_reader(unicode_csv_data, dialect=csv.excel, **kwargs):
# csv.py doesn't do Unicode; encode temporarily as UTF-8:
csv_reader = csv.reader(utf_8_encoder(unicode_csv_data), dialect=dialect, **kwargs)
for row in csv_reader:
# decode UTF-8 back to Unicode, cell by cell:
yield [unicode(cell, 'utf-8') for cell in row]

def utf_8_encoder(unicode_csv_data):
for line in unicode_csv_data:
yield line.encode('utf-8')
unicode_csv_data.close()

def csvf(row, f):
try:
i=csv_fields.index(f)
except:
return ''

return row[i]

def convdate(d):
if len(d)<8:
return ''
return d[0]+d[1]+d[2]+d[3]+'-'+d[4]+d[5]+'-'+d[6]+d[7]

def addne(s, pre, post):
if post=="":
return s;
else:
return s+pre+post+'\n';

def csvline2vcf(row):
rv=""
rv=rv+"BEGIN:VCARD"+'\n'
rv=rv+"VERSION:3.0"+'\n'
rv=addne(rv, "N:", csvf(row, "Name"))
rv=addne(rv, "FN:", csvf(row, "First Name")+" "+csvf(row, "Last Name"))
rv=addne(rv, "NICKNAME:", csvf(row, "NickName"))
rv=addne(rv, "TEL;TYPE=CELL,VOICE:", csvf(row, "Mobile Phone"))
rv=addne(rv, "TEL;TYPE=WORK,VOICE:", csvf(row, "Business Phone"))
rv=addne(rv, "TEL;TYPE=WORK,VOICE:", csvf(row, "Business Phone 2"))
rv=addne(rv, "TEL;TYPE=HOME,VOICE:", csvf(row, "Home Phone"))
rv=addne(rv, "TEL;TYPE=HOME,VOICE:", csvf(row, "Home Phone 2"))
rv=addne(rv, "EMAIL;TYPE=PREF,INTERNET:", csvf(row, "E-mail Address"))
rv=addne(rv, "TEL;TYPE=WORK,VOICE:", csvf(row, "Work Phone"))
rv=addne(rv, "URL:", csvf(row, "Web Page"))
if csvf(row, "Home City")!="":
rv=addne(rv, "ADR:;;", csvf(row, "Home Street")+';'+csvf(row, "Home City")+';'+csvf(row, "Home State")+';'+csvf(row, "Home Postal Code")+';'+csvf(row, "Home Country"))

rv=addne(rv, "BDAY:", convdate(csvf(row, "Birthday")))
rv=addne(rv, "X-ANNIVERSARY:", convdate(csvf(row, "Anniversary")))
rv=rv+"END:VCARD"+'\n'+'\n'

return rv

TMPFILENAME="/tmp/contacts.csc"

if len(sys.argv)<3:
print sys.argv[0], " PIMbackupfile.pib output.vcf"
sys.exit()

print "Processing", sys.argv[1]

zf=zipfile.ZipFile(sys.argv[1])

contactsFN=[fn for fn in zf.namelist() if (fn.find('contacts')!=-1)][0]

tmpfile=open(TMPFILENAME, 'w')

tmpfile.write(zf.read(contactsFN))

tmpfile.close()

cf=unicode_csv_reader(codecs.open(TMPFILENAME, 'r', "utf-16"), delimiter=';', quotechar='"')

vcf=codecs.open(sys.argv[2], 'w', "utf-8")

lineNo=0

for row in cf:
if lineNo==0:
csv_fields=row
lineNo=lineNo+1
else:
vcf.write(csvline2vcf(row))

vcf.close()

os.remove(TMPFILENAME)
</pre>

== Extending the script ==

The script would, with little modifications, import contacts data from generally any csv file. The csv file has to contain initial line with columns' titles. Data contained in the output VCF file is defined in the '''csvline2vcf(row)''' function - which converts a csv line to a vcf record string.