Columns data moves every 1000 rows

  • whaleman

    (@whaleman)


    4 years, 9 months ago

    I am trying to download data from one of my forms. There are several thousand entries.

    When I open the file in Excel I’ve noticed that every 1000 entries, the column headings are repeated in a row but three of the columns swap round making the data impossible to filter.

    So for instance 3 columns headed address, date, optin change to optin, date, address.

    Then after another 1000 entries they swap back again.

    The data is all fine and there are no issues with it when it is also exported automatically to my main database.

    Wondering what is causing this? Thanks

    • This topic was modified 4 years, 9 months ago by whaleman.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Arshid

    (@arshidkv12)

    4 years, 9 months ago

    I will check it soon.

    chrissmyth

    (@chrissmyth)

    4 years, 9 months ago

    Hi Arshid,

    It looks like the issue here may be that binary fields, such as checkboxes, don’t have an off state stored in the JSON output. If they are not checked they are just not included. This means that some fields are entirely missing from the output for some records. This then throws the CSV output off because the field is there if it is checked, but not there if it isn’t.

    Can you let me know if this is the case and if there’s a way of correcting this?

    Thanks
    Chris

    Plugin Author Arshid

    (@arshidkv12)

    4 years, 9 months ago

    Please note, this plugin has no json option.
    Please check you installed this plugin or not.
    Upload CSV to google drive and check it.

    chrissmyth

    (@chrissmyth)

    4 years, 9 months ago

    Hi, sorry for the confusion – JSON seems to be how the form data is being stored in the database (in the db7_forms table, in the form_value field)… If a checkbox field has not been checked on the CF7 form then it looks like the field is omitted altogether from the data. It looks like the CSV export is including the field if it is checked and omitting the field if it’s not checked… This means that the fields run out of order in the csv export.

    Plugin Author Arshid

    (@arshidkv12)

    4 years, 9 months ago

    Can you see check box on wp-admin (if unchecked)?

    Add default option.
    Example: default:1

    • This reply was modified 4 years, 9 months ago by Arshid.
Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Columns data moves every 1000 rows’ is closed to new replies.