01-20-2010 05:38 AM
I am experiencing difficulty in uploading Notes (from an Excel file) during the initial Load of records into Act. Some notes do load, but most do not during the update process. All other fields load properly (ncluding User Fields) but the Notes are not being recognized from the Mapping process. Is there a mapping or upload step that I am missing? Any suggestion is welcomed.
01-20-2010 10:44 AM
What version of ACT!?
Do you just have one Excel column for the Notes?
01-20-2010 07:57 PM
01-21-2010 09:46 AM
I am using an Excel File with 2 columns labeled Note 1 & Note 2. Then in the IMPORT process, I have mapped those 2 Note fields from the Excel file to be imported (matched) to the "Add Act Notes" field in Act. During this same Import Process, all other Excel Fields have been mapped simiilarly to designated Act fields (inclusive of User Fields) and have all successfully been imported. The Note1 and Note 2 fields from the Excel file are the only fields not successfully loaded.
01-22-2010 01:24 AM
Pretty sure the import to Notes only works with ONE field. Try only assigning one column to the Notes and see it that works.
Also, as it's importing as CSV, if the Note field has commas or quotes, it can throw out the data
02-19-2010 11:26 AM
This article has instructions for cleaning up the data you are importing. If it contains special characters it will fail to import: importing Outlook notes into Act!