Feature #81711
Add abolity to change timestamp to date after clicking on timestamp
90%
Description
There is very often a need to get real data for timestamp. Usually user must copy timestamp to clipboard and use some third part website/tool to get real data.
However there are plugins to adminer which allows to convert timestamp to data automatically on click.
Maybe its good idea to integrate it into t3_adminer.
Here are the plugins list with info how to install plugin:
https://www.adminer.org/en/plugins/
And the plugin on the list that convert timestamp is: "readable-dates"
https://gist.github.com/anonymous/7e9b5e9f4ddcf8a91f2bb4281a51604e
Files
Updated by Jigal van Hemert over 3 years ago
- Tracker changed from Bug to Feature
- Status changed from New to Accepted
Nice suggestion!
Updated by Jigal van Hemert over 3 years ago
- Status changed from Accepted to Needs Feedback
Just tested this, but it destroys the possibility for inline editing with CTRL + click for these fields. The script only works on fields with exactly 10 digits as contents. This could be valid for other fields but it won't work for dates before September 9, 2001 (which used only 9 digits).
The first issue can be solved with a little coding, but for the second issue I don't a concept for a solution.
Do you have any suggestions?
Updated by Krystian Szymukowicz over 3 years ago
- File timestamp.png timestamp.png added
You right.
What do you think of adding a text as link "(as timestamp)" under name of each column?
The if user will click the link all numbers in that columns will be converted from timestamps to dates.
Look at the attachment.
Updated by Krystian Szymukowicz over 3 years ago
Or better to name the link "(convert to date)" or something similar.
Updated by Jigal van Hemert about 3 years ago
- Status changed from Needs Feedback to In Progress
- % Done changed from 0 to 90
Found a solution to have tstamp, crdate and other date/datetime fields that have type=input and eval=date/datetime in TCA will be displayed as a human readable date/time.
After a click the timestamp is displayed. CTRL+click still works.
Next release (for v9 and v8) will have this feature.
Updated by Krystian Szymukowicz about 3 years ago
Jigal van Hemert wrote:
Found a solution to have tstamp, crdate and other date/datetime fields that have type=input and eval=date/datetime in TCA will be displayed as a human readable date/time.
After a click the timestamp is displayed. CTRL+click still works.Next release (for v9 and v8) will have this feature.
Woooohu! Great news :) :) :)