Datatables in Joomla/K2 content?
On a site that I am working on, a little problem has presented itself.
On the old site, there is some data that is being presented in tables. Of course, I could just continue with that. But I was hoping there was a better and more userfriendly way to maintain these tables.
The data in the tables are the results of a couple of simulator tournaments in golf. Take a look at one of them here:
http://www.golfsenteretmyrens.no/module_info/index.php?level=2&...
Each table represents one month. There is no fixed number of rows in a table (determined by number of participants). Main heading for a table is Month/Golfcourse played (on the simulator).
Column headings are:
Player/Team name
Handicap (I want to add this to avoid two lines in the name column)
Tee
Results (up to 3 values)
Best round (the lowest of the three previous values)
Ranking (1-15 and below)
Points - see the scale below.
Each tournament is played over 5 months. The worst month get dropped when the
end results are calculated.
Each player can play a maximum of 3 rounds each month. The best round counts
as that months result.
Lower score is better. A typical score for a month might be as low as 65-70-72
or as high as 100-102-115.
Points are awarded for the 15 first places each month.
1 - 30 points
2 - 25 points
3 - 20 points
4 - 18 points
5 - 16 points
6 - 14 points
7 - 12 points
8 - 10 points
9 - 8 points
10 - 6 points
11 - 5 points
12 - 4 points
13 - 3 points
14 - 2 points
15 - 1 points
In case of a tie between people/teams, they get the same points and the next
place(es) are skipped. So if two are tied for first, they both get 30 points
and nobody is on second. Next place is third.
The people working there are used to maintain the tables manually by doing the calculations and then typing in the results.
Does anyone have any idea about any component that would be ok to maintain these tables? What do you use in your own work? It could be that something obvious has passed by just because I do not know exactly what to search for. So I am turning to the community for suggestions.
I have been searching a lot on JED, but the league extensions I have found are too focused on either racing or teamsports (basketball, football). I have still not found any generic extension to maintain plain tables. If it would support sorting on one specific field, that would be fantastic.
I have a feeling that it might be possible to use something that can be used for videogame scores. But it has to be generic, not tied to one specific game.
It does not need to calculate scores etc., but a huge bonus if it does.
On the old site, there is some data that is being presented in tables. Of course, I could just continue with that. But I was hoping there was a better and more userfriendly way to maintain these tables.
The data in the tables are the results of a couple of simulator tournaments in golf. Take a look at one of them here:
http://www.golfsenteretmyrens.no/module_info/index.php?level=2&...
Each table represents one month. There is no fixed number of rows in a table (determined by number of participants). Main heading for a table is Month/Golfcourse played (on the simulator).
Column headings are:
Player/Team name
Handicap (I want to add this to avoid two lines in the name column)
Tee
Results (up to 3 values)
Best round (the lowest of the three previous values)
Ranking (1-15 and below)
Points - see the scale below.
Each tournament is played over 5 months. The worst month get dropped when the
end results are calculated.
Each player can play a maximum of 3 rounds each month. The best round counts
as that months result.
Lower score is better. A typical score for a month might be as low as 65-70-72
or as high as 100-102-115.
Points are awarded for the 15 first places each month.
1 - 30 points
2 - 25 points
3 - 20 points
4 - 18 points
5 - 16 points
6 - 14 points
7 - 12 points
8 - 10 points
9 - 8 points
10 - 6 points
11 - 5 points
12 - 4 points
13 - 3 points
14 - 2 points
15 - 1 points
In case of a tie between people/teams, they get the same points and the next
place(es) are skipped. So if two are tied for first, they both get 30 points
and nobody is on second. Next place is third.
The people working there are used to maintain the tables manually by doing the calculations and then typing in the results.
Does anyone have any idea about any component that would be ok to maintain these tables? What do you use in your own work? It could be that something obvious has passed by just because I do not know exactly what to search for. So I am turning to the community for suggestions.
I have been searching a lot on JED, but the league extensions I have found are too focused on either racing or teamsports (basketball, football). I have still not found any generic extension to maintain plain tables. If it would support sorting on one specific field, that would be fantastic.
I have a feeling that it might be possible to use something that can be used for videogame scores. But it has to be generic, not tied to one specific game.
It does not need to calculate scores etc., but a huge bonus if it does.
-
Comment by Gobezu Sewu on February 14, 2010 at 3:17pm -
you should definitely have closer look at (in named priority)
1. fabrik (this should do it with minor labor from your side, the forum is quite active and the devs are equally active in the forum so you would be better assisted over there)
2. LFRM (haven't used this one since 1.0 days)
just wondering though, how does k2 fit into this?
-
Comment by Jo Snow on February 14, 2010 at 8:14pm -
@Leo
the toolsjx extension seems to have come a long way in the past few weeks ( No puffery intended)
-
Comment by Svein Wisnaes on February 15, 2010 at 5:14am
-
@Gobezu
I have seen Fabrik befire, but never had the courage to actually dive in and do something with it as I am not a programmer... I might take a closer look now, though :-) Thank you for the tip!
As for toolsjx, again - does not seem to be any "pretty" way of doing the data input, only display of existing data.
-
Comment by Klas on February 15, 2010 at 5:39am -
LFRM can certainly provide what you are asking for, but it is not one of the easiest to manage
-
-
Just to give an update on what I have done so far:
To make this easy to update, I set up a system with articles in K2 and added a CSV field. The customer can now maintain their lists in a spreadsheet and upload a new version any time to the website.
This is a temporary solution. New and possibly more complex things will be coming, so eventually I will have to bite the bullet and make a special app for it using one of the systems mentioned here.
Comment
© 2012 Created by Amy Stephen.
You need to be a member of All Together, As A Whole to add comments!
Join All Together, As A Whole