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
Dan Dodd 3Dan Dodd 3 

Import case via Data Loader is missing data

Importing from this CSV file: 
"OWNERID","STATUS","ORIGIN","SUBJECT","PRIORITY","DESCRIPTION"
"3D00G1U000002xbcg","New","EMAIL","New order.","HIGH","Seven TwentyOne Main"

Gives me this success message showing new ID : 
"ID","OWNERID","STATUS","ORIGIN","SUBJECT","PRIORITY","DESCRIPTION","STATUS"
"5002900000BrQN4AAN","3D00G1U000002xbcg","Item Created","EMAIL","New subscription renewal order.","HIGH","Seven TwentyOne Main","Item Created"
A Case is created but the detail is missing, Origin is blank, owner is me, not the OwnerId, subject blank, descriptrion blank, Just ... Nothing but the defaults for Status and Priority

I disabled the trigger.
Best Answer chosen by Dan Dodd 3
Maharajan CMaharajan C
Dan,
1. Did you done the field mapping?

2. Check whether you are doing the correct field mapping in data import?

Thanks,
Maharajan.C

All Answers

Maharajan CMaharajan C
Dan,
1. Did you done the field mapping?

2. Check whether you are doing the correct field mapping in data import?

Thanks,
Maharajan.C
This was selected as the best answer
Dan Dodd 3Dan Dodd 3
Yes Mapping was incomplete. Thanks
Dan Dodd 3Dan Dodd 3
Still not seeing how to map createddate. I have set  the org that audit fields are insertable. I could do this with a triggger? put created date in an unused fields and use a before insert trigger to grabit and update the actual field.
Dan Dodd 3Dan Dodd 3
Mapping created date require setting the System permissions to allow editing Audit field on insert
and a permission set entry of the same. https://help.salesforce.com/articleView?id=000334139
and https://help.salesforce.com/articleView?id=Enabling-Create-Audit-Fields-for-Professional-Edition&type=1 (https://help.salesforce.com/articleView?id=Enabling-Create-Audit-Fields-for-Professional-Edition&type=1)