Blog

Manage & Export WordPress Registration Forms Data

How to manage and export WordPress registration forms data?

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:

 

RegistrationMagic Sample Form

 

 

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.

 

Export WordPress Registration Forms Data - 2

 

It is important to learn reading this page.

 

Export WordPress Registration Forms Data - 3

 

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.

 

Export WordPress Registration Forms Data - 4

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:

 

Export WordPress Registration Forms Data - 5

 

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.

 

Export WordPress Registration Forms Data - 6

 

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.

 

Export WordPress Registration Forms Data - 7

 

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.

 

Export WordPress Registration Forms Data - 8

 

 

Here’s a nice little note stacked right below the submission record.

 

Export WordPress Registration Forms Data - 9

 

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!

About RegistrationMagic

RegistrationMagic Editorial Staff (rmagic) is a team of WordPress registration experts and major contributor to the development of RegistrationMagic - WordPress User Registration Plugin.
Subscribe
Notify of
guest

19 Comments
Inline Feedbacks
View all comments
Andre Lafreniere
Andre Lafreniere
3 years ago

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.

RegistrationMagic
RegistrationMagic
3 years ago

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/

carlo nucci
carlo nucci
4 years ago

I am able to export form as .xml file instead of csv, how do i resolve?

RegistrationMagic
RegistrationMagic
4 years ago
Reply to  carlo nucci

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.

Andy Byers
Andy Byers
4 years ago

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?

RegistrationMagic
RegistrationMagic
4 years ago
Reply to  Andy Byers

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.

Brian R Coleman
Brian R Coleman
4 years ago

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.

RegistrationMagic
RegistrationMagic
4 years ago

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.

Brian Coleman
Brian Coleman
4 years ago

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?

Reinis
Reinis
4 years ago

Hello, my export all button is showing grey, and i canot press it. Any advice?

RegistrationMagic
RegistrationMagic
4 years ago
Reply to  Reinis

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.

Tibor
Tibor
5 years ago

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?

RegistrationMagic
RegistrationMagic
5 years ago
Reply to  Tibor

You can export the submissions from RegistrationMagic > Inbox > Export All.

Kay Schmidt
Kay Schmidt
5 years ago

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.

RegistrationMagic
RegistrationMagic
5 years ago
Reply to  Kay Schmidt

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.

Imdemotest
Imdemotest
7 years ago

How can i check database entry of my registered user?

RegistrationMagic
Admin
RegistrationMagic
7 years ago
Reply to  Imdemotest

User registrations are all available in “User Manager” page of RegistrationMagic’s backend.

Grace Chieso
Grace Chieso
7 years ago

I am using registration magic on my website but the form export as .xml file instead of csv, how do i resolve?

Thank you