Address Cleanse CSV

Discuss your general Proclaim related queries here.
gav76
Posts: 9
Joined: Wed May 20, 2015 9:22 am
Has thanked: 1 time

Address Cleanse CSV

Post by gav76 »

Hi
I need to do a bulk clean up of our address book. I was hoping to export to Excel, do my cleanup in there, then import back in.

I know that there is the AFD Cleanse service available but we don't want to use DX going forward.

I thought that I may be able to use the Cleanse Service Export / Import functions to do what I wanted, but when I came to import back in, Proclaim was expecting additional columns in my CSV. Does anyone know what the spec for the import CSV is, so I can import "cleansed" data back in to the address book?

thanks
Andrew

steve
Posts: 446
Joined: Wed Nov 30, 2011 10:20 pm
Been thanked: 105 times

Re: Address Cleanse CSV

Post by steve »

Hi,
look in "v3.2 New Technical Features and Enhancements" manual. p78 shows the impoted CSV structure

gav76
Posts: 9
Joined: Wed May 20, 2015 9:22 am
Has thanked: 1 time

Re: Address Cleanse CSV

Post by gav76 »

Brilliant, thanks Steve!