Hi all,
I've been running in circles with a Constituent Import. Every time I make some progress, I run into a new error. This one has gotten me stuck and I haven't heard back from Support in awhile, so I thought I'd post it here
I assume this has something to do with the formatting of the txt data file, possibly a special character that it doesn't like? I have been able to successfully import smaller chunks of this dataset, but I cant narrow down what is throwing this larger error. Has anyone run into this one before or have an idea on where to start so I can identify it? Many thanks!
-Grant
'Would be truncated' means too many characters in a field. If you're not using a custom import format, you can find the maximum number of characters for each field in this (MAX_LENGTH=) https://www.tessituranetwork.com/Help_System/Content/Constituent%20Import/Preparing%20the%20Constituent%20Import%20Format%20File.htm and then look for things that exceed the max length(s), including possibly spaces. I think spaces count here.