Delete values in z-fields via data-upload

[former_member700057]

Dear SAP,

we´ve created several z-fields in contact profile. Via data-upload you can of course bring values into that fields (in template for data upload the z-fields are included). It´s also possible update the values in fields where e.g. allready a value exist. Now I want to make sure, that via data upload the values of a z-field can be deleted. I tried it out, but was not successfull.

Has anybody a idea how I can delete the entries of z-fields via data upload? Or do I have to delete the values manually in the contact profile?

Thanks for your help,

Lukas

[benjamin_schaedle]

Hi jimbotbs

I have the same issue with deleting values of custom contact fields via the data load app. Uploading the custom field with no value, did NOT delete the existing value in SMC.

Can you please share an example upload file where you did manage to delete a field value.

Thank you

Benjamin

[former_member599277]

Hi Lukas,

I just checked by uploading a blank value to the custom fields using data file upload and data was cleared from the field as required.

So it should generally overwrite with the values ( if blank then - delete the existing value for the field ).

If not , Please provide more details on the exact steps followed from your end .

Regards,
Saravana.

[former_member700057]

Hello schneidert

hello saravana92,

that was exactly what I did. First I uploaded the contact with value in the particular field and after that I tried to delete the allready existing value with another upload (with no value in that field in the upload file).

Sadly no change is visible in the field of contact person. My expectation was like yours Tobias.

Kind regards,

Lukas

[former_member599277]

Hello Lukas,

Can you check if there is any custom logic implemented in the system ? as ideally it should clear the value in your case.

Regards,
Saravana.

[SCHNEIDERT]

Hi Lukas,

if you upload the contact without the z-field included it should get overwritten as per my knowledge. But that didn't happen?

I will double check on my system.

BR Tobias

[SCHNEIDERT]

wissing,

I tried to reproduce your issue but I'm also not able to. I tried both possible ways:

1.

Step a) Upload a contact with a value for the custom field

Step b) Upload the same contact without the value for the custom field

Value of the first import is overwritten with the empty value from upload two.

2.

Step a) Upload a contact with a value for the custom field again

Step b) Upload the contact but deleted the whole column with the custom field in the import file.

Same here. Value of the first import is also overwritten with the empty value of the second import.

I also checked the guides again and the statement is that always the whole import file is considered. So, because of this it is also not possible to "update" a contact by providing only one or two fields that he hasn't already filled with values (think because it is technically a PUT and not a PATCH).

How does your uploaded data look like in the import monitor?

As Saravanakumar already said, I would check if there's any custom logic or something like that.

Otherwise I think you should open an incident to let SAP check that issue.

If it helps, you could provide screenshots of your import data or of the import monitor here.

BR Tobias