CSV Archive - pi3g.com

How to restore images for a Shopify product you’ve overwritten accidentally by CSV file

By Maximilian Batz | 2021-08-06

Problem: (wrong handling of CSV files) Yesterday I wanted to bulk-edit products in Shopify, and to change the vendor. I used LibreOffice to select just the rows with the vendor in it, updated it, and uploaded only these updated rows as a new CSV to Shopify. The result was that Shopify dropped many variants, and…

Exception: Unexpected quote at 1:2 (CSV::MalformedCSVError) Crystal

By Maximilian Batz | 2019-01-13

While trying to parse an Amazon pay file, I stumbled across this particular problem: Exception: Unexpected quote at 1:2 (CSV::MalformedCSVError) The reason: Amazon Pay encodes it’s files in UTF-8 with BOM. The BOM is an optional (in UTF-8 files) marker. You can see it with the tool xxd for instance xxd apolish_amazon_2018DecMonthlyTransaction.csv | less The…