MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Novice user question on integrating data into Mappoint

This is a discussion on Novice user question on integrating data into Mappoint within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hello all – New member here – I’ve concentrated on Microsoft Streets and Trips for last 8 years, as the ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  3 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 4 Weeks Ago
Junior Member
White Belt
 
Join Date: Aug 2008
Posts: 2
Novice user question on integrating data into Mappoint

Hello all –

New member here –

I’ve concentrated on Microsoft Streets and Trips for last 8 years, as the lower cost and feature set are a good fit for the average sales rep. I’m familiar with MapPoint – and remember you can create ‘com-add ins’ as I recall to automate mapping processes.

I’ve run into a prospect that has a requirement that can’t be accomplished elegantly with Streets and Trips, and I beg your indulgence here to let me describe to you the basic feature set of the request – and then get your input on some of the tools/skill sets required to accomplish the task .

Here goes: My prospect is looking to have a mapping program that is tied to his Goldmine CRM application. The mapping application would pull data from Goldmine – plotting customer and prospect locations on the map. The pushpin icon would be based on a status field in the Goldmine account record. So for instance, all prospects that were forecasted to close within 90 days would be a gold circle. Upon double clicking the pushpin, a balloon would open up with customer defined Goldmine field data showing pertinent account data.

MapPoint and Goldmine would reside on the same network, and I would envision choosing an add-in from the MapPoint menu bar that automatically went out to the Goldmine tables, extracted the data and populated the map as described. An additional nice feature might be to be able to click a link in the balloon to bring user directly to the GoldMine application record.

I’m not a programmer – but am a quick study. I’m trying to determine if this project is something I should tackle. So my questions to the forum are – does the functionality described here seem like it’s doable in MapPoint (I’m guessing yes – barring any difficulty accessing potential proprietary Goldmine tables)? And if so, what programming knowledge will I need to acquire – like – must I learn SQL, etc.?

Thanks very much in advance for any help on the subject!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 4 Weeks Ago
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,322
Blog Entries: 1
Re: Novice user question on integrating data into Mappoint

Yes it sounds do-able, but I'm not sure about this

>>An additional nice feature might be to be able to click a link in the balloon to bring user directly to the GoldMine application record.<<

You can put a URL on the Pushpin, but I doubt a Goldmine application record can be reference by a URL? Maybe you can do it by monitoring the mouse click events and have the MapPoint com add-in automate Goldmine? I am not sure.

I would see if you can first just export the data from Goldmine to an Excel spreadsheet, and then map it in MapPoint using the data import wizard. i.e. before you spend any time in books or delving into the programming, first mock up the map and how you want the map designed in MapPoint. Then you already have the map you want, even though it took several steps and clicks to get there.

hope this helps,
Eric
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 4 Weeks Ago
Junior Member
White Belt
 
Join Date: Aug 2008
Posts: 2
Re: Novice user question on integrating data into Mappoint

Thanks Eric - Yes, I agree accessing speciifc Goldmine record would be tough. In my work with Streets and Trips, I can include a URL in the pin to start the CRM app, but still need to navigate to the individual record once it's open.

Thanks very much for quick response!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/novice-user-question-integrating-data-into-mappoint-8194.html

Posted By For Type Date
Microsoft MapPoint 2009 - MP2K Magazine This thread Refback 3 Weeks Ago 04:08 PM
MapPoint For Dummies - MP2K Magazine This thread Refback 4 Weeks Ago 01:16 PM
About MP2Kmag - MP2K Magazine This thread Refback 4 Weeks Ago 01:00 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
New user: Exporting multiple data sets to excel rpone605 Products: Pushpin Tool, Single State Mapper 0 06-20-2006 03:54 PM
OLE Delphi 6 Novice BigH42 MapPoint 2006/2009 Discussion 4 07-21-2005 07:13 AM
New 2004 user trying to Access Demographic Data in trial ver bfloeyes MapPoint 2006/2009 Discussion 1 10-24-2003 01:32 PM
New user question DanC MapPoint 2006/2009 Discussion 2 08-28-2003 08:31 AM
New User Question!!! megc MapPoint 2006/2009 Discussion 0 07-28-2003 10:30 AM


All times are GMT -5. The time now is 12:29 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Cheap Skiing
When it comes to cheap skiing, Holiday Hypermarket will speed you on your way. Searching the leading travel brands, Holiday Hypermarket offers you great value skiing.

Italy Weather
Check Italy Weather before you travel. We provide information on Italy including weather, flights and accommodation.

Holidays to Jamaica
At dealchecker.co.uk, we'll shop around for cheap holidays to Jamaica so you don't have to. We search deals from the UK’s top holiday companies all in one go. Try it for free.

Cyprus Holidays
Cyprus holidays will offer you a wealth of activities all in the most beautiful surroundings. Relish the beauty of Cyprus on a short break.

Cheap Morocco Holidays
Cheap Morocco holidays may be the answer to your cheap holiday search. With sunshine throughout most of the year it can be great value if you avoid the peak season. Why not include a trip to the small tranquil town of Chefchaouen Tangier in your visit?

Bargain family holidays
We can help you find family holidays at bargain prices when you check out the options at Travel.co.uk

Sharm el Sheikh Holidays
Visit Egypt! Get info on Sharm El Sheikh holidays, only at On The Beach.


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