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

Willing to Pay for a Way to...

This is a discussion on Willing to Pay for a Way to... within the Development forums, part of the MapPoint Desktop Discussion category; I'm willing to pay a programmer or developer, to show me a way, or to create a program that will ...

  1. #1
    Texoma is offline Junior Member White Belt
    Join Date
    Sep 2008
    Posts
    8

    Willing to Pay for a Way to...

    I'm willing to pay a programmer or developer, to show me a way, or to create a program that will allow me to import from Excel, to existing pushpins in Microsoft Streets and Trips 2009.

    I inspect mortgaged property for about 120 banks. Month after month, when ever someone is behind in their payments, I am sent to inspect the property to see if it is occupied, and it's condition.

    Over the past 6 years of using MSST, I've accumulated about 6,000 pushpin locations on a master map that I use. I don't go to all of them every month. Only to about 500 each month.

    Most are Route and Box number type addresses, where I placed a pushpin on my master map with the exact location, using my GPS.

    Or when I get an address that maps out automatically, I'll move the pushpin based on my GPS to the correct side of the street that it is on, or move it down the street a few hundred yards to it's exact location.

    The thing is, if I imported that same address using Excel, it will NOT route to my existing pushpin, but rather it will create ANOTHER pushpin back in the same position it thinks it is located. Then I end up with two pushpins on the same street for the same address.

    Most of my pushpins are route and box addresses. Currently, I have to paste the address in the Find window, then when it comes up, I click on the Place/Data tab, and hit find again, and then it will match the address to my previously placed pushpin. I have to do this one at a time for each and every address. It literally takes hours and days to do this manually.

    What I would like, is for Excel to import to my existing pushpins so that I don't have to do this manually for every address that I've already been to and marked.

    How much would this cost to have someone find a way to do this?

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Willing to Pay for a Way to...

    Streets and Trips doesn't have a programming interface, so you are likely to have a long wait.

    After positioning your pin, you could find the new coordinates from Streets & Trips, then save it to your Excel worksheet so that Streets & Trips loads it properly.

    MapPoint (yes it costs more) has a programming interface that could be customized to handle this kind of thing.

    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    Texoma is offline Junior Member White Belt
    Join Date
    Sep 2008
    Posts
    8

    Re: Willing to Pay for a Way to...

    Quote Originally Posted by Winwaed View Post
    Streets and Trips doesn't have a programming interface, so you are likely to have a long wait.

    After positioning your pin, you could find the new coordinates from Streets & Trips, then save it to your Excel worksheet so that Streets & Trips loads it properly.

    MapPoint (yes it costs more) has a programming interface that could be customized to handle this kind of thing.

    Richard
    Hi Richard,

    Could you please go into a little more detail about how to save a coordinate BACK to Excel. I know how to import, but I don't see a way to export pushpin locations to a spreadsheet.

    Does MapPoint allow importing to existing pushpins? If so, I'll just buy it.
    If not, how much would someone charge me to make it match existing pushpins? $270 bucks for MapPoint is a steal if I can get it to match to existing pushpins. I would save that in time, during my first day!

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Willing to Pay for a Way to...

    You would have to look up the pushpins - eg. using the Location Sensor.

    However, John Meyer's Pushpin Tool will export pushpins to Excel including coordinates.
    http://www.mapping-tools.com/pushpintool

    for our sales links (Eric also has sales links on this site)


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

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

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 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127