I'm currently trying to import a CSV file using Solspace Importer, and I've mostly gotten my issues worked out. However, I have a column in my csv that needs to be imported into a Matrix field consisting of two Text fields (one required). According to the Solspace docs here:
I should be able to wrap my values and comma separate them like so:
But this just imports one row into the Matrix field with the value "Column1Row","Column1Row2","Column1Row3" for the first column. At first I thought it was a parse issue, so I made sure to have my CSV files enclosed in single quotes and use that as the encloser for the import profile, so this segment of the CSV looks like this:
...,'column before matrix column','"Column1Row1","Column1Row2","Column1Row3"','column after matrix column',...
But that doesn't work either. I've tried a myriad of enclosers and quotation depth, as well as various escapements, but it always takes the entire column in as one row. My data is coming from someone who can't use anything but Excel, and his data already required 100's of lines of macro to get right, so trying to interchange to a different data-type and formatting my columns and... well, this is why we want to use a utility like Importer. Does anyone know what CSV format Importer requires to parse into a Matrix field??