Openmoko - User contributions [en]

Import Vcf Contacts

2008-09-10T14:33:46Z

David Hicks: Add ASU addressbook purging details

== Import for 2007.2 ==
=== Basic Information ===

Neo FreeRunner uses Evolution data server (eds) to save contacts.
However, the specific version used differs from what is probably used on your desktop (if you have Evolution installed).

You ''cannot'' copy your addressbook.db from your desktop to Neo ([http://docs.openmoko.org/trac/ticket/1119 bug 1119]).

=== Import and Manage Scripts ===

If you want to import your old contacts to the Neo you could use this script:

[http://www.smurfy.de/files/neo/manage-contacts Manage Contacts script] [http://www.placard.fr.eu.org/~roland/tmp/manage-contacts.py mirror]

If you first want to remove all existing contacts you could use this script.

[http://www.smurfy.de/files/neo/remove_all_contacts remove all script]

If you have all contacts in seperate vcf files and just want to import all at once:

[http://www.smurfy.de/files/neo/ac Simple script]

[http://www.smurfy.de/files/neo/import_contacts Simple script for one big contactsfile]

(please add a .py after the filename, sorry my hoster gives an error if i link to .py files, even .py.txt)

In the simple scripts you need to add the following lines
ps = os.popen ('ps auxwwwwe | grep -m 1 DBUS_SESSION_BUS_ADDRESS')
l = ps.read ()
r = re.compile ('DBUS_SESSION_BUS_ADDRESS=(\S+)')
m = r.search (l)
a = m.expand ('\\1')
os.environ ['DBUS_SESSION_BUS_ADDRESS'] = a

=== Exporting old contacts to VCard format ===

To use the manage Script you need your Contacts in VCF format.

# on nokia phones i used the nokia phone manager (long time ago)
# on windows mobile phones you could use active sync to sync with Outlook and then use a Outlook export plugin to export as vcf
# on lg phones the backup function to memory card creates one file with multiple VCards.

=== Exporting from Outlook / ActiveSync to VCF ===

Doing a quick google I was unable to find a free export plugin for outlook (they all seem to want between $19.95 and $49), so I put together some quick-and-dirty VB code to do it. To use it, Open Outlook, then open the VB editor by pressing ALT-F11, Insert a module, and paste in the following. Change "Z:\Openmoko\contacts" to wherever you want your vcf files saved (should be an existing, empty directory), and press F5 to run it.

'''Code:'''

<pre>

Sub ExportContactsToVCF()

'Cheap and nasty way to export All Contacts to VCF files.
'By Dale Maggee, antisol (at) earthling (dot) net

Dim CN As ContactItem
Dim NS As NameSpace
Dim Fld As MAPIFolder

Set NS = Application.GetNamespace("MAPI")
Set Fld = NS.GetDefaultFolder(olFolderContacts)

For Each CN In Fld.Items
Debug.Print CN.FullName
CN.SaveAs "z:\Openmoko\contacts\" & CN.FullName & ".vcf", olVCard
Next CN

MsgBox "Done!"

End Sub
</pre>

voila! you now have multiple VCF files in whatever directory you chose, suitable to be imported by the python script below.

=== Usage ===

The script is for the 2007.2 Version (default install on Neo FreeRunner), not for Qtopia

You need Python to use this script so do a

opkg install python-dbus

to install python and the python dbus module

==== Manage Contacts Script ====

'''This script needs all contacts in one big file'''

'''You also could run this script on a ssh session!'''

# Copy your big contacts file (contacts.txt) to your Neo
# Copy script to your Neo
# Connect via ssh to your Neo
# Fix special chars in your contacts file with you favorite text editor
# To import the file run on the SSH shell:

python manage-contacts.py load < contacts.txt

# For a backup your existing contacts on the Neo

python manage-contacts.py dump > contacts.txt

==== Simple Script ====

'''You must run the script in the OM Terminal, not over ssh'''

The script does a listdir and imports ALL files it found in that dir. (i'm a bad python programmer)

# Copy all vcf files to a separate directory on my freerunner
# Copy the ac script to the parent directory also on my freerunner
# Have the contacts program running (so you have eds running too)
# Go to the terminal on the freerunner and type in the vcf directory: "python ../ac" (root@om-gta02:~/vcf# python ../ac)
## Note: '''You must call the script in the OM terminal''' not via Bluetooth or USB or you get a dbus error. Using "dbus-launch python ../ac" doesn't work either.
# Done :D

==== Troubleshooting ====
* Make sure you have python and python-dbus installed
* Make sure you have no illegal chars (utf) in the filename and inside the vcf files. (I had problems with Ü,Ä etc)
** The characters seem to work if you convert them from =C3=A4 type of format to proper UTF-8, and the vcards also specify UTF-8 charset. you cannot use other charsets besides UTF-8 since they are delivered via DBus which does not allow others.
* Only vcf files should be in your current directory so do a ../ac.
* You must call the script in the OM terminal not via Bluetooth or USB. If you do so a dbus error occur

=== Authors ===
* Simple script by smurfy - phil <openmoko at smurfy.de>
* Manage Contacts script by Roland Mas <lolando at debian.org>
* Remove all Contacts script / simple script for one big file by Andreas Dalsgaard <andreas.dalsgaard at gmail.com>

Thanks to [[Import_Sim_Contacts]] for the original Python Script.

== Import for ASU/Qtopia ==
The Qtopia addressbook application supports import of VCF files out of the box. However, since there is a bug, if there are non-ASCII characters in your contacts you cannot use the version 3 format, otherwise you get multibyte UTF-8 characters mangled. Use the version 2.1 to get the encoding stated explicitly and thus characters imported correctly. But because there is another bug, when using version 2.1 vCards, the addressbook eats up all memory (and potentionally crashes the system) on ''some'' vCards with multiline entries.

If you're connected via SSH, run the following command first:
export DISPLAY=:0

''(So that the addressbook will show on your phone. If you do not that and try to run addressbook locally on your computer display, you won't be able to use the application since the needed buttons will not show.)''

Then you can simply run:
addressbook path_to_vCards_file_to_import.vcf

You will be asked if you want to import the contacts form addressbook.vcf (the contact name will be taken from the "N:" vCard field).

To import a huge number of contacts, single .vcf files can be merged together using cat *.vcf > all.vcf, than import all.vcf

''Tip: If you want to prevent crashing your system if the memory leak occurs, set some limit on memory available to use, so that only the addressbook application dies after reaching the limit. I.e. prior to running the import, do something like:''
ulimit -v 50000

If the above does not work, here are the original import guidelines:

To import your address book from VCard format (ASU/<=Qtopia 4.3.2-080808 snapshot):
LD_LIBRARY_PATH=/opt/Qtopia/lib /opt/Qtopia/bin/addressbook /home/root/addressbook.vcf

To import your address book from VCard format (>=Qtopia 4.3.2 stable):
LD_LIBRARY_PATH=/opt/Nokia/Qtopia/lib /opt/Nokia/Qtopia/bin/addressbook /home/root/addressbook.vcf

===Mass Delete===

The Qtopia addressbook doesn't seem to have a delete all function, which means that botching a vcf import is a painful process to undo through the phone gui.

If you want to delete your entire addressbook or do other mass edits then you'll need access to a command line or GUI SQLite client (SQLite Database Browser seems to be a good, free one, though the SQLite command line client should be fine). Shutdown Qtopia and use the client you have chosen to open up /home/root/Applications/qtopia_sqlite.db

Important tables -
{|cellspacing="0" border="1" cellpadding="5"
| contacts
| Contact names and other descriptive information, plus a unique id (recid)
|-
| contactphonenumbers
| A list of contact phone numbers matched to recid
|-
| contactaddresses
| Links address information to recid
|}

Restart Qtopia when you're done and you should have a reset addressbook.
[[Category:Advanced End User]]

Talk:Import Vcf Contacts

2008-09-10T14:14:24Z

David Hicks: /* Delete all script for ASU? */

'''Exporting your contacts from Thunderbird'''

Get "MoreFunctionsForAddressBook" from
http://nic-nac-project.de/~kaosmos/morecols-en.html

Install the downloaded *.xpi file in Thunderbird.
Export your address books to a file in Vcf format.
"scp" the text file containing your contacts to somewhere in your phone.
run phyton script.
Works beautifully!.

This can be expanded to a howto. Let me know what you think.
Cheers, Saul

== Import for ASU/Qtopia ==

If Contacts loads but no confirm dialogue appears try renaming the file to .vcf.<br>
I was trying to do this with a .txt file and changing it to .vcf made it work as described.

== Delete all script for ASU? ==

The remove all script returns an error on ASU -
dbus.exceptions.DBusException: org.freedesktop.DBus.Error.Spawn.ExecFailed: dbus-launch failed to autolaunch D-Bus session: Autolaunch requested, but X11 support not compiled in.

is there an ASU friendly version?

Edit - Qtopia uses an SQLite database and that should be edited to achieve this.

Talk:Import Vcf Contacts

2008-09-08T15:19:49Z

David Hicks:

Openmoko Local Groups: London

2008-08-01T11:11:57Z

David Hicks:

Welcome to OpenMoko London!

Beer and Neo anyone?

{|border=1
!Name (IRC nick)
!Skills
!Interest
!Location
!Device owned
|-
|[[User:jptmoore|John Moore]]
|C/Scheme
|Application development
|Pinner
|[[Image: Moko.jpg|center]]
|-
|Alex
|Java,Perl,Python
|User & developer
|Hampshire
|
|-
|[[User:Phlash|Phil Ashby]]
|C/C++/Java /Embedded/Hardware
|Kernel & Application development
|Felixstowe
|[[Image: Moko.jpg|center]]
|-
|John Cass
|Java,C
|User & developer
|London
|[[Image: Moko.jpg|center]]
|-
|[[User:TonyGarnockJones|Tony Garnock-Jones]] (tonyg)
|C, assembly, Erlang, Scheme, ML, Haskell, Smalltalk, ...
|User & developer
|London
|[[Image: Moko.jpg|center]]
|-
|[[User:ThomasWood|Thomas Wood/OpenedHand]]
|C, GTK+ developer
|User & developer
|London
|[[Image: Moko.jpg|center]] [[Image: MokoBox.jpg|center]] + GTA02 (FreeRunner Prototype)
|-
|[[User:Stephmw|Steph Meslin-Weber]]
|Java (J2ME), C, User Experience, Interface prototyping
|User, developer and general busybody
|London
|-
|[[User:WebJames|James Olney]]
|General experience
|User
|Oxford
|Wanted Freerunner perhaps get into a 10pack group]
|-
|[[User:chrestomanci|David Pottage]]
|Perl, Java (J2se), C
|User & developer
|Reading
|Freerunner
|-
|[[User:vermoos|Michael Nandris]]
|Python/Plone ethusiast, interest in DPA (1998)
|User, developer
|London, Camden
|Wanted Freerunner perhaps get into a 10pack group]
|-
|[[User:Weiss|Weiss]]
|C, GTK+, ARM Assembly, Perl, TCL
|User, developer
|Cambridge
|Wanted Freerunner [perhaps get into a 10pack group]
|-
|[[User:TimW|TimW]]
|C++
|User, developer
|Pinner
|Freerunner
|-
|[[User:Menno|Menno Smits]]
|Python, C, GTK+
|User, apps development
|London
|Freerunner
|-
|[[User:David_Hicks|Dave]]
|C, SSL/TLS, POSIX threading
|User, apps development
|London
|Freerunner
|}

Key:
[[Image: Moko.jpg]] = GTA01
[[Image: MokoBox.jpg]] = Debug board

See [[Talk:OpenMoko_Local_Groups:_London|discussion]]
[[Category:Community]]
[[Category:Openmoko Local Groups]]

User:David Hicks

2008-08-01T11:11:37Z

David Hicks: About me

Hullo.

I'm Dave and I 'm a Linux user.

I think I have a problem, the Freerunner is now the 10th Linux device I own or look after. I'm hooked. I even have a Debianised NSLU2 under the bed.

And now I'll have linux with me everywhere I go. Just what I needed....

== Techie Stuff ==

I'm a Software Engineer with CS degree, been working in C (with bits of C++, Python, Java etc) since 2000.

I've worked mostly on server software of various sizes and purposes, though also on point-of-sale EMV card transaction processing. The things that bring me most joy in programming are cryptography, secure comms (SSL/TLS) and multithreaded programming.

I don't know exactly what I can bring to Openmoko as I'm not the most GUI oriented kind of guy, but we'll see eh?

User:David Hicks

2008-08-01T11:03:27Z

David Hicks: Initial version