Data Editor
Use your PayPal Account. Get an immediate download link
You can still pay with credit card, you just need a PayPal login.
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 the plugin as an attachement.
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.
Limitation: This works only in the administration console, not in regular posts or pages.
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.
Import/Export Data as CSV
Compatibility
This extension is compatible with CFDB Plugin version 2.0 or later.
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.
Installation
- Be sure your existing install of the free Contact form to Database Extension is update (at least version 2.0)
- Purchase and download contact-form-to-database-extension-edit.1.0.zip
- Go to your site’s Admin page, Plugins
- Click “Add New“
- On the Install Plugins Page, click “Upload” link
- Select contact-form-to-database-extension-edit.1.0.zip and click “Install Now“
- Click “Activate Plugin“
@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
Is there a function or capability of having an automatic export that sends or emails new leads on a daily basis?
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?
Yes, use cfdb-html with the filelinks option.
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
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.
Is there a way to re-order the tables once they are added in the admin section?
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.
@Michael Simpson
Thank-you for your reply. I figured that I add to go into the database and change it there.
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.
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.
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
It is one purchase per WP install. See the EULA.
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.
@Glory
It is one purchase per WP install. See the EULA.
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?
No, editing is only works through the Database administration page.
is there a way to import csv’s, that you may have xported earlier on?
Unfortunately no.
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.
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.
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!!
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….
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?
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.
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
Please see http://cfdbplugin.com/?p=662
@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).
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.
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?
It looks like contact-form-7-modules can capture post information in the form.
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/
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)?
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.
Ok, thanks!
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!
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
@Jim
Go to the Database Options admin page, set “Can See Submission when using shortcodes” to Anyone
Will the edit upgrade allow me to alphabetize the rows of my database by a specified field?
No.
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?
@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.
@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?
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)
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!
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!
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
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!!!!
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?
You need to stop them from being captured. See http://cfdbplugin.com/?p=662
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.
@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
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
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 :-}.
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
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.
BTW I’m using FS Contact Form plugin!
@David
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 ?
@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')
Thanks worked great! @Michael Simpson
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?
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.
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)?
The plugin does not allow you to do this. You can only edit the data in the admin page.
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!
Point taken. Thanks for the input.
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.
@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)
Thanks mr. Simpson, but when I change the number of rows I get an Internal Server Error.
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"]
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; }"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
Yes, all information you already have stored in your DB will become editable in the Administration panel.
Excellent Michael, thank you so much. We will be executing shortly.
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
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.
@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
@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**
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)
@Michael Simpson
Thanks for the quick response Michael!
How do you delete rows?
Hello Again Michael Simpson,
Can you tell me the name of the database where all of the form data is captured?
@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
@Paul Podczervinski
The data is stored in table wp_cf7dbplugin_submits. See Database table structure rationale
@Michael Simpson
My manager bought the Editor for me today and I LOVE IT! Thank you SO MUCH for making my life easier
@Pete
Dear Pete,
Can you please let me know how you reorder fill data i need to reorder data fill please.
Thanks
I don’t understand what you mean by “fill data”, and reorder it how?
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
No, there is no good work around. Editing must be done via the admin page. Otherwise this opens a security hole.
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
@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!
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));
@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,
No, the plugin only allows editing in the Administration page.
@Michael Simpson
Thanks for that Michael, worked like a charm.
Great plugins.
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.
Unfortunately no, there is no simply way to change the column order.
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.
No, this only affects information captured by form submissions.
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.
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!
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.
@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! =)