Update Contact Person with DTW

[michael_boucher2]

Hi all,

I want to update all our BP contact persons using the DTW, however I need to specify the linenum, which doesn't seem to be kept in the database (OCPR), only the cntctcode, which isn't an option in the DTW.

Does anyone know of an easy way to do this?

Thanks,

Michael

[former_member187989]

hi boucher,

Check this thread,

It will solve problem.

Jeyakanthan

[Former Member]

Please check this thread:

Thanks,

Gordon

[michael_boucher2]

Thanks, but I'm getting an error saying I can't have nulls in the name column... but I'm updating not inserting and I don't have the name column in my template!

[Former Member]

You may not be able to update Contact Person only by line number. Try add name field to see.

[michael_boucher2]

When I add the name field it says the value already exists.

[Former Member]

Uncheck Add records. Only left updating existing records.

[michael_boucher2]

I've never had add ticked, it's only update that is ticked.

Thanks,

Michael

[Former Member]

Post a couple of sample data here for other to check then.

[michael_boucher2]

recordkey linenum cntctcode u_conttype

recordkey linenum cntctcode u_conttype

1 1 103 1

2 2 110 1

2 4 1732 1

I tried adding the name in, but no good.

The header template is just recordkey and cardcode.

[Former Member]

Do you just need to add one UDF value for some existing Contact Persons? Where do you get those line numbers?

[michael_boucher2]

Yes, we just need to populate the UDF.

I got the line numbers by manually adding them in based on that link you posted...

so for cardcode XYZ, cntctcode 1,30,56, 1 would be line 1, 30 line 2, and 56 line 3.

Thanks

[former_member187989]

Check this link

Jeyakanthan