Combine two import file fields to map to one document type property
Hi Richard,
Is it possible to combine/concatenate two fields into one during the import process? For example, a customer has an import file with the date and time split into two separate columns, when imported they will need to be combined to create a single DateTime value for the document type property.
You can't do this via the UI. What you can do is use the event system to update the value after the record was imported . Or create a custom Data provider that combines the 2 fields during read of the file. Both require a bit of coding but it is possible then.
Combine two import file fields to map to one document type property
Hi Richard,
Is it possible to combine/concatenate two fields into one during the import process? For example, a customer has an import file with the date and time split into two separate columns, when imported they will need to be combined to create a single DateTime value for the document type property.
Thanks, Simon
Hi Simon,
You can't do this via the UI. What you can do is use the event system to update the value after the record was imported . Or create a custom Data provider that combines the 2 fields during read of the file. Both require a bit of coding but it is possible then.
Best,
Richard
OK thanks Richard - I thought that may be the case.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.