Using Perl modules I can deliver a relational database frontend,
with the underlying storage in CSV format - so that if necessary,
users/administrators can use the raw data without exporting
I could use mySQL, but my main environment at home - and that of
potential users, generally - is Windows, and I don't think mySQL is
particularly easy to distribute/install. (Unless you know
different?) However, I will look at mySQL - you've got me
interested in this path...
Once the data is in the database, I can publish/export in XML/HTML
etc with ease (dangerous statement). I will probably use XML
internally, and XSLT (XSL stylesheets) to format the export formats,
to give flexibility on export formats, without having to recode the
I know that Colin is intending to add XML publishing to Sailwave -
one thing I could do now is to take a BLW file and produce an XML
format file from it, if this would be of use to you. Of course, we
need to come up with a schema, for which Colin should, I think, be
--- In email@example.com, Herman van Beek <hvanbeek@c...>
Sorry for the slow response - am busy getting ready for our
regatta in Florida next week.
A csv or tsv formatted file should work fine for interfacing to
and Excel. However, in rereading the thread, I think there may be
expectation that much more would be delivered; i.e., a relational
database program. My next major push is to do just that - use
(free) to hold all results, write Perl or PHP utilities to
the data as needed, and then output to html templates for
results on the Web. In that environment, I would like a more
intelligent output format from Sailwave with tags (like XML)
over time I know I will be adding new parameters/criteria that
could/will obsolete the csv/tsv format and require reprogramming
Would be interested to hear from others on this. It is
design such a system to work with Access on a PC instead of on a
server running Unix or Linux.
James Lavery wrote:
> Hi Herman,
> I'm currently looking at a simple csv or tsv (tab-separated
> for the actual data files - so that it's readable by Word/Excel
> if people want to 'do other things' with the data.
> However, I'm also happy to use XML for the storage, and/or
> publish/import in a 'standard' XML format (I code in Perl and XML
> daily at work). I'd be interested in your ideas on this front,
> would be happy to collaborate.
> --- In firstname.lastname@example.org, "Herman van Beek"
> > Hi Colin,
> > Great discussion and am keenly interested in outcome. My
> > from another perspective: the regatta organizers. I use Perl to
> > about 20-30 on-line registrations per year for the MC scow
> > class (http://www.mcscow.org) <http://www.mcscow.org%29> and
> information collected to
> > display a list of registrants, provide organizers with details
> > meals and other items ordered, and drive the population of
> > programs. I currently support four (4): Sailwave, St Pete
> > JavaScore, and one I wrote myself in Excel VB (MC Score); see
> > http://www.mcscow.org/regatta/ for a brief description of the
> > The interface becomes real messy when you have multiple
> > the four, I've found JavaScore the simplest - it uses an XML
> > Tracking the standings of competitors (I process about 50
> > year involving 500-600 participants) is best handled by a
> > database. And having, as others have already suggested,
> a "standard"
> > output format would make feeding that db a much more manageable
> > The XML approach offers the best of both worlds: the format is
> > but the mark up language can be expanded to bring in new
> > and it is easy to create as well as parse!
> > Regards,
> > Herman
> > --- In email@example.com, "steven_atkinson"
> > <Steve.Atkinson@w...> wrote:
> > > --- In firstname.lastname@example.org, "James Lavery"
> > wrote:
> > > > Hi Colin,
> > > > Thanks - I'm in danger of overloading as well, but this
> > good
> > > > thing to do.
> > > >
> > > > Notes on the file format would be useful - I can derive
> > > > inspection, though. If you want to send it outside the
> > (i.e.
> > > > via email), that's fine.
> > > >
> > >
> > > I don't suppose you would consider making the file format
> > information
> > > public knowledge. I've toyed with the idea in the past of
> > some
> > > perl or php so that I can just drop the .blw files straight
> > > club website and the cgi scripts display the information by
> > > the file. I just quite fancy the idea of being able to do
> > > interactive stuff like display all the results for a
> > boat,
> > > or display each race on a single page on it's own without
> > > publish each race individually and things like that. I've
> > > wary of doing the work in the past just in case the file
> > > changes much between versions of sailwave and I have to keep
> > updating
> > > my scripts.
> > >
> > > Thanks
> > > Steve Atkinson
> > > Carrickfergus Sailing Club
> -!- Tired of Hotmail? Try Fastmail -!- http://www.fastmail.fm/
> -!- Sick of Spam? Get Spam Pal <free!> -!-
> Convert to daily digest of emails send blank email to:
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> * To unsubscribe from this group, send an email to:
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
Herman van Beek email: hvanbeek@c...
2816 Biscayne Drive phone: 972.596.9524
Plano, Texas 75075-7504 fax: 509.692.3503
[Non-text portions of this message have been removed]