Importing CSV

Discuss your general Proclaim related queries here.
Niamh91
Posts: 11
Joined: Mon May 20, 2019 11:37 am

Importing CSV

Post by Niamh91 »

Hi

I have set up a directory monitoring task to import new leads into Proclaim from a CSV file and create a new lead.

It imports it but the CSV file always has a header which I cant see an option for this task to ignore the header when importing unless I do it manually each time which isn't going to work for us. So when the task runs, it sets up a new lead using the header details aswell.

Also, when it imports the details from the CSV, it inputs them into the Proclaim fields in Quotation Marks.

Has anyone had this same issue and managed to resolve it?

Thanks

Archais
Posts: 13
Joined: Wed Jul 31, 2019 2:15 pm

Re: Importing CSV

Post by Archais »

Hi

Try the extra instruction ExcludeHeaderLine on the import job, or if the header is always the same you could put a field description test (something like TEST, IV = "ExampleHeader" , IgnoreCase) on the data template - field descriptions are detailed further in the Tech 4 Manual.

I've only seen the Quotation Marks a couple of times - usually when the field has a tab or carriage return, and wouldn't know where to start (other than by getting the data cleansed before import while it's still in the CSV) to fix that...