Missed the OP for this. Back In June I posted this:
For a little while
I've been pondering how best to integrate Sailwave
Results into a CMS
like Joomla. The gold standard would be to have a
Joomla Extension that
took the results and then let you do all sorts of
stuff like search for
competitors... that'd take a fair bit of coding.
Some people are copying
the html into an 'article' which of course
works. But sailwave has
publishing potential which shoudl be much
simpler than logging into a CMS
and creating articles. *SO* my
suggestion is to FTP the result over with
Sailwave. BUT Joomla can't
just cope with listing that, and although you
could just allow directory
listign on the ftp folder its hardly clean and
integrated into the
website. The solutiobn is to create a little menu
building service that
can look in the sailwave results folder where
sailwave FTPd them and
then list them. With years of results you'll
probably want to list them
by year.
So I wrote a tiny piece of PHP top
take those results and create a
menu... For now its sat on one of my test
servers here:
php5.chemo.org.uk - its running joomla, but uses NO joomla
code to show
the results - they are simply wrapping
php5.chemo.org.uk/sailwave in an
iframe.
It uses a standardised naming
convention to do the listing:
YEAR-Results_name.htm is the format of the
results page file name, and
they are uploaded to ../sailwave/results
if
anyone wants the code its freely available from the site at:
http://php5.chemo.org.uk/images/files/sailwavemenu-0.1.zip [1]
Code
released as GPL v2.0 or later. Critique welcome.
(You don't even need a
CMS to make use of this... you could simply wrap
an iframe round it in a
flat format site too.)
Calum
AIM WAS PURELY A VERY QUICK "MENU" FOR
RESULTS. HOWEVER I COMPLETELY AGREE WE COULD BENEFIT FROM A CMS SOLUTION.
MY CLUB DOESN'T CURRENTLY USE A CMS (DONT ASK!) BUT I'D BE HAPPY TO
CONTRIBUTE TO THE PROJECT. I HAVE CODED SOME JOOMLA BEFORE. DID A BIT OF
WORK WITH AEC - AND COULD SEE HOW IT MIGHT BE INTEGRATED TO TAKE
REGISTRATION PAYMENTS ETC.
See below for my thoughts...
···
On Wed, 17 Nov 2010 11:31:50 -0000, "Eddie Aldridge" wrote:
1. What version of
Joomla people are currently using.
IF YOU WRITE SOMETHING FOR 1.5.X IT
SHOULD BE REASONABLY SIMPLE TO PORT TO 1.6.X - NOT LIKE 1.0.X TO 1.5.X
1.0.X IS DEAD NOW SO SHOULDN'T BE USED TO DEVELOP, WHICH MAKES LIFE
EASIER CAUSE YOU CAN USE THE MVC MODEL IN 1.5 TO BETTER EFFECT.
NOOKU
FRAMEWORK SEEMS TO HAVE A LOT OF CHATTER ABOUT IT AT THE MINUTE IN THE J!
WORLD AND WOULD APPARENTLY MAKE THIS BETTER STILL...
2. Do you have plans
to upgrade to Joomla 1.6 once it's released as a stable version.
It
would be daft not to be planning for a component to be released in beta in
April to be 1.6 native - givenit will be what anyone installs on a new
site. BUT if it was backwards compat that would make sense as has already
been said - if the 3PD Components aren't upgraded people get stuck in
limbo.
3. What sort of administration would you like to see?
I CAN SEE
AN ADVANTAGE TO BEIGN ABLE TO DO A LOT MORE THAN JUST RESULTS... ...BUT
BEAR IN MIND COLIN'S PLANS FOR MYSAIL /ONLINE SAILWAVE VS
SAILWAVE4WINDOWS.
4. What other functionality would be useful.
THERE
WOULD BE TWO OPTIONS - UPLOAD RESULT FROM SAILWAVE TO J! OR UPLOAD THE
WHOLE .BLW FILE TO J! UPLOADING THE RESULT MEANS WRITING STUFF INTO
SAILWAVE AND THAT MEANS YOU NEED COLIN TO BE ONBOARD BUT BE AWARE OF THE
DEVELOPMENT TRACK OF SAILWAVE.
HOWEVER, THE .BLW FILE IS AN XML FILE. IT
SHOULD BE POSSIBLE TO UPLAOD THE WHOLE FILE, PARSE IT, EDIT IT ONLINE (TOLD
YOU I WANTED LOTS MORE!!), AND READ OUT RESULTS. MY REASON FOR SUGGESTING
THIS IS THAT I HAVE SEVERAL PEOPLE WHO MAY UPDATE RESULTS FROM ACROSS
DIFFERENT COMPUTERS - I'D SUGGEST WE HAVE THE BLW ON THE WEB AND PULL IT
OFF INTO SAILWAVE IF NEEDED AND THEN RE-UPLOAD.
MY ONLY CONCERN IS THERE
IS SOME POTENTIALLY SENSITIVE DATA IN THE BLW FILE. MEDICAL INFO ETC. SO I
THINK THE SAFEST APPROACH WOULD BE TO PUT THE FILE IN THE SQL TABLE AS A
BLOB AND THEN PULL IT OUT WHEN NEEDED TO WORK ON. BUT NOT SURE THATS
EFFICIENT.
I CAN SEE A LOT OF LOGIC TO ALLOW ON-LINE SIGN UP WHICH WOULD
POPULATE INTO THE BLW FILE...
ALL RESULTS SHOULD BE LINKED BY AS MANY
MEANS AS POSSIBLE. SO YOU SHOULD BE ABLE TO CLICK MY NAME AND SAY FIND ALL
RESULTS FOR ME.
AGREE THE RESULTS NEED TO BE ADDED TO THE MENU SYSTEM
AUTOMATICALLY...
So i'd have results viewing, results entry online as
well.
This is only an embryonic idea at this stage, but any feeback /
thoughts would be useful. IF I get the project off the ground, I would hope
to have a first beta ready for release for Easter next year.
I'd also be
interested in collaborating, if anyone else is interested in helping with
this project.
HAPPY TO COLLABORATE - IF YOU SET IT UP ON JOOMLAFORGE OR
SOMETHING DROP ME SOME SVN DETAILS?
Just had a baby boy so short on
development hours but would be keen to be part of it if I can,..
Cheers
Keith
Links:
------
[1]
http://php5.chemo.org.uk/images/files/sailwavemenu-0.1.zip
[2]
mailto:eddie.aldridge@btinternet.com?subject=RE: [sailwave] Jooma
Integration
[3] mailto:sailwave@yahoogroups.com?subject=RE: [sailwave]
Jooma Integration
[4]
http://groups.yahoo.com/group/sailwave/post;_ylc=X3oDMTJxNW5sYm5mBF9TAzk3MzU5NzE0BGdycElkAzMwODY1MzAEZ3Jwc3BJZAMxNzA1MDY1NzkyBG1zZ0lkAzEwNjI1BHNlYwNmdHIEc2xrA3JwbHkEc3RpbWUDMTI4OTk5MzUyNg--?act=reply&messageNum=10625
[5]
http://groups.yahoo.com/group/sailwave/post;_ylc=X3oDMTJlaGJwZHVqBF9TAzk3MzU5NzE0BGdycElkAzMwODY1MzAEZ3Jwc3BJZAMxNzA1MDY1NzkyBHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTI4OTk5MzUyNg--
[6]
http://groups.yahoo.com/group/sailwave/message/10624;_ylc=X3oDMTM2N3R2ZGR1BF9TAzk3MzU5NzE0BGdycElkAzMwODY1MzAEZ3Jwc3BJZAMxNzA1MDY1NzkyBG1zZ0lkAzEwNjI1BHNlYwNmdHIEc2xrA3Z0cGMEc3RpbWUDMTI4OTk5MzUyNgR0cGNJZAMxMDYyNA--
[7]
http://groups.yahoo.com/group/sailwave/members;_ylc=X3oDMTJmbG1tMmwyBF9TAzk3MzU5NzE0BGdycElkAzMwODY1MzAEZ3Jwc3BJZAMxNzA1MDY1NzkyBHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEyODk5OTM1MjY-?o=6
[8]
http://groups.yahoo.com/group/sailwave;_ylc=X3oDMTJlcWc4a3NqBF9TAzk3MzU5NzE0BGdycElkAzMwODY1MzAEZ3Jwc3BJZAMxNzA1MDY1NzkyBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTI4OTk5MzUyNg--
[9]
http://www.yachtsandyachting.com/
[10] http://www.sailing.org/
[11]
http://www.sailwave.com/
[12] http://sailwave.com/help/HTML
[13]
http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf
[14]
http://groups.yahoo.com/;_ylc=X3oDMTJkdG83MWM4BF9TAzk3NDc2NTkwBGdycElkAzMwODY1MzAEZ3Jwc3BJZAMxNzA1MDY1NzkyBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMjg5OTkzNTI2
[15]
mailto:sailwave-traditional@yahoogroups.com?subject=Change Delivery
Format: Traditional
[16]
mailto:sailwave-digest@yahoogroups.com?subject=Email Delivery: Digest
[17]
mailto:sailwave-unsubscribe@yahoogroups.com?subject=Unsubscribe
[18]
http://docs.yahoo.com/info/terms/