Help with Importing not updating existing entries

By: Martin Lord | Asked: 06/06/2023
ForumsCategory: How-toHelp with Importing not updating existing entries
Martin Lord asked 10 months ago

Hello. I have a excel sheet that looks similar to the following:
Common names; Scientific names;       IUCN Red List status 
Rifleman               Acanthisitta chloris    LC
Bushwren             Xenicus longipes       EX
Rockwren             Xenicus gilviventris   EN
My form is 3 text fields. Each is called the same as the title of the CSV headers. 

When I import I put the CSV header to the corresponding field of the the name.  Below the blue import button there's a note.
"Note: If you select a field for the Entry ID or Entry Key, the matching entry with that ID or key will be updated."
How do I go about using this?
I cant seem to find anything in the documentation to help me. 

I wish to have the Scientific names as the unique ID, Entry ID or Entry Key. 
But I also need the Scientific names to be its own field.
How do I go about this? 

1 Answers
Rob LeVineRob LeVine answered 10 months ago
I suggest exporting some existing entries from any table. That way you'll see the "Key" column. If you're creating your own entry key, you can put your own values in that column and when you go to import, make sure you map the columns correctly if they aren't automatically. If you don't put anything in the "Key" column Formidable will generate a key unique to your system. If you do fill in the column on your own, you need to be sure they're all unique. You will tear a hole in the space-time continuum if there are two entries with the same key.
Martin Lord replied 10 months ago

Thank you very much. I will go try this out.
And ill double-check for any potential space-time-worthy errors!

Victor Font replied 10 months ago

This article explains keys vs. ids and how to structure your forms to make them transportable across WordPress instances. It may bring some light to the requirement you're trying to solve:

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