Thread: [Gpsbabel-misc] CSV format
Brought to you by:
robertl
From: BRENT M. <rbm...@gm...> - 2012-06-27 01:18:20
|
I am having trouble just getting started. I am trying to convert CSV format into .hmr format for my humminbird 597ci hd di fish finder this is the error I am getting: gpsbabel -w -i csv,snwhite=0,snupper=0,snunique=0,prefer_shortnames=0 -f C:\Users\Brent\Desktop\GPS Coordinates.txt -o humminbird -F C:/Users/Brent/Desktop/HumminbirdGPS.hwr csv: Invalid latitude 360.000000 in waypoint . Error running gpsbabel: Process exited unsucessfully with code 1 this is the way I have set up the csv 50' REEF LIVE BOTTOM N 33 44.920 W -78 28.000 If this is incorrect could someone please correct this and repost the correct way. |
From: Robert L. <rob...@gp...> - 2012-06-27 01:51:07
|
On Tue, Jun 26, 2012 at 8:18 PM, BRENT McLAMB <rbm...@gm...> wrote: > I am having trouble just getting started. > > I am trying to convert CSV format into .hmr format for my humminbird 597ci > hd di fish finder > > this is the error I am getting: > > gpsbabel -w -i csv,snwhite=0,snupper=0,snunique=0,prefer_shortnames=0 -f > C:\Users\Brent\Desktop\GPS Coordinates.txt -o humminbird -F > C:/Users/Brent/Desktop/HumminbirdGPS.hwr > > csv: Invalid latitude 360.000000 in waypoint . > > Error running gpsbabel: Process exited unsucessfully with code 1 > > > this is the way I have set up the csv > > > 50' REEF LIVE BOTTOM N 33 44.920 W -78 28.000 > > > If this is incorrect could someone please correct this and repost the > correct way. > Hint: Where are the commas in your Comma Separated Values? If I put them in the order described in our documentation at http://www.gpsbabel.org/htmldoc-development/fmt_csv.html and sprinkle some commas around, it would look like: N 33 44.920,W -78 28.000, 50' REEF LIVE BOTTOM GPSBabel happily slurps that right up. For today's Stupid GPSBabel trick, here is that line converted to humminbird then piped to another GPSBabel that successfully reads it and gives you back the same (well, mathematically the same) data, subject to Hummminbird's length restrictions. gpsbabel -i csv -f xxx.csv -o humminbird -F - | gpsbabel -i humminbird -f - -o csv -F - 33.74867, -78.46667, 50' RF LV B RJL If you find GPSBabel useful, especially if a feature was added or fixed for you, please consider supporting its development at http://www.gpsbabel.org/contribute.html |
From: BRENT M. <rbm...@gm...> - 2012-06-27 02:17:56
|
Thanks and another question... is there a format available to where I do not have to change anything around in the way I have the example? I know this is a long shot but I am new to this whole thing On Tue, Jun 26, 2012 at 9:51 PM, Robert Lipe <rob...@gp...>wrote: > > > On Tue, Jun 26, 2012 at 8:18 PM, BRENT McLAMB <rbm...@gm...> wrote: > >> I am having trouble just getting started. >> >> I am trying to convert CSV format into .hmr format for my humminbird >> 597ci hd di fish finder >> >> this is the error I am getting: >> >> gpsbabel -w -i csv,snwhite=0,snupper=0,snunique=0,prefer_shortnames=0 -f >> C:\Users\Brent\Desktop\GPS Coordinates.txt -o humminbird -F >> C:/Users/Brent/Desktop/HumminbirdGPS.hwr >> >> csv: Invalid latitude 360.000000 in waypoint . >> >> Error running gpsbabel: Process exited unsucessfully with code 1 >> >> >> this is the way I have set up the csv >> >> >> 50' REEF LIVE BOTTOM N 33 44.920 W -78 28.000 >> >> >> If this is incorrect could someone please correct this and repost the >> correct way. >> > > Hint: Where are the commas in your Comma Separated Values? > > If I put them in the order described in our documentation at > http://www.gpsbabel.org/htmldoc-development/fmt_csv.html and sprinkle > some commas around, it would look like: > > N 33 44.920,W -78 28.000, 50' REEF LIVE BOTTOM > > GPSBabel happily slurps that right up. For today's Stupid GPSBabel > trick, here is that line converted to humminbird then piped to another > GPSBabel that successfully reads it and gives you back the same (well, > mathematically the same) data, subject to Hummminbird's length restrictions. > > gpsbabel -i csv -f xxx.csv -o humminbird -F - | gpsbabel -i humminbird -f > - -o csv -F - > 33.74867, -78.46667, 50' RF LV B > > RJL > > If you find GPSBabel useful, especially if a feature was added or fixed > for you, please consider supporting its development at > http://www.gpsbabel.org/contribute.html > > > > > |
From: Robert L. <rob...@gp...> - 2012-06-27 02:30:05
|
On Tue, Jun 26, 2012 at 9:17 PM, BRENT McLAMB <rbm...@gm...> wrote: > Thanks and another question... > > is there a format available to where I do not have to change anything > around in the way I have the example? I know this is a long shot but I am > new to this whole thing > We don't have any "guess where each field starts and stops" option. If it's a one time need and you have control over the data, you could write something quick and dirty that grabs everything up to " N " (assuming you have no waypoints with an N surrounded by spaces) and then parsed and rearranged from there. If you have fewer than a few hundred, you can probably "fix" them by hand faster than you could work out the regular expressions to try to do it with regular expressions in sed or whatever. If this is a one-time conversion need for a small data set, it's unlikely you'll recover that development cost. If you're converting many thousands, send me your data set for a quote. RJL > > > On Tue, Jun 26, 2012 at 9:51 PM, Robert Lipe <rob...@gp...>wrote: > >> >> >> On Tue, Jun 26, 2012 at 8:18 PM, BRENT McLAMB <rbm...@gm...> wrote: >> >>> I am having trouble just getting started. >>> >>> I am trying to convert CSV format into .hmr format for my humminbird >>> 597ci hd di fish finder >>> >>> this is the error I am getting: >>> >>> gpsbabel -w -i csv,snwhite=0,snupper=0,snunique=0,prefer_shortnames=0 -f >>> C:\Users\Brent\Desktop\GPS Coordinates.txt -o humminbird -F >>> C:/Users/Brent/Desktop/HumminbirdGPS.hwr >>> >>> csv: Invalid latitude 360.000000 in waypoint . >>> >>> Error running gpsbabel: Process exited unsucessfully with code 1 >>> >>> >>> this is the way I have set up the csv >>> >>> >>> 50' REEF LIVE BOTTOM N 33 44.920 W -78 28.000 >>> >>> >>> If this is incorrect could someone please correct this and repost the >>> correct way. >>> >> >> Hint: Where are the commas in your Comma Separated Values? >> >> If I put them in the order described in our documentation at >> http://www.gpsbabel.org/htmldoc-development/fmt_csv.html and sprinkle >> some commas around, it would look like: >> >> N 33 44.920,W -78 28.000, 50' REEF LIVE BOTTOM >> >> GPSBabel happily slurps that right up. For today's Stupid GPSBabel >> trick, here is that line converted to humminbird then piped to another >> GPSBabel that successfully reads it and gives you back the same (well, >> mathematically the same) data, subject to Hummminbird's length restrictions. >> >> gpsbabel -i csv -f xxx.csv -o humminbird -F - | gpsbabel -i humminbird -f >> - -o csv -F - >> 33.74867, -78.46667, 50' RF LV B >> >> RJL >> >> If you find GPSBabel useful, especially if a feature was added or fixed >> for you, please consider supporting its development at >> http://www.gpsbabel.org/contribute.html >> >> >> >> >> > > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Gpsbabel-misc mailing list http://www.gpsbabel.org > Gps...@li... > To unsubscribe, change list options, or see archives, visit: > https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc > > |
From: Gary T. <g...@el...> - 2012-06-27 04:05:04
|
I think you're talking way over Brent's head there Robert! Brent: You said "this is the way I have set up the csv". Apart from the obvious mistake (the lack of commas) - that implies to me that you have some control over the output of what is creating that example. You should fix that, rather than trying to work around the mistake. If, as Robert says, you can't fix it up, and/or it's a one-off and/or infrequent job, one option which you (or a mate) might be more familiar with, would be to use excel or some other spreadsheet program to massage the data into something more 'machine readable'. You could use formulas to add commas at the appropriate place, and then use gpsbabel. ----- Original Message ----- From: Robert Lipe To: BRENT McLAMB Cc: gps...@li... Sent: Wednesday, June 27, 2012 2:30 PM Subject: Re: [Gpsbabel-misc] CSV format On Tue, Jun 26, 2012 at 9:17 PM, BRENT McLAMB <rbm...@gm...> wrote: Thanks and another question... is there a format available to where I do not have to change anything around in the way I have the example? I know this is a long shot but I am new to this whole thing We don't have any "guess where each field starts and stops" option. If it's a one time need and you have control over the data, you could write something quick and dirty that grabs everything up to " N " (assuming you have no waypoints with an N surrounded by spaces) and then parsed and rearranged from there. If you have fewer than a few hundred, you can probably "fix" them by hand faster than you could work out the regular expressions to try to do it with regular expressions in sed or whatever. If this is a one-time conversion need for a small data set, it's unlikely you'll recover that development cost. If you're converting many thousands, send me your data set for a quote. RJL On Tue, Jun 26, 2012 at 9:51 PM, Robert Lipe <rob...@gp...> wrote: On Tue, Jun 26, 2012 at 8:18 PM, BRENT McLAMB <rbm...@gm...> wrote: I am having trouble just getting started. I am trying to convert CSV format into .hmr format for my humminbird 597ci hd di fish finder this is the error I am getting: gpsbabel -w -i csv,snwhite=0,snupper=0,snunique=0,prefer_shortnames=0 -f C:\Users\Brent\Desktop\GPS Coordinates.txt -o humminbird -F C:/Users/Brent/Desktop/HumminbirdGPS.hwr csv: Invalid latitude 360.000000 in waypoint . Error running gpsbabel: Process exited unsucessfully with code 1 this is the way I have set up the csv 50' REEF LIVE BOTTOM N 33 44.920 W -78 28.000 If this is incorrect could someone please correct this and repost the correct way. Hint: Where are the commas in your Comma Separated Values? If I put them in the order described in our documentation at http://www.gpsbabel.org/htmldoc-development/fmt_csv.html and sprinkle some commas around, it would look like: N 33 44.920,W -78 28.000, 50' REEF LIVE BOTTOM GPSBabel happily slurps that right up. For today's Stupid GPSBabel trick, here is that line converted to humminbird then piped to another GPSBabel that successfully reads it and gives you back the same (well, mathematically the same) data, subject to Hummminbird's length restrictions. gpsbabel -i csv -f xxx.csv -o humminbird -F - | gpsbabel -i humminbird -f - -o csv -F - 33.74867, -78.46667, 50' RF LV B RJL If you find GPSBabel useful, especially if a feature was added or fixed for you, please consider supporting its development at http://www.gpsbabel.org/contribute.html ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Gpsbabel-misc mailing list http://www.gpsbabel.org Gps...@li... To unsubscribe, change list options, or see archives, visit: https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ------------------------------------------------------------------------------ _______________________________________________ Gpsbabel-misc mailing list http://www.gpsbabel.org Gps...@li... To unsubscribe, change list options, or see archives, visit: https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc |
From: BRENT M. <rbm...@gm...> - 2012-06-27 13:47:14
|
I am making headway I believe but I am curious if I need to go thru my entire list and add the negative (-) in front of all westward data? Also I am looking for away to convert the .hwr file back to something that is view-able like Google Maps or Earth to ensure that when I load the info onto an SD card for the fish finder it will be correct info. I do apologize that I am not a coding genius and have little experience in all things GPS conversions. I do however appreciate all the time and energy involved in helping a noob at something they are not even slightly versed in at all. Brent On Tue, Jun 26, 2012 at 11:38 PM, Gary Turner <g...@el...> wrote: > ** > I think you're talking way over Brent's head there Robert! > > Brent: > You said "this is the way I have set up the csv". Apart from the obvious > mistake (the lack of commas) - that implies to me that you have some > control over the output of what is creating that example. You should fix > that, rather than trying to work around the mistake. > > If, as Robert says, you can't fix it up, and/or it's a one-off and/or > infrequent job, one option which you (or a mate) might be more familiar > with, would be to use excel or some other spreadsheet program to massage > the data into something more 'machine readable'. You could use formulas to > add commas at the appropriate place, and then use gpsbabel. > > ----- Original Message ----- > *From:* Robert Lipe <rob...@gp...> > *To:* BRENT McLAMB <rbm...@gm...> > *Cc:* > *Sent:* Wednesday, June 27, 2012 2:30 PM > *Subject:* Re: [Gpsbabel-misc] CSV format > > > > On Tue, Jun 26, 2012 at 9:17 PM, BRENT McLAMB <rbm...@gm...> wrote: > >> Thanks and another question... >> >> is there a format available to where I do not have to change anything >> around in the way I have the example? I know this is a long shot but I am >> new to this whole thing >> > > We don't have any "guess where each field starts and stops" option. > > If it's a one time need and you have control over the data, you could > write something quick and dirty that grabs everything up to " N " (assuming > you have no waypoints with an N surrounded by spaces) and then parsed and > rearranged from there. > > If you have fewer than a few hundred, you can probably "fix" them by hand > faster than you could work out the regular expressions to try to do it with > regular expressions in sed or whatever. If this is a one-time conversion > need for a small data set, it's unlikely you'll recover that development > cost. If you're converting many thousands, send me your data set for a > quote. > > RJL > > > >> >> >> On Tue, Jun 26, 2012 at 9:51 PM, Robert Lipe <rob...@gp...>wrote: >> >>> >>> >>> On Tue, Jun 26, 2012 at 8:18 PM, BRENT McLAMB <rbm...@gm...>wrote: >>> >>>> I am having trouble just getting started. >>>> >>>> I am trying to convert CSV format into .hmr format for my humminbird >>>> 597ci hd di fish finder >>>> >>>> this is the error I am getting: >>>> >>>> gpsbabel -w -i csv,snwhite=0,snupper=0,snunique=0,prefer_shortnames=0 >>>> -f C:\Users\Brent\Desktop\GPS Coordinates.txt -o humminbird -F >>>> C:/Users/Brent/Desktop/HumminbirdGPS.hwr >>>> >>>> csv: Invalid latitude 360.000000 in waypoint . >>>> >>>> Error running gpsbabel: Process exited unsucessfully with code 1 >>>> >>>> >>>> this is the way I have set up the csv >>>> >>>> >>>> 50' REEF LIVE BOTTOM N 33 44.920 W -78 28.000 >>>> >>>> >>>> If this is incorrect could someone please correct this and repost the >>>> correct way. >>>> >>> >>> Hint: Where are the commas in your Comma Separated Values? >>> >>> If I put them in the order described in our documentation at >>> http://www.gpsbabel.org/htmldoc-development/fmt_csv.html and sprinkle >>> some commas around, it would look like: >>> >>> N 33 44.920,W -78 28.000, 50' REEF LIVE BOTTOM >>> >>> GPSBabel happily slurps that right up. For today's Stupid GPSBabel >>> trick, here is that line converted to humminbird then piped to another >>> GPSBabel that successfully reads it and gives you back the same (well, >>> mathematically the same) data, subject to Hummminbird's length restrictions. >>> >>> gpsbabel -i csv -f xxx.csv -o humminbird -F - | gpsbabel -i humminbird >>> -f - -o csv -F - >>> 33.74867, -78.46667, 50' RF LV B >>> >>> RJL >>> >>> If you find GPSBabel useful, especially if a feature was added or >>> fixed for you, please consider supporting its development at >>> http://www.gpsbabel.org/contribute.html >>> >>> >>> >>> >>> >> >> >> >> ------------------------------------------------------------------------------ >> Live Security Virtual Conference >> Exclusive live event will cover all the ways today's security and >> threat landscape has changed and how IT managers can respond. Discussions >> will include endpoint security, mobile security and the latest in malware >> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >> _______________________________________________ >> Gpsbabel-misc mailing list http://www.gpsbabel.org >> Gps...@li... >> To unsubscribe, change list options, or see archives, visit: >> https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc >> >> > ------------------------------ > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > > ------------------------------ > > _______________________________________________ > Gpsbabel-misc mailing list http://www.gpsbabel.org > Gps...@li... > To unsubscribe, change list options, or see archives, visit: > https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc > > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Gpsbabel-misc mailing list http://www.gpsbabel.org > Gps...@li... > To unsubscribe, change list options, or see archives, visit: > https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc > > |
From: Robert L. <rob...@gp...> - 2012-06-27 13:54:44
|
On Wed, Jun 27, 2012 at 8:47 AM, BRENT McLAMB <rbm...@gm...> wrote: > I am making headway I believe but I am curious if I need to go thru my > entire list and add the negative (-) in front of all westward data? Use the format I described before. > Also I am looking for away to convert the .hwr file back to something that > is view-able like Google Maps or Earth to ensure that when I load the info > onto an SD card for the fish finder it will be correct > Convert to GPX or KML. Google Earth will read either. |