Hi Sachin,

How exactly can I debug this? I have nothing in my UI to make this action go, so "start debugging" does nothing. I tried running the timer but nothing happened when I did. I'm not sure how else I can track if the flow is working properly or not. Also, what is the OML?

It is the OutSystems Module file which can be saved as .OML file. 

Please go to the Menu Module --> Export --> Save AS and give it a name and attach here.

I attached the file here, there are multiple entities that I want to do this with but they're all set up the same way so I only need help with one of them ie. TheLatestTrends

So this should replace all of the entity data with whatever is in the excel file, right? I just tried to run it and the record that I wanted removed is still there. Can this action not handle deleting things as part of the update?

Also, once I make a change in excel, is it necessary for me to re-import that excel file or will it update automatically?

Wait a second, you want to remove the data that is no longer in Excel file?

If that is the case, the easiest way is to delete all records in bulk with an Advanced Query and create it once again.

NOTE: Be careful when deleting data that might be referenced, so if you are using the LatestTrendId in another table, you might have database inconsistencies if you remove the record.

Regarding the second question, this logic flow is binded to a Timer which is scheduled to run When Published. So whenever you publish this module, this timer (and the logic flow associated to it) will run.

I apologize if I'm not being very clear. I want to update to exactly what is in the excel file; that is, if I delete a record, add a record, or change an existing record, I want the entity to update to that with each publish. Is all of this possible with just the CreateOrUpdate, or do I need the Delete in there as well?

Hi Joseph,

The above solution and OML will cope with your requirements.

It will delete everything and it will insert the new data, so:

• what was there will still be there (it will be removed and inserted again in the database)
• what is no longer there will be removed from the database
• what is new, it will be inserted in the database

The delete worked and cleared everything, but now for some reason the CreateOrUpdate is not adding the records to the entity and it's staying empty.

I attempted to use CreateOrUpdate but it either didn't do anything or just created duplicate entries. I'm not sure why.