Updating zip codes
Salesware module uses zip codes for two purposes:
1. To provide auto-population of City and State fields when inputting data (these fields are auto-populated when you tab through those fields to the Zip code field and type in the Zip code.)
2. To validate that correct Zip codes are entered (this capability must be configured by using the ValidateZip.INI setting at the salespoint.)
Zip codes (and their corresponding cities and states) are stored on the server and in local salespoint data (Zipcode.cdx and Zipcode.dbf). Zip code update files are available from the accesso Siriusware Information Portal (Downloads > Updates > 4.2 Zipcodes).
To update zip code data on your server (used by SysManager):
1. Download the Utility to update zipcodes for SiriusSQL (Update_Zipcodes_4200.exe) and unzip it to a folder on your SQL server.
2. Run the utility on your SQL server (an installer program starts), select your database(s) (SiriusSQL, SiriusSQL_Training or one you can specify) and follow the prompts.
Note: The utility requires osql.exe, which is installed with SQL server.
Note: This utility deletes any zip codes that do not exist in the new zip code table that you are installing. If you added your own custom zip codes to the SQL database, you may lose them.
To update the zip code data on your local salespoints:
1. Obtain the appropriate c_s_misc.exe file from the accesso Siriusware Information Portal (U.S. only, US/Canadian, Australian, etc.)
2. Put the c_s_misc.exe into your updates folder, over-writing the old version.
3. Re-start Sales on each salespoint. If the date on the c_s_misc.exe file in the updates folder is later than the date on the c_s_misc.exe file currently in the local Siriusware\Sales directory, and then, the new c_s_misc.exe is copied to the salespoint, overwriting the old c_s_misc.exe file. Sales executes c_s_misc.exe, overwriting the Zipcode.cdx and Zipcode.dbf files in the Sales\Data directory.
Note: Double-check to ensure that the above step completed. If the Zipcode.cdx and Zipcode.dbf files are not the latest, yet the new c_s_misc.exe was copied into the Siriusware\Sales directory, and then, simply execute (double-click on) c_s_misc.exe and the new files are written into the Sales\Data directory.
Note: When local data is deleted and rebuilt at a salespoint (this is done sometimes to re-initialize the data at a salespoint), the Zipcode.cdx and Zipcode.dbf files are empty. You must double-click on the c_s_misc.exe file in the Sales directory to copy the zip code files into the Sales\Data directory.