# Read integer and transform in time

**URL:** <https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [May 13, 2022, 2:41pm UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546 "2022-05-13T14:41:09Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![andreia\_chiurato](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@andreia\_chiurato](https://forum.inductiveautomation.com/u/andreia_chiurato)\
**Post date:** [May 13, 2022, 2:41pm UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/1 "2022-05-13T14:41:09Z")

</div>

I read a value from a PLC tag that is integer (seconds), and save this data in an SQL table. I would like to show this value in a powertable but in hh:mm:ss format, and this cell must be editable ( in the powertable) in that format, but write in integer format in plc.  
Example: PLC 60 seconds / Ignition 00:01:00

Thanks so much

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [May 13, 2022, 6:04pm UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/2 "2022-05-13T18:04:13Z")

</div>

I would adjust the query to return the time in hh:mm:ss format.

In the onCellEdited, your script might look something like:

```python
if colName == 'timeColumn':
	seconds = sum(int(x) * 60 ** i for i, x in enumerate(reversed(newValue.split(':'))))
	ndx = self.data.getValueAt(rowIndex, 0) # Or however you are discerning one row from another

	query = 'UPDATE myTable SET timeColumn = ? where ndx = ?'
	system.db.runPrepUpdate(query, [seconds, ndx], myDbConnectionName)
	# Refresh the table after writing to the db.
	system.db.refresh(self.data)

```

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [May 14, 2022, 5:58am UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/3 "2022-05-14T05:58:25Z")

</div>

> [@JordanCClark](#):
>
> `seconds = sum(int(x) * 60 ** i for i, x in enumerate(reversed(newValue.split(':'))))`

That one-liner for getting seconds from "hh:mm:ss" is excellent. 👍

Do you also happen to have a one-liner for reverse operation: getting the time string ("HH:mm:ss") from seconds?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 14, 2022, 6:38am UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/4 "2022-05-14T06:38:56Z")

</div>

> [@zxcslo](#):
>
> Do you also happen to have a one-liner for reverse operation: getting the time string (“HH:mm:ss”) from seconds?

This function isn't quite what you asked for but you can certainly call it with a one-liner.

```auto
def format_seconds_to_hhmmss(seconds):
	minutes, seconds = divmod(seconds, 60)
	hours, minutes = divmod(minutes, 60)

    # For maximum readability don't return leading zeros.
	if hours:
		return "%1i:%02i:%02i" % (hours, minutes, seconds)
	elif minutes:
		return "%02i:%02i" % (minutes, seconds)
	else:
		return "%02i" % (seconds)

```

I created it for machine uptime / downtime (where the colour changes from green to red) and it can display \> 24 hours.

I call the function from a binding script transform:  
`	return (timeFunctions.format_seconds_to_hhmmss(value))`

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [May 14, 2022, 9:27am UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/5 "2022-05-14T09:27:24Z")

</div>

> [@zxcslo](#):
>
> Do you also happen to have a one-liner for reverse operation: getting the time string (“HH:mm:ss”) from seconds?

Almost.

```python
from datetime import timedelta
hms = str(datetime.timedelta(seconds=inputValue))
```

---

<div class="post-metadata">

**Author:** ![andreia\_chiurato](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@andreia\_chiurato](https://forum.inductiveautomation.com/u/andreia_chiurato)\
**Post date:** [May 17, 2022, 9:25am UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/6 "2022-05-17T09:25:27Z")

</div>

Yes! this worked when I write on cell ( like you mentioned on CellEdited), but…

I have a button, with some scripts to read the value of tag on PLC and refresh the PowerTable with this values), I put the same line (**`seconds = sum(int(x) * 60** i for i, x in enumerate(reversed(newValue.split(':'))))`** ) in the script button, but continue writing the integer number and not in format “HH:mm:ss”.

Thanks for all help.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [May 17, 2022, 9:53am UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/7 "2022-05-17T09:53:05Z")

</div>

Maybe if you show your code. My mind reading skills are not what they used to be. 😉

---

<div class="post-metadata">

**Author:** ![andreia\_chiurato](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@andreia\_chiurato](https://forum.inductiveautomation.com/u/andreia_chiurato)\
**Post date:** [May 17, 2022, 12:17pm UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/8 "2022-05-17T12:17:13Z")

</div>

I used float and not int, because some numbers can be float. Thanks!!!

```auto
***onCellEdited - work, I can write in the table's cell and in the PLC tag OPC**

if colIndex == 5: # write new value JUST INTO the table
			for row in py_TableData:
				
				
					tPath = self.data.getValueAt(rowIndex,1) # copy tagpath from column 1
					vlr = self.data.getValueAt(rowIndex,5)
					print vlr , "vlr"
					
					#convert time in integer
					import datetime
					from datetime import timedelta

					seconds = sum(int(x) * 60 ** i for i, x in enumerate(reversed(newValue.split(':'))))
					print seconds
					
					system.tag.write(tPath,seconds) # write tagpath with new value in PLC and table
					id = self.data.getValueAt(rowIndex, 0) # Or however you are discerning one row from another
						
					query = "UPDATE IgnitionDB.dbo.ParamTimer SET ValuePLC = ? WHERE TagName = ?" % (colName)
					system.db.runPrepUpdate(query, [seconds, TagName])
			# Refresh the table after writing to the db.
					system.db.refresh(self, "data")  

# ********************************button - actionPerformed - don't work - used to refresh the power table with int or float values from PLC************

import system

TableData2 = system.gui.getParentWindow(event).getComponentForPath('Root Container.PowerTable2').data

ltable = [TableData2]
for TableData in ltable :

#Convert to PyDataset (easier to loop through)
	py_TableData = system.dataset.toPyDataSet(TableData)
	
#Start the transaction
	txID = system.db.beginTransaction(timeout=5000)
	columnDB = system.db.runQuery('SELECT id FROM IgnitionDB.dbo.ParamTimer').getColumnAsList(0)
#column ID from table and ID from DB and compare returning a list
	columnDB = str(tuple(columnDB ))
	columnDB = columnDB.replace("(", '')
	columnDB = columnDB.replace(")", '')
	columnDB = columnDB.replace(",", '')
	columnDB = columnDB.replace("u'", '')
	columnDB = columnDB.replace("'", '')
#Loop through the rows in the dataset, and insert them into the database.
	
	for row in py_TableData:
		
		if str(row['id']) in columnDB:
		
			column1 = row['id']
			column2 = row['TagPath']
			column3 = row['Descr']
			column4 = row['ValueDB']
			column6 = row['ValuePLC']
			column7 = row['TagName']
			
			print column7 , "tag"
			vlr = system.tag.read(row['TagPath']).value # READ tagpath with new value in PLC 
			print vlr , "vlr"
			
			colName = "ValuePLC"
	
			query = "UPDATE IgnitionDB.dbo.ParamTimer SET %s = ? WHERE id = ?" % (colName)
			args = [vlr, column1]
			
# HERE ------Convert to HH:mm:ss ************************************************************************
			import datetime
			from datetime import timedelta
			
			newValue = str(vlr)
			print newValue
			
			seconds = sum(float(x) * 60 ** i for i, x in enumerate(reversed(newValue.split(':'))))
			print seconds , "sec"
			
			if "TIME" in column7: **# JUST FROM TAG WITH "TIME" IN THE NAME**
				vlr = vlr/60
				vlr= str(vlr) # because I have errors with int and string

				seconds = sum(float(x) * 60 ** i for i, x in enumerate(vlr.split(':')))
				print seconds , "secif"
				
				query = "UPDATE IgnitionDB.dbo.ParamTimer SET %s = ? WHERE id = ?" % (colName)
				
				args = [seconds, column1]
				print "if"
		
			
		    # Run the query with the specified arguments.
			system.db.runPrepUpdate(query, args)
			#system.db.refresh(self, "data")

```

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [May 17, 2022, 1:09pm UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/9 "2022-05-17T13:09:38Z")

</div>

> [@andreia\_chiurato](#):
>
> I used float and not int, because some numbers can be floa

If you're talking about this bit:

```python
seconds = sum(float(x) * 60 ** i for i, x in enumerate(reversed(newValue.split(':'))))

```

Then it makes no sense.  
We're talking about time here, the 3 parts separated by `:` in `03:14:53`, which are hours, minutes and seconds. Those can't be float.

what's `vlr` when you first get it ? Right here:

```python
vlr = system.tag.read(row['TagPath']).value # READ tagpath with new value in PLC 

```

what are its type and value ?

---

<div class="post-metadata">

**Author:** ![andreia\_chiurato](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@andreia\_chiurato](https://forum.inductiveautomation.com/u/andreia_chiurato)\
**Post date:** [May 17, 2022, 1:49pm UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/10 "2022-05-17T13:49:43Z")

</div>

> [@pascal.fragnoud](#):
>
> `vlr = system.tag.read(row['TagPath']).value `

Hiii  
I read just one value from PLC, this tagPath: vlr = system.tag.read(row['TagPath']).value and it is float ( but is a number that represent seconds for example 60,120,3600,7200), and I want convert to this format HH:mm:ss. I don't have a number for each HH, mm, ss.  
The problem isn't in the "read" the number, but convert it.  
Thank you.

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [May 17, 2022, 2:02pm UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/11 "2022-05-17T14:02:03Z")

</div>

Well you can’t expect this `newValue.split(':')` to work on a float.  
You need to format your timestamp to a date with `system.date.format()` or whatever formatting function you prefer. Maybe not this one actually, I think it takes an `int`, a float won’t work.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [May 17, 2022, 2:08pm UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/12 "2022-05-17T14:08:02Z")

</div>

Or, from post 5...

> [@JordanCClark](#):
>
> ```python
> from datetime import timedelta
> hms = str(datetime.timedelta(seconds=inputValue))
> 
> ```

example:

```python
from datetime import timedelta

inputValue = 1234.5
hms = str(timedelta(seconds=inputValue))

print hms

```

Output:

```plaintext
0:20:34.500000
>>> 

```

---

<div class="post-metadata">

**Author:** ![andreia\_chiurato](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@andreia\_chiurato](https://forum.inductiveautomation.com/u/andreia_chiurato)\
**Post date:** [May 18, 2022, 9:05am UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/13 "2022-05-18T09:05:04Z")

</div>

Thank you so much, worked! I’ve tried before but I was missing a line of code and it didn’t work, now I tried again and it worked 🙂

```auto

from datetime import timedelta
**inputValue = 1234.5**
hms = str(timedelta(seconds=inputValue))

```

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 18, 2022, 9:33am UTC](https://forum.inductiveautomation.com/t/read-integer-and-transform-in-time/59546/14 "2022-05-18T09:33:40Z")

</div>

Note the nice code formatting blocks in the answers. Use the `</>` code formatting button to do this. It preserves indentation and applies syntax highlighting. If you want a bit of inline code then put it between two backticks ``like this``.