gobbles

importing from CSV file errors

Discussion created by gobbles on Nov 21, 2012
Latest reply on Nov 22, 2012 by gobbles

I am creating a CSV file with google app scripts and then importing this into filemaker pro 11.

 

the format is something like:

 

timestamp,firstname,lastname,dob,comment,...etc

 

for an example like:

 

Tue Oct 30 2012 15:35:39 GMT+1100 (EST),john,doe,31/1/1930/,I really like choc chip cookies, etc

 

It works perfectly.

 

Because there are several comment fields that allow multiple lines on the user form however, some times google scripts spits out a CSV of the form:

 

Tue Oct 30 2012 15:35:39 GMT+1100 (EST),john,doe,31/1/1930/,I really

like

choc

chip

cookies, etc

 

When the later is imported into filmaker pro 11 I am seeing a new record being produced for each line. In cases where there is a blank line an entire blank record is being produced.

 

Is there a way for me to fix this internally in filemaker pro or do I have to solve the problem at the google script end?

 

thanks for any help!

Outcomes