SV: SV: [sailwave] Integration of Sailwave with Joomla

Hi,

This is not quite integration but it creates a reasonable illusion. My objectives were:

http://www.burghfieldsailing.org/results

- To create a page layout which is "in theme" with our site whilst not being constrained to the middle panel of our content area
- To have all links auto-generated just by the presence of the .htm files
- To allow easy navigation both down to the current results and then to the same results on previous years

We have been using it for a year or so now and it seems to work OK.

It is driven from the file naming convention, which is documented here:

http://www.burghfieldsailing.org/content/results/show.php?page=admin_help

Our site is phpWebsite rather than Joomla but I suspect that the principle is the same.

Ian

Hi,

I understand what you mean. I once started a project to parse the blw-file
with PHP, but no one will release any documentation on the file, thus it
would be hard to get it working for different versions. If the file had been
an XML-file, things would have got a lot easy. Yes, I know that sailwave can
export as XML, but this feature came after I gave up. There is also a
problem concerning editing of the XML-file – sailwave can’t open it again.

The reason for not making any “documentation” on the blw-format is that
Colin wants to be free to make changes for the format (I got an email from
him some time ago concerning this). I don’t know what he wants to be free to
change, but if it is to add more fields to compeditors I can’t see any
problem, neither for the current format or an XML-format (even though XML
would be easiest to parse with tools like SimpleXML and so on.)

In my project, I also planed to let my CMS create a basic blw-file to be
used directly in sailwave, thus removing the “import of compeditors part”.
This should also have included the correct scoringsystem and so on. It is
not really difficult, if someone just can tell me what the different fields
in each line in the blw-file means.

"compalias","0","20",""

"comphigh","0","20",""

"compnat","NOR","20",""

"compfleet","Intro","20",""

"compboat","TS kran","20",""

"compclass","Optimist","20",""

"compcrew","Odd Ola Nordfar","20",""

"comphelm","Ola Nordmann","20",""

"compclub","Stavanger Seilforening","20",""

"compexclude","0","20",""

"compdivision","Tysdag","20",""

"comphelmagegroup","15","20",""

"compdistrict","Stien","20",""

"comparea","4000","20",""

"compregion","Stavanger","20",""

"compcrewemail","mail@mail.no","20",""

"comphelmsex","F","20",""

"comphelmphone","510000000","20",""

"compcrewphone","900000000","20",""

"compmedicalflag","0","20",""

The above is as far as I can figure out the data for one compeditor. Each
line is for one compeditorfield, and contains 1. fieldname, 2. value, 3.
compeditorID and 4. empty? What is this last field?

Actually, all the lines contains placeholders for 4 values. The first is
always an ID of the line, which again is divided in to what I think is
groups of valuetypes where the first couple of chars describes the goups.
Ex: “comp” for compeditor, “ser” for series and so on.

Espen

···

_____

Fra: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] På vegne av
lawrni
Sendt: 13. juni 2008 09:42
Til: sailwave@yahoogroups.com
Emne: Re: SV: [sailwave] Integration of Sailwave with Joomla

--- In sailwave@yahoogroup <mailto:sailwave%40yahoogroups.com> s.com, "Espen
Molven" <espenmolven@...>
wrote:

Hi,

You can publish via FTP to a folder om your server. To store the

HTML-file

on your webserver, hit Publish and choose "website" as destination.

Edit the FTP-prefs in global options.

Espen

Hi Espen,

Many thanks for your reply, - yes I know that you can ftp an html
file to a website. I was really wondering if anyone had found a neat
and simple way to integrate this information into Joomla - so that
the results are then automatically listed in some page somewhere
whenever someone ftp's the results to the site (without having to
create static links to hmtml file that do not contain the same
formatting as the rest of the site...

Cheers,

Lawrni

_____

Fra: sailwave@yahoogroup <mailto:sailwave%40yahoogroups.com> s.com

[mailto:sailwave@yahoogroup <mailto:sailwave%40yahoogroups.com> s.com] På
vegne av

lawrni
Sendt: 12. juni 2008 20:20
Til: sailwave@yahoogroup <mailto:sailwave%40yahoogroups.com> s.com
Emne: [sailwave] Integration of Sailwave with Joomla

Hi,

I'm new to sailwave, but we are looking at using it for doing race
results at our sailing club. We've just re-done our website so that

it

runs under the Joomla content management system and I'm wondering

what

the best method is for incorporating results from sailwave ?

I know you can publish to a html file and then cut/paste into a

wrapper

or an article, but I was wondering if there was a more 'elegant'

way of

doing this - such that results might be stored in a database or

that

results could be uploaded to a directory where Joomla 'finds' them

and

then lists them on the correct page.

Any thoughts from seasoned users of sailwave and Joomla would be

much

appreciated...

Many thanks (in advance)

Lawrni