search

solidusio-contrib / solidus_importer

Solidus importer extension to migrate data from other eCommerce systems
BSD 3-Clause "New" or "Revised" License
15 stars 30 forks source link

Handle BOM #55

Open jarednorman opened 3 years ago

jarednorman commented 3 years ago

CSVs exported from Excel normally contain a byte-order-marker at the beginning of the file. It manifests as the first column header having invisible characters at the start of it, which will mean that it'll look like "handle" in your console but won't actually be equal to "handle" due to the invisible characters.

There's some info on the issue here: https://estl.tech/of-ruby-and-hidden-csv-characters-ef482c679b35

It's kind of annoying to tell clients to open their CSVs in Numbers.app or Google Sheets and export them from there.

stale[bot] commented 3 years ago

This issue has been automatically marked as stale because it has not had recent activity. It might be closed if no further activity occurs. Thank you for your contributions.

jarednorman commented 3 years ago

Not stale, pal.

stale[bot] commented 3 years ago

This issue has been automatically marked as stale because it has not had recent activity. It might be closed if no further activity occurs. Thank you for your contributions.