Rob LeVine
Staff replied 1 month ago

Do you mean you have two CSV exports of the entries? If so, do they contain different versions of the same entries, different entries, or a combination of the two? Do they create the same columns? Finally, have you noted the information in the knowledgebase? " If an imported form, entry, or View matches the key and creation date of an existing form, entry, or View, the existing item will be updated."
https://formidableforms.com/knowledgebase/import-forms-entries-and-views/

Ayman Sheta
replied 1 month ago

They contain different versions of the same entries... same columns. but one with extra columns ....

Rob LeVine
Staff replied 1 month ago

Then that link should give you all the information you need. If the entries that are the same have the same information in the key column, then you upload the CSV with the earliest data, and then you import the most recent data afterward, and it will update the data.

Ayman Sheta
replied 1 month ago

Are there a way for Duplicated fields ? we can say I have two customer fields ..Are there a way to merge the two customer in one field ?

Thanks

Victor Font
Staff replied 1 month ago

You have to write custom code to do the kind of processing you want. The mistake you made is using two forms with the same data. It’s a bad design choice. Effective data management follows the “single source of truth” principle.

Ayman Sheta
replied 1 month ago

I am not using two form , its one form with two backup in diff. date ...

Rob LeVine
Staff replied 1 month ago

Any data manipulation you want to do will either have to be done manually in the CSV files, before the import or during import using the frm_after_create_entry or frm_after_update_entry developer hooks. I suggest adding a (temporary) hidden field to the form to identify if the entry is imported, so your custom code will only be run when a row is imported (e.g., create a field "Imported?", set its default to "N" and then add that row to your CSV file and set it to be "Y" for all entries).