Problem in importing from an MySql-database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rune Myhr - 21 Sep 2007 12:40 GMT

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.

Reply to this Message

Brian Tillman - 21 Sep 2007 15:22 GMT

> 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.

Signature

Brian Tillman [MVP-Outlook]

Reply to this Message

Karl Timmermans - 21 Sep 2007 17:09 GMT

#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

> Hi
> I have created a database of members from a web-site which stores data in
[quoted text clipped - 15 lines]
> of
> many.

Reply to this Message