CSV import includes quotes

J

Jon Sherry

I've been trying to get a large set of Contacts into Entourage. The
problems are the email addresses, and the notes field.

Entourage does a great job of importing Now Contacts, except for the
email address field, where gobs of data go missing. This suggests a
text import.

On top of this, every available field is used in Now Contact, and since
the fields in Now and Entourage don't entirely jive, I brought
everything into Filemaker to concatenate data as necassary.

The cleanup went fine. However, because the notes field has Paragraph
marks, I need to import as CSV with quotes as text qualifiers.
Filemaker exports fine, but Entourage imports the data with all the
quotes, which is useless.

I might import with Outlook for Windows, but the field mappings are
different. 9 of the Custom fields were used in Now Contact, and
Entourage has 8. Outlook 2002 for Windows has only 4 custom fields,
plus other extra fields. I don't have time to experiment to see how the
data lines up in Entourage and Outlook when they're both using an
Exchange Mailbox.

And of course, the custom fields weren't used consistantly over the 8
years of life, so this is just about making sure all the data is
visible in Entourage, the main mail client to be used.

Any ideas on the CSV import into Entourage 10.1.4?

Thanks,
-jb
 
P

Paul Berkowitz

I've been trying to get a large set of Contacts into Entourage. The
problems are the email addresses, and the notes field.

Entourage does a great job of importing Now Contacts, except for the
email address field, where gobs of data go missing. This suggests a
text import.

On top of this, every available field is used in Now Contact, and since
the fields in Now and Entourage don't entirely jive, I brought
everything into Filemaker to concatenate data as necassary.

The cleanup went fine. However, because the notes field has Paragraph
marks, I need to import as CSV with quotes as text qualifiers.
Filemaker exports fine, but Entourage imports the data with all the
quotes, which is useless.

I might import with Outlook for Windows, but the field mappings are
different. 9 of the Custom fields were used in Now Contact, and
Entourage has 8. Outlook 2002 for Windows has only 4 custom fields,
plus other extra fields. I don't have time to experiment to see how the
data lines up in Entourage and Outlook when they're both using an
Exchange Mailbox.

And of course, the custom fields weren't used consistantly over the 8
years of life, so this is just about making sure all the data is
visible in Entourage, the main mail client to be used.

Any ideas on the CSV import into Entourage 10.1.4?
Click to expand...

Get my scripts Export-Import Entourage X from

MacScripter.net <http://macscripter.net/scriptbuilders/>

You can import contacts, calendar, tasks, notes. I was pretty sure you could
export from NUD as tab-text rather than .csv. If so, you might even manage
OK without the scripts. Or use the "Other Converters". If they must be CSV,
you can try two possible approaches with the scripts: use the Outlook
converters as "Non-English" to convert to .txt. But that may have a few
oddities due to the fact that they were designed for imports from Windows.
Better would be to open the files in Excel, then use the Excel Clean Save
Text to save, or even the Excel Import Adapter (more fuss) if need be.

--
Paul Berkowitz
MVP Entourage
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Entourage you are using - **2004**, X
or 2001. It's often impossible to answer your questions otherwise.
 
Top