[BUG] - Tool is ignoring field mapping

[mohanta-pankaz]

Describe the bug
I am running a use case where I need to move a custom object records between the orgs. I attempted doing multiple things to map the target org record Id as an externalId on source org field but it never writes the value into that field. I believe the tool is ignoring the field.

Few key points to be noted for better understanding of the context :
There was an earlier migration happened from Target to Source couple years back now we want to do reverse.

1. [Source] X_18_Record_Id (Text) (External ID) => This field holds the [Target record ref Id which was created earlier during first migration]
2. [Target] X_18_Record_Id (Formula)

Now I want to store [Source] record Id value into some other field New_Source_Id__c (Text)(External) on [Target] as the order of migration is now reversed.

.....

"fieldMapping": [
               {
                   "targetObject": "MyCustom_Object__c"
               },
               {
                   "sourceField": "Id",   // This Id I want to map from Source org 
                   "targetField": "New_Source_Id__c" // This field is not present in Source but I want to populate it on target to keep a ref of migrated records
                 }
           ]

....
Output : It is writing target record id into New_Source_Id__c (Text) instead of Source record Id

.....

 "fieldMapping": [
                {
                    "targetObject": "MyCustom_Object__c"
                },
                {
                    "sourceField": "X18_Formula_Record_ID__c", // I tried mapping with creating a new formula field on Source populating record Id
                    "targetField": "New_Source_Id__c"
                  }
            ]

....
Output : It is not writing anything into New_Source_Id__c (Text) , even on output csv on target it doesn't show value for this column (X18_Formula_Record_ID__c)

To Reproduce

{
    "objects": [
        {
            "query": "SELECT Id ,X18_Record_ID__c, Name FROM MyCustom_Object__c Where calendar_year(createddate) =2012",
            "operation":"Upsert",
            "externalId":"X18_Record_ID__c",
            "useFieldMapping": true,
            "fieldMapping": [
                {
                    "targetObject": "MyCustom_Object__c"
                },
                {
                    "sourceField": "Id",
                    "targetField": "New_Source_Id__c"
                  }
            ]
        }
    ]
}

Expected behavior
It should write the value as per mapping irrespective of formula or text.

export.json
Attach your export.json file.
Reference: https://help.sfdmu.com/full-documentation/export-json-file-objects-specification/export-json-file-overview

Log file
Attach your full .log file.
Reference: https://help.sfdmu.com/full-documentation/reports/the-execution-log

_target.csv file.
When you have an issue with failed rows, attach the dump of the _target.csv file containing the error messages (at least 1-2 relevant full rows).
Reference: https://help.sfdmu.com/full-documentation/reports/the-target-csv-files

[hknokh]

Hello, @mohanta-pankaz

Thank you for reporting a bug.
I will take a look at it as soon as possible and let you know of any updates.

Cheers

[hknokh]

Hey, @mohanta-pankaz
I'm still checking this and let you know as soon as I can.
Regards

[mohanta-pankaz]

Hello @hknokh , any updates on this?

[hknokh2]

Hello
Not for now, I will update you.

[hknokh2]

Hello,
Your issue should be solved.
Now the source id should be copied when mapped to another field in the target side.
Please update and check
Cheers

[hknokh]

Hello.

This case is now considered resolved, and I am closing it for now. If you have any additional questions or concerns, please don't hesitate to reach out.

Regards.