HomeMicrosoft


Pushpins in wrong location when imported from Excel to Streets & Trips
AnimalCop
Hello,

This is my first post as I just started using Microsoft Streets and Trips. With the help of one of you guys, I learned how to import an Excel File and route it.

I am having 1 issue, after I import and use Route Planner, when it shows the stops on the map, it will lump together 2 stops in the same town, so another words if my 2 Linden NJ stops is on the map it will look like this 2-3, the problem I have is I can not see on the map the actual street names and the separate 2 stops in the same town. I assume it just lumps the zip code together and just shows the post office location.
I need to be able to see both stops in that town separate on there actual street names.

Hope you understand my question and there is a solution.

Thanks
tcassidy
S&T 2010 has street addresses for Linden, New Jersey. Are you zoomimg in enough to see them? Perhaps you could tell us what the addresses are.

To zoom in, drag a rectangle around the area of interest while holding the right mouse button. Then left click on it.

Terry
winwaed
As well as being zoomed out, if it is really putting two pushpins with the same zipcode at the same location, then the problem is with your import. You are importing by zipcode only. Make sure the columns are assigned correctly when you import the pushpins - make sure the street address in particular is assigned and not set to "other data".


Richard
AnimalCop
Richard, that's exactly what I did wrong, I had city as other data. The reason I did that was it was the only way I was able to see the city come up when I was in Route Planner mode, it would only show the street address, but I need to see in Route Planner the Street address AND City, I do NOT need state as I only travel in NJ. Do you guys have a solution to this.

Thanks for the speedy reply

Adam
Larry
You could open the source addresses in Excel and duplicate the City column. Then during the import process call City "City" and call City2 "Name2". The title of the pushpins will be "Name" + "Name2" (if Name2 exists). I hope that makes sense and is close to what you are looking for.
AnimalCop
So I tried this and I do see the addresses and city now, but it is still lumping the the 2 Linden NJ stops as 2-3, When I zoom in its still together. As indicated in another post, that will mean it's routing from Zip Code. Could this be something in my Excel format?

In the spreadsheet, I have just a address, city, state and zip. As Larry suggested I also tried to add a second City column. I am still getting the 2 Linden, NJ address as 1. If I add the 2 Lindens manually, it shows as separate pins. So it has to be in my import process.
Ken in Regina
Do a manual search on those two addresses and see what comes up. The symptom you are describing is usually a result of the address search failing so it's "matching" on either city name or zip code or something less granular than the actual civic address.

There is another way to see what "matching" criteria were used for the various pushpins after an Excel import but I can't remember how to get there now.

...ken...
AnimalCop
Ken,
I mentioned that I did that on by post, I added them manually after I created the route and they show up as 2 separate pins, but when I add them via the import, they show as 1 pin with 2 consecutive numbers ie 1-2, 4-5, 7-8.
Ken in Regina
If you zoom really tight, do they still show as a single pushpin?

I think we're at a point where it would be a bunch easier to help you sort this out if you could just attach an Excel file with the problematic data in it so we can look at it ourselves to see what the issue(s) might be. Or if you're concerned about confidentiality, PM it to one of us to test.

...ken...
AnimalCop
Ken, How do I attach the Excel File. and Yes when I zoom in very tights still shows only 1 pushpin
Ken in Regina
When you type a Reply, just scroll down a little below the box that you are typing text into. In the section called "Additional Options" you will see a button marked "Manage Attachments".

When you click on that button you will get another window that lets you browse to a file on your computer and select it, then click the Upload button in that window. When you see that the attached file is uploaded, just close that window and submit your reply as usual.

...ken...
AnimalCop
OK I was using quick reply, here is the file, Thanks for your help
Attached Files
File Type: zip thursdy xl.zip (5.0 KB)
malaki86
Already found it - Name column is the street address
AnimalCop
I am not sure what you mean, can you be more descript.

Adam
malaki86
Look at the column titles: Name, City, City 2, State, Zip

You need an Address column.
laptopgpsworld.com About