Import File Deletes the Input Form Data
We noted that when importing a data file it deletes the input form data for the same category entity and time.
In the NW version there's also an AuditID (Datasource) segmentation for import, that allows a user to input to forms in one AuditID and and import data to another such that input form data is not deleted. This allows the users to constantly re-import their data (after corrections) without losing their input form data.
Any ideas for a solution in the MS version?
One manual solution is to import to another category (e.g. ACTUAL2) and then create a specific copy package from ACTUAL2 to category ACTUAL where the input form data resides, copying only the specific AuditID. This creates another step for the users.
Maybe automate the above option and add to the default script a copy statement that copies the above a when auditid = INPUT (the AuditID of the data) and not affecting the input form AuditID level.
Any other ideas?
The current setup assumes that the user will only enter input form data after completing the data import. This is not always the case. There are several import iterations.
Thanks in advance