AnySite 9.x and importing zipcodes to create a linked layer of zipcode regions
Product Affected: AnySite™
Issue
User running AnySite 9.1 US has an Excel file of some 700 zipcodes that they wish to import and then create a linked layer of zipcode regions.
Some of the zipcodes are in CT, so they start with a zero.
When following the correct steps to create a linked layer of zipcode regions
(i.e. create a database with Database Manager, then link to the zipcode boundary table),
the resultant table is made up of ALL zipcode regions in the US and not just the 700 expected
Some of the zipcodes are in CT, so they start with a zero.
When following the correct steps to create a linked layer of zipcode regions
(i.e. create a database with Database Manager, then link to the zipcode boundary table),
the resultant table is made up of ALL zipcode regions in the US and not just the 700 expected
Cause
For reasons still being investigated, the process seems to fail because of zipcodes with leading zero's having the 0's truncated, as the zipcodes come in as numeric and not character data.
Ideally, Anysite should not show any records that fail to join but instead joins to every zipcode.
Ideally, Anysite should not show any records that fail to join but instead joins to every zipcode.
Resolution
UPDATED: July 16, 2019First save the .xlsx/.xls file of ZIPCODES as a .txt file and then open the file in Excel.
The Text Import Wizard will appear. in Step 1 of 3, select Delimited and click Next
Click Next
Set the ZIPCODE column to Text and click Finish
Leading zeroes are now present:
Save the .txt file as a .xls or xlsx file. Import the xls in AnySite's Data Manager and create a "linked" layer:
Note: if user has MapInfo Pro, they can easily open the original xlsx in Pro and then open the zipcode boundary file from the AnySite datqa folder and
join the 2 tables where zip = zip and then save the qyery as a new mappable table to import directly in to AnySite
The Text Import Wizard will appear. in Step 1 of 3, select Delimited and click Next
Click Next
Set the ZIPCODE column to Text and click Finish
Leading zeroes are now present:
Save the .txt file as a .xls or xlsx file. Import the xls in AnySite's Data Manager and create a "linked" layer:
Note: if user has MapInfo Pro, they can easily open the original xlsx in Pro and then open the zipcode boundary file from the AnySite datqa folder and
join the 2 tables where zip = zip and then save the qyery as a new mappable table to import directly in to AnySite
