Problem in importing from an MySql-database

[Guest]

Hi
I have created a database of members from a web-site which stores data in a
MySql-database.

I am having some difiiculties in exporting these data from MySql into office
2007 Contacts. I have tried to first export the data from MySql to a .csv
file and import the csv file into contacts. I am then getting an error saying
something like ( freely translated from norwegian ) : An fileerror occured in
translating values....

Is there any possibilities to directly link databasefields to contact-fields
in outlook 2007. It would be so much easier to maintain one list instead of
many.

 

[Brian Tillman]

I am having some difiiculties in exporting these data from MySql into
office 2007 Contacts. I have tried to first export the data from
MySql to a .csv file and import the csv file into contacts. I am then
getting an error saying something like ( freely translated from
norwegian ) : An fileerror occured in translating values....

Perhaps if you were to export an existing Outlook Contacts folder to a CSV
and compare that to the CSV MySql generated, you'd see what might be wrong.

Is there any possibilities to directly link databasefields to
contact-fields in outlook 2007. It would be so much easier to
maintain one list instead of many.

I believe this is not possible.

 

[Karl Timmermans]

#1 - Re: direct connection to MySQL - answer is "no" using Outlook's import
wizard

#2 - Out of curiousity, does your CSV file contain a header row (a single
row containing column names?)

#3 - At what point exactly is this error message occuring? When mapping
fields? Or once import has started?

If it's at the field mapping stage, then you most likely have an issue with
the construction of the CSV file. If it's during the actual import phase,
likely problem is due to the contents of a field within one or more rows.
Are any contacts being imported at all? If yes, then your problem should be
easily traceable to the contact in your database (CSV file) that immediately
follows the last successfully imported contact.

#4 - Just some side questions/comments...........

a) if you're planning on repeatedly importing data from the database -
Outlook has no facility to "update" fields in pre-existing contacts. Just a
FYI item.

b) if you have the appropriate MySQL ODBC driver installed on your system -
ContactGenie DataPorter does support importing from MySQL (however - there
are no current plans to continue MySQL support in the next major release of
CGD). You may want to try the eval version of CGD to import the CSV file
created to see what if any errors occur since CGD is much more resilient and
tolerant the Outlook import wizard -
Info: http://www.contactgenie.com/cg20features.htm -
Download: http://www.contactgenie.com/cg20dlorder.htm

Karl

___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com