CSV export has mismatch between headers and data

  • Resolved ascdev

    (@ascdev)


    3 years, 9 months ago

    When I export user data, the CSV file is invalid because there is a single mismatch between header columns and data columns.
    All the headers and data upto column ~76 is correct – the header matches the data.
    But after this column, there is 1 extra column in the header that does not appear in the data. Most strange.
    A simple workaround is to manually edit the CSV file and delete the extra header field (it typically has not data associated with in anyway).

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Javier Carazo

    (@carazo)

    @ascdev,

    I have never seen this case.

    Are you using LibreOffice Calc to open the file? Or Microsoft Excel?

    Microsoft Excel has problems sometimes with CSV and create this kind of problems.

    Thread Starter ascdev

    (@ascdev)

    OK, problem sorted.

    The issue was caused by residual data in the database from a deleted plugin.
    All the redundant data now deleted and the problem has gone away.

    For interest, the CSV file being generated contained an additional copy of “display_name” field in the middle of the old plugin fields. There were no corresponding fields in the data rows.
    I assume having duplicate column names was the issue.

    Plugin Author Javier Carazo

    (@carazo)

    @ascdev,

    Yes, we have to fix it… this is not usual, but it can appear.

    Thanks for your research in next release we will include ?? to avoid this kind of problems.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘CSV export has mismatch between headers and data’ is closed to new replies.