View Full Version : Territory Labels Wrong after Export
Smithsfan
09-02-2011, 02:46 PM
I mapped out areas of states and labled them. For instance, in the state of Pennsylvania, I have 3 regions: PA Easy, PA Medium, PA Hard. I exported data to Excel and some of the Hard Zips are labled as PA Easy. When I go into Map Point and search for the ZIP it is clearly well within the Hard area and is labled as hard.
Any idea why some of my zips are getting mislabled after export? It happens all over the country, though I believe the percentage of mislabled zips is prettylow.
Mattys Consulting
09-03-2011, 10:04 PM
Very interesting! I've never heard of this problem before.
You're not using a third-party addin?
Could you possibly post [some of] your data for us to perform testing?
Smithsfan
09-06-2011, 09:47 AM
I'd be happy to post some of my data, but I don't know how. What are you looking for? Just the mislabled zips, or something else?
Thanks,
Rich
Mattys Consulting
09-06-2011, 10:23 AM
When you press reply, you'll see the usual tools.
Clicking the paperclip will allow you to add a zip.
Attach the data that you used to create the map.
That way, anyone can replicate your map to see where the problem lies.
Mattys Consulting
09-06-2011, 10:50 AM
Rich,
I've just realized that you need only attach the zipped up ptm (MapPoint Map)
Smithsfan
09-13-2011, 11:28 AM
So, I created a small sample map and I've attached the file.
In this smaller map, I am noticing a similar but different problem.
All of these ZIPs are found in the area "California Easy" when you search for them in Map Point.
90189
90659
90899
90639
90224
In the map that I created for the entire country, those ZIPs were in the exported file labelled incorrectly as "California Medium".
In the map that I created as an example to send to you, those ZIPs don't appear in the exported data at all.
This happens all over the country.
Thanks for your assistance!!
Rich
Eric Frost
09-13-2011, 11:36 AM
I noticed when you switch from the Territories pane to the Legend pane some issues with territories sort of automagically get resolved. Try that?
Eric
Smithsfan
09-13-2011, 01:57 PM
Hi Eric,
The data exported to excel still has mislabled areas.
Thanks,
Rich
Mattys Consulting
09-13-2011, 11:26 PM
I know that some of these are point zips:
90899 LA International Service Center
90189 Citibank
90639 Biola University
etc
MapPoint exports the enclosing zipcodes of these (probably all P O Boxes).
Obviously that isn't the problem you're trying to solve.
Smithsfan
09-14-2011, 12:20 PM
It looks as though our system has a tendency to return unique zips when we "guess zip" for a particular city. It still doesn't explain why, when you look up a ZIP, it's clearly in the easy area, yet it's labeled as medium, or vice-versa.
Mattys Consulting
09-15-2011, 09:06 AM
I exported the dataset from MapPoint to Excel, then split them to tabs.
After re-importing as pushpins and exporting, I find them accurate.
See attached xls in the zipfile.
Maybe I'm doing this differently than you are?
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by
vBSEO 3.6.1