[yoswalt]

Hello, has anyone done data import before? From File menu -> Import -> From File... -> Updating existing prospects -> CSV file

Fields like Address, Business Address, etc allow multiple lines, the documentation says using Paragraph Mark to separate lines. I am pulling data from Oracle database, I tried chr(10), chr(11), chr(12), chr(13) and chr(46). Chr(10) and Chr(13) cause carriage return and you can see separate lines in the address field when viewing CSV files, but at the last step of the Researcher's Edge import, chr(10) and chr(13) messed up the layout of the records.

Does anyone know which ascii character(s) I should use as paragraph mark to make the import work? I would appreciate your help. Meanwhile, I will try and contact Blackbaud's technical staff too about this. I will let everyone know what I find out too.

I know this is a blackbaud user society. Hope I am posting my message at the right place. Is there a technical support forum? I just started my new job, I am new to Blackbaud products.

Thanks,
Yun