[Plugin: MM Forms] Exported CSV Columns Swapping

  • I’ll do my best to explain:

    I have a form on https://www.wjacweatherblog.com/?page_id=2957 for Weather Spotters to report back. We use that for our weather for our newscasts.

    That information is exported to CSV via MMForms plugin and then we have an excel file that goes and pulls the CSV into it.

    If I change anything in the plugin contact form (even like deleting a record or anything else), the next time it pulls down the data, the columns are all in different places. I’m not sure why this is doing this.

    It breaks all of my formulas when this happens.

    Does anyone have any suggestions?

    Thanks!

    Tim

    https://www.ads-software.com/extend/plugins/mm-forms/

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hello Tim,

    Put the column names in the exported fields field. That way you can keep the same layout when exporting to CSV.

    Tom

    I have the same problem. The order of the fields seem to change randomly. Unfortunately Tom’s suggestion of setting the names for exporting the CSV does not work for me. If I do that I get empty quote marks (“”) instead of data.

    Even if that did work it is not ideal when viewing the data in the backend to have the fields in a different order for each submisssion.

    This is unfortunately not the only bug in what could be a very useful plugin. Perhaps the slogan should be changed to “comes with the power of a tank, but drives like a faulty tank!”

    Richard

    Update: I have found a solution to my CSV export problem. If you specify a delimiter other than a comma, you must use the same delimiter in the list of field names eg for semi-colon “your_name; your_email”.

    Kind of obvious maybe but the documentation, such as it is, specifies commas.

    Richard

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: MM Forms] Exported CSV Columns Swapping’ is closed to new replies.