For anyone that is interested here is a link to more info about the Rand McNally RVND 7710
Thanks for the link. The Rand McNally seems interesting. I wonder if we can load our own POIs or if we are stuck with its internal POIs?
It seems we can!
creat your own or load csv files. Used my new one this weekend on a camping trip.
I'd be glad to create my own, but I find nothing on the proper format needed to load to the 7710. The Rand McNally web site, and this location right here on POI's web site [http://www.poi-factory.com/node/34592] discusses it. But...
If you download a .gpx file (the file I want is only available in this format) it will not show up in the loader's window. It only allows .CSV and .TXT files.
EPE can be used to convert .gpx to .csv
I don't know whether the Rand McNally uses the same format .csv files as Garmin. Perhaps turboccc could comment on whether a file could be saved as a Rand McNally file.
.csv is a simple text file. It should only be a matter of where to put commas and quotes in each line.
From what little documentation there is for the 7710 it doesn't use the same format as Garmin. We're already working on getting better documents from RM as it does sound like a great unit for RVers.
In the FAQ at the Rand Mcnally site, this statement is made:
"Yes, custom locations can be added via the Dock (connecting your unit to a personal computer with an internet connection). Add information such as red light cameras, special shopping areas, and more. Once added through the Dock, they can be accessed from the POI feature. Look for the Custom Locations button. Any .csv format may be imported, such as those found at www.poi-factory.com or www.roadmapgps.com/poi/".
The documentation for the RVND7710 gives some instructions on creating CSV files for this unit which do not follow the format used for Garmin units.
The FAQ I gave the link to is at the Rand Mcnally site and is for the RVND 7710. Isn't that "for this unit"?
going by the user manual and from what the OP stated.
There is no manual for the RVND 7710 posted on the Rand McNally website, but manuals for other units are posted with detailed instructions for .csv format.
It is not the same as Garmin, and there can be many more fields with more info than Garmin .gpx files. It seems easy to manually construct POIs with Notepad or Excel, but for batch processing of large POI files I don't think EPE can save as a Rand McNally .csv.
Perhaps Rand McNally will come up with dedicated software to do this job.
For now, the claim that, "Any .csv format may be imported, such as those found at www.poi-factory.com or www.roadmapgps.com/poi/"." may be true, but they are not explaining how.
wa0mqe, please try to load a Garmin .csv POI file from this site, or make a very short, simple .csv file using the FAQ here. It will show in the window, but we need to test whether it loads into the GPS at all and whether the info in the fields loads correctly.
If this does work, then the file you want can be converted from .gpx to Garmin .csv format using Extra_POI_Editor, for loading to the GPS in Garmin .csv format.
Ok, the RVND does accept .csv files. I downloaded a Propane.csv file from POI-Factory and loaded it via the loader unto my RVND7710. It worked and now I have it on the GPS.
However, I've found another issue. My RVND came with a Custom POI file (Railroad Crossings) from the factory. When I loaded the Propane.csv file I expected to see it in the RVND subdirectory where it keeps the Custom POI's. But the loader appears to merge all the Custom POI's into one file. It's called MyCustomPOI in the TripMaker RVND (Drive) /RM/User subdirectory. This is okay, but now I'm wondering how do I get the Propane POI's out of this file. It appears to be a proprietary file called a data base file.
I guess I could delete the MyCustomPOI file, but then I lose everything. Any ideas...
Thanks very much for trying to load the Garmin format files. I am glad it worked!
Disorganized POIs happens with Garmin GPSs also. There are two things to try to organize them into categories.
I am assuming Railroad Crossings is not a factory POI file. Before running the loader program (is it "Dock?") organize your POI files on the PC into one folder named MyCustomPOI with two subfolders inside. Name one Propane and the other Railroad Crossings. Put the respective POI files inside their folders. Every time you run Dock it should overwrite all Custom POIs. If it does not, delete all Custom POIs first. (the custom Custom POIs, not the factory Custom POIs) Browse Dock to the MyCustomPOI folder and it should load the contents of all the subfolders even if you can't see the files in the browse window. My guess, after loading, is that in the RVND menu inside MyCustomPOI there will be a menu of two categories to choose from, Propane and Railroad Crossings. If this works, make as many subfolders as needed for each POI file you want.
In the Garmin GPSs, you can organize the POIs into categories or at least put them in order after loading by using choices in the GPS menu. BUT, this capability only appears after two or more POI files have been loaded. Before that, it is hidden!
I hope the RVND will be able to organize POIs like a Garmin!
I don't understand how to unmerge the factory POIs from the custom loaded POIs. On the Garmin they are kept separately.
I just got my 7710 and downloaded and imported 7 or 8 line csv files from this site. They imported fine. I tried to use the gpx files saved as 4 line csv with the EPE program and these tried to import but had many read errors.
The MY POI area on the 7710 showed each csv file as a sub category with the name of the file as its title.
I just need to find our a better way to convert the gpx files to csv, not sure if I use all the features of the EPE.
Now some of the csvs had a unique icon and some did not, if anyone know how to attach a specific icon to the imported file I can change out the non uniques ones.
The settings in EPE as recommended by Turbocc to me is; open EPE, go to options-4 column csv fields and set to user profiles to 10 . Then to to options- prefrences-csv output and set to pipe.
It seems the RVND needs a 4 column single line format; not any csv such as Garmin.
I called Rand about inputing custom icons; not at this time but will consider for future upgrades.
Check out the discussion at POI-factory,creating POI files-EPE(using with Rand McNally), Maybe this will shed some light on the subject.
Now I have to figure out how to change the pipes to comma's.
I have created a couple of files and changed a few downloaded from this site (for the Rand). I have to figure out how to upload to POI factory. Any help here?
In Excel isn't there a "Search and Replace" function?
Yes; but is there a code or something to represent the pipe to input into the search and replace?
I don't know what the code is, but you could copy a pipe and paste it into the search field.
Interesting that you are saying you were told that you had to go through all the steps. I just downloaded the Garmin csv files as they were and they imported fine without any read errors and seem to work okay on the 7710 as far as I can tell. The Garmin GPX's were another story, all I did was save them as a csv using EPE saveas, when they imported they had a lot of read errors so the amount that imported was a fraction of the whole file. However the ones that did read, seem to work fine. Unless there is another method with EPE to do the conversion instead of saveas, I will go back to these and try the xtra steps you mentioned one at a time and see what happens. But bottom line is it seems to like the Garmin csvs.
Just to make sure we're on the same page; download from this site Michigan Recycling. My 7710 showed; 196 files read, 109 failed.
I think this was mentioned in the other conversations at this site that for the Rand; a csv file must be on one line. The michigan recycling (column D) has four line creating the errors.
Therefore; a csv created with a single line works fine. A csv with multiple line creates errors.
I have reported this to Rand McMally with no reply yet.
The quick fix for this type of situation is (assuming you have Excel) to load the ASAP Utilities. There is a function in the utilities for Advanced Character Replacement where you can replace the line break characters with another. I use this function when converting many CSV files to GPX.
Can you direct me to this? Is it already in Excel someplace or a download from the web?
Yup, just tried that and I got the same error result you did and yet all the other Garmin csv's I have tried so far imported correctly even though they were 3 to 4 coloums long... not single records.
When I get some time I have to play with my conversion of the gpx files some more to get them to import more completely.
I just tried the Mi Rinks gpx. Ran it through the EPE,saved as csv and lost all address's and alot more info. I also found that there is no need for quote " symbols but a leading comma in column D is required. Nothing shows before the leading comma.
Now; how do I put leading comma's in column D without disturbing anything else?
Now; how do I put leading comma's in column D without disturbing anything else?
Use Excel's Concatenate function. Create a column of commas, row for row with the column containing your data. Then use the Concatenate function to merge the two columns into one without changing the data within. Then copy/paste values into the original column - "D" in this case.
Insert a blank column between C & D. In the new d1 type =","&E1
then coy that formula into all the cells in the new column. Right click to highlight the column, select copy, right click again and select Paste Special - Values. Delete the original column D.
Just another way to reach the same goal.
Itch, in case you are interested.
I tried your edits you had mentioned previously and it did not do any good in eliminating the read errors. In the process of using EPE I noticed that I had an option to save as a Garmin CSV so I took all of the Garmin GPX files I had download previously that gave read errors on import to the 7710 and saved them as Garmin csv, using profile 1 with no changes except for the imperial/us one. They all read in fine this time with no errors. Even the Michigan Recycle csv I resaved that again as a Garmin csv and that also came in with out any errors.
At least I am a happy camper now that I know I can use any of the Garmin files on this site on my 7710.
Your idea of Garmin csv worked great. Most of the data (address,hours open ,ect.) was lost but the cordinates work. By putting a comma at the beginning of column D; the information showed up but created lots of errors. It seems the Rand only likes 3 comma's per line. The fourth comma and all info after that is lost and in error.
I could not figure this one out. Tried help menu without success. Thanks anyway.
This worked great. I copied the instructions on my desktop for future use.
Another problem solved!
Tried using the saveas mio,csv.Everything worked fine except the need for the leading comma. Used Boxcar's suggestion; (Insert a blank column between C & D. In the new d1 type =","&E1 then coy that formula into all the cells in the new column. Right click to highlight the column, select copy, right click again and select Paste Special - Values. Delete the original column D.)
It's getting easier everyday!
Now if we can get Turbocc to do his magic; we are all set.
Tried using the saveas mio,csv.Everything worked fine except the need for the leading comma. Used Boxcar's suggestion; (Insert a blank column between C & D. In the new d1 type =","&E1
The & is the same as the concatenate command. Glad it worked out for you.
Zadmi - Thanks for this page!
Rand McNally - Loading POI files with the Rand McNally Dock
When you go to the DOCK it will let you down load and print the manual....
But when you try to down load custom POI's it will not let you.....talking to India was a waste of time because I knew more about the GPS than the help line...
I tried down loading my poi file but with a Mac you have to load each one separately take for instance restaurants you cannot just load restaurants you have to load each and every one, one at a time.....what a pita......
It's great that you can load POI's onto the Rand McNally but I used one for a short period and I hated it. Sometimes it wouldn't turn on, its real slow to calculate and re-calculate, it turns off without notice, and it freezes. If you read the reviews you will see that this unit has some issues.
Hopefully you have better luck.
When I first purchased this pos I hooked it up to my mac iBook and got a message that I needed to upgrade my software. I ended up spending 1200 dollars on a new computer only to find out that the dock software would not work as advertised. So I called customer service only to find out that I had made a huge mistake. The garmin gps is a piece of cake to down load new poi's. The customer service agent was useless as to how to down load poi's..He was going to have some one call me back, I followed up with 2 emails and have yet to have any one return my calls. No one there seems to know how to deal with the mac that they say you need. I do not think this unit was ready to be sold to the public. In short, unless you are an IT specialist then stay far away from this unit......am I angry you bet...
You can download a convert program called GPXtoPOI. I works great. Rand McNally has a sample .CVS file on there web page.
1. Make BACKUP FILE
2. In a blank column place a comma in (example K1)
3. Copy that K1 cell all the way to the last entry
4. In L column place the formula =K1&D1
5. Copy that L1 cell all the way to the last entry
6. Copy L column and PASTE SPECIAL - VALUES to D1 Column
7. Save File.
That is all.
1. Backup the file
2. Insert =","&d1 in a blank column
3. Copy and paste that value into the remaining cells in that column
4. Highlight the changed values and select copy
5. Select Column D and PASTE SPECIAL Values
6. Clear contents of Column used in step 2
7. Save the file.
But the ASAP utilities eliminates most of these steps and has a lot more useful functions included.
When I look at the POI files, they usually give a choice between Garmin and TomTom. There is usually a "raw" file in .csv format but no explanation of how to load it. Which one do I download for the Rand McNally 7710??
I think you can pretty much figure this out on your own by seeing what kind of files the 7710 needs. When it talks of loading custom POI does it tell you to use a file in the OV2 format?
If you read this post you would know. It is summed up in the 1st two posts.
You can read here also: http://www.randmcnally.com/POI-import/custom_poi_import.jsp
They even point to poi-factory
And we even have a "How to" that they link to. You can't ask for any more.
How to load a poi: http://www.poi-factory.com/node/34592
terms | privacy | contactCopyright © 2006 - 2014