Prevent Confiforms import API for multi-value fields from removing quote-escaped commas on import?

Wade Meredith_p7kpr9

I am importing a CSV file using the Confiforms import API. When I import field types that are NOT multi-value fields, my strings that are double-quote-escaped and include commas import correctly, but when the target field is a multi-value field, the importer strips out commas from the same double-quote-escaped strings.

String as rendered in the CSV file:

"additionalType,alternateName,description,disambiguatingDescription,identifier,image,mainEntityOfPage,name,numberOfBeds,potentialAction,sameAs,subjectOf,typeOfBed,url",

String as shown in the import API mapping screen:

additionalType,alternateName,description,disambiguatingDescription,identifier,image,mainEntityOfPage,name,numberOfBeds,potentialAction,sameAs,subjectOf,typeOfBed,url

Result when mapped to a text field:

additionalType,alternateName,description,disambiguatingDescription,identifier,image,mainEntityOfPage,name,potentialAction,sameAs,subjectOf,supersededBy,url

Result when mapped to a multi-value field:

additionalTypealternateNamedescriptiondisambiguatingDescriptionidentifierimagemainEntityOfPagenamenumberOfBedspotentialActionsameAssubjectOftypeOfBedurl

 

Alex Medved _ConfiForms_

Hi

You need to use " as quote character and wrap your multi-select values into quotes ("")

Or consider using Excel files as a source for your data to import

 

Updated:

---

This seems to be a bug in CSV parsing. We will fix it asap and will try to include a fix into https://wiki.vertuna.com/display/CONFIFORMS/Release+Notes#ReleaseNotes-Version2.13.9

---

Alex