Introduction: Manage and Export WordPress Registration Forms Data
Let’s get started on another WordPress registration system tutorial. We will focus on how to manage and export WordPress registration forms data and database. Call them submissions, entries, records or simply form data; every piece of information submitted through forms on your WordPress sites is vital for your business or blog. More disorganized this information, more difficult it will be to make sense of your forms. Good old email notifications simply don’t cut it these days. You may miss a mail, or your server may not shoot the notification message (believe me, that happens) or worst you lose access to your inbox. Therefore, for any plugin that purports form building credentials, it must pay equal importance to the data that its forms collect over time. It should not only be organized but also able to provide meaningful insights into how forms are working.
Manage and export WordPress registration forms data is in the very DNA of RegistrationMagic. Its multiple parts work as a whole to filter and present the information users send out to us. We call every entry a Submission. Therefore, the first and foremost area of RegistrationMagic, after the Forms Manager is the Submission Manager. Before we take a look at the Submission Manager, lets fill out a form to make sure we have at least one submission when we go there.
Sample From and Data
Here’s a simple form we built on our site:
Have a good look at the 4 fields we have on our form. Let’s quickly fill them out and then visit Submission Manager inside the dashboard.
It is important to learn reading this page.
We see that submissions are recorded as a table with each field forming a column header and the subsequent submissions displaying the user entered information below. By default first 4 fields will form the columns in Submission Manager. Any more fields will make the whole table cramped, so they won’t appear here. On right side, last column shows View button. That’s how we enter the page where complete information about the corresponding submission record is accessible.
Before we do that, let’s check out the filter.
Filters sidebar allows us to quickly filter the submission records for analysis. Since we have only single submission right now, there does not appears to be a need for filtering. How about when we have few hundred! Or thousand!!
We use RegistrationMagic to manage registrations on our own site and here’s how the Submission Manager looks like on a regular day:
Personal information has been blurred for privacy. In such cases filters come in handy if we want to quickly check submission records for today, this week, month or year. We can also check records between a specific date range.
Batch operations are also supported. See the checkboxes in the first column? You can select multiple records and then delete them.
Match Fields and Entry ID
Match Field allows us to find submission records with matching field data. A good example would be finding students from same grade on an enrollment form data. Or if we are searching for a user with specific first name.
When we click on any of the records, a new page displays all the record attributes neatly.
On top, Entry ID is unique number associated with each submission, while Entry Type tells us if the filled form is a simple contact form or configured for accepting WordPress registrations. We can also download the individual submission as PDF using the Print button above. The PDF will also show business logo if we have configured it in Global Settings. Handy if you want to print submission forms with your own branding.
Multiple notes can be added to each submission for internal purposes. Colors can be assigned to these notes during creation.
Here’s a nice little note stacked right below the submission record.
Notes can be edited later.
A word about the Export button on the Submission Manager page. It allows downloading submission records as a single CSV file. Many external programs support CSV standard for importing data. Direct connections to MailChimp and Aweber are supported out of the box, so no need to go through an extra step if you are using one of them.
This is just the beginning of things that we can do with submission records inside RegistrationMagic plugin. We shall discuss more features in upcoming posts. Hope you can manage and export WordPress registration forms data in a better way now. Have a great day!
- How to display registration forms on WordPress site? - July 26, 2022
- Create Your First WordPress Registration Page – Starter Guide - July 13, 2022
- Setup payments on Registration form using Products [Payments Guide] - June 10, 2022
- WordPress Registration Shortcodes List - April 14, 2022
- WordPress User Registration Status Guide - April 9, 2022
- How to add or update user profile fields using WordPress forms - August 5, 2020
- Boost RegistrationMagic User Profiles With ProfileGrid Integration - February 19, 2019
- Advance WordPress User Login Plugin Guide - August 8, 2018
- Create Intelligent Contact Form in WordPress [Breakthrough Ideas] - February 8, 2018
- How to Add Custom Fields to WooCommerce Checkout Form - November 3, 2017
I am using registration magic on my website but the form export as .xml file instead of csv, how do i resolve?
Please open a support ticket so we can help you. Thanks!
How can i check database entry of my registered user?
Please provide examples how the exported data looks. The CSV report we get Using WordPress, WooCommerce, and EventTickets is almost useless. Our event has several tickets, and the data for one person is fragmented on multiple rows. Difficult to explain.
The submissions can be exported from RegistrationMagic > inbox > export all. We can provide you example as to how it looks but will need you to raise a ticket for our support team, since comments section doesn’t allow sharing of the files.
I have to export users data from Premium version. The export function exports the activities, not the whole user database. How can I export the users database? Not the activities, but the data fields for all users?
You can export the submissions from RegistrationMagic > Inbox > Export All.
Hello, my export all button is showing grey, and i canot press it. Any advice?
The export all button available in RegistrationMagic > inbox, is a feature of premium version of RegistrationMagic and not present in the standard version. Please make sure you are using the premium version of RegistrationMagic.
When will you allow choosing which fields you want to export, now all you can do is export all? I have about 20 fields but need to create a spreadsheet with just 4 fields, as of now I have to export all and delete 80% of the data then rearranged it which is time consuming.
We will be considering this feature in one of our future releases.
In our submission form we have fields for street address, city, state and zip code. However, when they a exported they are all combined into one column of the Excel spreadsheet. How can we get the individual submission fields exported into individual columns.
Each field of RegistrationMagic displays in a separate column of Excel sheet. This can be downloaded with “Export All” link on inbox page. Address field is a combination of multiple sub fields such as street address, city, state, and zipcode. Since all these attributes are part of address field, they are combined into one column of Excel sheet.
Why if each element of the address is a separate field for the customer to fill in do they get combined to form one column in Excel?
I also get a number of fields like “Unique token”, “Payment Invoice”, “Payment TXN Id” that I don’t want downloaded. How do I eliminate those?
I need to create a form that records daily mileage from a group of registered users. I then need to be able to query the database and display the user’s total miles for the year on a leaderboard page. Is it possible to query the database?
As of now, there is such option to find out records daily mileage from a group of registered users. So we are unable to provide any custom query the database.
I am able to export form as .xml file instead of csv, how do i resolve?
If you want to export form data with RegistrationMagic, go to RegistrationMagic > inbox > export all. The submissions shall be exported in form of csv. This is a feature of premium version of RegistrationMagic. The form data however can be exported in form of .xml file.
We have the premium version and it is not possible to export form data with RegistrationMagic in a format CSV, just a .xml. What is the solution to do it.
Please make sure you are using the latest version of RegistrationMagic. In order to export submissions, go to RegistrationMagic > inbox > export all. In case you still face any issue, please raise a ticket on our support portal here in order to allow us assist you: https://metagauss.com/help-and-support/