MapPoint Forums

MapForums

Community of MapPoint and Bing Maps Users and Developers




Import Excel/Access files into MapPoint 2009 ActiveX control

This is a discussion on Import Excel/Access files into MapPoint 2009 ActiveX control within the Development forums, part of the MapPoint Desktop Discussion category; Hey: I have a need to import Excel/Access files into MapPoint 2009 ActiveX control on an ASP .NET ASPX page. ...


Go Back   MapPoint Forums > Map Forums > MapPoint Desktop Discussion > Development

Today's Posts Twitter Feed Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 04-09-2009
Junior Member
White Belt
 
Join Date: Apr 2009
Posts: 7
Import Excel/Access files into MapPoint 2009 ActiveX control

Hey:

I have a need to import Excel/Access files into MapPoint 2009 ActiveX control on an ASP .NET ASPX page. There is quite a bit of talk on this forum on how to embed an ActiveX control on an ASPX page using the object tag and the CLS ID. That works fine. However, I cannot find an object model or even discussion of the ability parameters.

I am currently doing a proof of concept and I need to be able to do the following:

1) Specify Excel and Access file and import into MapPoint so it shows pushpins (or whatever the user chooses) within the ActiveX control. This would be similiar as if the user used the application
2) Specify map point template for use with the import discussed in step 1
3) Save the map to the user's machine

Can anyone point me in the right direction?
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 04-09-2009
Winwaed's Avatar
Mapping-Tools.com
Black Belt
 
Join Date: Feb 2004
Posts: 1,324
Blog Entries: 32
Re: Import Excel/Access files into MapPoint 2009 ActiveX control

All of the MapPoint 2009 objects are documented in the help file.

Start MapPoint and look at the help. The programming information is at the end of the contents. What is documented there is actually pretty good - I wish all software APIs had that kind of description!

You will see that there is an Application object and a Map object (the application's ActiveMap property). I think the method you want is "ImportData" on the map object?


Richard
__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
See the Geoweb Guru for online mapping
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 04-09-2009
Junior Member
White Belt
 
Join Date: Apr 2009
Posts: 7
Re: Import Excel/Access files into MapPoint 2009 ActiveX control

Quote:
Originally Posted by Winwaed View Post
All of the MapPoint 2009 objects are documented in the help file.

Start MapPoint and look at the help. The programming information is at the end of the contents. What is documented there is actually pretty good - I wish all software APIs had that kind of description!

You will see that there is an Application object and a Map object (the application's ActiveMap property). I think the method you want is "ImportData" on the map object?


Richard
All the documentation is geared towards VB6/.NET using the COM object withina desktop application. My need is to embed the MapPoint 2009 ActiveX control within a web page. I am able to do that by using the few examples on this forum that have an object tag and use JavaScript to load a map of North America. After that, I am lost as I cannot find any of the OM. I am able to create a desktop application, reference the MapPoint OCX and successfully load my CSV. Works great. The ImportData method of the DataSets collection doesn't appear to be available via web.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 04-10-2009
Winwaed's Avatar
Mapping-Tools.com
Black Belt
 
Join Date: Feb 2004
Posts: 1,324
Blog Entries: 32
Re: Import Excel/Access files into MapPoint 2009 ActiveX control

The ActiveX control (and object model) are the same as the COM objects. ActiveX is simply a Microsoft marketing term for COM - especially controls implemented using COM. If you are happy working with ActiveX/COM in general (I realise that isn't a trivial 'if'!) then it should be relatively simple to understand the VB6 examples and translate them to any COM-aware language. I've used MapPoint from a wide range of languages and typically the only hurdle is getting the language's COM interface to work.

Do you have MapPoint installed on the client machines?

BTW, Using the desktop version of MapPoint in a webpage is generally a bad idea. There are usually beter options - eg. the Virtual Earth JS control or the Virtual Earth Web Service - the latter is set to replace the MapPoint Web Service which is still an option.


Richard
__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
See the Geoweb Guru for online mapping

Last edited by Winwaed; 04-10-2009 at 09:04 AM..
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 04-10-2009
Junior Member
White Belt
 
Join Date: Apr 2009
Posts: 7
Re: Import Excel/Access files into MapPoint 2009 ActiveX control

Quote:
Originally Posted by Winwaed View Post
Do you have MapPoint installed on the client machines?

Using the desktop version of MapPoint in a webpage is generally a bad idea. There are usually beter options - eg. the Virtual Earth JS control or the Virtual Earth Web Service - the latter is set to replace the MapPoint Web Service which is still an option.


Richard
I have MapPoint on all of my clients but I am currently just doing proof-of-concept. The map rendering is actually pretty good. It's fairly responsive and looks nice. I just can't figure out any of the functionality.

Yea, there were discussions of Virtual Earth JS but they decided to go MapPoint. Not 100%.

Is there command line parameters that I could use for MapPoint? Maybe that is another option. To launch the app via the web page programatically. Another option is a desktop app but each client would nee the app installed and that's another headache.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6 (permalink)  
Old 04-15-2009
Junior Member
White Belt
 
Join Date: Apr 2009
Posts: 7
Re: Import Excel/Access files into MapPoint 2009 ActiveX control

Ttt ttt
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #7 (permalink)  
Old 04-15-2009
Senior Member
Red Belt
 
Join Date: Dec 2002
Posts: 568
Re: Import Excel/Access files into MapPoint 2009 ActiveX control

Nope, no command lines.

Maybe make a COM Addin that accesses a linked back-end or use Citrix?

Mike Mattys
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

Tags
activex, control, excel or access, files, import, mappoint 2009


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/import-excel-access-files-into-mappoint-2009-activex-control-10128.html

Posted By For Type Date
The Magazine for MapPoint - MP2K Magazine This thread Refback 04-13-2009 12:38 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
Adding the location sensor in MapPoint 2009 to the activex control lewism MapPoint Desktop Discussion 5 09-26-2008 09:00 AM
Cannot Import Excel Files GKing MapPoint Desktop Discussion 6 08-04-2007 05:54 AM
MS Access and Mappoint ActiveX Control Anonymous MapPoint Desktop Discussion 3 06-26-2004 02:29 PM
can´t import excel files Anonymous MapPoint Desktop Discussion 2 03-18-2004 03:02 AM
Using MP ActiveX Control in Access/Foxpro etc Anonymous MapPoint Desktop Discussion 0 02-21-2003 12:51 PM


All times are GMT -5. The time now is 09:03 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.2
MP2K Magazine
Visitor Map



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