Skip to content

Major bugs importing CSV with commas or newlines in text columns #9

Open
@acoulson2000

Description

I ran into some major bugs when importing CSV files that contain commas or newlines in text columns - the existing parsing just did simple splitting on commas and newlines and did not take into account the totally valid possibility that such character might exist between quotes in text columns. I submitted a pull request for my branch, which does much more sophisticated parsing of the CSV, keeping track of the opening and closing quotes that are required around such text when present in a CSV. I also added a MysqlLogger implementation, since I needed a persistent import audit trail.

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions