You need to sign in to do that
Don't have an account?
steve456
Apex Data Loader ----Insert issue
I have two objects 'Building ' and 'Lease' .Lease is a child of building
I have an excel sheet with all information regrad to building and lease.
What i did is I inserted the information pertaining to 'Building' which is the Master object.All the records were inserted successfully ,Happy tilll here
Next when I tried to insert records for the child object 'Lease' .I got error for all inserted records.
The error is like this 'Building: id value of incorrect type: XZ006'
Can anybody help me out of this cave
how u are inserting the child records?
through data loader
I am mapping the lookup field "Building" to the available field "Building" which is showing value as refernce
Then i created recordtypeid field in the excel and gave the same recordtypeid value .and map the recordtype id to recordtypeid which has value as reference
how u are referencing the accounts in contact csv?
still i am getting the same errorr
Hi,
Steve since you are using the dataloader for importing the record you have to specify the buildindId (salesforce id after inserting of billing records) inside the child object then map this field with billindid in dataloader. Now you will be able to insert the child record with exact billing field vale. But if you are goin to use import wizard i.e. inside the Org then you can use field name as mapping. SO from here you can use your CSV file without mentioning the BillingId. Here you can use the billing field name for mapping but for dataloader you must have to put the salesforce id for all those field which is lookup or masterdetail relation.
Think this will help you.
You need to insert your parent records first, pull the Ids back out, put those Ids in your child record CSV file, then import the children.
this is good if you have few records.What happens wen u have records in thousands.
Not a gud idea.I heard that the best possible way is to use v look up. Some one needs to shred light on this
Annoyingly I had this working in dataloader however since spring release/reformat of my laptop (meaning reinstall of dataloader) I can no longer import lookup fields without using saleforce ID. I used to be able to specify the external ID of the parent item in the .csv and import. Alas this is not working now and I am pulling my hair out trying to figure out what has changed.