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 3 of 3

Creating Territories from a linked data set problem

This is a discussion on Creating Territories from a linked data set problem within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi, I'm relatively new to MapPoint and have come across a slight problem when creating territories from either an Excel ...

  1. #1
    smallcock is offline Junior Member White Belt
    Join Date
    Nov 2007
    Posts
    2

    Creating Territories from a linked data set problem

    Hi, I'm relatively new to MapPoint and have come across a slight problem when creating territories from either an Excel spreadsheet or a .udl file linked to an SQL Server 2005 database.

    After setting up a number of territories across the UK, one of our managers exported the data to excel and sent it to me to be uploaded onto our server. When I uploaded the data it does not match what is in the spreadsheet. I decided I would upload the data into SQL Server and see if this would help, it didn't!!

    I decided I would create a territory manually using Postcode Districts, export this to Excel, exit MapPoint, create a new map and import the territory from the data in the spreadsheet. This again did not work, completely disredarding what is actually in the spreadsheet.

    Can someone give me any pointers as to what I may be doing wrong or if this is a common problem within MapPoint?

    Thanks in advance...

  2. #2
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Creating Territories from a linked data set problem

    There is a casing problem in MP Europe 2006. You'll have to read the postcode sector names in as lower case ie kt17 instead of KT17.
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  3. #3
    smallcock is offline Junior Member White Belt
    Join Date
    Nov 2007
    Posts
    2

    Re: Creating Territories from a linked data set problem

    Excellent... Thank you so much davidb that would've have driven me insane!!! I've tested it and it works perfectly.

    Once again, thanks...

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. problem with hyperlinks in linked data
    By hpaul in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-26-2009, 12:57 AM
  2. Problem updating linked records
    By alwasl8 in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-20-2006, 08:50 AM
  3. Territories creating city territories
    By cableghost in forum MapPoint Desktop Discussion
    Replies: 8
    Last Post: 08-30-2005, 03:47 PM
  4. Creating Territories from Postcode data UK
    By norty303 in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-10-2003, 12:16 PM
  5. creating territories using imported data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-04-2003, 04:45 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 82 83 84 85 86 87 88 89 90 91