Sorry to disappoint you but unfortunately format like you wrote below will not be included in our new update.
About customization:
1. We are currently releasing the beta version and unfortunately we do not have free developers to implement this feature for you so may I suggest to contact us after the beta is released.
2. When we implement some custom solutions we first test it on our side to be sure that everything is working fine, if you need to make a backup of the custom files we will let you know so the plugin should be stable and working without any problems
3. I can not tell you precisely the price of this customization because I will need more details about requirements of the customization. Just a note that our price is 50$/hour.
The site I am building is for an amateur sports community who regularly take part in run , swim , cycle & multisport (triathlon, duathlon, aquathlon) events.
Ultimately they want to see their annual progress, also chart all the events their taking part in.
In the table we need a time column that is not the clock, but rather total time taken to finish a race. We can achieve this with the string 00:00:00:00 but as a string we cannot use the data to sum up the time, most importantly we can't use the data for the graph or chart to see progress against the distances or progress with dates. Without set rules / format on the column everyone is going to add their timings differently.
We need to be able to show time, like any specialised sports website.
Wp Datables is missing one essential column, which is the sports time column . This column is required by millions of users, it will be great to have.
Users take part in various events, in order for them to have all the results in one table for their sport, they need to enter it manually and have it in one place, like my website .
Do let me know the cost , if it is in the plans for the future, then I can wait.
I spoke with my team and unfortunately for the upcoming 2.0 version this feature will not be included. Also about the customization, because we are already late on releasing the beta version we do not have free developers to implement this feature for you for now. I added your suggestion to our TODO list so we can consider to implement this feature but if you are in a hurry we can recommend this service for customizations: https://wpkraken.io/?tms-plugins (by this link they would know you come from us) - they do develop such custom solutions, could you please send your inquiry to them?
Sorry for any inconvenience and thank you for understanding.
That is sad, but I am patient, do you think in later versions it might be included ?
My primary concern to get a 3rd party to develop the sports time column as an add on is, when TMS one day develops the same function into its core, there will be a clash and I will have problems with my data being imported to the core plugin.
Do you think once after version 2 is developed, your team will have the time to work on the customisation.
I have an answer from Kraken, they can do it, the price is ok, but I rather wait till you guys are free to do it and pay you guys, my main worry is maintenance of the plugin, with each update.
Also can you check if there is any plans to have the y axis of a graph to be inverted, so 1 is at the top of the graph and as the numbers increase it goes to the bottom of the graph. This way when an athlete has a good position in a race, the graph point is high up .
Hi Titus, Sorry for delayed reply the 2.0 version is keeping us very busy.
"I have an answer from Kraken, they can do it, the price is ok, but I rather wait till you guys are free to do it and pay you guys, my main worry is maintenance of the plugin, with each update."
- I understand you that you want us to implement this functionality for you but sorry again and unfortunately at this moment we don't have time for customizations because of the 2.0 Beta version and writing the documentation for it is taking too much time. Our user experience from Kraken customization service are quite positive so I think there is no need to worry about plugin maintenance.
Also I can give you a guide how you can achieve your request.
Only workaround for Time with seconds is to have MySQL table with data. Times will be displayed with seconds and sorting will work but editing from WP backed is not possible. You will have to edit this time values directly in database.
Steps you need to follow to achieve this:
Have to go in database, find table wp_options. In this table find wdtTimeFormat in option_name column and set h:i:s as option_value for this column.
After that you have to create new MySQL table where you will place data. This table will be called "time_table" in this example, and one of the column (or more then one it depends how much time columns do you need) will be TIME type:
Then when you created a table in database, you'll have to create wpDataTable based on time_table from database, and you can create it if you choose Add From Data Source and select MySQL table. Your query should be:
SELECT * FROM time_table
Like that you'll show time with seconds and will be able to sort it, but only way to edit data is directly from the database. Column type for this column should be Time in optional column setup.
"Also can you check if there is any plans to have the y axis of a graph to be inverted, so 1 is at the top of the graph and as the numbers increase it goes to the bottom of the graph. This way when an athlete has a good position in a race, the graph point is high up."
-There is an option to revert Axes in wpDataCharts, but I am not sure that is that you need. Something like that will probably possible with little custom coding (1-2 hours). You can also take a look at wpDataCharts callback - Link to see how to add chart options that are not included in the plugin out of the box.
I work with Titus and have been working on the time field as you advised below. We are nearly there :), but have hit a snag. When the hour field is listed as '00' it displays as '12'. Anything I can do to change that?
Glad to hear that you managed to customize the plugin by yourself, good job. From my experience i know that it should not cause any issues on other tables or something that I am not familiar with in case there is some.
i want a new date format in DateTime value: YYYY-MM-DD (2017-07-21 16:55), and i have duration Time value for example 91 and i want see as 01:31 (minute:second). In Php: gmdate("i:s", $row["duration"]) How can i implement to wpdatatable? How can i from to DateTime strings language change?
Hi Bogdan,
Can you please tell me if there are any plans to create a time column
00:00:00:00 to record sports achievements. If there is, what is the time scale, if it is not in the plan
1) Can I get a customization done?
2) Once customization is done, will the plugin still be stable
3) What is the full cost, what is the maintenance cost?
Titus
Hi Titus,
Thank you for your purchase.
Sorry to disappoint you but unfortunately format like you wrote below will not be included in our new update.
About customization:
1. We are currently releasing the beta version and unfortunately we do not have free developers to implement this feature for you so may I suggest to contact us after the beta is released.
2. When we implement some custom solutions we first test it on our side to be sure that everything is working fine, if you need to make a backup of the custom files we will let you know so the plugin should be stable and working without any problems
3. I can not tell you precisely the price of this customization because I will need more details about requirements of the customization.
Just a note that our price is 50$/hour.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan,
Thanks for coming back to me.
The site I am building is for an amateur sports community who regularly take part in run , swim , cycle & multisport (triathlon, duathlon, aquathlon) events.
Ultimately they want to see their annual progress, also chart all the events their taking part in.
In the table we need a time column that is not the clock, but rather total time taken to finish a race. We can achieve this with the string 00:00:00:00 but as a string we cannot use the data to sum up the time, most importantly we can't use the data for the graph or chart to see progress against the distances or progress with dates. Without set rules / format on the column everyone is going to add their timings differently.
We need to be able to show time, like any specialised sports website.
http://runnersunite.racetecresults.com/StartPage.aspx?CId=16634
Wp Datables is missing one essential column, which is the sports time column . This column is required by millions of users, it will be great to have.
Users take part in various events, in order for them to have all the results in one table for their sport, they need to enter it manually and have it in one place, like my website .
Do let me know the cost , if it is in the plans for the future, then I can wait.
Titus
Hi Titus,
I spoke with my team and unfortunately for the upcoming 2.0 version this feature will not be included.
Also about the customization, because we are already late on releasing the beta version we do not have free developers to implement this feature for you for now.
I added your suggestion to our TODO list so we can consider to implement this feature but if you are in a hurry we can recommend this service for customizations: https://wpkraken.io/?tms-plugins (by this link they would know you come from us) - they do develop such custom solutions, could you please send your inquiry to them?
Sorry for any inconvenience and thank you for understanding.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan,
That is sad, but I am patient, do you think in later versions it might be included ?
My primary concern to get a 3rd party to develop the sports time column as an add on is, when TMS one day develops the same function into its core, there will be a clash and I will have problems with my data being imported to the core plugin.
Do you think once after version 2 is developed, your team will have the time to work on the customisation.
Titus
I have written to Kraken, will update soon.
Titus
Hi Titus,
I will make sure after the update to ask my team if someone is available to do this custom work for you if you can not make a contact with Kraken.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
of course if your guys can do it,it will be much better. :)
Hi Titus,
Of course I understand you
I will keep you updated, we hope that the beta will be released in next 15 hours.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan,
I have an answer from Kraken, they can do it, the price is ok, but I rather wait till you guys are free to do it and pay you guys, my main worry is maintenance of the plugin, with each update.
Also can you check if there is any plans to have the y axis of a graph to be inverted, so 1 is at the top of the graph and as the numbers increase it goes to the bottom of the graph. This way when an athlete has a good position in a race, the graph point is high up .
Thanks
Titus
Hi Titus,
Sorry for delayed reply the 2.0 version is keeping us very busy.
"I have an answer from Kraken, they can do it, the price is ok, but I rather wait till you guys are free to do it and pay you guys, my main worry is maintenance of the plugin, with each update."
- I understand you that you want us to implement this functionality for you but sorry again and unfortunately at this moment we don't have time for customizations because of the 2.0 Beta version and writing the documentation for it is taking too much time.
Our user experience from Kraken customization service are quite positive so I think there is no need to worry about plugin maintenance.
Also I can give you a guide how you can achieve your request.
Only workaround for Time with seconds is to have MySQL table with data. Times will be displayed with seconds and sorting will work but editing from WP backed is not possible. You will have to edit this time values directly in database.
Steps you need to follow to achieve this:
Have to go in database, find table wp_options. In this table find wdtTimeFormat in option_name column and set h:i:s as option_value for this column.
After that you have to create new MySQL table where you will place data. This table will be called "time_table" in this example, and one of the column (or more then one it depends how much time columns do you need) will be TIME type:
Then when you created a table in database, you'll have to create wpDataTable based on time_table from database, and you can create it if you choose Add From Data Source and select MySQL table. Your query should be:
Like that you'll show time with seconds and will be able to sort it, but only way to edit data is directly from the database. Column type for this column should be Time in optional column setup.
"Also can you check if there is any plans to have the y axis of a graph to be inverted, so 1 is at the top of the graph and as the numbers increase it goes to the bottom of the graph. This way when an athlete has a good position in a race, the graph point is high up."
-There is an option to revert Axes in wpDataCharts, but I am not sure that is that you need. Something like that will probably possible with little custom coding (1-2 hours). You can also take a look at wpDataCharts callback - Link to see how to add chart options that are not included in the plugin out of the box.
Hope this can help you out.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan,
I work with Titus and have been working on the time field as you advised below. We are nearly there :), but have hit a snag. When the hour field is listed as '00' it displays as '12'. Anything I can do to change that?
Thanks
Navin
Hi Again Bogdan,
Fixed the issue below by using H instead of h. Please inform me if this could cause any other issues anywhere else in the tables?
Thanks
Navin
Hi Navin,
Glad to hear that you managed to customize the plugin by yourself, good job.
From my experience i know that it should not cause any issues on other tables or something that I am not familiar with in case there is some.
Well done again.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi,
i want a new date format in DateTime value: YYYY-MM-DD (2017-07-21 16:55), and i have duration Time value for example 91 and i want see as 01:31 (minute:second). In Php: gmdate("i:s", $row["duration"]) How can i implement to wpdatatable? How can i from to DateTime strings language change?
Thx! :)