SIGN UP

User data not importing from Gravity Forms

By: Davood Denavi | Asked: 08/27/2024
Forums › Category: General questions › User data not importing from Gravity Forms
0 Vote Up Vote Down
Davood Denavi asked 4 months ago

Hi, I am currently helping a client move their forms from Gravity Forms into Formidable. A couple of their forms can only be accessed by logged-in users. Users sometimes need to update the data collected by these two forms on the front end so this is why we are switching over to Formidable Forms, among other reasons, since no third-party plugins are needed to accomplish this with an Elite License. 

While the entries for both of the forms which require users to be logged in are importing the data in the hidden username field from the Gravity Forms is not showing up when we import the data from Gravity Forms using the built in importing feature of Formidable Forms. This is causing users to not see their last submission on the front end and it is causing us as admins to see the last submission no matter who is the user. Please advise how we can fix this?

Thank you in advance for your help! :)

1 Answers
0 Vote Up Vote Down
Victor Font answered 4 months ago
You'll have to rely on your own expertise as it relates to GF's architecture. The link that follows is the current Formidable database schema. Formidable's form entries are stored in wp_frm_items and wp_frm_item_metas. User_id is a field in wp_frm_items. There's no other way to match a user with the current_user filter in a view unless you've explicitly added a user_id field to the form in the builder. I'm going to continue my answer about moving content between systems in the comments. https://formidableforms.com/knowledgebase/database-schema/
Victor Font replied 4 months ago

I don't know what value GF stores in the hidden user_id field you reference in your question. Formidable's views expect a valid WordPress user_id that matches the current user filter. While you might see names when user id fields are shown in Formidable, only the WordPress user_id is stored in the database.

I have never imported GF data, but I do know that when importing user_ids, the WordPress user tables must match user_ids exactly as expected in the import, otherwise the default admin user is used. Admins should be able to see all data anyway unless explicitly filtered out by user_id = current_user in your view.

You don't mention your development environment setup. If Gravity Forms and Formidable are being worked together in the same WordPress instance and are sharing the same WordPress User tables, then there could be a difference between the value GF sends in its CSV as opposed to how Formidable can map that value to a valid user.

To help with the diagnostics, please open the GF CSV in Excel? What value is in the GF hidden user_id field? Is it a numeric user_id or a text value like username or login name?

If numeric, does it match the expected WordPress user for both systems?

Was the hidden user_id field properly mapped to the form's user_id field during the import mapping process?

I'm just about out of ideas until we know approximately what went wrong. You do have an Elite license, if the problem is on the Formidable side, open a priority support ticket with Strategy 11. You're entitled to it. I might open a ticket anyway to see if anyone else has reported a similar issue to them. This is a community volunteer forum, so it's a little hit or miss at times for answers to appear here.

Davood Denavi replied 4 months ago

<p>Actually Victor your second reply proves that it is not an issue with GF's architecture. That said, I figured out what the problem I was having was last night and it was in fact an issue with built in importer crashing when I uploaded the CSV export I had from GF. So I split the CSV up into 4 smaller CSVs and the problem was resolved.</p>

Victor Font replied 4 months ago

Did you use the CSV splitter I made available on Formidable Masterminds?

Davood Denavi replied 4 months ago

No I did not. I did not know it existed.

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
crossarrow-right