×
RadLog
Edit Long Term Trend?
1 week 3 days ago #7046
by Simomax
Replied by Simomax on topic Edit Long Term Trend?
Alright, I got there and made a php page for converting the crazy time stamp (45578.87503472222222) in the xml to a human readable date and time, and also the reverse so you can generate the crazy time stamp from a given date and time. It's quite simple to use:
To generate a crazy time stamp simply choose the date and time at the top, and click the 'Date Time to Days and Percentage' button.
To decode a crazy time stamp simply copy and paste it into the box at the bottom and click the 'Days and Percentage To Date Time' button.
Usage cases; 'I want to find something in the xml file at a certain time date': Use the top section and punch in a date and time so you can see the readings around that time. It should get you in the ball park.
'I see something in my xml file and I want to know the date and time of the thing.': Use the bottom section and copy the crazy time stamp from the xml file into the box in the bottom section. It will show you the date and time in a human readable format.
Whilst this isn't a panacea for finding spikes, it should allow for getting in the ball park, getting somewhere close. It will still require some manual work browsing the xml file to find the spike, but it should get you reasonably close. I have a couple of other spikes in my long term log so I'll try finding them with this tool. But tomorrow. My brain is tired from all of those calculations.
There was one anomaly I came across. When I took a crazy time stamp from the xml, decoded it and then looked in the long term text file, the date was a couple of days out. I did this with the very last log in both the text file and the xml, so they should have been the same. Maybe not though as I'm not sure what the text file really does. It might be for shared data.
The tool is here: https://www.schmoozie.co.uk/radmon/time_tools.php
And source here for hosting yourself (.php):
To generate a crazy time stamp simply choose the date and time at the top, and click the 'Date Time to Days and Percentage' button.
To decode a crazy time stamp simply copy and paste it into the box at the bottom and click the 'Days and Percentage To Date Time' button.
Usage cases; 'I want to find something in the xml file at a certain time date': Use the top section and punch in a date and time so you can see the readings around that time. It should get you in the ball park.
'I see something in my xml file and I want to know the date and time of the thing.': Use the bottom section and copy the crazy time stamp from the xml file into the box in the bottom section. It will show you the date and time in a human readable format.
Whilst this isn't a panacea for finding spikes, it should allow for getting in the ball park, getting somewhere close. It will still require some manual work browsing the xml file to find the spike, but it should get you reasonably close. I have a couple of other spikes in my long term log so I'll try finding them with this tool. But tomorrow. My brain is tired from all of those calculations.
There was one anomaly I came across. When I took a crazy time stamp from the xml, decoded it and then looked in the long term text file, the date was a couple of days out. I did this with the very last log in both the text file and the xml, so they should have been the same. Maybe not though as I'm not sure what the text file really does. It might be for shared data.
The tool is here: https://www.schmoozie.co.uk/radmon/time_tools.php
And source here for hosting yourself (.php):
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php
$excelDate = 0;
$dayPercentage = 0;
$daysDate = '0000-00-00';
$days = 0;
$date = '';
$time = '';
$dayPerc = '';
$dated = date('Y-m-d');
$datet = date('H:i:s');
$daysPercentage = '';
extract($_REQUEST);
if(isset($submitDateTimeToDaysAndPercentage)) {
$days = dateToExcelDate($dated);
$dayPercentage = timeToDayPercentage($datet);
$tempArr = explode(".", $dayPercentage); // use temp array to strip (1st index) '0.' from percentage to show only past the decimal
$dayPercentage = $tempArr[1];
$daysPercentage = $days . '.' . $dayPercentage;
}
else if(isset($submitDaysAndPercentageToDateTime)) {
//echo $dayPerc;
$tempArr = explode(".", $dayPerc);
$date = daysToDate($tempArr[0]);
$time = percentageToTime('0.' . $tempArr[1]);
}
// Function - date to Excel date format
function dateToExcelDate($dateStamp) {
$date1 = new DateTime('1900-01-01'); // Epoch date
$date2 = new DateTime($dateStamp); // Our date
$interval = $date1->diff($date2); // Get the date difference
return $interval->days; // Return number of days of the date difference
}
// Function - date to Excel date format
function timeToDayPercentage($timeStamp) {
$timeArray = explode(":",$timeStamp); // Insert hours, minutes and seconds into an array from our time
$hours = $timeArray[0];
$minutes = $timeArray[1];
$seconds = $timeArray[2];
$hoursP = $hours/24; // Do some maths to get the percentage of the day for the hours, minutes and seconds
$minutesP = $minutes/1440;
$secondsP = $seconds/86400;
return ($hoursP + $minutesP + $secondsP); // Return the sum of the three percentages
}
// Function - date after x days after 1900:01:01
function daysToDate($days) {
$startDate = new DateTime('1900-01-01'); // Epoch date
$startDate->modify("+$days days"); // get date x days since epoch date
return $startDate->format('Y-m-d'); // Return date in readable form
}
// Function - convert percentage of a day to a time
function percentageToTime($percentage) { // This is messy to comment. It is easier to just comment with the actual math. The percentage for this is 0.682294444443
$totalHours = 24 * $percentage; // Total hours = 24 * 0.682294444443 = 16.374706666632 hours
$pHours = floor($totalHours); // this is the whole hours number (16). We loose the decimal and everything after
$totalMinutes = 60 * ($totalHours - $pHours); // Then calculate the total minutes from the decimal of total hours: Total Minutes = 60 * (total hours - whole hours)
$pMinutes = floor($totalMinutes); // this is the whole minutes number (22). We loose the decimal and everything after
$totalSeconds = 60 * ($totalMinutes - $pMinutes); // Then calculate the total seconds from the decimal of total minutes: Total Seconds = 60 * (total minutes - whole whole)
$pSeconds = floor($totalSeconds); // this is the whole seconds number (28). We loose the decimal and everything after
return $pHours . ':' . $pMinutes . ':' . $pSeconds; // Return the time formatted as ##:##:##
// Phew......
}
// echo '<br /><br />';
// $dateStamp = '2022-04-25';
// $excelDate = dateToExcelDate($dateStamp);
// echo "Date to days since 1900:01:01: " . $excelDate;
// echo '<br /><br />';
// $timeStamp = '16:22:29';
// $dayPercentage = timeToDayPercentage($timeStamp);
// echo "Time to percentage of a day: " . $dayPercentage;
// echo '<br /><br />';
// $days = 44678;
// $daysDate = daysToDate($days);
// echo "The date " . $days . " days after 1900:01:01 is " . $daysDate;
// echo '<br /><br />';
// $percentage = 0.68228009259259;
// $timeStamp = percentageToTime($percentage);
// echo "The time is: " . $timeStamp;
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Radlog.exe XML time tools</title>
<link rel="icon" type="image/x-icon" href="favicon.ico">
</head>
<body>
<form method="post" enctype="multipart/form-data">
Convert readable date time into Radlog.exe XML date code:<br /><br />
<label>Date Time</label>
<input required type="date" value="<?php echo $dated; ?>" name="dated" >
<input required type="time" step="1" value="<?php echo $datet; ?>" name="datet" > = <?php echo $daysPercentage; ?><br /><br />
<input type="submit" name="submitDateTimeToDaysAndPercentage" value="Date Time to Days and Percentage">
</form>
<br /><br /><br /><br /><br /><br />
Convert Radlog.exe XML date code to readable date time:<br /><br />
<form method="post" enctype="multipart/form-data">
<label for="dayPerc">Days and day percentage:</label>
<input type="text" id="dayPerc" value="<?php echo $dayPerc; ?>" name="dayPerc"> = <?php echo $date . ' ' . $time; ?><br /><br />
<input type="submit" name="submitDaysAndPercentageToDateTime" value="Days and Percentage To Date Time">
</form>
</body>
</html>Attachments:
Please Log in or Create an account to join the conversation.
1 week 3 days ago #7047
by GetSirius
Mineral Point radiation/lightning monitor: getsirius.com/radiation
Replied by GetSirius on topic Edit Long Term Trend?
Thanks for the code. I will probably put that on my server for use should I need it some day.
Success! I now have a useable graph. Thanks for your help!
I removed the live graph from my post, really don't need Google finding the folder. Here is a copy:
Success! I now have a useable graph. Thanks for your help!
I removed the live graph from my post, really don't need Google finding the folder. Here is a copy:
Mineral Point radiation/lightning monitor: getsirius.com/radiation
Please Log in or Create an account to join the conversation.
Moderators: Gamma-Man
Time to create page: 0.212 seconds