[Plugin: Contact Form 7 to Database Extension] new great feature for great plugin

Hi, the plug-in is a generally good idea but in my case it is storing the data in a very inconvenient way. Instead of making a table with a UI and further placing the data for each client in one raw which would be expected, it is making a general column called, for example “field-name” and making a separate raw for each piece of client data (name, surname, email). As i am a database administrator working with a web developer that decided to use this plug-in we are both puzzled.
Would it be possible to make the data load into an SQL table ( wp_CF7DBPlugin_SUBMITS) similar to the table that is presented on the actual plug-in page, so that i have the table with data in order strait away instead of exporting it to Excel and then loading it back into SQL table to be used. Basicaly i would like the plug-in to create the table with separate column for each desired value, like the user login table is created in word press or most of the other tables in use.
Hope this made sense, please help, this is really cracking my head.
Thank you, Milan

I understand your point. A brief answer to your question is on this thread.

For those reasons, I don’t intend to support form-specific tables at this time. Sorry.

I’m using this plugin on a site which is basically a petition website using CF7. It works really well. I was wondering if there’s a way to get it to display the number of submissions as a value? So we could just have a numerical value on the homepage to see how many people have signed it.

Really great plugin by the way!

Thank you

btw the cool idea! We also have to count some values in tables of our site to build charts and even simple (count,sum,%) math functions will make us happy. And even more. Most of free jquery chart plugins (ie highcharts) work with json object and i feel it possible to realize BUT i’m afraid it is not easy and will take a time. Dear Michael, what is your professional opinion about this, is it possible at all?

Good idea about counts and simple math functions. I’ll look into creating a shortcode for that.

In the mean time, if you are displaying a DataTable and want to get the row count as well, this DataTable forum article might help on using Javascript to get that value. Although I figure you just want the count and not to display the table…you could stick the table in a DIV that you make invisible and put the count somewhere visible.

On the topic of doing data visualizations, that’s a whole new topic I need to get my head around but I would certainly like to support. In particular I’m happy to support shortcodes to output JSON targeted to whatever a particular visualization widget needs. I haven’t looked at JQuery charts yet. I was looking at Google visualization stuff a while back and it looks really cool. But I haven’t had time to pursue it yet.

So if you want a particular JSON format, let me know and help me by pointing me to what the format should be…

In the development version I have enhanced the [cfdb-value] plugin to be able to do count, sum, min, max, mean. I set up some documentation here. There are also a couple different formats for the [cfdb-json] tag.

Thank you so much, that worked perfectly. Really great work on an excellent plugin!

Thanks again!