Michael Simpson
Forum Replies Created
-
Forum: Plugins
In reply to: [Contact Form DB] can i use mysql or adminer to access the form input?Yes but the data isn’t organized in the DB the way you might expect.
See: https://cfdbplugin.com/?page_id=71On the CFDB Options page, there is an option to turn on displaying the query that the plugin uses to fetch data into the administration page.
Forum: Plugins
In reply to: [Contact Form DB] Importing form data to an independent databaseWith the CFDB Editor upgrade, you can export and import data form CFDB forms on different sites by exporting a CSV file then importing it.
There is no Word or PDF export.
Forum: Plugins
In reply to: [Contact Form DB] Export ALLNo, it does not support creating multiple tabs. Good idea though.
Forum: Plugins
In reply to: [Contact Form DB] Parsing numbers from field and getting SUM?I made this data set:
your-field 1 billet 2 billetter 1 billet 1 billet Ingen billetter 2 billetter 2 billetter Ingen billetter Ingen billetter Ingen billetter 1 billetUsing [cfdb-value] then:
[cfdb-value form="sum-with-text-example" show="your-field" trans="your-field=intval(your-field)" function="sum"]
Gives:
10try also:
[cfdb-table form="sum-with-text-example" trans="SummationRow(your-field)"]
Transform to Compute StatisticsForum: Plugins
In reply to: [Contact Form DB] Export ALLYou can’t get the form name as a column in the export. You would have to have a field to identify which category a form submission is.
I recommend to put a hidden field in your form to identify the category rather than use the form name.
Since you are using Contact Form 7, you could also turn on the CFDB Option to
– Save Page Title from Contact Form 7 submissions
– Save Page URL from Contact Form 7 submissions
which will add fields to your form submissions. If your category is based on which page the form is placed on, this might work for you.I made my own example and it works OK. Your shortcode can get messed up if you have the wrong kind of quotes or you have line breaks.
Switch you post editor to Text mode instead of visual, then copy and paste from below and preview the post:
[cfdb-export-link form="Enfold" show="Submitted,2_1,3_1,4_1,5_1,6_1,7_1,8_1,1_1,9_1" headers="2_1=Title,3_1=Surname,4_1=First Name,5_1=Address,6_1=Suburb,7_1=State,8_1=Postcode,1_1=Email,9_1=Phone,subject_1=Tour Name"]What do you mean by not working? What happens?
Make sure there are no line breaks inside the shortcode.
Forum: Plugins
In reply to: [Contact Form DB] Export ALLYou confused me by using “category” when you mean “form”.
If you go to the Shortcode page and create and export link, you can select * All Forms * then click the link to export
Forum: Plugins
In reply to: [Contact Form DB] Export ALLWhen you do a basic export, you get all the saved form submissions. I don’t see how you would only get those from a certain category unless you explicitly set up the export with a filter on category.
Forum: Plugins
In reply to: [Contact Form DB] Automated exportsNot exactly. You can make an export link that exports everything since yesterday, then you can click it every day, but the plugin doesn’t have a way to automatically export. Although you might be able to setup something using wp_cron
The orderby option orders the rows bases on their values in the columns you name.
List the columns in the order you want in “show”, I.e. Just change orderby to show in your shortcode.
Forum: Plugins
In reply to: [Contact Form DB] EXCEL Import problemsForum: Plugins
In reply to: [Community Yard Sale] Set Map Location & ZoomThe shortcode builder sets the location in the shortcode parameters. When you paste the shortcode on a page and save the page, the shortcode and its settings are the same every time you view the page.
- This reply was modified 9 years, 4 months ago by Michael Simpson.
Forum: Plugins
In reply to: [Contact Form DB] Using CFDB with multiple forms across multisitesNo, since they are logically different sites, they all have independent tables to store data. The plugin doesn’t currently support consolidating them.
Yes, you can create an export link with the same options as shootcodes