Hi all,
I have been trying desperately to get the Constituent Import to work and I can’t figure out what the issue is. I have formatted the file according to the guidelines (it’s a .txt with a space reserved for the customer number). The error I keep getting is:
Error = [Microsoft][SQL server Native Client 10.0]String data, right truncation
I have checked through the procedure and looked at the data types and their corresponding partners in TW_CONSTITUENT_IMPORT and everything looks fine. I have also done a character count for each column that has data to be imported and none of them go over. SQL forums online suggest creating a brand new table…I figured this seemed a little weird and not a particularly good solution.
Does anyone know what could be causing this and how I can fix it?
Thanks for any help, driving me bonkers…..
Natasha
P.S. We are still on V10
Natasha, I think you have prepared the Excel file first. IN V10 the last columns of the Excel must be:
Q Day_phone R Eve_phone S E_address T Constituent_typeU Customer_no
Then you should save the file as a txt, tab-delimited. Could you open the txt file with a text editor which sows invisible characters, for instance with MS Word? Then check out that all the tab characters are presented before the Carriage Return (Line brake) character -- Please find my example of a right format, in MS Word. I suspect the last column "Customer_no" (blank is OK) was missing in your file.
Thanks,
Simon
sbasyuk@carnegiehall.org
Ah! That was it...those invisible characters really do cause allot of very visible trouble.
Thanks so much Simon!