Hello,
So i'm trying to do this import, right :)
Columnm 26 should be Standardized Zip+4 with a max Lenght of 5! hehe, oops, but to make matters worse, i had to dig into the table structure of TW_NCOA_INCOMING to find that the field is limited to 9 characters, which means that little hyphen is a problem too.
I'm getting another truncation error, but least half the data ran this time.
James
I was about to reply that there was an option to strip characters from zips, when I figured I should check and see if that's actually true... turns out, I would have been wrong. I think I'm remembering that from the constituent import utility. Might be a nice feature to add.