forcedotcom / SFDX-Data-Move-Utility

SFDMU is a cutting-edge Salesforce data migration tool for seamless org population from other orgs or CSV files. It handles all CRUD operations on multiple related objects in one go.
BSD 3-Clause "New" or "Revised" License
451 stars 75 forks source link

[QUESTION] - Organization SObject Update #708

Closed dieffrei closed 7 months ago

dieffrei commented 7 months ago

Hi, I'm trying to export and import Organization SObject information. My configuration looks like this:

` { "objects": [ { "query": "SELECT Id, Name, DefaultLocaleSidKey, TimeZoneSidKey, LanguageLocaleKey FROM Organization", "operation": "Upsert", "externalId": "Name" }

]

}

`

But I still don't get any results, it just says that there is nothing to update:

` === Target: === ============= [10:16:43.143] {Organization} Fetching the Target data from Org (STAGE 2: all records) ... [10:16:43.144] {Organization} Query string: SELECT Id, Name, DefaultLocaleSidKey, TimeZoneSidKey, LanguageLocaleKey FROM Organization. [10:16:43.144] {Organization} Using REST API to retrieve the data ... [10:16:44.223] {Organization} Data retrieval (Target) has been completed. Got 1 new records. [10:16:44.225] Data retrieval (STAGE 2) has been completed.

=== Triggering Add-On events ... [10:16:44.226] No Add-On modules found to run.

=== Data retrieval summary. [10:16:44.228] {Organization} The total amount of the retrieved records: 1/1.

=== Updating the Target (STAGE 1) ...

[10:16:44.230] Nothing was updated.

=== Updating the Target (STAGE 2) ...

[10:16:44.231] PASS 1 === =============

[10:16:44.232] PASS 2 === =============

[10:16:44.232] Nothing was updated.

=== Triggering Add-On events ... [10:16:44.233] No Add-On modules found to run.

=== Data processing summary. [10:16:44.234] {Organization} Totally processed 0 records.

[10:16:44.234] Writing to /Users/dieffrei/Desktop/workspace/****/data/config/MissingParentRecordsReport.csv ...

=== Triggering Add-On events ... [10:16:44.235] No Add-On modules found to run.

Command in progress... done

[10:16:44.237] Command succeeded. [10:16:44.238] Execution of the command sfdmu:run has been completed. Exit code 0 (SUCCESS). [10:16:44.238] Total time elapsed: 00h 00m 13s 664ms .

`

dieffrei commented 7 months ago

I got this extra info: [11:00:49.353] [WARN] No fields available for insert/update were detected for the object Organization.

There is no way to set FLS via Profile/Permission Set for Organization Object. But I can see in the SObject Metadata those fields are updatable. I also could update the field values via API.

dieffrei commented 7 months ago

It would be very helpful when we need to config, Org default language, currency, etc...

hknokh2 commented 7 months ago

Hello, Thank you for reaching out to me. The sfdmu works only with fields available both for insert and update. Cheers.

dieffrei commented 7 months ago

Thank you @hknokh! That is good to know! Cheers