Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Transfer Greek Outlook Contacts Database to Evolution
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Greek
View previous topic :: View next topic  
Author Message
ktsaou
n00b
n00b


Joined: 10 Jul 2003
Posts: 63

PostPosted: Tue Dec 09, 2003 12:19 am    Post subject: Transfer Greek Outlook Contacts Database to Evolution Reply with quote

To transfer an Outlook Contacts Database to Evolution, the official way is (from the Evolution FAQ):

    1. Export contacts from Outlook to DOS CSV
    2. Move the file to Linux and use the csv2vcard program to create a .vcf file
    3. Import the file to Evolution

Although this works, it does not handle Greek characters correctly, because Evolution expects everything in UTF-8.

Solution:
Follow the procedure above with the following exceptions:

    1. export the contacts from outlook to WINDOWS CSV (not DOS CSV).
    2. Instead of using csv2vcard, use the supplied script (see bellow).
    3. Import the generated file to Evolution and enjoy Greek contacts...

The program to be used instead of csv2vcard is:

Code:

#!/bin/sh

if [ ! -f "$1" ]
then
   echo "USAGE: $0 file"
   echo "Output will be created at file.vcf"
   exit 1
fi

in="$1"
tmp="/tmp/`basename $in`.tmp"
log="/tmp/vcf$$.log"

cvs2vcard="/usr/libexec/evolution/1.4/csv2vcard"
if [ ! -x "${cvs2vcard}" ]
then
   echo "Where is cvs2vcard?"
   exit 1
fi

cset="ISO-8859-7"

echo "Converting CSV to VCF in $tmp, log in $log"
date >$log
"${cvs2vcard}" "$in" "$tmp" >>$log 2>&1


cat $tmp |\
   sed "s/^N:/N;CHARSET=$cset:/"      |\
   sed "s/^FN:/FN;CHARSET=$cset:/"      |\
   sed "s/^ADR:/ADR;CHARSET=$cset:/"   |\
   sed "s/^ADR;/ADR;CHARSET=$cset;/"   |\
   sed "s/^TITLE:/TITLE;CHARSET=$cset:/"   |\
   cat >$in.vcf

rm $tmp
rm $log


Costa
Back to top
View user's profile Send private message
ksenos
Apprentice
Apprentice


Joined: 06 Nov 2003
Posts: 164
Location: Athens, Greece

PostPosted: Tue Dec 09, 2003 8:14 am    Post subject: Reply with quote

Εγώ τα έκανα με λίγο διαφορετικό τρόπο. Τα έκανα export σε csv και στην συνέχεια με το gnumeric (ή άντε, άντε με το excel :lol: ) διόρθωσα και πρόσθεσα κάποια πραγματακια.

Στην συνέχεια πήγα στα contacts του mozilla και έκανα import το csv (θέλει μια μικρή αντιστοιχεία στα δεδομένα) και απο εκεί έκανα export σε ldiff format.

Τέλος έκανα το ldiff import στο evolution.

Αυτά.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Greek All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum