search

eltoroit / ETCopyData

SFDX Plugin to populate your scratch org and/or developer sandbox with data extracted from multiple sObjects.
113 stars 23 forks source link

OrgWideEmailAddress not pulled in? #5

Closed homerlex closed 5 years ago

homerlex commented 5 years ago

Is the a reason OrgWideEmailAddress data would not be pulled in?

Looks like its ignored all together.

Here is what is in my json for it:

    "sObjectsData": [
        {
            "name": "OrgWideEmailAddress",
            "ignoreFields": "OwnerId,CreatedBy,CreatedDate,CurrencyIsoCode",
            "maxRecords": -1,
            "orderBy": "Address",
            "where": null
        }
    ],
eltoroit commented 5 years ago

Please run this with --loglevel trace and send me the log.

homerlex commented 5 years ago

Here is the full ETCopyData.json:

{
    "now": "2018-12-13T12:12:49.948Z",
    "orgSource": "PTDataSource1",
    "orgDestination": "PTDataDestination9",
    "sObjectsData": [
        {
            "name": "OrgWideEmailAddress",
            "ignoreFields": "OwnerId,CreatedBy,CreatedDate,CurrencyIsoCode",
            "maxRecords": -1,
            "orderBy": "Address",
            "where": null
        }
    ],
    "sObjectsMetadata": [
        {
            "name": "RecordType",
            "fieldsToExport": "Id,DeveloperName",
            "matchBy": "DeveloperName",
            "orderBy": null,
            "where": null
        }
    ],
    "rootFolder": "./ETDataFiles",
    "includeAllCustom": false,
    "stopOnErrors": true,
    "ignoreFields": "OwnerId, CreatedBy, CreatedDate, CurrencyIsoCode",
    "maxRecordsEach": -1,
    "deleteDestination": true,
    "pollingTimeout": 100000
}

Here is the output when running the export:

Timestamp      #   Level  Line Number           Description
─────────────  ──  ─────  ────────────────────  ────────────────────────────────────────────────────────────────────────────────────────────────
12:12:49.923Z  1   TRACE  export.js:14          Log level: trace
12:12:49.925Z  2   INFO   export.js:16          ETCopyData:Export Process Started
12:12:49.930Z  3   INFO   Settings.js:254       Configuration value for [orgSource]: PTDataSource1
12:12:49.931Z  4   INFO   Settings.js:254       Configuration value for [orgDestination]: PTDataDestination9
12:12:49.932Z  5   INFO   Settings.js:254       Configuration value for [includeAllCustom]: false
12:12:49.934Z  6   INFO   Settings.js:254       Configuration value for [stopOnErrors]: true
12:12:49.935Z  7   INFO   Settings.js:254       Configuration value for [rootFolder]: ./ETDataFiles
12:12:49.936Z  8   INFO   Settings.js:254       Configuration value for [ignoreFields]: OwnerId, CreatedBy, CreatedDate, CurrencyIsoCode
12:12:49.937Z  9   INFO   Settings.js:254       Configuration value for [maxRecordsEach]: -1
12:12:49.939Z  10  INFO   Settings.js:254       Configuration value for [deleteDestination]: true
12:12:49.940Z  11  INFO   Settings.js:254       Configuration value for [pollingTimeout]: 100000
12:12:49.942Z  12  INFO   Settings.js:186       Configuration value for [sObjectsData]: 1 sObjects found.
12:12:49.943Z  13  INFO   Settings.js:194       Configuration value for [sObjectsMetadata]: 1 sObjects found.
12:12:49.954Z  14  TRACE  ETCopyData.js:240     Configuration settings read.
12:12:50.153Z  15  INFO   OrgManager.js:27      [PTDataSource1] Alias for username: [ptdatasource1@pt.com]
12:12:50.773Z  16  INFO   OrgManager.js:27      [PTDataDestination9] Alias for username: [ptdatadestination9@pt.com]
12:12:51.403Z  17  TRACE  Exporter.js:45        [PTDataSource1] Querying Metadata sObject [RecordType]
12:12:51.405Z  18  TRACE  Exporter.js:111       [PTDataSource1] Querying [RecordType] with SOQL: [SELECT Id,DeveloperName FROM RecordType ]
12:12:51.408Z  19  TRACE  Exporter.js:45        [PTDataDestination9] Querying Metadata sObject [RecordType]
12:12:51.409Z  20  TRACE  Exporter.js:111       [PTDataDestination9] Querying [RecordType] with SOQL: [SELECT Id,DeveloperName FROM RecordType ]
12:12:51.505Z  21  INFO   Exporter.js:69        [PTDataSource1] Queried [RecordType], retrieved 22 records
12:12:51.564Z  22  INFO   Exporter.js:69        [PTDataDestination9] Queried [RecordType], retrieved 22 records

The recordTypes exported just fine. No sign of OrgWideEmailAddress.

eltoroit commented 5 years ago

OrgWideEmailAddress is not a data sObject. It's a metadata object.

eltoroit commented 5 years ago 
 "sObjectsMetadata": [
    {
        "name": "OrgWideEmailAddress",
        "fieldsToExport": "Id,Address",
        "ignoreFields": "OwnerId,CreatedBy,CreatedDate,CurrencyIsoCode",
        "matchBy": "Address",
        "orderBy": null,
        "where": null
    }
]