[feat] Import : format relations as expected on paste

[tprouvot]

When exporting data from inspector, the format is "MaskSObject__r.APIName__c"

But the expected format is : "MaskSObject__r:MaskSObject__c:APIName__c"

Either update the expected format or format the input as expected on the paste

[tprouvot]

Since the udpate is only on the main object this feature is useless

[dufoli]

hello, this feature is not useless. If we do an upsert we can use external id to of linked object to create the link.
Example, I have an Account with externalID__c field (externalID checked on setup) then I can Import a contact with:
Contact Name, Account:Account:ExternalID__c
Olivier; MyAccountExternalId

then SF on import will find the link to account based on it and provide AccountId on Contact.

[tprouvot]

Hi @dufoli ,
OK I re-open this issue 👍

[dufoli]

anyway great tool and happy to see it back. I can try to provice a PR for that.

[dufoli]

@tprouvot I have 2 potentials solutions:

1. on exportside by setting header with name like needed on import
2. on import by guessing the the right field

[tprouvot]

Hi @dufoli,
I would be more than happy to review your PR!
About the approach, I think it would be better to update the expected format on import side since those convention ":" does not exist in Salesforce and we are used to see the "." for separating the related object.

What do you think?

[dufoli]

'thats whats i have done