MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Import then Map by Date field

This is a discussion on Import then Map by Date field within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Is Date data type supported by the ImportData method (MP2002)? (I think not) I am successfully importing a tab delimited ...


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 11-28-2003
Member
Yellow Belt
 
Join Date: Feb 2003
Posts: 48
Import then Map by Date field

Is Date data type supported by the ImportData method (MP2002)? (I think not)

I am successfully importing a tab delimited file containing Long., Lat. and Date/Time (and other) fields into a dataset but then cannot map the data using DisplayDataMap to show points colour/symbol coded by date. Other fields, containing numeric or string data, can be mapped OK. The import seems to know that the date/time field is data type 7, but the mapping seems not to be able to do anything constructive with them.

Is there another way?

Does latest MP support Date data type?

TIA

M.
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 12-01-2003
Member
Yellow Belt
 
Join Date: Feb 2003
Posts: 48
Mapping by Date fields

Got round problem by importing file into Excel, adding another field containing julian date (derived from original Date/Time field), saving workbook as tab delimited file and then importing that file. Eventually mapping by unique values on the added field. Will be OK until row limit in Excel is busted.

Tell me that MP2004 supports Dates!!!!

M.
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
date, field, import, map


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
Construction Zone Information Out Of Date WonderMonkey MapPoint 2006/2009 Discussion 0 06-23-2006 12:40 PM
How do I update the value of a field in a recordset? stephenmillington MapPoint 2006/2009 Discussion 4 10-10-2005 01:52 PM
Roads out of date. Is there solution? amowat MapPoint 2006/2009 Discussion 1 03-18-2004 05:15 PM
Census Tract Input Field Jim Grace MapPoint 2006/2009 Discussion 2 06-03-2003 06:38 PM
Field Format issues with import from Excel Verh0ef MapPoint 2006/2009 Discussion 3 03-31-2003 01:42 AM


All times are GMT -5. The time now is 05:44 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


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