Bug importing .csv files with ' in field values

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • marcusquinn
    Senior Member
    • Jan 2021
    • 133

    Bug importing .csv files with ' in field values

    There seems to be a bug importing .csv files with ' in field values, and LibreOffice/OpenOffice won't save .csv files with every field quote delimited.

    Attached a file for you to test with.
    Attached Files
  • yuri
    Member
    • Mar 2014
    • 8495

    #2
    Would be good if you provided more details with the bug report.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment


    • marcusquinn
      marcusquinn commented
      Editing a comment
      True, sorry, I thought you might just see if ' is an escaped character.

      It seems that everything updates up to the point of the first ' character, so I'm guessing it's prematurely ending the function loop.

      If that doesn't help I'll come back with the entity design packaged as well to test with.
  • marcusquinn
    Senior Member
    • Jan 2021
    • 133

    #3
    Solved with the source data instead, which is reasonable: In Libre Office, use Save a copy... > Edit filter settings > Quote all text fields = Ticked.

    It seems strange that isn't done by default and appears not to work with Save As... but it seems to work.

    Comment

    • yuri
      Member
      • Mar 2014
      • 8495

      #4
      I tried to import the attached file and it imported well. Didn't test all fields though. Country names were OK.
      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

      Comment


      • marcusquinn
        marcusquinn commented
        Editing a comment
        Thanks. I'm going to make all of that data into an Extension Pack to share with the community at some point. I want to build out the relationships for Regions / Zones / Languages and link them nicely first.
    Working...