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?

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Komi Siabi 13,228 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello Marco,

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

Was this reply helpful? Yes No
Verified answer

sagar_patil 920 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Marco M 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Sagar,

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

Was this reply helpful? Yes No