Data Source excel file does not upload all cell data with unlimited character length

[JENNIFER OCAMPO]

Hello!!

I create large batches of Incidents to the INC table via data sources then scheduled imports.  My Data Source is excel files and everything is mapped and gets uploaded correctly with the exception of a singled column of data.  The data takes only the first sentence and not the rest of the data in those cells, gets cut off.

I checked the rules for that field at it was changed from 40 character to 4,000...to basically allow for all cell content to be mapped to that Incident field.  

The excel file format is set to "General" for those cells.  I did find/replace any line breaks in those cells thinking that was causing the issue but the issue persists.

How should excel files be formatted, what symbols or characters should the cells not have, so all data is Loaded into the Data Sources then to Scheduled Imports?

Many thanks!

Jen O. 

[Tony Chatfield1]

Hi, did you check both the source (import) and destination table field sizes?
Text is the best excel formatting option if the field contains special characters, this should result in the content being encapsulated in double quotes "my text".
Personally I try to avoid double quotes and commas within a text field, otherwise as long as the content is from a character set that excel recognizes I don't think you should have any issues - if data is copied\pasted from different sources it is possible that this will result in unrecognized characters that will look visually correct but be something different.
if in doubt and having issues I would start using CSV format for your import, and once successful look at using an excel variation.