Discussions
- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Security
- Mobile
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
- Force.com Discussion Boards
- :
- Developer Boards for Force.com and Database.com
- :
- General Development
- :
- Completed Task export fields invalid mapping
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Completed Task export fields invalid mapping
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
12-04-2012 10:01 AM
Using the command line dataloader, I would like to export some of the fields in the Task table. I want to differentiate between Calls, Emails, etc. My thought is this data would be found in the Type field.
I've built the sdl file, setting the mapping for a few of the SF fields, then written the sql in the process-conf file. The following works:
#Mapping values
#Tue Dec 04 10:36:00 EST 2012
Description=Description
ActivityDate=ActivityDate
Subject=Subject
CallObject=CallObject
Id=Id
CallType=CallType
OwnerId=OwnerId
WhoId=WhoId
CallDisposition=CallDisposition
WhatId=WhatId
CreatedDate=CreatedDate
SystemModstamp=SystemModstamp
with the following sql in the process-conf:
<entry key="sfdc.extractionSOQL" value="Select WhoId, WhatId, Subject, ActivityDate, Description, CallType, CreatedDate FROM Task"/>
However, if I add Type to the mapping:
#Mapping values
#Tue Dec 04 10:36:00 EST 2012
Type=Type
Description=Description
ActivityDate=ActivityDate
Subject=Subject
CallObject=CallObject
Id=Id
CallType=CallType
OwnerId=OwnerId
WhoId=WhoId
CallDisposition=CallDisposition
WhatId=WhatId
CreatedDate=CreatedDate
SystemModstamp=SystemModstamp
and the process-conf:
<entry key="sfdc.extractionSOQL" value="Select WhoId, WhatId, Subject, ActivityDate, Description, CallType, CreatedDate, Type FROM Task"/>
I get the following error:
FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Unable to run process CompTaskExtract java.lang.RuntimeException: com.salesforce.dataloader.mapping.Mapper$InvalidMa
Any help would be appreciated!
Thanks,
Connie
Re: Completed Task export fields invalid mapping
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
12-04-2012 11:40 AM
I think I have it figured out.
From reading other posts, I checked the setup for the tasks & the field was not on the screen design. Once I added the field, I was able to pull the data.

