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$InvalidMappingException: No such field type on entity Task.

Any help would be appreciated!

Thanks,

Connie