MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Faulty import from Excel + MP2004 Europe

This is a discussion on Faulty import from Excel + MP2004 Europe within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; ..this used to be OK in MP 2002 with same input.. 1. Import data from Excel sheet using wizard to ...


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-22-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Faulty import from Excel + MP2004 Europe

..this used to be OK in MP 2002 with same input..
1. Import data from Excel sheet using wizard to pushpins
2. Skip those it is unsure of
3. Finish

There are some addresses MP automatically plots incorrectly. In this case one example is "Eccles Close, York, YO30 5DX". This address is not found by "Find", but the import plots it without complaint in a different postcode and road (though still York).

Apart from go back to MP2002, any ideas..?
Is there a way of checking Pushpin data against where it is in MP?

Cheers,
Loo
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 02-19-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
....alright now

OK the problem is caused by the upgraded version of Mappoint which tries to be 'clever' and map the addresses to 'street level' not just postcodes (as before). This leads to the incorrect plotting of addresses even if the postcode is not recognised (i.e. it defaults to use street address rather than postcode if postcode is not recognised).
DON'T DO THIS IF YOU NEED PINPOINT ACCURACY!

To overcome this, when the columns of data are displayed select 'other data' in the drop down lists for everything other than postcode.

It was due to the talents of Simon who worked this out.

Thank you Simon.

We love you
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
europe, excel, faulty, import, mp2004


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
Import roads into mappoint 2004 Europe Anonymous MapPoint 2006/2009 Discussion 4 03-22-2005 09:27 AM
Using MP2002 Europe maps with MP2004 Europe Anonymous MapPoint 2006/2009 Discussion 4 09-17-2004 10:39 AM
can´t import excel files Anonymous MapPoint 2006/2009 Discussion 2 03-18-2004 03:02 AM
Import on Excel Anonymous MapPoint 2006/2009 Discussion 0 12-01-2003 01:48 PM
Motorway/Road Junction/Exit numbers MP2004 (ALL OF EUROPE!) daxydoggie MapPoint 2006/2009 Discussion 6 11-25-2003 11:45 AM


All times are GMT -5. The time now is 10:40 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 55