• I am using a shortcode to display a WP page to allow data editing of the database. The database is displayed properly and it allows the fields to be clicked on to edit or add data. But there appears to be an issue when adding data to an empty field. I used gravity forms to create the fields as hidden fields. I then used the CDBF editor and added values to the hidden fields for one entry so the fields would show up in the short-code generator.

    When I executed the short-code and added data to the records that had nothing in them, I clicked OK which closed the edit box and properly displayed the added data. But when the page is refreshed, the added data does not show. If you click on the field again to edit it, the updated data appears.

    When I export the data with the updated fields to a CSV the added data does not show at all.

    here is the sort code i am using:

    [cfdb-datatable form="2015 Flag Database" edit="true" show="Submitted,First Name,Last Name,Phone,Email,House #,Street,Neighborhood,Route,Sub-route,Flag Lease Quantity,Delivery 1,Delivery 2,Delivery 3,Delivery 4,Delivery 5" orderby="Route,Sub-route,Neighborhood,Street,House #"  filter="Route #=13"]

    https://ww.wp.xz.cn/plugins/contact-form-7-to-database-extension/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter andywt

    (@andywt)

    I have found the issue. I had added the fields to an existing database. When CFDB attempted to update the field, there was no entry in the _submits table, and therefore no where to save the data. What I did to get around this issue was to export the entire database to a CSV file. Open the CSV in Excel and add a ” ” to the new field in every record in the database. Then I deleted the old database and re-imported it and all is good.

    Plugin Author Michael Simpson

    (@msimpson)

    The plugin should handle that case. But I’ll check the code and fix it if necessary.

    Sometimes there can be introduced a duplicate entry for the same field where one is blank. On the Import page there is now a button to clean up such bad data. You might try that and see if it indicates any issues and fixes them.

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

The topic ‘CFDB Editor Not saving Data added to empty fields’ is closed to new replies.