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

Import then Map by Date field

This is a discussion on Import then Map by Date field within the MapPoint Desktop 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 ...

  1. #1
    Mossoft is offline 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.

  2. #2
    Mossoft is offline 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.

Thread Information

Users Browsing this Thread

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

Similar Threads

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

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