I have a list of sensor readings covering a 24-hour period that I would like to get into PRTG for tracking and reporting purposes. This file contains several channels collected at specified time intervals during the period.

Sample of source file:

<!DOCTYPE html>

<html>
<body>

<table>
<thead>

<tr>
<td>Timestamp</td>
<td>Current_A</td>
<td>Current_Avg</td>
<td>Current_B</td>
<td>Current_C</td>
<td>KVA_Total</td>
<td>KVAR_Total</td>
<td>KW_A</td>
<td>KW_B</td>
<td>KW_C</td>
<td>KW_Total</td>
<td>KWH_Total</td>
<td>PF_A</td>
<td>PF_B</td>
<td>PF_C</td>
<td>PF_Total</td>
<td>Volts_AB</td>
<td>Volts_AC</td>
<td>Volts_BN</td>
<td>Volts_BC</td>
<td>Volts_BN</td>
<td>Volts_CN</td>
<td>Volts_LL_Avg</td>
<td>Volts_LN_Avg</td>
</tr>

</thead>

<tbody>
<tr>

<td>2020-12-02 16:17:57 -8H</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>211.59</td>
<td>212.28</td>
<td>121.41</td>
<td>212.09</td>
<td>121.55</td>
<td>122.81</td>
<td>211.97</td>
<td>121.91</td>

</tr><tr>

<td>2020-12-02 16:12:57 -8H</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>211.63</td>
<td>212.25</td>
<td>121.39</td>
<td>212.34</td>
<td>121.67</td>
<td>122.88</td>
<td>212.06</td>
<td>121.97</td>

</tr><tr>

<td>2020-12-02 16:07:57 -8H</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>0.00</td>
<td>211.31</td>
<td>212.31</td>
<td>121.25</td>
<td>212.41</td>
<td>121.69</td>
<td>122.84</td>
<td>212.00</td>
<td>121.92</td>

</tr><tr>

<td>2020-12-02 16:02:57 -8H</td>
<td>10.00</td>
<td>20.00</td>
<td>30.00</td>
<td>40.00</td>
<td>50.00</td>
<td>60.00</td>
<td>70.00</td>
<td>80.00</td>
<td>90.00</td>
<td>1000.00</td>
<td>1100.00</td>
<td>1200.00</td>
<td>1300.00</td>
<td>1400.00</td>
<td>1500.00</td>
<td>211.78</td>
<td>212.38</td>
<td>121.47</td>
<td>212.31</td>
<td>121.72</td>
<td>122.86</td>
<td>212.16</td>
<td>122.00</td>

</tr>
</tbody>
</table>

</body>
</html>

I have no problems converting and importing this file into PRTG in the proper format, but it will only accept the readings from the final entry in the list. In my actual file, this file can contain over 6000 lines of data (22 channels @ 5 minute intervals over 24 hrs = a lot of records :)

Is there a way that I can insert all of the records into one sensor, including the stored timestamp, without having to run the powershell script 6000 times?

I do not have the access to the actual servers providing this data other than the data file shown.

Thanks!

Article Comments

Hello,

Thank you for your message.

Regarding your question "Is there a way that I can insert all of the records into one sensor", I'm afraid that it's not possible to do so. You can only get values at a certain time (at each scanning interval) but not import all the readings in PRTG.

According to the results, they are provided periodically and therefore the only way would be to configure the sensor in PRTG with the same interval to get the latest values. However, the previous data is of course not taken into account.

Regards.


Jan, 2021 - Permalink