Variable Field Names in VRM Advanced Page/Tab CSV Log Downloads

DIY
, , ,
1

My Solar Solution:
1 x Victron Energy Quattro 48/8000 (Grid Tied)
1 x Cerbo GX
1 x Victron Energy RS450/100 Solar Charge Controller or MPPT
1 x 48V Freedom Won Lithium Ion battery

I want to get a better understanding of how well my solution is working and need data, not charts.

I want to import the data to Microsoft Access, but it appears that when the duration is 1 day (yesterday) the are duplicate field names in the first row of the Log CSV file. I think there were 138 fields.

This morning I want to dowload data for May, and again have problems that the fields in the CSV file do not match the fields in the Access table. I saw the number of fields increase to 158.

Is my observation correct? If so, how will the fields change if the duration is changed to the last 6 or 12 months.

My preference is to do it monthly unless there are fields in the longer durations which might be of value. Without knowing how the fields change, I would not know.

Is the a list of fields per duration?

2

Below are the filed names for “Last Month”. I see that for this time period / duration, there are no duplicate field names.

|Field No.|Fieldname|
|1|timestamp|
|2|VRM Log time offset|
|3|ESS Scheduled Charging|
|4|DESS Available|
|5|DESS Mode – Controlled by user|
|6|DESS State – System following a schedule or not|
|7|DESS Grid/battery energy exporting restrictions|
|8|DESS error code|
|9|DESS system efficiency|
|10|DESS battery capacity|
|11|DESS full charge interval|
|12|DESS full charge duration|
|13|Grid setpoint|
|14|Relay 1 state|
|15|CCGX Relay 2 state|
|16|Generator run reason|
|17|Relay 1 function|
|18|Relay 2 function|
|19|Solar Irradiance|
|20|Solar Irradiance Forecast|
|21|Total solar forecasted yield for today|
|22|Total solar forecasted yield for today - BETA|
|23|PV Yield model day-ahead MAPE|
|24|PV Yield model day-ahead MAPE - BETA|
|25|Consumption model day-ahead MAPE - LIVE|
|26|Total (day-ahead) forecasted consumption - LIVE|
|27|Miscellaneous Consumption Forecast|
|28|Phase rotation|
|29|Input voltage phase 1|
|30|VE.Bus custom name|
|31|Input current phase 1|
|32|Input frequency 1|
|33|Input power 1|
|34|Output voltage phase 1|
|35|Output current phase 1|
|36|Output frequency|
|37|Output power 1|
|38|Voltage|
|39|Current|
|40|Active input|
|41|Active input current limit|
|42|AC Input 1 Current Limit|
|43|AC Input 2 Current Limit|
|44|AC Input 1 Current Limit Adjustable|
|45|AC Input 1 Current Limit Adjustable2|
|46|VE.Bus state of charge|
|47|VE.Bus state|
|48|VE.Bus Error|
|49|Switch Position|
|50|Temperature|
|51|Low battery|
|52|Overload|
|53|Temperatur sensor alarm|
|54|Voltage sensor alarm|
|55|VE.Bus BMS Pre-alarm|
|56|High DC Ripple|
|57|Temperature L1|
|58|Low battery L1|
|59|Overload L1|
|60|High DC Ripple L1|
|61|Temperature L2|
|62|Low battery L2|
|63|Overload L2|
|64|High DC Ripple L2|
|65|Temperature L3|
|66|Low battery L3|
|67|Overload L3|
|68|High DC Ripple L3|
|69|Charge state|
|70|BMS lost|
|71|Unequal output distribution in parallel system: L1|
|72|Unequal output distribution in parallel system: L2|
|73|Unequal output distribution in parallel system: L3|
|74|Unequal mains distribution in parallel system: L1|
|75|Unequal mains distribution in parallel system: L2|
|76|Unequal mains distribution in parallel system: L3|
|77|Ignore AC input|
|78|Ignore AC input 2|
|79|Serial number of 1st device|
|80|Minimum cell temperature|
|81|Maximum cell temperature|
|82|Voltage3|
|83|Current4|
|84|Battery temperature|
|85|State of charge|
|86|State of health|
|87|CVL - Charge Voltage Limit|
|88|DVL - Discharge Voltage Limit|
|89|CCL - Charge Current Limit|
|90|DCL - Discharge Current Limit|
|91|Minimum cell voltage|
|92|Maximum cell voltage|
|93|Voltage5|
|94|Current6|
|95|Battery watts|
|96|Charger on/off|
|97|Charge state7|
|98|PV Voltage on tracker 1|
|99|PV Voltage on tracker 2|
|100|PV power|
|101|PV power on tracker 1|
|102|Solar charge current limit|
|103|MPPT State|
|104|PV power on tracker 2|
|105|MPPT State Tracker 0|
|106|MPPT State Tracker 1|
|107|Relay on the charger|
|108|Yield today|
|109|Yield today on tracker 1|
|110|Yield today on tracker 2|
|111|Maximum charge power today|
|112|Maximum charge power today on tracker 1|
|113|Maximum charge power today on tracker 2|
|114|Yield yesterday|
|115|Yield yesterday on tracker 1|
|116|Yield yesterday on tracker 2|
|117|Maximum charge power yesterday|
|118|Maximum charge power yesterday on tracker 1|
|119|Maximum charge power yesterday on tracker 2|
|120|Error code|
|121|User yield|
|122|PV Yield Solar Charger Forecast|
|123|PV Yield Solar Charger Forecast - BETA|
|124|MPPT RS tracker 0 forcasted yield|
|125|MPPT RS tracker 0 forecasted yield - BETA|
|126|MPPT RS tracker 1 forcasted yield|
|127|MPPT RS tracker 1 forecasted yield - BETA|
|128|#1 Low SOC; discharge disabled|
|129|#2 BatteryLife is active|
|130|#3 Charge disabled by BMS|
|131|#4 Discharge disabled by BMS|
|132|#5 Slow charge is active|
|133|#6 Charge disabled by user setting|
|134|#7 Discharge disabled by user setting|
|135|PV - DC-coupled|
|136|AC Consumption L1|
|137|Grid L1|
|138|Genset L1|
|139|DC System|
|140|Voltage8|
|141|Current9|
|142|VE.Bus charge current|
|143|Battery Power|
|144|VE.Bus charge power|
|145|Battery SOC|
|146|Battery state|
|147|DVCC Multiple batteries alarm|
|148|GX Error #48 DVCC with incompatible firmware|
|149|AC-Input|
|150|Consumption Forecast|
|151|Grid alarm|
|152|Generator not detected at AC-input|
|153|Service due|
|154|Service interval|
|155|GX Auto start/stop disabled|
|156|Remote start is disabled on the genset|
|157|Generator autostart enabled|
|158|Generator state|