MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




ImportData: Match count dependant on order of records

This is a discussion on ImportData: Match count dependant on order of records within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I am using the ImportData method in MP2002 to map locations represented in a tab delimited text file. Some lines ...


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 12-09-2003
Member
Yellow Belt
 
Join Date: Feb 2003
Posts: 48
ImportData: Match count dependant on order of records

I am using the ImportData method in MP2002 to map locations represented in a tab delimited text file. Some lines in the file cannot be mapped as they are "status" messages from the GPS source, and therefore do not contain Lon/Lat values. This is acceptable.
The problem comes if these lines preceed the first valid location record. For example, if the following file is imported all is well (a matched count of 5)

15 09/12/03 09:17:28 C 65 -0.849435 51.4011116666667 0
15 09/12/03 10:31:24 C 65 -0.849435 51.4011116666667 0
15 09/12/03 10:31:34 C 65 -0.849435 51.4011116666667 0
15 09/12/03 10:31:44 C 65 -0.845721666666667 51.4051366666667 0
15 09/12/03 10:31:54 C 65 -0.839526666666667 51.4034383333333 0

However, if these records follow a number of "status" messages, NO records are matched, not even the good ones!! After some experiments, it would appear that 12 of these "status" records still allow the file to be imported properly, but adding the 13th to the file causes no records to be matched!?
Here is a typical "status" message:
15 08/12/03 08:50:43 RESET 08/12/03 08:50:42 08/12/03 08:50:43

After import, the values for field 4 of the matchable records become Null and the values for field 5 (longitude) become empty - and without a longitude, no match can be made.

Has anyone else come across this and conceived a workround? or can I go quietly mad on my own?

M :-)

PS. The tabs dont show up very well in the examples above; they are there and the data is formatted correctly.
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
count, dependant, importdata, match, order, records


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
Create a map listing a count of customers in ea 3 digit zip Anonymous MapPoint 2006/2009 Discussion 0 01-17-2005 05:32 PM
Newbie help; using Excel data to map by COUNT rjhbos MapPoint 2006/2009 Discussion 2 07-26-2004 12:06 AM
HOW TO IMPORT LIST OF ZIPCODES AND MATCH TO AVR. INCOME bromano MapPoint 2006/2009 Discussion 0 01-13-2003 03:43 PM
Match by Zip Not Displayed Anonymous MapPoint 2006/2009 Discussion 4 10-28-2002 12:22 PM
How do I map county data? Do I put state and count.... Anonymous MapPoint 2006/2009 Discussion 1 07-08-1999 07:16 AM


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