Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
1

Questions
2

Replies

2 replies

Delete Parent Child Relationship using Apex Data Loader

Beginning Winter '07, we can create Parent Child Relationships

while loading data using the Apex Data Loader.

For example:

I have the Account object with External ID = ERP_Id__c

In my org, one Account can be the Parent of the other.

Using the Data Loader, I am able to tie one account to the other

by defining the Parent field of the account being upserted

as a lookup (using the External ID) against all the available accounts.

The sdl entry for this is shown below

(left side = Input file header, right side = SFDC field):

Parent_ID=Parent\:ERP_Id__c

This works perfect when

- an exact match is found

- when an exact match is not found

However, when one account gets disconnected from its parent in the source ERP system,

I am sending an empty string for Parent_ID.

But the parent child relationship does not get deleted.

Does anybody have any ideas on how I can delete the Parent-Child relationship

using the data loader configuration and/or the input file data?

Regards,

Shiv.

PS: I have already tried the input data = single space for the Parent_ID field.

rsk_1980
September 21, 2007
Like
0

3 replies

Autopopulating Account Address when an Account is selected by lookup search

Hi all,

Iam a complete newbie.i have tried my level best to solve the above problem but could not make it .Iam posting here with a lot of hope and respect. hope i get a solution for this.

can any one help me in the following quesries :

1) How can i autopopulate the Account Address when i select the Account to reduce the double entry of the Account address?

2) Where can i find the various fields in the salesforce ,so that i can use the fields to display accordingly ?

waiting for your valuable replies ,

Thanks in advance

best regards
Pavan Kumar.Narra

pavan
September 22, 2007
Like
0