Hi there,

Has anyone managed to get Excel 2016's Get & Transform Salesforce Objects or Salesforce Reports functionality to work?
I can connect via SSO easily enough, but I get the error code below.

DataSource.Error: Web.Contents failed to get contents from 'https://[company name].my.salesforce.com/services/data/v29.0/sobjects' (400): Bad Request
Details:
    https://[company name].my.salesforce.com/services/data/v29.0/sobjects

My guess is that it is probably a case of my company only using Professional, but I cannot find any documentation on either Microsoft or Salesforce's side that lists requirements.

​Thanks!

Can I get apex managed sharing enabled for my production and sandbox instances? I was told I can't open a case(10803467) for this.

Hello, everyone,

 

Wonder if anybody knows how to use variables in the XML beans of the Data loader CLI processes?

 

For example, I would like to replace the path "c:\dataloader\samples\" with a text variable in the body of the bean and be able to change the value of this variable when necessary.

 

It seems like the standard XSLT variable syntax does not work within a bean... :(

 

Thanks a lot for your help!

 

<bean id="opportunityUpsertProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>Opportunity Upsert job gets the Customer record updates from a CSV file and uploads them to salesforce using 'upsert'.</description>
        <property name="name" value="opportunityUpsertProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
                <entry key="sfdc.username" value="user@mycompany.com"/>
                <!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
                the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
                <entry key="sfdc.password" value="5555555555555555"/>
                <entry key="process.encryptionKeyFile" value="c:\dataloader\samples\conf\sample.key"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.externalIdField" value="Oracle_Id__c"/>
                <entry key="sfdc.entity" value="Opportunity"/>
                <entry key="process.operation" value="upsert"/>
                <entry key="process.mappingFile" value="c:\dataloader\samples\conf\opportunityUpsertMap.sdl"/>
                <entry key="dataAccess.name" value="c:\dataloader\samples\data\opportunityData.csv"/>
                <entry key="dataAccess.type" value="csvRead"/>
                <entry key="process.initialLastRunDate" value="2006-12-01T00:00:00.000-0800"/>
            </map>
        </property>
    </bean>

Hello, everyone,

 

Wonder if anybody knows how to use variables in the XML beans of the Data loader CLI processes?

 

For example, I would like to replace the path "c:\dataloader\samples\" with a text variable in the body of the bean and be able to change the value of this variable when necessary.

 

It seems like the standard XSLT variable syntax does not work within a bean... :(

 

Thanks a lot for your help!

 

<bean id="opportunityUpsertProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>Opportunity Upsert job gets the Customer record updates from a CSV file and uploads them to salesforce using 'upsert'.</description>
        <property name="name" value="opportunityUpsertProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
                <entry key="sfdc.username" value="user@mycompany.com"/>
                <!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
                the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
                <entry key="sfdc.password" value="5555555555555555"/>
                <entry key="process.encryptionKeyFile" value="c:\dataloader\samples\conf\sample.key"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.externalIdField" value="Oracle_Id__c"/>
                <entry key="sfdc.entity" value="Opportunity"/>
                <entry key="process.operation" value="upsert"/>
                <entry key="process.mappingFile" value="c:\dataloader\samples\conf\opportunityUpsertMap.sdl"/>
                <entry key="dataAccess.name" value="c:\dataloader\samples\data\opportunityData.csv"/>
                <entry key="dataAccess.type" value="csvRead"/>
                <entry key="process.initialLastRunDate" value="2006-12-01T00:00:00.000-0800"/>
            </map>
        </property>
    </bean>