How to map 'To', 'From', 'Bcc', and 'Cc' email fields in KingswaySoft where the data type is 'ntext'? I'm getting GUIDs for these fields in the source, but the GUIDs are different from those in the target. How can I resolve this mapping issue?
I'm working on a data migration project using KingswaySoft to map email fields in Dynamics CRM. Specifically, I need to map the 'To', 'From', 'Bcc', and 'Cc' fields, which have an ntext data type.
When I attempt to map these fields, I receive GUIDs for each field in the source, but the GUIDs are different from those in the target system. I’m unsure how to properly map these fields, given that the source and target GUIDs do not match.
Has anyone encountered this issue before? How can I correctly map these email fields while resolving the GUID mismatch?
Additional Details:
Source: Dynamics CRM (email entity with ntext fields for To, From, Bcc, and Cc)
Target: Dynamics CRM
Using: KingswaySoft SSIS Integration Toolkit
Data Type: ntext for the email fields
The input of those fields is expected to be a JSON data structure or delimited text value that consists of the activity party ID values in GUID format. For more details on how to work with those fields, please refer to the documentation topic. In case that the ID might be different in the target system, you can leverage the Text Lookup feature. For CRM to CRM migration/integration, you can very much map the same field from the source to the destination.