Ignoring blanks in csv files #1737
-
Hi, Any thoughts on the best way to handle empty lines in csv files when importing? Sometimes when converting excel to csv there are empty lines at the bottom of the file that need to deleted manually. For example
I think a simple check in before_import_row could maybe work, if all fields are empty ignore row. Any better ideas? Would a PR to include this functionality + config option be considered? Thanks |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 2 replies
-
There is a similar question here. Like you say, I would recommend override |
Beta Was this translation helpful? Give feedback.
There is a similar question here. Like you say, I would recommend override
before_import
orbefore_import_row
to sanitize the data. I would consider a PR to enable this with a setting on the resource for the v4 release (see release-4 branch). Alternatively documenting best practice would be ok.