I have a database with a table that is just for a couple epa tags and alarm events. I was using the tag historian before the was set up and now i have to get the old data moved over. This is the last one I tried. I have the return size on 2 so that I can make sure I see it working before I do the rest.
pathofTag = ['[Ignition403DB]/oxidizers/oxidizer/chamber_avg'] starttime = system.date.parse('2023-01-06 00:00:00', 'yyyy-dd-MM HH:mm:ss') endtime = system.date.parse('2023-03-14 11:14:36', 'yyyy-dd-MM HH:mm:ss') results = system.tag.queryTagHistory(paths=pathofTag, startDate=starttime, endDate=endtime, returnSize=2, returnFormat='Wide') pyData = system.dataset.toPyDataSet(results) dataBase = "EPA_403" for row in pyData: time = row temp = row system.db.runPrepUpdate("INSERT INTO dbo.epatable (t_stamp, chamber_avg) VALUES (?, ?)",[time, temp], dataBase)