I am trying to convert the complete walmart csv file posted here by sy2. I am using the Magellan poi file editor to convert the csv to .mgln. This file has 3100+ locations and seems to convert, display in the editor and save fine. However when I open the saved file there are only about 5 location there. The file size is very small so I know the entire file was not saved. I have successfully converted other .csv files from here. Does anyone have an idea what the problem could be?
I am having the same problem with my Magellan POI Editor. I get the same results with the Cracker Barrel file. I am thinking it may be due to all the names being the same. I have looked at the user manual for any explaination about he name field but it is too vague. I did get the CompUSA file to work fine and it has different names for each entry.
I was going to try changing the names of a few of the Walmart entries to see if I get more than 5. It would be a bummer if that is what has to be done!
I first tried adding a # to the description column to see if that is all it needed, but I got the same results. Next I changed the names of the first five entries by adding a -# to each. This time the ones I changed came in, so I guess that is the problem. If you have the same name on multiple entries you can only get one of them to save.
I think your right, I took the Walmart file and opened it in Excel. I copied the contents of the latitude column and pasted into a new column. When I used the Magellan program to convert I used the new column as the "name" and the walmart column as description and everything worked fine. I guess this will work out ok.
I did the same kind of thing and got all the data in mine also. I can live with doing this for free POI's
If you are pretty comfortable with Excel here is another way to get all the data onto the Magellan and keep the name that is in the list.
1. Open the downloaded cvs file in Excel, Column A is Longitude, Column B is Latitude, Column C is the Name of the store.
2. In Column D number the first 3 stores. Put a 1 in cell D1, a 2 in D2 and a 3 in D3. Then use the auto increment feature in Excel to fill in the rest of the numbers in Column D. You can see how to do this in Excel Help just search for the word "increment". I did this first on the Wal-Mart file and it had too many entries to number them individually.
3. In Column E type this formula in cell E1.
If there is data already in Columns D or E just move over and change the formula to match the columns you want.
If you are interested, you can find this in Excel Help searching the word "combine" and select "Combining Text and Numbers".
Copy this formula to all the other entries in Column E.
This will add a dash and the number in Column D to the text in Column C.
4. Save this as a cvs file and name it something different than the cvs file you imported, ignore the warnings about format problems when you save it, select Yes.
When you bring the new file into the Magellan POI Editor use the newly created Column E as the
name and ignore the data in Columns C and D.
When you upload this to your Magellan you will get the name Wal-Mart - #. The # means nothing
but you do get the name Wal-Mart or Super Wal-Mart - # on you Magellan POI list.
Hope this helps.
maybe it just wal mart
i am so so glad that i read this board.
i also had that same problem... it was with 6 lists.
the ones were... applebees, arbys, best buy, cracker barrel, macaroni grill, and cheesecake factory.
i have now done exactly what jjt typed in and i will be loading them into my maestro tonight.
thank you very much jjt for your input on this manor.
I don't see how to put a number in front of all the walmarts. Looked at increment. Still could not figure how to do it.
Here is an example using the CONCATENATE command:
-117.9349,37.32345,Wal-Mart,1,123 Any Street, My Town,=CONCATENATE(C1," - ",D1)
Assuming you are using a standard CSV file, highlight column D and then select INSERT and add a new column D. Manually number the first 3 row and use the auto increment by highlighting the first 3 cells in Column D. Grab the bottom right corner of the highlighted cells (the cursor changes to a +) and then holding the left mouse button down, drag the highlight to the last line of the file.
In the first empty cell in line 1, copy the formula =CONCATENATE(C1," - ",D1) and then copy this formula down for all the remaining rows. The formula is replaced with the combined text and number. Then save the file as a CSV in the format needed for your Magellan.
The Concatenate function can be used to change the order of the data while putting it all into a single cell.
I'll thry this, but wish there was a program to do this for us...
By far the easiest way is when you put in the long and lat, put the address in for the name, not the name, example longitude 73,123 latitude 41.209.00 name 123 smith st, in other words don't put in wal mart for the name put in the address, and its' as easy as that.
Hope this helps....Ralph
terms | privacy | contactCopyright © 2006-2020