Wattmon Documentation Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
======get_csv_data======

<badge>FW >= 1317</badge>

Extract partial CSV data from an existing CSV file

====Description====

<well size="sm"><html>
<span style="font-size:125%;color:green">string
<span style="color:black">get_csv_data (
<span style="color:green">string
<span style="color:blue">$filename<span style="color:black">,
<span style="color:green">string
<span style="color:blue">$columns
<span style="color:black">,
<span style="color:green">int
<span style="color:blue">$interval<span style="color:black">]
<span style="color:black">[,
<span style="color:green">int
<span style="color:blue">$json<span style="color:black">]
)
</html></well>

This function takes a filename (including the full path) in the $filename parameter and a list of columns to extract in the $columns field.  The $interval period in minutes is used to extract data at predefined intervals from the start of the file.

====Parameters====

<html><b><span style="color:blue">$filename<span style="color:black"></b></html>:  Valid filename of a CSV file (with the first row containing the column names)</html>

<html><b><span style="color:blue">$columns<span style="color:black"></b>:  Comma separated list of column headers (case sensitive) to extract from the CSV file</html>

<html><b><span style="color:blue">$interval<span style="color:black"></b>:  Interval in minutes between result rows</html>

<html><b><span style="color:blue">$json<span style="color:black"></b>:  Return data as CSV by passing 0, or as JSON by passing 1
</html>

====Return Values====

<html><b><span style="color:green">string<span style="color:black"></b></html> resultant rows in the format specified (CSV or JSON)

====Examples====

<code php>
<?
  $data = get_csv_data("/logs/2024/07/20240708_0.csv","inverter1_AC_Active_Power,meter2_AC_Active_Power_A",30,1);
  print($data);
?>
</code>

The above example will display:

<code>
[[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
,[0,0]
]

</code>

The above example shows zero due to the CSV file having blank entries.
Wattmon Documentation Wiki

User Tools

Site Tools

Page Tools
