How to bulk update the "street" field in "postal codes V3" using data management?

(0) Share

Report

Posted on by Marco M

We imported about 20000 Postal codes in our system, and almost all of them have some information in the /street/ field. However, we found out that the information in /Street/ field are not correct, and we need to delete information in the /Street/ field for all 20000 postal codes. The problem is, when we try to import the same postal code but with an empty /Street/ field, the system create new records instead of updating existing records. What should we do?

All responses (3)

Answers (1)

Marco M 8 on at

Like (0)

Report

How to bulk update the "street" field in "postal codes V3" using data management?

Hi Sagar,

Will truncating the data also remove the link to addresses that reference the deleted postal codes?
Verified answer

sagar_patil 742 Super User 2025 Season 1 on at

Like (0)

Report

How to bulk update the "street" field in "postal codes V3" using data management?

Hi,

When you import the 'Postal code v3' data entity select following option. Truncate entity data will overwrite the old line instead of creating a new separate line. What the Truncate box does is actually remove all the data that is there wherever you are loading to based on the entity, and then adds what is in your file.

Note: Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.
Suggested answer

Komi Siabi 12,837 Most Valuable Professional on at

Like (0)

Report

How to bulk update the "street" field in "postal codes V3" using data management?

Hello Marco,

I suggest you use the Open in excel to update the address field. I just tried that and it worked for me.