Hello,
I have some questions about DMWs and whether it’s possible to specify that one or more fields should not be overridden unless a value is supplied during the DMW import when using the default Worksheet Channel in ETM.
For example, when updating Item Users, there may be some users who already have an existing Item Users record. During import, instead of creating a new record, the existing record is then instead updated. The issue is that if say the original record had data in the Access Note or Remarks fields, and the DMW import file has a blank column for those fields, then the previous data is overwritten with an empty string.
If the column is not included in the import file then any existing value is not overwritten, however as long as the column header is present then the original data is blanked if left empty in the import file. We’ve tested applying a default value of Empty_Record to the DMW import file sub‑header for the appropriate columns, but this has had no effect.
The workaround we currently use is to delete the Remarks or Access Note column from the DMW import file so that existing data is not overwritten. However, this becomes cumbersome when the import file contains a mix of rows where some have values and others do not, and the import file then has to be broken into separate chunks.
Is this sort of non‑destructive update possible when working with the default Worksheet Channel?
Thank you very much for your time,
Richard
