MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Need Assistance with Displaying CSV data by City

This is a discussion on Need Assistance with Displaying CSV data by City within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; OK, I've spent a day on this and its time to admit I need help. I'm trying to import a ...


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

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-05-2004
Junior Member
White Belt
 
Join Date: Dec 2003
Posts: 3
Need Assistance with Displaying CSV data by City

OK, I've spent a day on this and its time to admit I need help. I'm trying to import a CSV with 6 columns and a varying row length. I borrowed (stole) the array of fields code from an earlier post.

The columns are:

1. Address
2. City
3. State
4. Postcode
5. Country
6. Name

My code is:
Dim objMap As MapPointCtl.Map
Dim objDataSet As MapPointCtl.DataSet
Dim objDataMap As MapPointCtl.DataMap

Dim JobFieldArray(6, 1)
JobFieldArray(1, 0) = "Address"
JobFieldArray(1, 1) = MapPoint.GeoFieldType.geoFieldAddress1
JobFieldArray(2, 0) = "City"
JobFieldArray(2, 1) = MapPoint.GeoFieldType.geoFieldCity
JobFieldArray(3, 0) = "State"
JobFieldArray(3, 1) = MapPoint.GeoFieldType.geoFieldRegion1
JobFieldArray(4, 0) = "Zip"
JobFieldArray(4, 1) = MapPoint.GeoFieldType.geoFieldPostal1
JobFieldArray(5, 0) = "Country"
JobFieldArray(5, 1) = MapPoint.GeoFieldType.geoFieldCountry
JobFieldArray(6, 0) = "Name"
JobFieldArray(6, 1) = MapPoint.GeoFieldType.geoFieldName

Set objMap = MPC.NewMap(geoMapNorthAmerica)
Set objDataSet = objMap.DataSets.ImportData("I:\try.csv", JobFieldArray(), geoCountryDefault, geoDelimiterComma)
Set objDataMap = objDataSet.DisplayDataMap(geoDataMapTypeSizedCircl e, , geoShowByCountry)

I can get this to plot a shadedArea or Sized Circle of names by region or country but not by city. I tried using the other geodatamap types and changing the order of the columns in the csv file and I get Error 4073 Cannot map data because the selected geography type is invalid.

How do you map Names by city? Also, is there any documentaion of the object model besides the Microsoft site. Thanks for the help
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
assistance, city, csv, data, displaying


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 data and displaying territorries fridi69 MapPoint 2006/2009 Discussion 9 06-16-2006 06:55 AM
Displaying a few simple data numbers per state on a US map Anonymous MapPoint 2006/2009 Discussion 1 05-05-2005 07:03 AM
city-level demographic data econalan MapPoint 2006/2009 Discussion 0 02-08-2005 06:05 PM
Will Pay $$$ for Assistance - ASP / VBSCRIPT webdbx MapPoint 2006/2009 Discussion 1 07-09-2004 09:31 PM
displaying custom data on Pushpins when linked TheJudge MapPoint 2006/2009 Discussion 3 04-13-2004 09:53 AM


All times are GMT -5. The time now is 01:15 PM.


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


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