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!
Last change on Jan 13, 2021 7:16:21 AM by
Add comment