Best Method to Update Post Code Table 225

(0) Share

Report

Posted on by MahGah

15,445

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

All responses (6)

Answers (1)

MahGah 15,445 on at

Like (0)

Report

RE: Best Method to Update Post Code Table 225

Thanks Steve. This solved my problem.
Verified answer

Community Member on at

Like (1)

Report

RE: Best Method to Update Post Code Table 225

MahGah,

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

Steve
MahGah 15,445 on at

Like (0)

Report

RE: Best Method to Update Post Code Table 225

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.
Suggested answer

Community Member on at

Like (0)

Report

RE: Best Method to Update Post Code Table 225

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]
MahGah 15,445 on at

Like (0)

Report

RE: Best Method to Update Post Code Table 225

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
Suggested answer

JAngle 95 on at

Like (0)

Report

RE: Best Method to Update Post Code Table 225

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