function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
bkmmspbkmmsp 

Excel Connector PE and Inserting Tasks

I am having no luck inserting Tasks via the Excel Connector.  Can someone advise if it is just not possible?
 
I have a professional Account and have successfully used Excel Connector for a lot tables but cannot get it to work on tasks.  I literally queried the table, cut and pasted an actual task, changed the date and attempted an insert.  I always get this error:
 
Salesforce Create()
invalid range, missing data type,  or other error,
Type is: Task
The current field definition for "CreatedById" requires a value to be set
 
Things I have tried:
User the actual UserRecordID data in place of just the Alias
Removing the Account ID data
Changing the default "Created By ID" to the referenced "CreatedByID"
And just about every other permutation of variables associated with the created by id field.
 
HELP!  Am I just barking up the wrong tree - is it not possible?
 
Thanks for any help!
 
BKM
 
 
Ron HessRon Hess
try removing the CreatedById from the column list