Import contacts from outlook
I do have a problem importing Contacts from MS Outlook (2000 as well as 2003).
I do have German Outlook.
I create a CSV File of my contact data in outlook and choose to import a csv in outlook format within OX.
First Time I got problems with the Birthday and the Anniversary field and nothing would be imported.
So I choose them not to be exported in outlook.
This time I got some entries imported, but for example the email was not imported.
I do have the following fields related to eMail within the CSV:
Angezeigter Name, E-Mail n
Adresse, E-Mail n
Type, E-Mail n
with n from 1 to 3.
Probably, I have to change these field names - but into what?
OK - I've found the OutlookCSV Format description - and it fits my data.
But why is the E-Mail field not imported?
are there maybe more than one e-mail addresses or any "special" think like a empty e-mail address field?
Within this set of contacts I try to import for test reasons, not all of the entries do have an e-mail address, but non of them does have more than one.
Originally Posted by Martin Braun
Within the "real" data, there will be some entries with more than one address...
During the import, I get the following error message:
Error code: Could not find the following fields [Position, Straße geschäftlich 2, Straße geschäftlich 3, Straße privat 2, Straße privat 3, Weitere Straﬂe 2, Weitere Straße 3, Benutzer 1, Benutzer 2, Benutzer 3, Benutzer 4, Büro, E-Mail-Adresse, E-Mail-Typ, E-Mail: Angezeigter Name, E-Mail 2: Typ, E-Mail 2: Angezeigter Name, E-Mail 3: Adresse, E-Mail 3: Typ, E-Mail 3: Angezeigter Name, Empfohlen von, Geschlecht, Hobby, Initialen, Internet-Frei/Gebucht, Konto, Ort, Postfach geschäftlich, Postfach privat, Priorität, Privat, Regierungs-Nr., Reisekilometer, Sprache, Stichwörter, Verzeichnisserver, Weiteres Postfach] (I_E-0803,-297405692-97)
I set up a test entry at Outlook and filled all 3 e-mail addresses.
The first and the third are ignored during the import - the 2nd one is imported as "private" e-mail address...
Finally, I think I found an error in "GermanOutlookMapper.java"
The Field which will be stored into "ContactField.EMAIL1" is named "Abrechnungsinformationen" - but shouldn't be "E-Mail-Adresse"?
But even if I change the .CSV File so there is "Abrechnungsinformationen" instead of "E-Mail-Adresse", the import goes wrong...
And "E-Mail 3: Adresse " (shouldn't this be "E-Mail 3: Adresse" without a space?) seems to be correct - but not imported...
And another try ;-)
If I rename the Fields "E-Mail-Adresse" and "E-Mail 3: Adresse" into "Abrechnungsinformationen" and "E-Mail 3: Adresse ", the import is not successfully and I get the message
"Error code: Could not find the following fields:[Abrechnungsinformationen,E-Mail 3: Adresse ] (I_E-0803,-297405692-330)"
But if I rename the E-Mail address fields in e.g. "Telex" and "Name Assistent", the addresses are imported and shown on the 3rd Page of the contacs information...
Could please someone help me out? I am driving nuts with this
Am I in the wrong forum with my question?
Or is this an unusual problem?
Or one, which is allready solved and put into FAQ?
- but I didn't found it...
confirmation for behaviour
Hi forum, hi diwa,
i can confirm this behaviour.
I am using Outlook 2003 german.
Exporting the contacts to csv (windows) and importing the csv in OX results in this problem:
Only "Email 2" is imported as "private mail".
Email 1 and Email 3 are ignored.
The csv contains the following mail fields in the first line:
Find the full first line attached.
"E-Mail-Adresse","E-Mail-Typ","E-Mail: Angezeigter Name","E-Mail 2: Adresse","E-Mail 2: Typ","E-Mail 2: Angezeigter Name","E-Mail 3: Adresse","E-Mail 3: Typ","E-Mail 3: Angezeigter Name"
I also tried to rename the fields like in http://www.open-xchange.com/wiki/ind....22contacts.22 but had no luck
I am not German, but I did figure out the easiest way I could import my outlook contacts was to save them as CVS and then just write a PHP script that created a vcard file with all the contacts in it. You'll have to compensate for the locations of items in each row but here's the code I wrote.
//this will take a comma separated file and create a vcf file.
$username="user"; //this is used to name the file that is created.
$filename="user.csv"; //this is the comma separated file you are getting contacts from
$fp = fopen($filename,"r");
//use this line for outlook
//list($first,$last,$email,$comp,$title,$street,$city,$state,$zip,$ctry,$bizph,$ph,$cell,$fax,$note)=explode(",",fgets($fp)); //gets data until linebreak and splits it on ,
//use this line for webmail
list($short,$first,$last,$email,$note)=explode(",",fgets($fp)); //gets data until linebreak and splits it on ,
header("Content-Disposition: attachment; filename=".$username."_contacts.vcf");
foreach($ctc[$i] as $v)
Last edited by rcable; 12-01-2008 at 05:18 PM.
Reason: copied from terminal which didn't show full lines.