Feature Requests

November 19th, 2014

There is no official road map for the plugin development, I am collecting feature requests here. Comment if you would like to advocate for one or add your own ideas.

Shortcodes

We want to include some SQL-like functionality including

  • Pagination of results from shortcodes
  • DONE! Filter by a relative date (e.g. all submissions in the past week)
  • Rename a column (select column AS new-name)
  • Does anyone want a short code to create a JgGrid table sort code as an alternative to Datatable?
  • Short code to create a search form and display data as in existing shortcode

Data Visualization

  • Short codes or options that can create data visualizations such as JQuery charts and Google Visualizations

Editing Submitted Data

Others

  • Import data from CSV file into DB
  • Save data to a different table
  • Post submission to Post

 

 

  1. February 26th, 2011 at 12:31 | #1

    Do you know when you’ll publish the edit submitted data function? I’m look forward to it.

  2. Gillian
    March 5th, 2011 at 05:47 | #2

    Thank you for this plug-in, it is great :-)

    Yes please, I would love to advocate for your existing proposed features
    ~ edit submitted data
    ~ shortcodes: order by, and rename column

    and add another one … being able to import data into the table from a spreadsheet which contains earlier data received via email before I installed your wonderful plug-in

    Thanks for the opportunity to make suggestions.

  3. Kevin
    March 6th, 2011 at 07:57 | #3

    Thanks, really looking forward to the edit submitted data function!

  4. March 14th, 2011 at 11:23 | #4

    The ability to edit/update submitted would be great.

  5. Jeroen
    March 17th, 2011 at 09:12 | #5

    Is it possible to include an option that it stores its form data to a post (of a certain category) in stead of a separate database table?

  6. March 22nd, 2011 at 05:43 | #6

    I’d already left a comment about this, but didn’t realise there was a dedicated thread. I’d also like to add my vote for the edit data and add column features. Are there plans to implement this? Any idea of a time frame? Thanks :)

  7. March 22nd, 2011 at 14:06 | #7

    Another idea for a feature request. If some of the fields contain image uploads it would be great to see a thumbnail preview of the image, rather than the file name or url. Or, if not a thumbnail, if the image could ‘pop-up’ when you mouseover the filename?

  8. shanthaseelan
    March 25th, 2011 at 03:24 | #8

    awesome plugin. Am looking forward to the edit and update submitted data .

  9. March 25th, 2011 at 13:04 | #9

    Just a small request – it appears that when trying to order a cfdb-table, if the values are numeric they’re treated as strings and so not sorted correctly. Would it be possible to place an option to cast numeric columns so they’re sorted properly? Maybe ‘column desc numeric’ in the orderby or something.

  10. Goat
    March 31st, 2011 at 03:00 | #10

    Definitely require the edit function.

    ALSO, I am looking to find a way to have data submitted from a form to look like it was submitted by multiple forms. EG. have 5 forms, form 1 – 4 are for 4 different trainings, form 5 is for all 4 trainings. If a visitor uses form 5 then they get added 4 times and show up in form 1 – 4.

  11. Paul
    April 1st, 2011 at 19:46 | #11

    As per our discussion at http://wordpress.org/support/topic/plugin-contact-form-7-to-database-extension-possible-to-select-data-rage-to-export?replies=4

    The ability to download/export the data in XML form in any chosen data range would be good. As it stands, the export function becomes almost pointless and the system unusable with regular form submissions taking place as the data set just becomes too large!

    Thanks!

    Paul

  12. Rocco
    April 8th, 2011 at 10:06 | #12

    Great Plugin!! I would like to advocate for the “Editing Submitted Data” feature.

    Thanks

    Rocco

  13. June 7th, 2011 at 13:41 | #13

    Great plugin you have here. I am actually in the process of adding in some custom functionality to your plugin.

    Basically I am adding in the ability to send an email (monthly) with an csv attached as well as an output of the db data in the email itself.

    Obviously this could be extended to select the file format you’d like and the frequency of the emails etc.

    I’m doing a pretty quick implementation but if you are interested I can send you the code when I am done.

  14. June 20th, 2011 at 15:52 | #14

    I also second the request for an import feature for existing data sets in some standard csv format. That alone would help me a great deal. Having the first row auto generate a form which I can then adjust would be icing on the cake! BTW, if you don’t have any plans for the import feature, can you advise on how to hack my way to a solution. I have a table with almost 200 entries in it and the form is a great solution for adding additional content to it.

  15. David Elliott
    June 21st, 2011 at 13:58 | #15

    I added a user as an editor, and set the plug-in to allow editors to be able to see the database. However, WordPress does not allow Editors to see the plug-in… and he therefore cannot see the database. Am I missing something? how can I allow him to see the database without giving admin access?

  16. Michael Simpson
    June 21st, 2011 at 20:58 | #16

    @David Elliott
    Please post such questions in the future to the support forum: http://wordpress.org/tags/contact-form-7-to-database-extension

    Seems to work OK for me. Be sure you are not confusing settings “Can See Submission data” with “Can See Submission when using shortcodes”.

  17. July 8th, 2011 at 08:35 | #17

    Hi Michael, I can see you have created a great tool that improves Contact 7, etc. and I know that Wp-Table Reloaded is a table and not a database but it is actually a table inside the generic WordPress Database, anyway my question is, are you going to improve WP-Table Reloaded anytime soon :-) I certainly hope so.

  18. July 21st, 2011 at 05:00 | #18

    Thanks for this great plugin. I also would find it very useful to be able to edit the db.

  19. Michael Simpson
    July 29th, 2011 at 15:59 | #19

    @Lewis Lane
    Should be fixed now

  20. August 12th, 2011 at 05:13 | #20

    To piggyback on Jeroen’s request, I could see a way for to use CFDB for frontend posting. And while it may not be expressed that explicitly, it sounds like it’s something in which a number of people may be interested.
    So, basically, someone could create a form in CF7 or FSCF to ask site visitors to submit (structured) content. Submissions could be available as “pending” or “draft” posts. With custom post types, taxonomies, and fields, it could all make a lot of sense in terms of create content repositories which are also available as a separate database table.
    I’m not a coder but I’m looking at the CFDB documentation to find ways to do this. Sounds like processing data from PHP, both ways, might be needed: both “Accessing Form Data via PHP” and “Submitting Data via PHP”. Even some of the “Create Your Own Short Code” info sounds relevant.
    Might be able to hack it myself but it actually sounds more involved than coding frontend posting by itself. But the advantages in terms of formhandling (through FSCF or CF7) and database processing (through CFDB) might make it worth the extra effort, if any.
    And, sure, there are plugins to do frontend posting (or frontend editing). Problem is, none of them is that incredibly flexible. And Gravity Forms is cost-prohibitive for an academic organization running multi-site.

    So, adding support for frontend posting to CFDB would be more useful than it might appear at first blush.

    Cheers! And thanks for a cool plugin.


    Alex

  21. August 12th, 2011 at 09:42 | #21

    Hi Michael, I am wanting to export the data to a file on the host so it can be retrieved via a third party API via FTP. Is this possible.
    Cheers
    Gary

  22. Michael Simpson
    August 12th, 2011 at 13:57 | #22

    @SBIMarketing
    Not exactly. First, be aware that you can craft a URL to directly download an export file via HTTP. But if you are stuck with FTP, maybe you could set up a script on your server that runs something like “wget” to download the export file to an FTP-accessible directory. You could even have that script run by “cron” so it happens automatically on a regular basis. To craft a download URL, use the Short Code builder page, cfdb-export-link choice, but instead of using the generated shortcode, copy the generated link to use in your script.

  23. Michael Simpson
    August 12th, 2011 at 14:29 | #23

    @Alexandre Enkerli
    Point taken. I don’t think you could string this together with what is currently available with this plugin. If you want to you want is form-to-post then you probably don’t need/want that same stuff in the DB. So you don’t need this plugin, but something similar. Maybe I should create a separate plugin like this one that just pushes stuff into a post instead of the DB. Since I already have all the scaffolding code from this plugin, I could probably do that quickly. But then people will want to configure which category to tag posts from different forms, so I’d have to make a configuration panel. Anyway, I have to think it through.

  24. August 23rd, 2011 at 14:54 | #24

    Thanks for this great script! I’m just wondering if it is possible to change the table name? I have an existing table that collects the data and I need the table name to stay the same as it is because the data gets pulled into our sharepoint contact database. Is this possible?

  25. September 7th, 2011 at 04:20 | #26

    Hi, just wondering if your able to automate the export of the DB’s table to a local (on server) CSV file and then send to another server? not huge issue. just would be nice.

    on the support side, can i rename the fields within the DB to new names.

    e.g. i have 4 forms, they all have same contents however when my dev setup he just used default names, when i export these fields they come out with different names per form (obviously).

    the issue i have is i am trying to rationalize the design and build a script that exports this content to a single CSV file and it give me a crappy structure within the CSV file.

    thanks

    • Michael Simpson
      September 7th, 2011 at 09:47 | #27

      There isn’t a built-in way to automate export. But you could conceivably create a cron job to download it. This is basically what the Google Spreadsheet Live Data option does. It has a google script to call back to the server and download CSV. The tricky part is that you need to have the user and password in the POST data of the requires (not the GET) to authenticate and get to the download URL (you can get the URL via the shortcode builder page, cfdb-export-link).

      You can rename fields via the editor plugin (I think you got that) just by clicking on the col heading. Otherwise this is done by doing SQL updates in the DB. Be sure to also change the field name on your input form. The easiest approach would be to get all the 4 forms and their submissions named the same way. But if you mean to rename the columns as part of the export operation, then no, it’s not supported. (It’s on my list to have a sort of “select as” to rename the columns in short codes and exports but I haven’t done it yet)

  26. September 7th, 2011 at 20:32 | #28

    Hi Michael, thank you for the prompt response! im looking at a problem at the moment that is only occuring since i installed the editor plugin yesterday.
    when i delete a junk column, it seems to corrupt the next column and over-rights ALL the data in that field… bit weird… but unsure whats happening. if i seem anything thats out of the ordinary i will follow up with you.

    Thanks

  27. Michael Simpson
    September 8th, 2011 at 11:28 | #29

    @Greg
    Let me know. If it’s a bug I want to fix it. Thanks.

  28. September 9th, 2011 at 03:20 | #30

    @Michael Simpson
    Yes seems to be a bug, i’ve re-created on a second test site. let me clear the database of customer data and i’ll let you at it :-)

  29. October 3rd, 2011 at 04:20 | #31

    @Michael Simpson
    sorry, seemed to have bigger issues and now back to working with it. seems fixed now though a possible bug within CF7 we found thats been sent in.

  30. Michael Simpson
    October 3rd, 2011 at 08:49 | #32

    Thanks for the update

  31. October 3rd, 2011 at 21:35 | #33

    Hi Michael,
    I should have read the feature requests before that post I made earlier. Please excuse that.
    I know you are probably busy with other project but any idea on a release for the filter by relative date? Or anything I do as a temporary fix? I tried using filter by date_time but have no idea what I would do to limit the results to a certain time frame. If you could let me know, or let me know what it would cost for a little bit of custom development.

    Not trying to be a bother by any means just want to finish this project up to get the site launched.
    Thanks!

    • Michael Simpson
      October 4th, 2011 at 09:32 | #34

      Here is what you can do:

      First look at how you can use “submit_time” in the filter of a short code like:
      [cfdb-table form="Contact form" show="submit_time, field1,field2" filter="submit_time>1308511772.4792"]. Look at that in the Database Short Code page. Click the generated link to see the results. This is just to get you oriented.

      That submit_time number is seconds since 1970 gotten from a call to PHP microtime(true); Given you understand that, what you would need to do, is follow the instructions in the Create Your Own Short Code page. But in that code, before you call “export()”, you will need to:
      1. call microtime to get the current time, then subtract from that the number of second in your time window (like a week or whatever)
      2. add/edit $atts[‘filter’] to have “submit_time>computed_value” in it.

  32. October 4th, 2011 at 14:09 | #35

    @Aaron Ware

    We would love the functionality to be able to schedule a monthly email with the CSV file attached. If anyone can assist, please contact me via our website.

  33. October 4th, 2011 at 14:10 | #36

    @Aaron Ware

    We would love the functionality to be able to schedule a monthly email with the CSV file attached. If anyone can assist, please contact me via our website.

    Thanks in advance!

  34. Michael Simpson
    October 10th, 2011 at 22:15 | #37

    @cope
    Relative date functionality now implemented. http://cfdbplugin.com/?page_id=553

  35. November 1st, 2011 at 19:16 | #38

    Hi,

    It would be great to have the possibility to display data from several forms in one table (e.g. [cfdb-datatable form="Form1, Form2, Form3 etc...], and also to have ONE search field to search the data. Also, it would be cool if the appearance of the data tables could be controlled…cause now, as soon as one submission is too long, the whole table gets messed up.

  36. Dana Caulder
    November 3rd, 2011 at 01:53 | #39

    Hi Michael,

    I’m definitely interested in the “Post submission to Post” feature. In our use case this would create a draft post, that could be edited / reviewed before being finalized.

    This is the use case:

    I have a private page where all submissions for the past week are displayed (use your shortcodes).

    There would be a (new) shortcode that would allow me to render a button near my preview form submission. Clicking the button would generate the draft post (not all submissions might need to be posted).

    Once the draft post is created, you would want to NOT render the button anymore, but instead give some indication that the draft was already created (so you don’t try creating a new draft).

    If you have any questions, please let me know.

    Thanks,
    Dana

  37. November 4th, 2011 at 14:58 | #40

    First let me say THANK YOU for your wonderful plugin. Your Contact Form 7, now with the database extension is ABSOLUTELY terrific and a must have. Please check your bank for a small donation in appreciation of your contribution (confirmation number: 1YR58573CB9085141).

    I would like to see a date field added to the tag options lists which includes a DATE PICKER. This helps validate data entered in the field, rather than just free text (which vary in input).

    • Michael Simpson
      November 4th, 2011 at 15:18 | #41

      Thank you kindly. Good idea.

  38. Dana Caulder
    November 10th, 2011 at 00:57 | #42

    @Michael Simpson
    Hi Michael,
    Just wondering if you have anything in the works for the “Post submission to Post” feature. If so, I’m eager to get my hands on it and test it for you. If not, I’m likely going to try to hack something together myself…

    Thanks,
    Dana

  39. Michael Simpson
    November 10th, 2011 at 09:23 | #43

    @Dana Caulder
    Not at the moment. I expect to be pretty busy through the end of the year with other things. You could create your own plugin.
    1. Create a function similar to what I have in CF7DBPlugin::saveFormData($cf7) to capture the form submission, then write SQL inserts to the appropriate tables
    2. Set up hooks for your function:
    add_action(‘wpcf7_before_send_mail’, ‘your-function’);
    add_action(‘fsctf_mail_sent’, ‘your-function’);

  40. ixoadmin
    November 11th, 2011 at 11:29 | #44

    Hi Michael.
    First of all thanks for this great plugin.
    I had find one thing about fields with tags. When you export “excel internet query” this fields transforms in multi row.
    To solve this I had added “br {mso-data-placement:same-cell;}” in the styles. I do that in file exporttohtmltable.php – line 113.
    I had another problem with the attached files. My mySQL has a default 1Mb limit for attached files. I didn’t find this answer in forums and I tell you if other person asks you.
    Thanks again.
    Alberto.

    • Michael Simpson
      November 11th, 2011 at 12:48 | #45

      I’ll try your style suggestion.

      If you have multi-line data, you can change the setting in Database Options -> “Show line breaks in submitted data table” to “false” and that may help with the export.

      It might be not that your MySQL has a 1mb limit, but that your Contact Form 7 field definition has this default limit. In the Contact -> Edit page, if you create a File upload tag, you can see where you can set a different limit.

  41. Michael Simpson
    November 11th, 2011 at 13:07 | #46

    @ixoadmin
    I tried the style you suggested. I see how it works. Great tip. I’ll put that in the code.

  42. Dana Caulder
    November 11th, 2011 at 13:52 | #47

    @Michael Simpson
    Thanks for the response and suggestion.

    I was actually going to try creating my own shortcode. I want this to be an optional process initiated by a site moderator who is viewing a preview of the submissions on a private page. My thought was to use this new short code in the body of your [cfdb-html] [/cfdb-html].

    Something like this:

    [cfdb-html]
    [make-draft-post title=”${submission-title}” body=”${submission-body}”]

    [/cfdb-html]

    I did a little playing around with this last night and the cfdb shortcodes does not process nested shortcodes (although in theory this should be possible I think).

    Does this seem like a totally crazy way to go about this? I know I could create a new shortcode that does the entire iteration through the forms (basically copy your existing cfdb-html code and add my modifications / extensions)… but this seemed like a cleaner way to go about it (the nested shortcode).

  43. Michael Simpson
    November 12th, 2011 at 14:42 | #48

    Nested short codes don’t work in my experience.
    [UPDATE: nested shortcode support has been added]

    I went ahead and whipped up this: http://wordpress.org/extend/plugins/form-to-post/

  44. Michael Simpson
    November 12th, 2011 at 14:43 | #49

    @Alexandre Enkerli
    See new plugin to create posts from form submissions: http://wordpress.org/extend/plugins/form-to-post/

  45. December 7th, 2011 at 11:57 | #50

    First of all, this is a great plugin and has saved me a great deal of time. I am glad that we have plugin developers like you.

    I see that there are already requests for allowing .csv files to be imported into the DB, but I was just wondering if you knew when it would be available. Much of the data that I store in this database is simply inputted from Excel, and so it would be awesome to just import a .csv and call it a day.

    Thanks and great work!

  46. January 10th, 2012 at 01:07 | #51

    Hi,

    I would like, Short code to Delete File at Frond End.

    Thanks.

  47. Yasso
    January 11th, 2012 at 15:29 | #52

    I want to be able to fill drop down list on the form a field in the database, and to save a text box value to a custom table.

  48. Fred
    January 16th, 2012 at 08:45 | #53

    Hi,

    Thanks a lot for this great plugin !

    It would useful to be able to specify delimiter when exporting a table, so it can be different than comma.

  49. Sebastian
    January 26th, 2012 at 12:31 | #54

    First of all, this plugin is just amazing.

    Is there a way in the “cfdb-value” to make a “new line” at the end of each row?

    best regards

    Sebastian

    • Michael Simpson
      January 26th, 2012 at 13:47 | #55

      I should probably add that. Instead try using cfdb-html to create a template with and end-of-row delimiter. You don’t actually have to put HTML in cfdb-html; it is just a way to create a template for your output.

  50. Kate
    February 24th, 2012 at 19:49 | #56

    Hi Michael,

    Thank you for developing such a wonderful plugin, you are saving many business’ lives!

    When do you think we would have the feature to import Data into DB?
    Is there a way I can combine/merge different data into one single data?
    Thank you sooo much!

    God Bless!

  51. Mike
    February 29th, 2012 at 03:52 | #57

    Hi,

    Potentially a great plugin for us. Just one question, we have a form that allows people to apply for jobs, and they also submit their CV (as a PDF or Word file). Are these files also saved to the DB? If yes – in what format?

  52. Michael Simpson
    March 3rd, 2012 at 17:07 | #58

    @Mike
    Saved in the DB in binary.

  53. Eddi
    March 9th, 2012 at 10:27 | #59

    Hi,

    the plugin is really cool. One short question/request. Is there a way to update and delete form content for users? The admin can do that of course but a regular user that has a user_ID?

    • Michael Simpson
      March 9th, 2012 at 10:40 | #60

      No, there is no way to do this outside the admin area right now.

  54. March 18th, 2012 at 07:15 | #61

    Thanks for your plugin.
    Is there a way to be notified via email that a submission has been made to the db?
    My site is SSL, so I want form submissions to be secured in the db, and not sent by email. However, I would like some sort of notification when a form is saved to the db. Otherwise, I need to keep logging in and checking.
    Thanks.

    • Michael Simpson
      March 18th, 2012 at 08:34 | #62

      This plugin doesn’t do email notification. But if you are using CF7 for example, you can configure what is in the email template that gets emailed when a submission is done. You can simply not include any fields from the submission and just have the email have text like “form was submitted”.

  55. March 18th, 2012 at 09:24 | #63

    Thanks, Michael. I installed CF7 and modified the email template, as you had correctly suggested. @Michael Simpson

  56. April 12th, 2012 at 04:57 | #64

    Hello,

    This appears to be a really nice plugin.

    Q. I inserted your short-codes in a page and it works great as long as I’m logged into WP. If I log out and go to the page, as a visitor would, I get “You do not have sufficient permissions to access this data.’ – What am I missing?

    • Michael Simpson
      April 14th, 2012 at 10:07 | #65

      Admin page -> Database Options, set “Can See Submission when using shortcodes” to “Anyone”

  57. April 16th, 2012 at 01:18 | #66

    So far your plugin is working great for me, so nice job. Very much appreciated. I want to show my support for some Visualization functionality. I would love to be able to get the data to something like a FLOT chart. My users would benefit greatly from being able to see their monthly changes int the submitted data shown in a graphic chart rather than just tables. If there is already a way to get the data (user specific) that can be put into the FLOT chart, please let me know.
    Thanks.

    • Michael Simpson
      April 16th, 2012 at 09:40 | #67

      If you use the cfdb-json short code, you get get the data in a javascript variable in the page. You could then pass that as the data for the Flot chart. The data may not be organized exactly how Flot expects it, so you may need to transform into the right structure in Javascript.

  58. May 24th, 2012 at 23:56 | #68

    If contact Form is sumitted checking database and Duplicate email is Warned already registered is that possible?

  59. July 8th, 2012 at 16:52 | #70

    Hi

    Maybe Im missing something (hopefully) but looked and looked, cant see any method to paginate if there are more than 100 records etc. My user wants to be able to see ALL records submitted, divided into pages of 10/25/100 etc. Is this not possible ?

    If not, can it be included soon please

  60. Gareth
    July 17th, 2012 at 04:28 | #71

    Great plugin.

    One feature I would like to see is when using the contact form to collect feedback from registered users. I would want that, instead of the person having to fill in their details, the form automatically saves the username of the person who’s logged in. In my case the contact form would only be visible to registered users so there would be no need to indicate that an anonymous user filled in the form.

    • Michael Simpson
      July 17th, 2012 at 09:13 | #72

      Note: if a user is logged in and fills out a form, the plugin already captures the user id in the form submission. The trick is to make sure they are logged when accessing the page with the form.

  61. Gareth
    July 17th, 2012 at 09:26 | #73

    Brilliant thank-you. Till now I have only done tests by fillinging forms without being logged in. I can see the registered username now. This will make life a lot easier as I can now import exported data into an offline database using the username as primary key.
    Re restricting the form to logged in user – using a plugin, I will be placing the form on pages/posts that only registered users can access.

    Thanks again for all your hard work!!

    @Michael Simpson

  62. Post
    August 14th, 2012 at 23:27 | #74

    Thank you for the great plugin.

    The following additions would be great!

    1- import excel files to the database
    2- numbered and alphabetized pagination while showing database records on a page
    3- currently, orderby function doesn’t work correctly for TR language set.

    Thanks again for your help

  63. Matthew Stone
    September 21st, 2012 at 10:54 | #75

    Hello I am using Contact Form 7 export database functionality to export my data to a google spreadsheet. The issue I am having is I have a security setting set up to hide my backend of the normal login of http://www.examplesite.com/wp-admin. The script I put into google to collect the data uses this line to login to wordpress to collect that data and uses this code “/wp-login.php?redirect_to=wp-admin/admin-ajax.php%3Faction%3Dcfdb-export%26form%3D” to do so.

    Is it possible to change that code to make this work instead. The secure way I login to the admin area is this http://www.examplesite.com/wp-admin/?access-adminarea. Can you tell me how to edit this script to use my secure way of logging in?

    • Michael Simpson
      September 21st, 2012 at 17:42 | #76

      Certainly you can edit the script you embed in your google spreadsheet to try to make it go to a different URL. If it is more complicated than that you may need to read up on the google JavaScript call to fetch a URL an the authentication option it provides.

  64. Davidecat
    September 24th, 2012 at 10:19 | #77

    Hi, what about the – Pagination of results from shortcodes – feature? Any news?

  65. October 1st, 2012 at 18:40 | #78

    what about saving uploaded files from Contact form 7 to a folder on the server instead of the database tables?

    • Michael Simpson
      October 2nd, 2012 at 20:17 | #79

      You could accomplish this by creating a hook described in this post but instead of changing data, copy the upload file where you want it.

  66. December 8th, 2012 at 19:18 | #80

    @Michael Simpson
    I second this request! I hold a lot of giveaway on my website, and your plugin has been a huge time saver. I would love it if, while submitting, the database could be checked for duplicate emails, and not allow the person to enter twice.

    • Michael Simpson
      December 8th, 2012 at 22:08 | #81

      If you are up for coding, I think you could accomplish this but adding a filter (see here) then in that filter follow this to add code to query of the email. If the email or entry match is found, return null.

  67. Marco.S
    January 24th, 2013 at 11:28 | #82

    I’m looking for a solution to plot charts from values saved to the DB with cfdb.
    The closest one would be Gcharts that uses google api’s and is fed with a CSV file. Haven’t tried modifying it yet so I could feed it with an Url instead of a file upload – and the csv file might be in the wrong formatting too-, but anyway it would be great if your plugin will have a charts add-on (even not free), as there really isn’t anything working in that direction in the wordpress plugins.
    My customer needs to show charts from sun farms monitored activities and values, and I’m sure they wouldn’t mind paying an extra to have a solid solution instead of my workarounds ;)

    • Michael Simpson
      January 24th, 2013 at 14:29 | #83

      Many chart type libraries are Javascript libraries that work off of HTML tables or JSON data. You may find that you can use [cfdb-table] plus some javascript from a library to tell it to read data from that table. You may also be able to use the [cfdb-json] short code to feed data in a tabular form to some javascript visualization component.

  68. Daniele
    February 4th, 2013 at 07:08 | #84

    Hi there!
    Is there any way to export submitted datas from all forms in a single csv with an additional column that contains the form name?
    Thanks!
    d

    • Michael Simpson
      February 4th, 2013 at 11:25 | #85

      Unfortunately no.

  69. February 7th, 2013 at 22:49 | #86

    I would love an option to make a form from CF7 only submit to the database and not send out an email.

    • Michael Simpson
      February 8th, 2013 at 08:16 | #87

      CF7 sends the email, so that plugin should provide the option to not send it.

  70. February 15th, 2013 at 14:09 | #88

    Would like to see the ability to send out email digests. Daily, Monthly or Weekly, and either “Full DB” or “Since last digest”. Since the code’s already there for choosing an export format, I guess it would allow you to choose a format to be attached to the email, as well.

    Thanks for the great plug-in, though!

  71. Fox
    April 13th, 2013 at 13:06 | #89

    Is there a possibility to change the data of the form automaticly before receiving the email?
    Example:
    The form have a pull-down with country-names like “Austria, Germany, Spain”. When I’ll get the email, I want to get short-data like AT, DE or ES instead of Austria, Germany or Spain. Is there a possiblity to do this?

  72. jsherk
    April 30th, 2013 at 22:10 | #91

    @David
    Fast Secure Contact Form can do this (submit to DB or URL and not send an email).

  73. Jennifer
    May 13th, 2013 at 18:22 | #92

    Is it possible to add a “Check All/Uncheck All” feature in the table view? We need to purge records from time to time. Not all, just most. Right now, I need to individually select each row. Would be very helpful to be able to “check all” then deselected those few I want to keep.

    thanks!

  74. John
    May 17th, 2013 at 14:09 | #93

    Is it possible to have an option to integrate with MailChimp? TIA

  75. July 18th, 2013 at 01:02 | #94

    We are looking for a storage mechanism in a database that can be used to connect with directly for document automation. The problem we have come across is that every forms program stores there entries in a row based delineation rather that by row for each record separated by column for each piece of data. What we would like is a capture plugin for the data to be stored in such a way, or even just the option to store it that way so it is easily usable via odbc for document automation. Please feel free to contact us if you would like to discuss it more, all of our contact information is available on out website.

    • Michael Simpson
      July 18th, 2013 at 11:43 | #95

      If you application is read-only, they I suggest creating a view in MySQL that makes the data look like it is one-row-per-submission. More details here.

      Alternatively, you could create a filter in PHP to save the data to a separate table that you define (in addition to where it is saved by the plugin). Then your application could both read and write to that table. But if it did write, it would not be consistent with what is in the plugin’s table.

  76. July 18th, 2013 at 01:04 | #96

    It may be unclear, or confusing without clarification to what we are referring. We are not referring to your output on the screen, but rather how the data is stored in the MySQL database on the back end.

  77. AndreaKalli
    April 22nd, 2014 at 20:39 | #97

    I would love to be able to automatically schedule an export file to be emailed. For example, it would be great if at the end of each month I could send that month’s form entries to the admin or other specified email address. That’s even a feature I would pay for in a premium add-on.

  78. johnja1
    May 26th, 2014 at 12:19 | #98

    Hi Michael,

    I have started to write my own short code to orderby in desc order. I was just wondering if you already have a orderby shortcode in your plugin then how would i make a difference in buldignmy own. Below is my php short code, not sure if I have to connect to sql database and the sort the order by desc for column “USCF-Rating” or can I just add to the $exp variable the orderby ? this is fantastic plugin but this one problem is really giving me a hard time. My field is a character type.Can you just advice me on how I can write teh php for the shortcode. Everytthing else works very well.

    the order I like
    2000
    1500
    900
    and not like
    900
    2000
    1500

    require_once(ABSPATH . ‘wp-content/plugins/contact-form-7-to-database-extension/CFDBFormIterator.php’);
    $exp = new CFDBFormIterator();
    $exp->export($atts[‘Greensboro Chess Tournament Form New’], $atts);
    while ($row = $exp->nextRow()) {
    // Adding my stuff here!
    echo ‘USCF Rating=’ . $row[‘USCF-Rating’] . ”;
    }

    my site url: http://www.greensborochess.org/tournaments/pre-online-registration-list/

    my shortcode on the page.
    [cfdb-table form ="Greensboro Chess Tournament Form New" headers="First-Name=First Name,Last-Name=Last Name,PhoneNum=Telephone,Membership-Status=Membership Status,byesradio=Byes,
    USCFID=USCF ID,USCF-Rating=USCF Rating,Tournament-date=Tournament Date" unbuffered="true" orderby="USCF-Rating desc" role="Anyone" hide="Submitted,Submitted From,Submitted Login,email,captcha-728,TournamentFees"]

    Many Thanks
    Jacob

  79. chrs
    June 25th, 2014 at 02:27 | #99

    Hi Michael, thank you for the great plugin.
    One request or idea that I have is to have the option to automatically email the data as a csv or excel export file, instead of manually exporting from within the admin panel.

    We have to export our data at the end of each week, and it would be great if there was an automated way, and we wouldn’t have to remember to login every week and export manually.

    Do you have anything similar to our request in mind for future updates/releases… in fact I wouldn’t mind paying for such a add-on feature.

    Another feature would be having the option to choose a date range for the export, for example June-01-2014 – June-08-2014.

    As I mentioned we wouldn’t mind paying for this features. So please feel free to contact me directly.

    Thank you.

    • Michael Simpson
      June 25th, 2014 at 09:58 | #100

      Notes on how you could put this together:
      1. From the short code builder page you can choose an Export File which creates an “Export Link” on the page. You can use this link to get to the export bypassing the admin page.
      2. You can add a date filter (filter by submit_time) to it. You can use a specific date or something like “submit_time>1 week” which means submissions since a week ago.
      3. The problem with the export link is that you need to be logged in. But there is a way to pass your login info via the URL…but I only have this shown in the builder page for exports to “Google Spreadsheet Live Data”. If you choose that option temporarily, you get user/password fields. Enter in a login. The page generate =IMPORTDATA(“URL”). Click on that to be sure it works. Copy the URL part to use.
      4. As for an automated export, I suggest that if you can get onto the computer hosting your WP site, set up a cron script (Linux) and use wget or curl to hit that URL and mail it to you. You could also try the wp-cron plugin but that can’t guarantee that it will execute at the same time every day (which can throw off the “submit_time>1 week” filter).

Comments are closed.  Go To Support Forum