Is there a way to export User Information?

By: Marius Pascu | Asked: 10/10/2023
ForumsCategory: General questionsIs there a way to export User Information?
Marius Pascu asked 6 months ago

Hello, I have several forms, each form having between 50-200 entries.

Is there a way to export these entries to a CSV/XML which includes each entry User Information?

By user information, I mean:

  • IP address
  • Browser/OS
  • Referrer
  • Pages visited

If I open an entry, I can see this information, but if I export the entry, the information is not there (with the exception of "printing" the page, but I need to export all the entries from that form, so it doesn't help).  

Did anyone find a solution to this?

Thank you.

Marius Pascu replied 6 months ago

Update: I managed to export it from Formidable Forms -> Export/Import -> XML.
The XML export shows all the User Information under the "description" column.
All this information is in a single text string, so you have to use various methods to separate it.

These are the steps I did:
1. Used an online tool to make the XML to CSV;
2. Opened the file with LibreOffice Calc;
3. I used REGEX commands in Find & Replace to delete unnecessary text before and after what I needed, which was the "referral" data.
3.5. To use REGEX commands in Find & Replace, you have to check the "Regular expressions" box.

I hope this helps someone one day.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community