View Full Version : Territory Labels Wrong after Export
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.
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?
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?
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.
09-06-2011, 10:50 AM
I've just realized that you need only attach the zipped up ptm (MapPoint Map)
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.
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!!
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?
09-13-2011, 01:57 PM
The data exported to excel still has mislabled areas.
09-13-2011, 11:26 PM
I know that some of these are point zips:
90899 LA International Service Center
90639 Biola University
MapPoint exports the enclosing zipcodes of these (probably all P O Boxes).
Obviously that isn't the problem you're trying to solve.
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.
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