• Resolved brandonwebfast

    (@brandonwebfast)


    Hi, I just want to say I love your plugin and it has helped me SO MUCH!

    I am just a little bit stuck as a cross road.

    Currently my submissions from CF7 comes out in one field and in JSON format.

    Example:{"username":"Brandon","the-field":"Welcome, ! It's great to see you here.","company-name":"test","company-address-line":"test","installer-name":"test","installer-phone":"","installer-email":"","installer-registration":"","coc-number":"brnadontest040720221","client-name":"Brnadon test","site-address-line":"","erf-number":"","plot-number":"","building-name":"","gps-coordinated":"","enegizer-type":"","serial-number":"","date-of-purchase":"","peak-voltage":"","voltage-under-500ohm-load":"","noise":"","joule-reading":"","date-recorded":"","meter-manufacturer":"","meter-model":"","meter-serial-number":"","open-circuit-test":["Yes"],"live-earth-short-test":["Yes"],"alarm-trigger":["Yes"],"alarm-trigger-2":["Yes"],"step2-long-label-1":["Yes"],"step2-long-label-2":["Yes"],"step2-long-label-3":["Yes"],"step2-long-label-4":["Yes"],"step2-long-label-5":["Yes"],"step2-long-label-6":["Yes"],"step2-long-label-7":["Yes"],"energizer-1":["Yes"],"energizer-2":["Yes"],"energizer-3":["Yes"],"energizer-earth-grid":["Yes"],"lightning-protection":["Yes"],"auxiliary-devices":["Yes"],"electric-fence-cable":["Yes"],"energizer-housing":["Yes"],"electric-fence-bracket-1":["Yes"],"electric-fence-bracket-2":["Yes"],"electric-fence-bracket-3":["Yes"],"fixing-for-brackets":["Yes"],"electric-fence-wire-1":["Yes"],"electric-fence-wire-2":["Yes"],"electric-fence-wire-3":["Yes"],"tension-point-1":["Yes"],"tension-point-2":["Yes"],"clamps-ferruls-1":["Yes"],"clamps-ferruls-2":["Yes"],"warning-signs":["Yes"],"conduit":["Yes"],"step4-long-label-1":["Yes"],"step4-long-label-2":["Yes"],"step4-long-label-3":["Yes"],"step4-long-label-4":["Yes"],"step4-long-label-5":["Yes"],"step4-long-label-6":["Yes"],"step4-long-label-7":["Yes"],"step4-long-label-8":["Yes"],"step4-long-label-9":["Yes"],"step4-long-label-10":["Yes"],"step4-long-label-11":["Yes"],"step4-long-label-12":["Yes"],"step4-long-label-13":["Yes"],"step4-long-label-14":["Yes"],"step4-long-label-15":["Yes"],"step4-long-label-16":["Yes"],"step4-long-label-17":["Yes"],"step4-long-label-18":["Yes"],"step4-long-label-19":["Yes"],"step4-long-label-20":["Yes"],"step4-long-label-21":["Yes"],"step4-long-label-22":["Yes"],"step4-long-label-23":["Yes"],"step4-long-label-24":["Yes"],"step4-long-label-25":["Yes"],"name-1":"","position-1":"","for-on-behalf-of-1":"","address-1":"","sign-1":"","date-1":"","name-2":"","position-2":"","for-on-behalf-of-2":"","address-2":"","sign-2":"","date-2":"","step-6-company-name":"","step-6-company-address-line":"","step-6-installer-name":"","step-6-installer-phone":"","step-6-installer-email":"","step-6-installer-registration":"","step-6-coc-number":"","step-6-client-name":"","step-6-site-address-line":"","step-6-erf-number":"","step-6-plot-number":"","step-6-building-name":"","step-6-gps-coordinated":"","is-the-electric-fence-complaint":["Yes"],"cf7mls_step-1":"","comments-on-electric-fence":"","comments-on-parts-of-electric-fence-not-covered-in-coc":"","cf7mls_step-2":"","cf7mls_step-3":"","cf7mls_step-4":"","upload-site-layout":"","upload-site-wiring-diagram":"","upload-photo-1":"","upload-photo-2":"","upload-photo-3":"","upload-photo-4":"","upload-photo-5":"","save-to-coc-cloud":"","save-to-device":"","send-coc-to-client":"","send-coc-full-document-to-client":"","send-sla-document-to-client":"","cf7mls_step-5":"","item-1":"","item-2":"","item-3":"","item-4":"","item-5":"","item-6":"","item-7":"","item-8":"","item-9":"","item-10":"","item-11":"","item-12":"","item-13":"","item-14":"","item-15":"","upload-photo-6":"","upload-photo-7":"","upload-photo-8":"","cf7mls_step-6":"","cf7mls_step-7":""}

    Is there a way for me to map these into a new Table with each data having their own column?

    Kind regards
    Brandon

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Brandon,

    I would love to help you, but WP Data Access does not support JSON imports. At least not yet. Sorry! Can you switch your format to CSV? You can import CSV from the Data Explorer.

    Doesn’t CF7 support saving data in a database table through hooks? I believe they do. Maybe ask them if that is possible? Might be much simpler and more efficient for sure.

    Does this help?
    Peter

    Thread Starter brandonwebfast

    (@brandonwebfast)

    Hi @peterschulznl,

    Thank you so much for your reply and advice!

    I didn’t even think that it was possible using hooks for cf7.
    I have done some research and have found a thread that might help me.

    I’ll let you know how it goes.

    This definitly helps!

    Thank you!
    Brandon

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Great! ??

    Good luck,
    Peter

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Mapping JSON Field Content to Multiple Table Columns’ is closed to new replies.