How to Delete Removed Records When Using Synchronize Objects in Excel Importer?

0
I am using the Excel Importer module in Mendix and the "Synchronize Objects" option to import data. However, I am facing an issue where deleted records from the uploaded file are not being removed from the database. For example: I upload a file with 5 records. Later, I upload the same file but with 1 record removed (now containing only 4 records).After import, the database still contains all 5 records instead of deleting the removed one. Any guidance would be appreciated. Thanks!  
asked
3 answers
0

Hello Asha,

You can check settings tab in your excel importer template.

You can read more about "Remove unsynced objects"

answered
0

Hi Asha,

Synchronizing objects while importing Excel will update existing objects and create non-existing objects.

so 1st time, if you import the file, it will create 5 objects; the 2nd time after removing 1 object from the file, it will synchronize the remaining 4 objects. 

 

 

Thanks

answered
0

Hi Asha,

You can’t delete data  directly from DB with the help of excel. 

Synchronize objects is used for add new records & update the existing records.

answered