Quick Question re:Constituent Import Utility

Hi Rog,

It'll probably be putting quotation marks around any field which has a comma in it.  This is often a bit frustrating for addresses.  In the past, I've done a bit of post import clean-up via SQL.

Grae

Hi Graeme,

Hope you're well. Yes - the test ones I did included commas. Cheers - at least now I know the cause.

Rog

This is only a guess to the cause.

My guess is that in one of your street1 fields, and it could be in any row, you have a comma “,”. Wherever you are getting the data is seeing this and converting your CSV into what is really a quote comma “,” separated file to “protect” that comma in your data.

I could be completely wrong. But is worth a hard look at your source data.

--Tom Brown
Business Analytics mgr

Brooklyn Academy of Music BAM
Peter J. Sharp Building
30 Lafayette Ave
Brooklyn, NY 11217

www.BAM.org

Tbrown@bam.org
718-724-8135



On Wed, Apr 27, 2016 at 8:35 AM, Rog Hildreth wrote:

I'm just testing out the Constituent Import utility in advance of a large import of Organisation-style constituent records... any idea why it would put the text for street1 in speech marks? street2 and all other areas are going in as normal.

I've never had this issue before, but have only imported on Individual style constituent records, not Organisations. Can't see what would cause this to be added.

Thanks,
Rog



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!