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 Form and Data
Here’s a simple form we built on our site:
Have a good look at the fields we have on our form. Let’s quickly fill them out and then visit inbox 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.
Export Function
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!
- RegistrationMagic Starter Guide - August 4, 2024
- WordPress Registration Shortcodes List - July 10, 2024
- WordPress Payment Form Guide: Setup Payments on Registration Form - July 8, 2024
- Experience the Unfolding Magic! - August 4, 2023
- List of Guides for WordPress User Registration Process - July 28, 2023
- Frequently Asked Questions About WordPress User Registration Forms - July 28, 2023
- How to display registration forms on WordPress site? - July 26, 2022
- WordPress User Registration Custom 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
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/
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.
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.
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?
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 available in the standard version. Please make sure you are using the premium version if you wish to access it.
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.
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.
How can i check database entry of my registered user?
User registrations are all available in “User Manager” page of RegistrationMagic’s backend.
I am using registration magic on my website but the form export as .xml file instead of csv, how do i resolve?
Thank you
In order to export in CSV format, refer to the following steps:
– Login to WordPress dashboard
– Under RegistrationMagic, click Overview menu item
– Scroll down to EXPORT option
– Select the form
– Click Submissions