Calling Developers!
We are reenergizing our code contribution process! Learn More

What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

On Windows machines, Excel can save CSV files using `;` as the separator character instead of `,`

Options
USDAKA3PD
USDAKA3PD Posts: 34 🧑🏻‍🚀 - Cadet

On Windows machines, Excel can save CSV files using ; as the separator character instead of , as it would be normal, so users will get an Invalid format. error when trying to upload the quick order(problem present on https://www.de.b2b.demo-spryker.com/en/quick-order also). It is kind of difficult to tell to all the customers that they should be careful how they save the files. Also the auto_detect_line_endings should be enabled in php.ini ( auto_detect_line_endings = On ) or used init_set
ini_set("auto_detect_line_endings", "1"); in \Spryker\Service\UtilCsv\Reader\FileReader::readFile to solve the issue of different line endings.

Comments

  • UKHD8KTMF
    UKHD8KTMF Posts: 393 🧑🏻‍🚀 - Cadet
    Options

    for a project we built a preview so that a customer could pick the delimiter

  • UKHD8KTMF
    UKHD8KTMF Posts: 393 🧑🏻‍🚀 - Cadet
    Options

    when you have international customers and CSVs from different sources that is the best way

  • USDAKA3PD
    USDAKA3PD Posts: 34 🧑🏻‍🚀 - Cadet
    Options

    how about the auto_detect_line_endings, how did you solved that, in php.ini or at runtime with init_set ?

  • UKHD8KTMF
    UKHD8KTMF Posts: 393 🧑🏻‍🚀 - Cadet
    Options

    can't remember that this was an issue to be honest. And we had CSV generated from both windows and linux

  • UQJBF1UKW
    UQJBF1UKW Posts: 5 🧑🏻‍🚀 - Cadet
    Options

    There are many more problems with excel, also around encoding and special characters

  • UQJBF1UKW
    UQJBF1UKW Posts: 5 🧑🏻‍🚀 - Cadet
    Options

    GoogleDocs and Openoffice are more reliable

  • UQJBF1UKW
    UQJBF1UKW Posts: 5 🧑🏻‍🚀 - Cadet
    Options

    Excel will cause a lot of headaches

  • UKHD8KTMF
    UKHD8KTMF Posts: 393 🧑🏻‍🚀 - Cadet
    Options

    excel is a nightmare, we ended up using cloudconvert to get proper CSVs out of it

  • e.g. good old byte order mark ... what a pleasure