Data Editor

Use your PayPal Account. Get an immediate download link

You can still pay with credit card, you just need a PayPal login. Emails you a download link.


Problems with purchase? Contact info@cfdbplugin.com

Pay without using PayPal account. Wait for email

After you pay, the order is manually processed. There may be a delay of several hours before you receive an email with a download link.

Your credit card will list SIMPSONSOFT as the merchant for the transaction.


Problems with purchase? Contact info@cfdbplugin.com

About The Data Editor

The Data Editor is an extension that provides the ability to edit submitted form data in the Administration console and save changes to the database.

 

First, Switch To Edit Mode

 

Edit Data in cells

Click on any cell to edit.

Limitation: Data in the Submit Time column cannot be edited.

 

Edit Cell Column Names

Limitation: The Submit Time column cannot be edited/renamed.

 

Add New Columns

Great for tracking order status and work flow. Add columns that do not appear as fields on your form for tracking internal information or metadata about each form submission.

Note: this adds a column to the data. Don’t confuse this with adding a new field to your HTML form. Adding a field to your form will automatically add a new column to your data after the first form submission that has that new column. If you want to add a field to your form, just add the new field in your form definition in Contact Form 7 or Fast Secure Contact form

 

Delete Columns

Note: if the column that you delete is a field on your HTML input form, then in addition to deleting the column (the data associated with that field) you will also want to remove the field from your HTML form definition in Contact Form 7 or Fast Secure Contact form. Otherwise, the column will re-appear once a user makes a new form submission containing that field.

Limitation: The Submit Time column cannot be deleted.

Opening an Entry to Edit

Click on the Submitted link for an entry.

Screen Shot 2014-07-22 at 9.45.16 AM

Brings up a new page with more room to edit just the value in that submission. Click on a value to edit.

Screen Shot 2014-07-22 at 9.45.33 AM

NOTE: When you update an entry in this new page, you will need to refresh the Administration page (table of submissions) to see the change there.

Editing in a Post or Page

To make an editable table on a post or page, use [cfdb-datatable form=”Your Form Nameedit=”true”]. See cfdb-datatable edit option.

Clicking on a cell or column header makes the cell editable just as it does in the administration page. A user can only edit if he is logged in and his role satisfies the Options page -> Can Edit/Delete Submission data setting. 

Table column header can be edited but this will not work if you are using the “headers” option in the short code to rename the column headers.

Import/Export Data as CSV

Import-Export-CSV

Compatibility

This extension is compatible with CFDB Plugin version 2.0 or later. But be sure to have the latest version so that all the Editor features are enabled.

 

License

The editor extension is NOT open source. The license terms are set forth in this EULA. Please review before you download. By downloading, copying, installing or otherwise using this software product, in whole or in part, you agree to be bound by the terms of the EULA.

Each purchase grants the rights to install the editor extension in ONLY ONE WordPress installation. However it is acceptable to install the plugin on a production site plus its test and development sites using the same license.

 

Installation

  1. Be sure your existing install of the free Contact Form to Database Extension is update to the latest version.
  2. Purchase and download contact-form-to-database-extension-edit.zip
  3. Go to your site’s Admin page, Plugins
  4. Click “Add New
  5. On the Install Plugins Page, click “Upload” link
  6. Select contact-form-to-database-extension-edit.zip and click “Install Now
  7. Click “Activate Plugin
  1. July 28th, 2011 at 19:42 | #1

    @Gillian
    An Update: I can’t speak highly enough of Michael’s support with my issue (which turned out to be due to a MYSQL bug). He has resolved this problem and gone above and beyond by helping me out with other queries as well. This is a wonderful plugin and I highly recommend it.

    Gillian

  2. August 16th, 2011 at 17:33 | #2

    Is there a function or capability of having an automatic export that sends or emails new leads on a daily basis?

  3. August 23rd, 2011 at 14:27 | #3

    I have it working on my site including the attachment. However, is there a way to display the images on a wp page using a shortcode or some other method?

    • Michael Simpson
      August 23rd, 2011 at 15:40 | #4

      Yes, use cfdb-html with the filelinks option.

  4. bart
    September 10th, 2011 at 10:16 | #5

    can every user then adjust my database. It is in my websites interest that only the treasurer should be able to mark payments, and for example the secretary to mark that a license has been given.
    kind regards,
    bart

    • Michael Simpson
      September 10th, 2011 at 12:15 | #6

      If a user can see the Database Admin page, then he can edit the data. This access is controlled in the Database Options page “Can See Submission data”. If you set that option to “Administrator” for example, then only a user with those rights can edit the data, and users who are “Author”, “Contributor” etc. cannot access the Database admin page at all.

  5. Pete
    September 12th, 2011 at 20:17 | #7

    Is there a way to re-order the tables once they are added in the admin section?

    • Michael Simpson
      September 12th, 2011 at 20:44 | #8

      Tables in the drop down list are in alphanumeric order; no option to change it. If you meant columns, they are in the order the appear on the form. There isn’t an easy way to change it, you would have to update the field_order column in the DB for the appropriate rows.

  6. Pete
    September 14th, 2011 at 08:26 | #9

    @Michael Simpson

    Thank-you for your reply. I figured that I add to go into the database and change it there.

  7. Mike
    September 16th, 2011 at 15:16 | #10

    Can a field from the form used for a file upload be edited to allow the admin to upload a new file, or does the editing capability just allow you to change the text in the field? Related, in creating a new column, can that be a file upload field? What I am trying to do is create a scholarship application where the applicant has letters of recommendation sent in separately, but then an admin can add the letters as attachments to the original submission.

    • Michael Simpson
      September 16th, 2011 at 15:29 | #11

      You can edit the name of the upload file in the editor, that is all. It does not allow you to edit the file. Nor does it allow you to attach a file to a field. Creating a new column with the editor does not allow you to add a file for that column. To add new upload columns, you add them on your submission form as upload fields, but then you will get new submissions. A possible work-around is to have a form for the first submission, then then a separate page with the form of the same name on a different page for attaching files. All submissions are different entries but are associated with the same form. Then use a cfdb-html short code (or the “make your own shortcode option” to pull out the data from all related submissions (you will have to provide some common id in all, like the application email addr) and display the data and all associated file links.

  8. September 30th, 2011 at 10:56 | #12

    Hello ,

    If I buy a plug-in version of the premium, is unique for a site or can I use this plugin for another website ?

    Have a good time
    houshmand

    • Michael Simpson
      September 30th, 2011 at 11:36 | #13

      It is one purchase per WP install. See the EULA.

  9. October 19th, 2011 at 15:31 | #14

    I would like to know if the data editor is a one time purchase and if it can be used on more than one website.

  10. Michael Simpson
    October 19th, 2011 at 16:43 | #15

    @Glory
    It is one purchase per WP install. See the EULA.

  11. October 24th, 2011 at 22:27 | #16

    Hello, Loving your Database insert already. Here’s my requirements though before I buy your data editor. I have created a page with your Short Codes with my code being:

    [cfdb-datatable form="Intake Form" hide="Submitted Login,Submitted From"]

    This is a private page. I want editors and Administrators to be able to edit the database from this page. Without having to go into the Dashboard. Is this possible with this plugin?

    And another note, I want to be able to link a User account to a form that they submitted. Any ideas on this?

    • Michael Simpson
      October 25th, 2011 at 09:14 | #17

      No, editing is only works through the Database administration page.

  12. brandon
    November 8th, 2011 at 12:52 | #18

    is there a way to import csv’s, that you may have xported earlier on?

  13. Michael Simpson
    November 8th, 2011 at 14:16 | #19

    Unfortunately no.

  14. November 15th, 2011 at 15:36 | #20

    is there a way to use this with fast secure contact form to have the exported file be emailed as an attachment with every form submission. This doesn’t seem like a clear distinction between asking you or the maker of the other extension. Sorry to ask you both.

    • Michael Simpson
      November 15th, 2011 at 16:05 | #21

      No. In fact there is a very loose integration between the plugins so FSCF code is not aware of exporting and CFDB code is not aware of any emails being sent.

  15. Rob Howells
    November 29th, 2011 at 06:28 | #22

    Like many other here I too cannot speak highly enough of Michael’s help & speedy support and lets not forget his plugins too. I’m using all of them and they’re excellent.

    Thanks Michael we appriciate your efforts!!

  16. December 16th, 2011 at 18:50 | #23

    I’m using the export to google spread sheet live option but wanted to know if there is a solution to have the rows appear like you have so nicely done in the wordpress admin – The field that contains the entire questionnaire is really long ( even with scroll bars ) and inside google docs i can’t seem to control the row height like you have in word-press admin. I understand this is more geared at google docs issue but wanted to know if anyone has found an answer to this….

  17. Houshmand
    January 21st, 2012 at 05:43 | #24

    i’m work with contact form7+contact form to db extension & contact-form-to-database-extension-edit , and enter a records to db

    then Edit Cell Column Names to any. From this time onward , new record to add db , was not save The same column and save in new column .

    Is this program the problem?

    • Michael Simpson
      January 22nd, 2012 at 21:26 | #25

      If you wish to change the name of a form field, you must also change it in your contact form definition. If you use Contact Form 7, edit the form definition there. My editor plugin will change the name of all form submissions saved in the past. To make all future submission match, you must also change for form definition.

  18. Pat Mc
    February 18th, 2012 at 16:02 | #26

    Question about how things work after adding the data editor; but it maybe the raw contact form>database process (as I’d updated all plugins before installing the data editor).

    I now get funky columns in my database from a form update. Mentioned here: http://wordpress.org/support/topic/plugin-contact-form-7-to-database-extension-_wpcf7_version-column-added-to-database-after-adding-edit-plugin?replies=1

    After some testing with a dummy form/database, where I tried to delete the funky columns (but they came back), it seems like the form plugin may now be sending more data that is interpreted as user/form data?

    Funky columns added to table: _wpcf7 _wpcf7_version -vpcf7_unit_tag _wpcf7_is_ajax_call

  19. Pat Mc
    February 18th, 2012 at 21:17 | #28

    @Michael Simpson
    Thanks, that solved it; tried searches with one of the column names but now that I look back I see I might have used one that I misspelled in my post. (_vpcf7_unit_tag).

    Now to figure out why I have one row, one cell, that won’t let me edit content (opens edit cell without any of the content in the cell).

  20. S
    February 21st, 2012 at 18:17 | #29

    Hello,

    Is there a way to add/include post title of the cf7 in the database?
    I use cf7 for event registration, so the submitted form without the name/title of the event is not so useful.

    • Michael Simpson
      February 22nd, 2012 at 14:04 | #30

      No. But you might try adding a CF7 dynamic hidden field which can be a short code. Maybe you can make a short code that gives that post title?

    • Michael Simpson
      March 4th, 2012 at 14:52 | #31

      It looks like contact-form-7-modules can capture post information in the form.

  21. S
    February 23rd, 2012 at 13:14 | #32

    I will try to use this plugin to achive this. I will update if it works. Thanks.

    http://wordpress.org/extend/plugins/contact-form-7-modules/

  22. March 21st, 2012 at 12:55 | #33

    I have a very long form collecting patient health history and insurance information. After I submitted a test entry, I changed the column names to something human readable :-) Then I submitted an additional patient and have twice the columns as the new data came in with the original column names… Does this mean I have to change the form field names in both the form and in the email (lots of time)?

    • Michael Simpson
      March 21st, 2012 at 13:16 | #34

      That is because your form definition still has the old not-so-readable names in it. Even though you rename existing form entries in the DB to a new column name, new ones that come in have the name that your form definition gave it. Consequently, you now have two columns. You would have to again rename the old-name column to the new-name column to consolidate them into the single new-name column. If you can change the name of the field in the form definition to what you want, that is your best bet.

  23. March 21st, 2012 at 13:23 | #35

    Ok, thanks!

  24. Cathy
    April 8th, 2012 at 05:34 | #36

    Just bought the extension!
    Really enjoy & appreciate your plugin & support.
    Your software saves me so much time!~
    Looking forward to see the Import CVS feature soon!

    Cheers!

  25. Jim
    April 18th, 2012 at 13:13 | #37

    Ok, thanks!
    I also built a page that displayed the data columns of the registrants. I can view it in the administration view but when looking from another computer, it displays “You do not have sufficient permissions to access this data”. Will the editor help with this? Page is “Registered Teams” at http://www.bigdoglacrossetournaments.com

  26. Michael Simpson
    April 18th, 2012 at 13:31 | #38

    @Jim
    Go to the Database Options admin page, set “Can See Submission when using shortcodes” to Anyone

  27. May 3rd, 2012 at 04:39 | #39

    Will the edit upgrade allow me to alphabetize the rows of my database by a specified field?

  28. May 5th, 2012 at 10:11 | #41

    Bummer. Thank you for answering, Michael. I am using C7DB to have people partially register online for a homeschool class day I direct. I know I could export the database to a google spreadsheet in a single transfer and then do whatever I want to the spreadsheet, but then I will have lost the live feature and will have to redo the process anytime someone new registers. We take new students throughout the year so this will be a hassle. Do you have any recommendations for me?

  29. Michael Simpson
    May 5th, 2012 at 15:35 | #42

    @Sandy G
    Have you tried export to Google Live Data? That sets up a google spreadsheet that pulls data from wordpress and should automatically get updates.

  30. May 5th, 2012 at 16:11 | #43

    @Michael Simpson
    Yes, I have done that, but the resulting spreadsheet is ordered by date of registration. I’d like to alphabetize the spreadsheet. Is there any way to do that without losing the “live” function?

  31. Michael Simpson
    May 5th, 2012 at 17:09 | #44

    You probably can. It would require editing the script code in the spreadsheet. If you look in “function fetchCF7ToDBCSVResponse” for the line:

    var url = siteUrl + “/wp-login.php?redirect_to=wp-admin/admin-ajax.php%3Faction%3Dcfdb-export%26form%3D” + encformName;

    if the field you are ordering by is “lastname” try changing that line to:
    var url = siteUrl + “/wp-login.php?redirect_to=wp-admin/admin-ajax.php%3Faction%3Dcfdb-export%26form%3D” + encformName + “%26orderby%3Dlastname”;

    (be careful to use regular double quotes in the script editor, not the slanted ones that you see in this comment)

  32. May 5th, 2012 at 18:19 | #45

    I am sooo excited! It worked!!! Michael, I wish I could send you flowers. I have to tell you that your plugin has been very helpful to a volunteer-run homeschool class day (www.haaclassday.org). We have grown to a size that hand-entering all of the contact info for the registration data was getting out of hand and taking more time than any volunteer could afford. Honestly, I don’t really know what I’m doing, but I was able to consult online tutorials, read your answers to others questions, get some help from a friend at one critical point, and then just kind of fake like I knew what I was doing even in implementing what you just told me to do and it’s working! I am so excited! Thank you! Thank you! Thank you!

    For next year, I’ll try to figure out how to do the rest of our registration online (actually signing up for classes), but for now, I am one happy volunteer!!! Thank you for this wonderful plugin AND for your ongoing support of it!!! God bless you, Michael Simpson!

  33. May 5th, 2012 at 19:27 | #46

    Ooops. I had it working beautifully for the class day’s spreadsheet. I have a second site and database that uses the same WordPress account. So I have one spreadsheet that says
    =CF7ToDBData(“http://www.haaclassday.org”, “Contact form 1″, “”, “login”, “password”)

    and a second that says
    =CF7ToDBData(“http://www.churchill82.org”, “Contact form 1″, “”, “same login”, “same password”)

    Now I’m getting errors in both spreadsheets. Any idea what I’m doing wrong? I may have to put a call into my friend who helped me previously, but I thought I’d ask you, too. I am trying to learn what I am doing well enough that I don’t have to pester people for help. Thank you so much for helping me get to that point!

  34. Michael Simpson
    May 7th, 2012 at 16:05 | #47

    I’m not sure what the issue would be. Changed password, timeout reaching your WordPress server…?

    PS please post such support questions on the support forum: http://wordpress.org/tags/contact-form-7-to-database-extension

  35. May 8th, 2012 at 00:31 | #48

    Thank you, Michael! I would go to the link you provided, but I figured it out! I had the wrong password in one that was causing the initial error. Then something got boggled accidentally. I never did figure out exactly what I’d accidentally messed up, but both spreadsheets are all good now. THANK YOU!!!!

  36. May 11th, 2012 at 23:30 | #49

    I purchased the Data Editor to delete columns of meta data (e.g., _wpcf7) from the database and front-end Excel spreadsheet. But whenever someone fills in the Contact 7 form, the meta data shows up again in both the database and spreadsheet. How can I permanently delete all meta data?

  37. May 12th, 2012 at 15:50 | #51

    I read all the comments related to deleting meta data before I purchased the Data Editor. What is the point in purchasing the Data Editor, if I can’t permanently delete the meta data from existing databases and spreadsheets? Some of these are too big to just start over. This should have been explained before the purchase, not after.

  38. Michael Simpson
    May 13th, 2012 at 15:52 | #52

    @Nathan Muller
    If all you want to do is avoid having the _wpcf7 fields, then the data editor is not necessary. How to do this is already documented in http://cfdbplugin.com/?p=662

  39. Martinez
    May 23rd, 2012 at 00:02 | #53

    To be honest everything that can be done with this plugin, can also be done without it. 50$ ?
    I would like to have a possibility to save the data to that sql database in a usable way so u can use the data in other programs without modifying them in advance.
    Cause that there are only 4 columns (submit time, field value and field name) is kind of annoying when u try to analyse the data with excel and co.
    You have to use multiple pivot tables before u really can use the date.
    So is there a way to have the “initial” SQL table for example with the coloumn names representing ur ex-fields in the formular and the values of the table as the data the person is sending ?
    having only these 4 or 5 columns makes no sende to me to spend that much money.

    cheers

  40. PatMc
    May 23rd, 2012 at 13:17 | #54

    Just my 2-cents as a consumer.

    The data editor plugin makes it easier to update cells, while looking at rows that make sense for my form/table, while also supporting the search to find what you need to zap.

    Zap meaning, this is not end user stuff.

    The data format underneath the tool is as it was, before the data editor plugin joined the party. That data format allows for the more generic (and free) tool that can scrape form input, from any kind of form, with any number of changing data value fields in the form, into a general purpose database that works for us all. We’re not really meant to look at it as simple users; admin/strong users of course like to drill down and understand things (I did that once I learned how; being new to Word Press that was a discovery of its own).

    The exports provide more natural content, but not with an update cycle.

    The live google spreadsheet looked like it might also give you some edit update rights, but I can’t say for sure as I’m still trying to get it to work for me (but I’ve not tried super hard yet).

    I’m not going to ask for a redesign of the internals just so they look right to me; I’m going to try and ignore the internals and use the fairly rich function; cheap at the $50 to get the data editor, unbelievable at free for just the form to db capability.

    (I’ll ignore internals at least until I try to make my own short code :-}.

  41. June 5th, 2012 at 12:44 | #55

    Hello there,

    Please bare with me if the answer already exists but could not find it.

    I’m using the DB editor plugin and changed the name of the fields. However when a new submission in coming, older field names are being populated causing a whole mess in the DB.

    What dod I do wrong in here?
    Thanks a million
    -David

    • Michael Simpson
      June 5th, 2012 at 23:01 | #56

      You need to additionally change your FS Contact Form field names to the new names that you want. The editor will change existing data in the DB, but whenever new form submission come it, you get the names as they are defined in the form. You can repeat the process of renaming those new form submission columns to the new column name to effectively move them to the new column.

  42. June 5th, 2012 at 12:48 | #57

    BTW I’m using FS Contact Form plugin!

    @David

  43. PatMc
    June 5th, 2012 at 23:21 | #58

    Side question on the column management.

    Is there a process that can be used to clone the column data such that I can get a second column with the matching data values for all rows? (the original is the before column, then the copied column data is the after column, where changes can be made (and still compared to original).

    Might it be something that can be done with a little raw SQL magic vs gestures in the data editor ?

  44. Michael Simpson
    June 5th, 2012 at 23:34 | #59

    @PatMc
    That would need to be done in SQL. Given you have a form named “myform” and a column named “colA” that you want to copy to “colB”, then issue a SQL command:

    INSERT INTO wp_cf7dbplugin_submits
    (submit_time, form_name, field_order, field_value, file, field_name)
    (select submit_time, form_name, field_order, field_value, file, 'colB'
    from wp_cf7dbplugin_submits
    where form_name = 'myform'
    and field_name = 'colA')

  45. David
    June 6th, 2012 at 01:48 | #60

    Thanks worked great! @Michael Simpson

  46. June 6th, 2012 at 09:49 | #61

    Hi Michael,
    I was wondering about the upgrade policy for the data editor addition. Does the $50 fee cover all future updates of that software (as in we can get a new version for free from you)? or is this a cost per version of the software?

    • Michael Simpson
      June 6th, 2012 at 21:33 | #62

      For now, the cost includes updates but I’m guaranteeing all updates in perpetuity. But generally I think it only fair to provide updates free to any purchaser.

  47. iamjinu
    July 9th, 2012 at 05:41 | #63

    how can i give admin access to my client without showing the wp backend and is it possible that he can edit the database (I will buy this plugin)?

    • Michael Simpson
      July 9th, 2012 at 10:34 | #64

      The plugin does not allow you to do this. You can only edit the data in the admin page.

  48. August 7th, 2012 at 19:57 | #65

    I used your db plugin for a customer and persuaded them to buy the edit option. The form has a file upload as one of the fields. It appears from the discussion above that an empty file upload field can’t be updated after the database record is created. Is that correct?

    If so, I’d recommend adding the ability to edit file upload fields. My customer and I assumed that any field would be editable with the edit add-on plugin. It may be difficult to add this capability to the edit plugin, but most people will assume that any field in the db can be edited.

    Overall, this is a very nice plugin!

    • Michael Simpson
      August 7th, 2012 at 22:09 | #66

      Point taken. Thanks for the input.

  49. September 11th, 2012 at 04:34 | #67

    Hi, finally I bought it on uploadnsell. But I have a question, is it possible to view the entire entries in the table, without pagination?

    Thanks o lot.

  50. Michael Simpson
    September 11th, 2012 at 14:13 | #68

    @Alberto García
    In the Database Options page, there is a “Maximum number of rows to retrieve from the DB for the Admin display” which may be set to 100. Increase that ensure all entries are pulled into the page. That pulls all the rows into the Database admin page. At the top of the table, you can then change Show XXX entry to control how many are displayed at a time in the table (but they are all there in the table)

  51. September 11th, 2012 at 15:42 | #69

    Thanks mr. Simpson, but when I change the number of rows I get an Internal Server Error.

  52. October 15th, 2012 at 08:17 | #70

    Hello,
    I’m trying to get all the fields to display in uppercase. I’ve tried a number of functions.
    Can you you tell me how to capitalize fields: Streetname?
    thank you so much.

    Here is the shortcode:

    [cfdb-datatable form="Contact form 1" show="HOUSENUMBER,STREETNAME,APTNUMBER,CITY,STATE,ZIPCODE" hide="FirstName,LastName,submit_time,Submitted From,Submitted Login" orderby="STREETNAME,HOUSENUMBER" role="Anyone" permissionmsg="true"]

    • Michael Simpson
      October 15th, 2012 at 18:21 | #71

      You can use CSS to uppercase for you.

      Try adding this to your short code to capitalize everything in the table:
      id="mytable" style="#mytable div { text-transform: capitalize; }"

      Similarly, you could upper-case everything with `text-transform:uppercase`

      If you want to just target the Streetname column, try:
      id="mytable" style="#mytable td[title=Streetname] div { text-transform: capitalize; }"

  53. October 17th, 2012 at 13:44 | #72

    Hello Michael,

    We are currently utilizing your CFDB plugin and would like to upgrade with the Editor Option ($50). Our computer knowledge is limited and was curious if the plugin will update with all of the current information already there and simply allow us to edit the submitted form data and the database? Thank you Michael, I want to make sure things are safe prior to executing. Enjoy,

    Joel

    • Michael Simpson
      October 17th, 2012 at 14:00 | #73

      Yes, all information you already have stored in your DB will become editable in the Administration panel.

  54. October 17th, 2012 at 14:08 | #74

    Excellent Michael, thank you so much. We will be executing shortly.

  55. October 17th, 2012 at 16:02 | #75

    Hey Michael,

    Sorry for posting this here. I just purchased the upgrade, how do I install it on wordpress? I looked for a posting on this but couldn’t find one. Thank you,

    Joel

  56. October 17th, 2012 at 16:56 | #76

    Stand Down Michael, I found it. I just had to slow down and read, simply excited. Terrific program. Best of luck in the future, I look forward to seeing what else you come up with.

  57. December 13th, 2012 at 14:27 | #77

    @Michael Simpson
    First I just want to say THANK YOU for such a great plugin!!!

    Secondly, if I purchase the Data Editor plugin, does it allow me to enter new data (row)? This would be extremely helpful :-)

  58. December 13th, 2012 at 14:29 | #78

    @Michael Simpson

    First I just want to say THANK YOU for such a great plugin!!!

    Secondly, if I purchase the Data Editor plugin, does it allow me to enter new data (row)? This would be extremely helpful :-)

    BTW
    Entering again because I forgot to check the Notify boxes before submitting **my bonehead move**

    • Michael Simpson
      December 13th, 2012 at 14:57 | #79

      Unfortunately no, you can’t add a new row in the editor. You would have to submit from your from.
      You can
      – edit existing cell values (except Submit Time),
      – add, delete, rename columns
      – delete rows (which you can do without the editor plugin)

  59. December 13th, 2012 at 15:16 | #80

    @Michael Simpson

    Thanks for the quick response Michael!

    How do you delete rows?

  60. December 13th, 2012 at 15:45 | #81

    Hello Again Michael Simpson,

    Can you tell me the name of the database where all of the form data is captured?

  61. Michael Simpson
    December 15th, 2012 at 12:16 | #82

    @Paul Podczervinski
    You don’t need to buy the editor to delete rows. In the admin page, check the rows and click the delete button

  62. Michael Simpson
    December 15th, 2012 at 12:18 | #83

    @Paul Podczervinski
    The data is stored in table wp_cf7dbplugin_submits. See Database table structure rationale

  63. January 11th, 2013 at 16:00 | #84

    @Michael Simpson

    My manager bought the Editor for me today and I LOVE IT! Thank you SO MUCH for making my life easier :-)

  64. January 12th, 2013 at 05:31 | #85

    @Pete

    Dear Pete,

    Can you please let me know how you reorder fill data i need to reorder data fill please.

    Thanks

    • Michael Simpson
      January 13th, 2013 at 11:54 | #86

      I don’t understand what you mean by “fill data”, and reorder it how?

  65. January 15th, 2013 at 11:57 | #87

    I need to let my users edit their mistakes that they are making in the DB. They are inviting guests to a party. Is there some kind of work around where I can let them access this via the dash board rather than making everyone an administrator? I want to buy this today. Thanks

    • Michael Simpson
      January 15th, 2013 at 18:41 | #88

      No, there is no good work around. Editing must be done via the admin page. Otherwise this opens a security hole.

  66. Matt Elliott
    January 24th, 2013 at 14:48 | #89

    Hello, just got this plugin and it looks great. Have a few questions:
    • I am trying to add a column to the database (from the Contact Form DB admin area) so I click “Edit Data Mode” then “Add Column” filling out the name and click add. The page reloads but I do not see the new column.
    • also the site i work for does not track or log IP addresses is there a way to remove the IP address column (and tracking?) from the db? When I click “remove” column I cannot select any columns from the dropdown menu.

    Maybe I am missing something.
    Thanks in advance for the help.

    – Matt

  67. Matt Elliott
    January 24th, 2013 at 15:02 | #90

    @Matt Elliott
    My bad, it just started working after I logged out and back in.
    I have added and removed columns successfully!

    However, I still want to make sure that the IPs are not being logged anywhere though – it is very important for my company to not allow user anonymity. Any thoughts Michael?

    Thank you!

    • Michael Simpson
      January 24th, 2013 at 21:40 | #91

      You would have to edit code to stop the IP address from being captured. In the CF7DBPlugin.php file, delete the lines:

      // Capture the IP Address of the submitter
      $order = ($order < 10000) ? 10000 : $order + 1; // large order num to try to make it always last
      $wpdb->query($wpdb->prepare($parametrizedQuery,
      $time,
      $title,
      'Submitted From',
      $ip,
      $order));

  68. taseen
    January 27th, 2013 at 16:19 | #92

    @Michael Simpson

    Hello i am using CF7 Data Editor plugin can i edit data form front end (using shortcodes) , right now i can edit my data form wp-admin panel (CF7 db page), if yes please guide me thanks,

    • Michael Simpson
      January 27th, 2013 at 17:40 | #93

      No, the plugin only allows editing in the Administration page.

  69. January 29th, 2013 at 12:27 | #94

    @Michael Simpson
    Thanks for that Michael, worked like a charm.
    Great plugins.

  70. Nan
    February 26th, 2013 at 13:05 | #95

    Hi, Thanks for this great plugin, so useful.

    Is there a way to position a column once you add it? Now a new column appears second, I’d like to have it appear further down in the table.

    • Michael Simpson
      February 26th, 2013 at 13:23 | #96

      Unfortunately no, there is no simply way to change the column order.

  71. jai
    March 4th, 2013 at 09:00 | #97

    hello sir,

    Thanks a lot for such a great plugin.

    Is it possible to fetch the database values, that would be used to show my users profile information on my site.

    • Michael Simpson
      April 19th, 2013 at 12:53 | #98

      No, this only affects information captured by form submissions.

  72. April 19th, 2013 at 11:33 | #99

    Thanks for providing such a good plugn.
    I found that non-english character can’t display in administration console.Could you please solve this problem?
    Thanks.

  73. Lar
    May 22nd, 2013 at 14:19 | #100

    Hi! I just setup CFDB Data Editor and the “Edit Cell Column Names” feature doesn’t work. I can edit data in cells but not the column names. When I set to edit data mode and click on any of the column names, it doesn’t display the text field where I can edit the column name text. Instead, the sorting happens. Please help.
    Thanks!

    • Michael Simpson
      May 22nd, 2013 at 15:00 | #101

      Thanks for bringing this to my attention. I can reproduce this problem. Clicking on the header is still sorting by the column instead of activating the edit field. I think the recent update the the datatables library is not conflicting. I will see if I can get this resolved in the next couple of days and provide an update.

  74. Lar
    May 22nd, 2013 at 15:04 | #102

    @Michael Simpson
    Sir Michael, Thanks for your response. I hope this can be fixed asap. Please do let me know when it’s done. Thanks! =)

  75. May 25th, 2013 at 18:20 | #103

    clients have been letting me know they cannot email via the contact page – the code keeps being rejected – is this attributable to this data editor? it worked in the past and now doesn’t
    and no one ever explained when the website was set up that it is a service i have to buy? –
    could you please let me know where things stand as regards my site?

    Micheal

    • Michael Simpson
      May 27th, 2013 at 14:18 | #104

      The Data Editor plugin does not interfere with email. Your specific complaints should be directed to the person or company that set up your site.

  76. Lar
    June 5th, 2013 at 10:47 | #105

    @Michael Simpson
    Sir Michael, any update on the “Edit Cell Column Names” feature not working. When can this possibly be done? Thanks!

  77. Michael Simpson
    June 21st, 2013 at 18:10 | #106

    @Lar
    The problem where column headers were not editable is now fixed. You will need to install the latest version of the plugin at http://cfdbplugin.com/?page_id=939

  78. June 26th, 2013 at 17:02 | #107

    I’ve just started using your plugin to capture information from a WP form, and it’s been working great. Now I’m interested in learning whether I can upload historical information into the table that’s receiving the data. I just started using the plugin, so my table only has 40 or so rows of data, but I have nearly 6000 rows that I’d like to add. I do not want to enter this information manually, so I only want to purchase the edit data plugin if it can enable me to upload into the table that currently has only 40 rows, but is receiving the new info from the WP form via your plugin. Thanks!

    • Michael Simpson
      June 26th, 2013 at 17:27 | #108

      This can be done. There is an import option that comes with the plugin. You can upload a CSV file into an existing form or new form. You will need to prepare the CSV file with the same column header as the form you want to import into. These new entries will have a submit time set to when you uploaded them.

      A couple people have had trouble with the import feature. Something on their server stops the upload and they only get a few rows of the file. I haven’t figured out the problem to fix it yet. But if that happens, you can send me the file and worst case I will send you a SQL file that you can upload via PHPMyAdmin to import it there.

  79. June 26th, 2013 at 17:38 | #109

    Thanks for the confirmation and for the quick response! @Michael Simpson

  80. Michael Simpson
    June 27th, 2013 at 16:13 | #110

    @Michael Simpson
    I have found and fixed the import issue that some people have reported. It is fixed in version 1.2.2

  81. July 2nd, 2013 at 07:45 | #111

    Hi,

    I want to test this plugin before buying is there a way to have a trial version?

    • Michael Simpson
      July 2nd, 2013 at 09:31 | #112

      There is no way to provide an evaluation version.

  82. July 12th, 2013 at 16:51 | #113

    Is there a way to import the timestamp while importing the data into CFDB? Please help.

    • Michael Simpson
      July 13th, 2013 at 10:40 | #114

      You need a “Submitted” column in the csv file and the date needs to be in unix time (a number, seconds since 1970) which can have a decimal value for miliseconds. If you create a Backup export of a form from the Import page, it will be in this format (for an example)

  83. July 15th, 2013 at 10:14 | #115

    I have a submitted column in the CSV file, but I am not able to convert the time to unix time! Also, the time zone is coming as 00:00. How do I change the time zone to IST or 05:30?

  84. July 15th, 2013 at 12:32 | #116

    @Sam
    Hi, I got the time zone options in the CFDB settings and also understand that by default it takes the WordPress time zone settings. So, I can change the settings in either of the places or both.
    Can you please help me out with the time zones import? Vishal had purchased the plugin a couple of days back if you remember. Thanks for your support.

  85. July 15th, 2013 at 18:16 | #117

    Also, sometimes when I import I am getting several of these warning messages. Can you please let me know why these are appearing? – Warning: date() expects parameter 2 to be long, string given in /home/public_html/staging/wp-content/plugins/contact-form-7-to-database-extension/CF7DBPlugin.php on line 859

  86. Michael Simpson
    July 16th, 2013 at 19:34 | #118

    @Sam
    This should be on the support page, not here.

    The warning suggests that your custom time zone value is not being accepted. What did you enter?

    I’ll also look into allow you to specify a time format during import so it doesn’t have to be unix time.

  87. re-read
    September 25th, 2013 at 15:33 | #119

    Hi there,

    Has anyone an idea on how to deal with accents and the search function ?

    For example in Spanish, searching for “esta” should find “esta” and “está” or in French searching for “gâté” would give “gate”,”gaté” and “gâté”.

    ¡ Muchas gracias !

  88. hotelwww
    February 13th, 2014 at 11:26 | #120

    Hi.

    In first place, I’d like to apologize, because my english is no big thing.

    I’m interested in buying the “contact-form-to-database-extension-edit”, however I must know if it’s possible to edit the source code of it in my project after I buy it. I have a project, and it has a few needs that I must to program, and it depends on editing avaibility of the plugin. Some systems like WHMCS are encrypted, and I’m not able to edit the code.

    • Michael Simpson
      February 13th, 2014 at 13:20 | #121

      You get the source code with the download. It is not encrypted. The license does not permit modifying the code, but I am willing to grant you permission if you need it.

  89. hotelwww
    February 13th, 2014 at 13:22 | #122

    @Michael Simpson
    Okay Michael, thank you very much.

  90. carolallanos
    May 13th, 2014 at 23:10 | #123

    Hi Michael, I’m not sure about something, if I move my site to other hosting, I can export my database, and then can I import it to my new site with this extension?
    Thanks

    • Michael Simpson
      May 15th, 2014 at 11:00 | #124

      Yes, using the editor you can import/export one form at a time. To move your whole site, you might find it easier to take a MySQL DB dump which includes all the data. You don’t need the editor to do that.

  91. carolallanos
    May 16th, 2014 at 00:52 | #125

    :D Thanks a lot Michael!

  92. csenguler
    July 15th, 2014 at 17:07 | #126

    1) If I add an extra column as an admin, let’s say to track the status of an order…when I export the data, would this additional column appear on the excel file?
    2) Also, if I put a direct link on the web page for other users to be able to download the excel file, will they be able to see the additional column as well.
    3) Is the payment one time only?…if there are any updates in the future do we get them for free?

    Thanks for the support!

    • Michael Simpson
      July 15th, 2014 at 19:05 | #127

      1) Yes, new columns will appear in export (assuming at least one entry has data in that field, I think)
      2) Export links will also give the extra column (unless you add “hide” or “show” options to the link)
      3) Payment is one-time per site where the plugin is installed. All updates are included. You can always download the latest version on the Get the Editor Update page.

  93. csenguler
    July 16th, 2014 at 06:01 | #128

    thanks Michael that was very helpful….we should get the editor within this week. cheers!@Michael Simpson

  94. mike123
    July 22nd, 2014 at 08:50 | #129

    Just purchased the extension and it seems to work on a regular page, editing in the datatable, using edit=”true” in the shortcode. But I notice above on this page, it says:

    “Limitation: This works only in the administration console, not in regular posts or pages.”

    I’m confused, since this seems to be working for me on a regular page.

    Will appreciate any info you can share on this.

    Thanks for a great plugin,

    Mike

    • Michael Simpson
      July 22nd, 2014 at 09:29 | #130

      That is an out-dated note on the page. I’ll update it. Form are editable in a page or post like this:
      [cfdb-datatable form="Your form name" edit="true"]

  95. jellegillesjans
    August 5th, 2014 at 05:01 | #131

    And is it possible to edit the form’s data in the exported spreadsheet?
    Instead of editing data in the Data Editor plugin, just changing the value of the cell in the exported spreadsheet. Does that work?

    I’d like to make an “approval column” in my spreadsheet, where I can approve requests by adding “OK” or “NOT OK” into the spreadsheet’s cell.

    Thanks in advance

    @Michael Simpson

    • Michael Simpson
      August 5th, 2014 at 07:30 | #132

      You can export the data to a spreadsheet without the editor. The editor does NOT give you the ability to have edits in the spreadsheet be saved back to the database.

  96. C4talyst
    September 9th, 2014 at 22:43 | #133

    I used this plugin to capture form submissions for a photography competition. We received around 150 entries, and everything was populated into the database, with the exception of about 50 of the submitted images.

    Will the Data Editor allow me to insert the missing photos, which I have in emails as attachments, or do I need to resubmit all these entries using our form again? I really hope there’s a better option than the latter. I submitted a few before realizing how unproductive that route would be.

    • Michael Simpson
      September 10th, 2014 at 08:18 | #134

      No, it will not allow you to attach files to a form submission after the fact.

  97. C4talyst
    September 10th, 2014 at 17:30 | #135

    @Michael Simpson
    Thanks Michael. If I purchase the editor, will it add the necessary column to the CFDB table that would then allow me to insert the images manually through phpmyadmin?

  98. Michael Simpson
    September 10th, 2014 at 18:34 | #136

    @C4talyst
    No, it doesn’t support an operations on images (other than file name change). Sorry.

  1. January 13th, 2013 at 05:53 | #1
You must be logged in to post a comment.