Changing Field Names in Contact Form 7 to Database Extension Error

  • emma2015

    (@emma2015)


    13 years, 2 months ago

    Firstly, thank you for this plugin – it’s brilliant.

    I tried to change the field names as displayed in the database by using the option on FSCF. This did not work, so I edited the MYSQL database with the code

    update wp_CF7DBPlugin_SUBMITS set field_name = ‘POSITION’ where field_name = ‘ex_field5’

    as found in one of your previous replies. This seemed to work. i also removed some fields in which i was uninterested.

    However, as soon as I received another form submission, this was displayed in the database under the original field headings ex_field(number), and the first set of results was displayed under my edited headings in parallel columns. How do I change this so that all new data submitted is under the headings I have specified? I have tried deleting all the ex_field(number) bits from my database, but they keep coming back!

    Many thanks,

    Emma

Viewing 9 replies - 1 through 9 (of 9 total)
  • Mike Challis

    (@mikechallis)

    13 years, 2 months ago

    All of the data export functions work, I just tested them (FSCF 2.9.8.4)
    Make sure you have the latest version of FSCF, a new one was released yesterday.

    Follow this FAQ for using the Data export fields to rename
    feature:
    http://www.fastsecurecontactform.com/save-to-database

    Note that it only alters new submissions, not old ones.

    Thread Starter emma2015

    (@emma2015)

    13 years, 1 month ago

    Hi Mike,

    I’ve tried changing the names again as described in the link above

    field1=sex
    ex_field2=age
    ex_field3=marital status
    ex_field4=employment
    ex_field5=education
    ex_field6=Residency SY
    ex_field7=Mobility
    ex_field8=Self-Care
    ex_field9=Usual Activities
    ex_field10=Pain/Discomfort
    ex_field11=Anxiety/Depression
    ex_field12=Thermometer

    But it still doesn’t seem to be working – those headings have appeared, but the information is still displaying in a table next to it under the headings ex_field4 etc.

    I have checked, and am definitely using the most current version of FSCF.

    What do I do now?

    Thank you!

    Mike Challis

    (@mikechallis)

    13 years, 1 month ago

    Note that the Data export fields to rename feature only alters new submissions column names, not old ones. You may want to delete all the old submissions, or change the label of your form # on the FSCF form edit page so that the new submissions are displayed under a new option select on the database viewer, that way the old column names would not get mixed with the new ones.

    I added this to the FAQ
    http://www.fastsecurecontactform.com/save-to-database

    Mike_ox

    (@mike_ox)

    12 years, 9 months ago

    Hi

    Thanks for building the short code generator, I have donated. It’s almost there on my site but it seems temperamental.

    I like the datatable as it’s dynamic. However it seems to loose this ability if I make any other changes to the page. If I create a new page and save it it works, if I update the page at any point it just shows a static table. I can live with this but it’s not ideal.

    Anyway that wasn’t my main problem…
    I’ve created a page and it was working fine in Google Chrome but it’s all over the place in Windows Explorer and Firefox. It’s lost all the dynamic search abilities in Explorer and it’s over to the left in firefox making half the table hidden.

    I’ve tried changing to a number of different themes but I’m having no joy.

    Try opening this in different browsers and you’ll see what I mean

    http://www.bandsforgigs.co.uk/events-needing-bands

    http://www.bandsforgigs.co.uk/wp-admin/admin-ajax.php?action=cfdb-export&form=Events&show=Date%20needed%2CTime%2CGenre%2CWhere%2CHow%20many%20bands%2CHow%20long%2CPayment%3F%2CDetails&orderby=Date%20needed%2CWhere%2CGenre&enc=DT

    Can you help?
    Thanks
    Mike

    Mike_ox

    (@mike_ox)

    12 years, 9 months ago

    Ah forget the second link, it just downloads the table as a csv for some reason???

    Please click instead on the first link and see the part that says “Click here to see the master table for more information”

    Thanks
    Mike

    Plugin Author Michael Simpson

    (@msimpson)

    12 years, 9 months ago

    Looking at the following link in Firefox with Firebug:
    http://www.bandsforgigs.co.uk/events-needing-bands

    I see the error “jQuery is not defined”. In that page, the jQuery library (as well as the datatables one) is included towards the end of the file, after an actual call to jQuery that would wrap the table in datatable javascript. So that call fails and you get no datatable. When I look at a page I created, it see those at the beginning, which is what I expect because the plugin “enqueues” the scripts so they are to be output in the WP Head section….I don’t know why yours are going out later.

    So I’m not seeing the datatable at all, so I can’t see differences in how it is displayed in different browsers.

    Mike_ox

    (@mike_ox)

    12 years, 9 months ago

    Thanks for the quick reply.

    I don’t know how to solve that. I had a few JavaScript plugins activated. I’ve turned them off now.

    Perhaps they have messed things up on my site? To be honest I’m starting to have trouble with a few things. I’m tempted to reinstall wordpress and start from scratch. Though I would prefer not to as it’ll take some time to recreate and I don’t really know how to reinstall.

    What do you think would be my best approach?

    I appreciate your fast help
    Mike

    Plugin Author Michael Simpson

    (@msimpson)

    12 years, 9 months ago

    Perhaps you would find it better to create a second site using a subdomain and go through all the (re)install and see if things work better. If not, delete it. If so, turn off the old site and change the URL of the new.

    You should look on the the web about how best to do it I haven’t done it myself, but the way I figure it:

    1. create a new WP site as a fresh install with a subdomain of what you are using (maybe test.www.bandsforgigs.co.uk).
    2. Install your theme & plugins.
    3. In PHPMyAdmin, export your old DB data into your new DB.
    4. You probably have to copy wp-content/uploads/ directory to get all uploaded images.
    5. I’m not sure if there are other directories to copy. In the admin panel, change the siteurl to the subdomain.

    You might want to search the web for more authoritative instructions.

    Mike_ox

    (@mike_ox)

    12 years, 9 months ago

    Hi

    I’ve managed to get the jQuery in the head through the HeadJSloader plugin. It’s made the table dynamic on the main webpage in FireFox but the layout is a little off.

    I’m still having problems getting the below to work in the latest Internet Explorer

    http://www.bandsforgigs.co.uk/wp-admin/admin-ajax.php?action=cfdb-export&form=Events&show=Date%20needed%2CTime%2CGenre%2CWhere%2CHow%20many%20bands%2CHow%20long%2CPayment%3F%2CDetails&orderby=Date%20needed%2CWhere%2CGenre&enc=DT

    Thanks
    Mike

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Changing Field Names in Contact Form 7 to Database Extension Error’ is closed to new replies.