Apex Code Development You need to sign in to do that
Don't have an account?
jojoforce Upload Child Records via Data Loader
Hi. I'm sure alot of people had ran into this type of issue. Basically, I have a Parent record, and Child record that I want to load via Data Loader. Since its an Insert (or Upsert), I wouldn't know the "Parent ID" initially. So I'd have to insert/upsert the parent. Grab the Parent ID and paste the Parent ID to the reference ID in the Child record. This is a pain especially if i am loading a lot of parent-child related records. Is there even an easier work around in data loader?
Why I do Basically is use MS Access and import the xls in that and create a diffrent table of parent and export the two tables together hope this helps....
but if I'm trying to import both the Parent and Child records, how would I know what the Parent ID is? I'd have to upload the Parent record first, then extract the parent record to get the Parent ID to paste it to the Child Record. It seems cumbersome.