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
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.
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.