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.
I'd recommend opening your import file in Notepad++ and turning on View > All Characters as their may be invisible padding in some cells (non-breaking spaces etc) that might trip you up.
If you are using a custom XML file as the template it'll be in your Prod drive (look in TR_IMPORT_CONTRIBUTION_SET Format File column for the pathway).
Thanks Heath, I thought it might be the invisible padding or whitespace but I don't see anything out of the ordinary when I open in Notepad++ with that setting. Its just frustrating the error wont tell you where to look in your data file.
Agree that it is likely to be the field with too many characters...I had this error recently and it was due to the "city" field being too many characters in one record. I hope that helps!
yep.Sometimes it can be a character is being interpereted as a carriage return and one or 2 data lines aer split across 2 rows.
Sometimes it's a foreign address with a state field that shouldn;t be there or a sublt unicode character that screws things up.
I've removed ----{,_,"> and , to name just a couple you probably would've already noticed by now, and really not unusual to find everything offset by a field, especially if there's bots or autofilling involved. And BTW, rats are OK in CSI, but are not.
What' the biggest import you have done? I'm looking at 10k records here.