Blank fields not being exported

  • Resolved huskyracer

    (@huskyracer)


    2 years, 5 months ago

    Hi guys

    I’m exporting submissions and fairly certain I’ve updated Forminator since I created my original test form.
    My issue is that the csv submission export doesn’t contain ‘blanks’ for empty fields in the form which means that when I open it in Excel, none of the data is in the correct columns where fields have been left blank.

    Any ideas please?
    Many thanks
    Steve

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support Jair – WPMU DEV Support

    (@wpmudevsupport15)

    Hi @huskyracer,

    I hope you are doing well today!

    1- Open blank excel sheet or any sheet you want to add the data, go to Data->From Text/CSV
    https://prnt.sc/SzWRkq9fNpEr
    2- Choose the Forminator CSV export file and import
    3- Click Load and import values as columns including the blank submissions
    https://prnt.sc/PgiUAAHROVit
    4- Result – https://prnt.sc/GO0LiKGQj5zu

    Kind regards,
    Zafer

    Thread Starter huskyracer

    (@huskyracer)

    Hi Zafer

    Thanks for your speedy response.
    I did try this yesterday and again this orning but it’s still not putting data in the correct columns
    https://prnt.sc/cZ_737CLQARR
    The entry amounts shown in Col S and T should be in column AT
    https://prnt.sc/stTyVke4C69b

    Many thanks for your help!
    Steve

    Hi there,

    I’m experiencing this bug as well. When you have a field as optional (e. g. you don’t show it if a certain drop down value is selected), the export does not insert a “,” for this empty field.

    Example:
    Title (Mr,Ms,Family)
    Firstname (this is only shown in case of Mr or Ms)
    Lastname

    Export (today, wrong):
    Mr,John,Smith
    Ms,Kate,Hudson
    Family,Mayer

    Correct would be:
    Family,,Mayer

    Plugin Support Nebu John – WPMU DEV Support

    (@wpmudevsupport14)

    Hi @huskyracer,

    @xampit

    Sorry for the inconvenience caused because of this. It is a known bug that our developers are already aware of and are currently working on a fix.

    As a quick workaround, we recommend reverting the plugin version to 1.18.2.

    You can find the previous version via the following URL under “Previous Versions”:
    https://www.ads-software.com/plugins/forminator/advanced/

    Kind Regards,
    Nebu John

    Yep, saw this “fix” in another thread. 1.18. is working as expected (expect of date including a “,” in language German which causes trouble with the comma separation, but that’s addressed in another thread as well).

    Thank you for the good work anyways ?? Apart from the bugs I really like your plugin.

    Plugin Support Nebu John – WPMU DEV Support

    (@wpmudevsupport14)

    Hi @xampit,

    Glad to know that you like using our plugin ??

    Please make sure to open a new ticket of your own when you need assistance next time. Have a good day!

    Kind Regards,
    Nebu John

    Thread Starter huskyracer

    (@huskyracer)

    I’ve just done the rollback and it works a dream.
    Thank you so much for your help guys and also @xampit for contributing as well.

    Great work guys!

    Hello !

    I have the same issue here but I can’t rollback as I’ve used a lot of group field, witch arent included in the 1.18 version.

    Can I expect you guys to resolve this soon ?

    Thank you !

    Plugin Support Williams – WPMU DEV Support

    (@wpmudev-support8)

    Hi @anthonyflibustiers

    The fix is already being tested and if it passes tests it’s expected to be included in version 1.22 release.

    Kind regards,
    Adam

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Blank fields not being exported’ is closed to new replies.