MapForums

How do I use MapPoint to divide clients into zipcode regions and write that regional info back INTO my database? I want to use MapPoint's visual ability to create regions but then save that information into my database so I can run reports based on those regions. Update Linked Data just refreshes the view MapPoint sees, it does not write to my database.

Thanks in advance...

If you want to do this through the standard MapPoint menus:
If you have territories by postal codes and your imported data contains postal codes (plot client by street address or by postal code), you can export to Excel. One worksheet provides the territory name and zip code pairings. Another worksheet has the matched address and the other fields that were imported to MapPoint. Make sure that the data you import has some key, Client_ID for example, that you can use to match data back to your database. You can then run a query to match the territory name with the address using the postal code. The downside is that the export to Excel can take a while if you are dealing with large datasets.

Thank you for your prompt answer.

Can you create subterritories in MapPoint?

Subterritories - No.

I found a similar thread from just a few days ago that seems to say there is no way to do subterritories.

Thanks...

Well, there is not an "easy" way of creating the sub-territories. If you are basing your territories off of postal codes you can simulate sub-territories by building the right queries. You will need to layer your data.

Let's say you want to see a count of clients by sub-territory within a larger territory as well as see the client locations by address.

First import your main territory (by zip/postal code). Then have a second query that groups ZIPs or postal codes into your sub-territories. Import this second query as a shaded area dataset. Plot the data by zip, not by territory. Your third query could plot client location by address. Plot this as a pushpin dataset and use a symbol like a large or small square. Build a fourth query that sums your client count by zipcode or assign one zip in each sub-territory as the "display" zip. Use a count of client id to get the total number of clients by zip or by your display zip. Import this query as a shaded circle dataset.

Downside to all of this is the limitation on the unique values that can be imported at once. I have had to split this into multiple queries and datasets as well as add some text boxes and symbols of my own.

Sometimes you just have to get creative with how you push your datasets around. Let me know if you want to see a small sample of how the output and datasets might look.