CSV file gets modified when saved in a row

Hi,

I noticed a bug with the "file" column type.
When a user fill this type of field, it'll create a copy of it under "AppName"/"TableName"/ (drive folders) which is expected. However I noticed that the newly created file has been modified compared to the original one.

In my case I'm using CSV files, when I upload one to the "file" field and then download it from the drive I can see 9 new lines have been added to my file, always following the same pattern :
A single line of ","","","","","","","","" followed by the last 8 lines of the original csv (starting from the penultimate line).

Though it doesn't seem to happen for smaller csv files, in my case it happens with csv with >=100 lines.

I can link you one of my csv files if you want to reproduce on your side.

0 2 98
2 REPLIES 2

Where is the CSV file generated?   When looking at the original CSV file, make sure there are NO EXTRA ROWS - blank or otherwise - inserted into the generated file.  These WILL be interpreted as file rows.

This is a "comma separated" file.  Make sure that NONE of the field data being inserted into the file has its OWN commas inserted into the data.  These will mess up the column listing in the CSV. 

Lastly, If the above checks out then please confirm/clarify...

...when you UPLOAD the file, is it reflected correctly on the cloud file system?  For example, if it is uploaded to Google Drive, if you go to Google Drive and open the file from there does it reflect the correct CSV file rows or does it already have erroneous rows?


The CSV is generated by the "Delver Lens" mobile app (it scans cards and then outputs the list as a csv).

There're commas in some text elements but this doesn't produce any issue.

However I do see a blank line at the end of my file. Removing it seems to resolve the issue.
Though, I don't really get why the file would be messed up on upload, even if it's content is bad, it should be copied as is.

My file is using Google Drive as the cloud file system, that's how I check if my file is correctly uploaded.
I download the new file from "AppName"/"TableName"/ in my drive and open it in a text editor.

Top Labels in this Space