function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
cmikkels1.3927987982443347E12cmikkels1.3927987982443347E12 

Data Loader export mapping file

Hi,

I have a script running on a linux server, that export data from salesforce via the Data Loader. The export is working fine, but I need to add some extra fields to the exported csv-file.

When inserting data it is done like this. SYSTEMMODSTAMP=

Just by leaving the field empty. But this is not possible when exporting data. I have tried:

"null"=MyField
=MyField
""=MyField

Do any of you know if this is possible?

I know that this doesn't make much sense, but the people i deliver this file to wants it this way, with empty fields. There are several empty fields, and I would like to avoid creating them in Salesforce.

Hope you can help me.

Best regards,
Christian.
dev_sfdc1dev_sfdc1
Hi,
You have to use like this '#N/A' in your csv  file in place of null.
cmikkels1.3927987982443347E12cmikkels1.3927987982443347E12
I have not been precise enough in my explaination. When I export, I use a mapping file. It could look like this:

#Mapping values
#Monday Jan 6 12:56:31 GTM 2014
CloseDate=FORCASTED_SIGN_DATE
Owner.Name=SALES_PERSON
StageName=LOCAL_STAGE
Description=OPPORTUNITY_DESCRIPTION
Service_Interest__c=LOCAL_PRACTICE
Service_Specification__c=LOCAL_ALLIANCE
Account.Name=ACCOUNT
Won_Amount__c=TOTAL_VALUE_ONSHORE
Amount=TOTAL_VALUE_UNWEIGHTED
Probability=%WEIGHTED
Won_Amount__c=TOTAL_VALUE_WEIGHTED
#N/A'=Test

The does not work here. I fear that is it not posible to do what I want. If any of you have any ideas of what to do, I would be very happy to hear them!

Kind regards,
Christian.