Import csv with blank cells

If you think that something doesn't work in Aware IM post your message here
Post Reply
JoshK131
Posts: 31
Joined: Tue Jan 26, 2021 11:09 pm

Import csv with blank cells

Post by JoshK131 »

Hello,

I am trying to import a csv using an import template from the front end side.

Below is a sample of a csv

Contact ID, Contact Name, Detail 1, Detail 2, Detail 3
11111, John Smith,,,
22222, Mohamad Lee,"","",""
33333, Peter Parker, "",,

Of the 3 rows above, only row 1 will be imported.

It seems to have trouble importing when the row contains empty double quotes.

Is there any way to work around this?
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Work around

Post by Jaymer »

Use text editor, find/replace all the “” to null/empty string
Then the import will work
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Post Reply