RV Trip Planning Discussions

Go Back   iRV2 Forums > CAMPING, TRAVEL and TRIP PLANNING > RV Trip Wizard - Trip Planner Topics
Click Here to Login
Join iRV2 Today

Mission Statement: Supporting thoughtful exchange of knowledge, values and experience among RV enthusiasts.
Reply
  This discussion is proudly sponsored by:
Please support our sponsors and let them know you heard about their products on iRV2
 
Thread Tools Search this Thread Display Modes
 
Old 07-31-2020, 12:40 PM   #1
Junior Member
 
SeeTheUSA2's Avatar
 
Join Date: Feb 2020
Location: Near Stuart, FL
Posts: 16
Looking for a tester or two for RVTW --> GPS app

Hi,

I have developed a little PC app that reads an Excel file exported from RVTW and converts it to a GPX file suitable for import to (at least) a Garmin RV890.

It only runs on a PC and I have only tested it on Windows 7 and Windows 10 where it seems to work.

I'm looking for a person to test the app and see if they can get a Trip full of Stops from RVTW to a late model Garmin GPS.

PM me if you would like to do this.

Tnx,
paul
__________________
Tiffin Open Road Allegro 32SA (2019)
Dinghy: 2017 white Jeep Cherokee
SeeTheUSA2 is online now   Reply With Quote
Join the #1 RV Forum Today - It's Totally Free!

iRV2.com RV Community - Are you about to start a new improvement on your RV or need some help with some maintenance? Do you need advice on what products to buy? Or maybe you can give others some advice? No matter where you fit in you'll find that iRV2 is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with other RV owners, see fewer ads, upload photographs, create an RV blog, send private messages and so much, much more!

Old 09-15-2020, 02:37 PM   #2
NXR
Senior Member
 
NXR's Avatar
 
Join Date: Mar 2019
Posts: 1,836
Quote:
Originally Posted by SeeTheUSA2 View Post
Hi,

I have developed a little PC app that reads an Excel file exported from RVTW and converts it to a GPX file suitable for import to (at least) a Garmin RV890.

It only runs on a PC and I have only tested it on Windows 7 and Windows 10 where it seems to work.

I'm looking for a person to test the app and see if they can get a Trip full of Stops from RVTW to a late model Garmin GPS.
Hi Paul,

How is this project working out?

Thanks,

Ray
__________________
2020 Forest River Georgetown GT5 34H5
NXR is online now   Reply With Quote
Old 09-16-2020, 11:53 AM   #3
Junior Member
 
SeeTheUSA2's Avatar
 
Join Date: Feb 2020
Location: Near Stuart, FL
Posts: 16
Ray,
I did get a PC based app to do the translation and it works pretty well. The app is not packaged for easy distribution though.



So I converted it to a web based app where you can upload a CSV file (taken from the RVTW exported XLSX), convert it to a GPX file, and then download it for moving to your GPS device. It even works on tablets, pcs, PCs, etc.


I put the project on hold while doing some work on our coach and getting the Jeep ready for towing.


I hope to have the web app available online in a week or two and will ask for testers at that time.


Thank you for asking
Paul
__________________
Tiffin Open Road Allegro 32SA (2019)
Dinghy: 2017 white Jeep Cherokee
SeeTheUSA2 is online now   Reply With Quote
Old 09-17-2020, 11:33 AM   #4
NXR
Senior Member
 
NXR's Avatar
 
Join Date: Mar 2019
Posts: 1,836
Quote:
Originally Posted by SeeTheUSA2 View Post
I did get a PC based app to do the translation and it works pretty well. The app is not packaged for easy distribution though.

So I converted it to a web based app where you can upload a CSV file (taken from the RVTW exported XLSX), convert it to a GPX file, and then download it for moving to your GPS device. It even works on tablets, pcs, PCs, etc.

I put the project on hold while doing some work on our coach and getting the Jeep ready for towing.

I hope to have the web app available online in a week or two and will ask for testers at that time.
Thanks for the update. Perhaps RVTW will collaborate with you on this to add it as a standard function. They could give you a lifetime subscription to RVTW or something for compensation.

Ray
__________________
2020 Forest River Georgetown GT5 34H5
NXR is online now   Reply With Quote
Old 09-20-2020, 09:01 AM   #5
Junior Member
 
SeeTheUSA2's Avatar
 
Join Date: Feb 2020
Location: Near Stuart, FL
Posts: 16
To anyone willing to help in testing:


I have converted the stand alone app to a web based that you can access from your browser.


PM me to get a link to the online version.


tnx,
paul
__________________
Tiffin Open Road Allegro 32SA (2019)
Dinghy: 2017 white Jeep Cherokee
SeeTheUSA2 is online now   Reply With Quote
Old 09-25-2020, 09:08 AM   #6
Junior Member
 
Join Date: Sep 2019
Posts: 22
Unless the GPS you're importing to also has an RV mode, the imported trip won't necessarily result in the same route that RVTW does. CSV imports are typically just GPS coordinates for start and stop. Your GPS will calculate the corresponding route on its own. Without RV settings you'll end up under that RR bridge you'd rather avoid. You can force it to avoid RV hazards with waypoints, but that requires you to know in advance which RV hazards it's avoiding, and trust that your non-RV GPS won't route you through others.

I truly wish Google Maps had an RV mode, even as a paid subscription. Perhaps RVTW is using a Google Maps API, supplemented with additional information? It doesn't seem so, though. RVTW routed us to a dead-end rural road that both Google Maps and Mapquest showed as dead end, while RVTW was using it as a route to another road. If RVTW were using Google Maps as an information source, it wouldn't have done that.
chriscowles is offline   Reply With Quote
Old 09-26-2020, 07:44 AM   #7
Junior Member
 
SeeTheUSA2's Avatar
 
Join Date: Feb 2020
Location: Near Stuart, FL
Posts: 16
The importing device must be able to route RVs safely

I completely agree. The conversion app is designed to copy RVTW stops to a GPS as waypoints.

No routing nor tracks are copied as they don't exist in the exported Excel format.

The app only creates waypoints that the device into which you import will use to fashion a safe route.

From the app's help file:

If you are doing this conversion for an RV, you should make sure the destination GPS device that will supply the routing knows about any special routing requirements of your RV. It is up to you, the user, to assure you are taking a safe route.


Tnx,
Paul (still looking for a tester :-)
__________________
Tiffin Open Road Allegro 32SA (2019)
Dinghy: 2017 white Jeep Cherokee
SeeTheUSA2 is online now   Reply With Quote
Old 09-26-2020, 09:14 AM   #8
Junior Member
 
Join Date: Sep 2019
Posts: 22
Since RVTW offers the means to export GPX, what is the purpose of your conversion utility? (I don't own a Garmin so I don't know the difference between it and others that import CSV.)
chriscowles is offline   Reply With Quote
Old 09-26-2020, 12:05 PM   #9
Junior Member
 
SeeTheUSA2's Avatar
 
Join Date: Feb 2020
Location: Near Stuart, FL
Posts: 16
Looking for waypoints, not tracks or routing

Hi,

RVTW can "Send to GPS" with options for GPX or CSV file format.

The GPS format contains the track and routing information for your trip (e.g. the GPX file contains trk and trkseg elements). I did not want the RVTW routed track, but did want the Stop information.

The "Send to GPS" CSV file contains a stop's Lat/Lon and stop name. Close to what I wanted, but...

I was looking for as much info as possible (e.g. url, phone number, CG description, etc.) as well as the stops for a single RVTW "Trip" assembled into one GPX route (<rte>) with route waypoints (<rtept>) as well as the waypoints in a non-route list (<wpt> elements). These are placed into separate storage areas of my RV890 GPS.

All this info is conveniently available in the RVTW Export to Excel function. All I needed to do was read that spreadsheet file and spit out a properly formatted GPX file, all w/o having to touch the data by hand where surely i will mess up something

That is why i wrote this little conversion app.

tnx,
paul
__________________
Tiffin Open Road Allegro 32SA (2019)
Dinghy: 2017 white Jeep Cherokee
SeeTheUSA2 is online now   Reply With Quote
Old 09-26-2020, 01:24 PM   #10
Junior Member
 
Join Date: Sep 2019
Posts: 22
Quote:
Originally Posted by SeeTheUSA2 View Post
... All this info is conveniently available in the RVTW Export to Excel function. All I needed to do was read that spreadsheet file and spit out a properly formatted GPX file, all w/o having to touch the data by hand where surely i will mess up something ...
Sounds useful. Too bad I don't have a Garmin to import it. The Excel export may provide some value to me, though. I'll check it out.
chriscowles is offline   Reply With Quote
Old 09-27-2020, 06:51 AM   #11
Junior Member
 
SeeTheUSA2's Avatar
 
Join Date: Feb 2020
Location: Near Stuart, FL
Posts: 16
The GPX file produced is in a standard format with three sections:
1) <metadata>
2) a list of <wpt> elements
3) a route element <rte> with <rtept> entries for each waypoint.

Theoretically, it should import into any device/app that can process these GPX sections.

That's a big "Theoretically" though
__________________
Tiffin Open Road Allegro 32SA (2019)
Dinghy: 2017 white Jeep Cherokee
SeeTheUSA2 is online now   Reply With Quote
Reply

Tags
gps, test



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copilot Car app vs RV app deandec Class A Motorhome Discussions 1 10-25-2018 09:55 PM
Where is the iRV2 app in the App Store? SCVJeff Forum 101 | Announcements | Member Forum Concerns 7 01-22-2015 08:24 AM


All times are GMT -6. The time now is 04:37 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2020, vBulletin Solutions, Inc.