Best Method to Update Post Code Table 225

(0) Share

Report

Posted on by MahGah

15,529

I need to update County (State) in Post Code Table 225. I downloaded the table through Configuration Package, updated County and uploaded back but got error message about City is exist. This is strange because I am just uploading the same file back and did not change City or add City.

I also tried Edit in Excel in Zip Code page and failed as well to publish changes.

What is the best method to update County in Table 225?

The only way I can think of is to upload the Configuration Package but select "Delete Table Before Upload" but I do not know the risk of that. What is the risk here?

Thanks for your help

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

JAngle 133 on at

Like (0)

Report

Primary key of the table is code and city. So you must handle that data. Do you have the city populated as well as the county? You could try turning off the validation for City at the field level of the configuration package

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

Hi Josh

@Josh Anglesea

Thanks.

1) Yes city is populated. I just want to download the Table change the County (State) to abbreviations and upload back. But it shows error that City is already exist.

2) I tried to turn off validate for City and got this error message

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

MahGah,

I am attaching my USPS Excel CSV import you can use that will populate the table via a configuration package.

Hope this helps.

Thanks,

Steve

[View:/cfs-file/__key/communityserver-discussions-components-files/758/PackageZIPCODE-_2800_1_2900_.rapidstart][View:/cfs-file/__key/communityserver-discussions-components-files/758/zip_2D00_codes_2D00_database_2D00_LOAD.csv]

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

Hi Steve

@Steven Chinsky

Thank you so much. When I upload this should I select delete table or something? I mean I never uploaded .rapidstart file before.

I appreciate your help in advance.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

MahGah,

I always delete the Table to start fresh from the zip code list.

Steve

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

Thanks Steve. This solved my problem.

Was this reply helpful? Yes No