Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 8 of 8

Export My Territories

This is a discussion on Export My Territories within the MapPoint Desktop Discussion forums, part of the Map Forums category; I've searched FAQ's and this forum. I have imported 600 companies into MapPoint 2004. I manually created territories (using census ...

  1. #1
    playadude is offline Junior Member White Belt
    Join Date
    Mar 2008
    Posts
    3

    Export My Territories

    I've searched FAQ's and this forum.

    I have imported 600 companies into MapPoint 2004.

    I manually created territories (using census tract).

    Now, I want to export those companies and see what territory they are in.

    Preferably using excel.

    It seams MapPoint 2004 cannot do this.

    Am I correct?

    Thank you,

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,039

    Re: Export My Territories

    playadude

    MapPoint doesn't have that function.
    It can be done programmatically.

    Mike Mattys

  3. #3
    playadude is offline Junior Member White Belt
    Join Date
    Mar 2008
    Posts
    3

    Re: Export My Territories

    Thanks Mike,

    Am I missing something here? It seems like importing hundreds of customers, then making territories...

    Logic would say that I would want to reference the territories with the customer data.

    Does MapPoint 2004 have a feature that would serve this purpose?

    Sorry if this question is basic.

  4. #4
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,039

    Re: Export My Territories

    The other folks may have a better answer ...

    MapPoint seems to work strictly by the data you put in.

    Apparently, it is assumed that a territory has already been assigned to
    each of your companies in your own managed database.


    Mike Mattys

  5. #5
    playadude is offline Junior Member White Belt
    Join Date
    Mar 2008
    Posts
    3

    Re: Export My Territories

    Mike,

    I thought your answer was fine.

    I think a mapping software should help me assign geographic territories to my customer data.

    I think it's logical to be able to import 600 records, layout my territories, and then export the results with the territory information.

    So I can give the customer data back to my salesforce.

    Thank you for trying to help me.

  6. #6
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,039

    Re: Export My Territories

    OK, but I can manage your territories, do analysis and reporting, provide
    excellent graphics ... just thought I'd offer

    Mike Mattys

  7. #7
    Graham.Barlow is offline Junior Member White Belt
    Join Date
    Feb 2012
    Posts
    1

    Re: Export My Territories

    MapPoint isn't really a territory design tool. It is more of a viewer that lets you visualise maps and the info you plot on them, plus the Postal boundary files can be many years out of date. If you are looking for a professional tool to create balanced and optimised territories then I would recommend Regiograph Planning. This costs circa 3,500 ($5,500). If you wanted help designing territories then we could help you on a service basis. See Sales territory alignment, sales route planning, franchise territory mapping, customer targeting (faststats), database enrichment, data migration. My email is graham.barlow@tech4t.co.uk

  8. #8
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,090
    Blog Entries
    4

    Re: Export My Territories

    Graham Barlow, thanks for your input and welcome to the forum!

    There's so many different mapping packages and tools out there, I'm not familiar with Regiograph Planning, but I'm sure it's worth every penny for some people for what it does.

    I'm not 100% sure until I try it, but I think the ObjectsFromPoint method might be able to extract at least the census tract if not the territory that each point lies in... it's probably worth a shot anyway. Actually I'm not so sure you couldn't get the territory, as MapPoint is more sophisticated under the hood than I sometimes realize.

    Alternatively, you could draw a quick freeform around each territory and do Export to Excel, although if you a lot of territories, manual work like this might be very time-consuming.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Export Territories
    By Rubinho in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 12-29-2006, 02:59 PM
  2. Territories creating city territories
    By cableghost in forum MapPoint Desktop Discussion
    Replies: 8
    Last Post: 08-30-2005, 03:47 PM
  3. how to add postal code to territories for an excel export ?
    By nat in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-25-2005, 06:23 AM
  4. How can I export POI data?
    By Wavshrdr in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 10-27-2004, 02:45 PM
  5. Export map to gif
    By pd1 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-19-2003, 01:36 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81