[SOLVED] Converting minutes into hour

andy31 · February 12, 2019, 10:43pm

Evening,

I currently display total runtime of a device in minutes in the following item on sitemap.

Number MyDevice3_Time_Day     "Total Runtime Today [%d]"

If would be nice if I could convert minutes into hours. What`s the best way to achieve it ? Can anyone suggest solution please.

rossko57 · February 12, 2019, 11:44pm

Assuming you don’t want to modify the actual Number state, you could use a JS transform in the Item label [ ] formatting part.

vzorglub · February 13, 2019, 8:01am

I use a javascript transform to that effect:

/*
Javascript transform function to change the number
of minutes of CPU time from the System Info Binding
into a more readable format
eg: 2365 into '1 day 15 hours 25 minutes

The item in the items file is defined as follow:
Number LocalComputer_Cpu_SystemUptime "[JS(CPUTime.js):%s]"
and linked via PaperUI to the System uptime channel
of the System Info Thing
*/

(function(i) {
    if (i == 'NULL') { return i; }
    if (i == '-') { return 'Undefined'; }
    var val = parseInt(i); // The value sent by OH is a string so we parse into an integer
    var days = 0; // Initialise variables
    var hours = 0;
    var minutes = 0;
    if (val >= 1440) { // 1440 minutes in a days
        days = Math.floor(val / 1440); // Number of days
        val = val - (days * 1440); // Remove days from val
    }
    if (val >= 60) { // 60 minutes in an hour
       hours = Math.floor(val /60); // Number of hours
        val = val - (hours * 60); // Remove hours from val
    }
    minutes = Math.floor(val); // Number of minutes

    var stringDays = ''; // Initialse string variables
    var stringHours = '';
    var stringMinutes = '';
    if (days === 1) {
        stringDays = '1 day '; // Only 1 day so no 's'
    } else if (days > 1) {
        stringDays = days + ' days '; // More than 1 day so 's'
    } // If days = 0 then stringDays remains ''

    if (hours === 1) {
        stringHours = '1 hour '; // Only 1 hour so no 's'
    } else if (hours > 1) {
        stringHours = hours + ' hours '; // More than 1 hour so 's'
    } // If hours = 0 then stringHours remains ''

    if (minutes === 1) {
        stringMinutes = '1 minute'; // Only 1 minute so no 's'
    } else if (minutes > 1) {
        stringMinutes = minutes + ' minutes'; // More than 1 minute so 's'
    } // If minutes = 0 then stringMinutes remains ''

    var returnString =  stringDays + stringHours + stringMinutes
    return returnString.trim(); // Removes the extraneous space at the end

})(input)

andy31 · February 13, 2019, 10:41pm

Thank you. Personally I`m not very familiar with transform at the moment, assuming will need to create new transform file or perhaps add to the exist one ?
This is what I can see in transform folder right now. Should I copy this script from above and paste it inside en file ? How would I integrate it with my item then ?

rossko57 · February 13, 2019, 11:33pm

No, for each transform you will make a new file. ilename of your choice, the .xxx extension tells thesystem what kind of transform, since there are several.
You might choose minstohours.js for example.

A transform can be shared by many Items that you want to process in the same way.

andy31 · February 14, 2019, 11:10pm

Thanks for explanation this is really helpful.

So I did created the separate file called minstohours.js

minstohours

I renamed my item definition to

Number MyDevice3_Time_Day     "Total Runtime Today [JS(minstohours.js):%d]"   <line-increase>   (Restore)

Is the restart of OH required at this point ? Still seeing time in minutes at the moment so probably made mistake somewhere along

EDIT: I tried restart minute ago but that didnt made any difference. Looking at the log file can see the following info, its complaining about this .js file for some reason.

Caused by: java.io.FileNotFoundException: /etc/openhab2/transform/minstohours.js (No such file or directory)
	at java.io.FileInputStream.open0(Native Method) ~[?:?]
	at java.io.FileInputStream.open(FileInputStream.java:195) ~[?:?]
	at java.io.FileInputStream.<init>(FileInputStream.java:138) ~[?:?]
	at java.io.FileInputStream.<init>(FileInputStream.java:93) ~[?:?]
	at org.eclipse.smarthome.transform.javascript.internal.JavaScriptTransformationService.transform(JavaScriptTransformationService.java:70) ~[?:?]

rossko57 · February 15, 2019, 12:11am

That doesn’t seem to be looking in the same place as your screenshot. I don’t know openhabian to say what is up.

Laufeyjarson · February 15, 2019, 12:38am

The “type” column is showing “MAP file”, instead of “JS file” or “Javascript file”. Could you have a hidden extension giving it the wrong file name?

andy31 · February 15, 2019, 11:02am

Good spot - indeed there is incorrect file extension. I will amend configs it as soon I get back home later this evening.

andy31 · February 15, 2019, 7:01pm

This javascript from @vzorglub works well, problem solved many thanks.

andy31 · July 2, 2019, 10:41pm

Evening All,

I have recently upgraded to OH 2.4. Looking in the log file I can see many warnings related to my javascript transform function converting minutes into hours/days.

2019-07-02 23:31:46.068 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '85.0' on item 'MyDevice4_Time_Day' with pattern 'JS(minstohours.js):%d': Cannot format state '85.0' to format '%d'
2019-07-02 23:31:46.079 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '240.0' on item 'MyDevice1_Time_Day' with pattern 'JS(minstohours.js):%d': Cannot format state '240.0' to format '%d'
2019-07-02 23:31:46.090 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '0' on item 'MyDevice5_Time_Active' with pattern 'JS(minstohours.js):%d': Cannot format state '0' to format '%d'
2019-07-02 23:31:46.093 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '85.0' on item 'MyDevice2_Time_Day' with pattern 'JS(minstohours.js):%d': Cannot format state '85.0' to format '%d'
2019-07-02 23:31:46.096 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '11.0' on item 'MyDevice5_Time_Day' with pattern 'JS(minstohours.js):%d': Cannot format state '11.0' to format '%d'
2019-07-02 23:31:46.106 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '240.0' on item 'MyDevice1_Time_Day' with pattern 'JS(minstohours.js):%d': Cannot format state '240.0' to format '%d'
2019-07-02 23:31:46.153 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '0' on item 'MyDevice5_Time_Active' with pattern 'JS(minstohours.js):%d': Cannot format state '0' to format '%d'
2019-07-02 23:31:46.170 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '11.0' on item 'MyDevice5_Time_Day' with pattern 'JS(minstohours.js):%d': Cannot format state '11.0' to format '%d'
2019-07-02 23:31:46.200 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '240.0' on item 'MyDevice1_Time_Day' with pattern 'JS(minstohours.js):%d': Cannot format state '240.0' to format '%d'
2019-07-02 23:31:46.209 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '0' on item 'MyDevice5_Time_Active' with pattern 'JS(minstohours.js):%d': Cannot format state '0' to format '%d'
2019-07-02 23:31:46.213 [WARN ] [rest.core.item.EnrichedItemDTOMapper] - Failed transforming the state '11.0' on item 'MyDevice5_Time_Day' with pattern 'JS(minstohours.js):%d': Cannot format state '11.0' to format '%d'

I can see that things has changed in new OH version, so was expecting some teething problems at the start. Would you be able to tell me if I need to changing anything on my script to get it working as I can`t figured that out yet.

rossko57 · July 3, 2019, 1:33am

The output of a JS transform is always a string. I don’t know why it used to work with format %d and now does not, but try %s instead.

andy31 · July 3, 2019, 5:54pm

@rossko57 changed output to string and working again. No sure either why it used to work with format %d

rossko57 · July 3, 2019, 10:02pm

I’ve only just realised that your JS returns something like "2 hours 10 minutes", which certainly is a string and won’t format nicely using %d for decimal number.

I was worrying it was some regression bug, but in fact it’s an enhancement to report instead of failing silently. Luckily it just passes the whole string along despite failure, I guess.

Felix_Schneider · March 28, 2020, 1:07pm

For everyone who just copied the code and is now wondering why it doesnt work: Check if JS Transformation is installed.^^

Then the code works flawlessly (Thanks @vzorglub!)

isoparme · June 5, 2020, 12:04pm

Hi , this minstohours.js work perfect thanks ! , but i want to know if whe can cast the result in a rule ?

for exemple my Item is :

Number StartTimeRuntimeMinutesHuman “Alarm cuisiniere StartTime Minutes Human[JS(minstohours.js):%s]” and work perfect in the sitemap.

There is a way to call the result of : minstohours.js directly in the rule ?

Actually this is what i find to say the minute past…
say(“Cuisiniere Allumee depuis”+ ((StartTimeRuntimeMinutesHuman.state as DecimalType).intValue ))
this work for Minutes but not for Hours …or i cast 61 minutes…not 1hour and 1 minutes like in the sitemap

thanks for your help

rossko57 · June 5, 2020, 1:13pm

Yes, you can use transformation services in rules too.
It’s in the docs -

with examples

var fahrenheit = transform("JS", "convert-C-to-F.js", temperature)

isoparme · June 6, 2020, 7:23pm

thanks rossko57 and thanks for the link ! :-

ciscomike · March 6, 2021, 3:50pm

vzorglub:

(function(i) {
    if (i == 'NULL') { return i; }
    if (i == '-') { return 'Undefined'; }
    var val = parseInt(i); // The value sent by OH is a string so we parse into an integer
    var days = 0; // Initialise variables
    var hours = 0;
    var minutes = 0;
    if (val >= 1440) { // 1440 minutes in a days
        days = Math.floor(val / 1440); // Number of days
        val = val - (days * 1440); // Remove days from val
    }
    if (val >= 60) { // 60 minutes in an hour
       hours = Math.floor(val /60); // Number of hours
        val = val - (hours * 60); // Remove hours from val
    }
    minutes = Math.floor(val); // Number of minutes

    var stringDays = ''; // Initialse string variables
    var stringHours = '';
    var stringMinutes = '';
    if (days === 1) {
        stringDays = '1 day '; // Only 1 day so no 's'
    } else if (days > 1) {
        stringDays = days + ' days '; // More than 1 day so 's'
    } // If days = 0 then stringDays remains ''

    if (hours === 1) {
        stringHours = '1 hour '; // Only 1 hour so no 's'
    } else if (hours > 1) {
        stringHours = hours + ' hours '; // More than 1 hour so 's'
    } // If hours = 0 then stringHours remains ''

    if (minutes === 1) {
        stringMinutes = '1 minute'; // Only 1 minute so no 's'
    } else if (minutes > 1) {
        stringMinutes = minutes + ' minutes'; // More than 1 minute so 's'
    } // If minutes = 0 then stringMinutes remains ''

    var returnString =  stringDays + stringHours + stringMinutes
    return returnString.trim(); // Removes the extraneous space at the end

})(input)

Thanks!
That helps a lot.

Eddie_0 · March 7, 2021, 8:49pm

Hello all,
I 've the same problem, using Openhab3
In took the javascript code and put it into the transform directory.
If I used the wrong datatype, I get an error in the log file. So, it’s working.
But: Nothing happens in the item view, there I have still the same display than before ( minutes )
And the widget also shows no difference.
I do not know, how to access the return key of the javascript.
I searched in the documentation, but I didn’t find a solution…