MySQL Support - Lowrance USR 4 support

View: New views
4 Messages — Rating Filter:   Alert me  

MySQL Support - Lowrance USR 4 support

by Lloyd Borrett :: Rate this Message:

| View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

G’day,

 

Would you consider adding support for generating a MySQL dump file as one of the output formats from GPS Babel?

 

Being able to convert various GPS file formats into a MySQL dump file would make it easy to publish the location database on a web site.

 

I’d be happy to be a beta tester for this. Plus I could come up with a PHP/MySQL solution for displaying the location database on a web site.

 

Also, are there any plans to support the Lowrance USR 4 file format anytime soon?

 

Best Regards,

Lloyd Borrett
35 Courtenay Avenue
Cranbourne North VIC 3977
Melbourne, Australia
 
mobile: +61 418 170 044 | tel: +61 3 5996 0033 | fax: +61 3 5996 0003
email: lloyd@... | web: www.borrett.id.au
 
MSN Chat: lloyd@... | Yahoo Chat: lloyd_borrett
Skype: lloyd_borrett | AOL/AIM: lrborrett | Twitter: borrett

 


------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
Gpsbabel-misc@...
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc

Re: MySQL Support - Lowrance USR 4 support

by Fernando Arbeiza :: Rate this Message:

| View Threaded | Show Only this Message

Hi,

On Tue, Nov 15, 2011 at 7:28 PM, Lloyd Borrett <lloyd@...> wrote:
> Would you consider adding support for generating a MySQL dump file as one of
> the output formats from GPS Babel?
>
> Being able to convert various GPS file formats into a MySQL dump file would
> make it easy to publish the location database on a web site.

Why not saving to a csv and then loading it into MySQL with something like:

load data local infile 'uniq.csv' into table tblUniq
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(uniqName, uniqCity, uniqComments)

Sounds easy and you avoid all the options that I think a MySQL output may need.

Regards,
--
Fernando Arbeiza

------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
Gpsbabel-misc@...
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc

Re: MySQL Support - Lowrance USR 4 support

by Robert Lipe-4 :: Rate this Message:

| View Threaded | Show Only this Message

Fernando's take on the MySQL side matches my own - there are plenty of existing ways to solve that problem.

There was one person that asked about USRv4 about a year and a half ago.  It's more than trivially different than USRv3 and the GPS he was using also supported formats more amenable to import/export like CSV  and GPX, so there wasn't much motivation on it.

If you have documentation on the new format, that would make it easier for an interested party to tackle it.

RJL

On Tue, Nov 15, 2011 at 12:28 PM, Lloyd Borrett <lloyd@...> wrote:

G’day,

 

Would you consider adding support for generating a MySQL dump file as one of the output formats from GPS Babel?

 

Being able to convert various GPS file formats into a MySQL dump file would make it easy to publish the location database on a web site.

 

I’d be happy to be a beta tester for this. Plus I could come up with a PHP/MySQL solution for displaying the location database on a web site.

 

Also, are there any plans to support the Lowrance USR 4 file format anytime soon?

 

Best Regards,

Lloyd Borrett
35 Courtenay Avenue
Cranbourne North VIC 3977
Melbourne, Australia
 
mobile: +61 418 170 044 | tel: +61 3 5996 0033 | fax: +61 3 5996 0003
email: lloyd@... | web: www.borrett.id.au
 
MSN Chat: lloyd@... | Yahoo Chat: lloyd_borrett
Skype: lloyd_borrett | AOL/AIM: lrborrett | Twitter: borrett

 


------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
Gpsbabel-misc@...
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc



------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
Gpsbabel-misc@...
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc

Re: MySQL Support - Lowrance USR 4 support

by sbenz :: Rate this Message:

| View Threaded | Show Only this Message

hi, you can find a lowrance usr4 file to gpx converter here http://lowranceusrv4togpxconverter.blogspot.com/2011/12/about-this-blog.html please let me know if it works kind regards s
Lloyd Borrett wrote:
Also, are there any plans to support the Lowrance USR 4 file format anytime soon?