Community of VE/MapPoint Users and Developers
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 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| |||
| ImportData: Match count dependant on order of records 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. |
![]() |
| Tags |
| count, dependant, importdata, match, order, records |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| 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 |