Export Referrer Data

By: Matt Grimes | Asked: 11/28/2022
ForumsCategory: General questionsExport Referrer Data
Matt Grimes asked 1 year ago
In the entry under User Information is a "Referrer" Field If I export a XML file this field is in a array , i can see it, if i export a csv, this information is not there at all. Has anyone been able to export his data out correctly to csv? Is there a hook anyone knows about that I can loop thru this data before export? Can I update the admin screen to show an additional field and loop thru this data maybe on the entries panel? My client wants the referrer information for there records
2 Answers
Victor Font answered 1 year ago
I haven't confirmed this, but I suspect the difference has to do with the import process. CSV exports cannot be used to import forms, only data. XML is used to import forms, views, data, and styles. XML accesses all the tables Formidable uses to store its content. CSV exports only data that is stored in the frm_item_metas table. The referrer information you want is not stored in frm_item_Metas, but in the description field in frm_items which CSV does not export. I don't know if this will help, but perhaps understanding Formidable's schema will help. https://formidableforms.com/knowledgebase/database-schema/. If you examine the entry contents in your site's PHPMyAdmin you can see what I'm talking about.
Matt Grimes replied 1 year ago

Is there a hook to access that data on export or just use a sql statement?
I even tried to use a view, hoping it would display but that info is just not present on wp backend

Matt Grimes answered 1 year ago
can we get data out with user flow?
Victor Font replied 1 year ago

What do you mean by "user flow"?

Matt Grimes replied 1 year ago

sorry User Tracking

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