can the excel templates exported from FDM (for example for Import Format,s Logic Accounts, etc), update/delete records?
For example, let0s say i have a custom table in FDM and I want to manage it using a XLS template that will be loaded using "Import XLS" menu entry.
Could we use that for totally manage the table?
I.e: If we have three records in the table, we export to the XLS, we remove one record from the XLS, would FDM remove that record from the custom table as well when XLS is imported?
I don't think so. I think the Import XLS simply does an append to the current data set. I've always deleted all the records from the relevant tables using a DML ststement kicked off from a web script in the FDM Taskflow and then loaded a complete dataset from the template with whatever changes are necessary, additional records, updates deletes etc. It's clean and works.
If you have created the custom table in the FDM database/schema then yes. Just for information its best to open a new thread for your question rather than post on an already closed/answered thread as you will get a better response.