Hi Michael,
Hoping you might be able to give me a nudge in the right direction in terms of getting the XAP system set up properly. I have installed ZMXAP on my Zoneminder system, and also the homeseer plugin in homeseer itself. This works fine and when motion is triggered through Zonealarm it updates the appropriate devices in Homeseer.
The issue i have is getting the database and charting part of the system working, as I would really like to be able to use your various charting tools to get produce some nice graphs.
I have extracted McsDatabase, and McsCharts to their respective folders in my download directory, and they are all up and running however i fall over when i try to do much with either of these. I added a few different temperature sensors and weather data to the database setup (Temperature is from RFXCOM 433 Rx through homeseer, and weather is from Cumulus). as High Rate and accept however i get errors in the database as below:
In terms of the charting, i then get an error saying no lines to graph / no data selected.
MCS Database Error:
MCS Database ini:
Mcs Chart ini:
Hoping you might be able to give me a nudge in the right direction in terms of getting the XAP system set up properly. I have installed ZMXAP on my Zoneminder system, and also the homeseer plugin in homeseer itself. This works fine and when motion is triggered through Zonealarm it updates the appropriate devices in Homeseer.
The issue i have is getting the database and charting part of the system working, as I would really like to be able to use your various charting tools to get produce some nice graphs.
I have extracted McsDatabase, and McsCharts to their respective folders in my download directory, and they are all up and running however i fall over when i try to do much with either of these. I added a few different temperature sensors and weather data to the database setup (Temperature is from RFXCOM 433 Rx through homeseer, and weather is from Cumulus). as High Rate and accept however i get errors in the database as below:
In terms of the charting, i then get an error saying no lines to graph / no data selected.
MCS Database Error:
PHP Code:
4/12/2013 9:47:33 AM | 4/12/2013 9:47:33 AM | Using xAP port 62989
4/12/2013 9:47:33 AM | 4/12/2013 9:47:33 AM | Created Database(s) C:\Users\vmware\Downloads\xapmcsDatabase\Data\xapmcsDatabase\xapmcsDatabase.mdb
4/12/2013 10:48:00 AM | 4/12/2013 10:48:00 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 10:48:00 AM | 4/12/2013 10:48:00 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_) VALUES (#2013-04-12 10:48:00# AS QT,1920 AS Q0) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 10:48:00# AS QT'.
4/12/2013 10:48:00 AM | 4/12/2013 10:48:00 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 10:48:00 AM | 4/12/2013 10:48:00 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint) VALUES (#2013-04-12 10:48:00# AS QT,1920 AS Q0,1470 AS Q1) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 10:48:00# AS QT'.
4/12/2013 10:48:00 AM | 4/12/2013 10:48:00 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 10:48:00 AM | 4/12/2013 10:48:00 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint,aUnknown_WindSpeeW) VALUES (#2013-04-12 10:48:00# AS QT,1920 AS Q0,1470 AS Q1,160 AS Q2) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 10:48:00# AS QT'.
4/12/2013 10:48:00 AM | 4/12/2013 10:48:00 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 10:49:43 AM | 4/12/2013 10:49:43 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint,aUnknown_WindSpeeW,aUnknown_WindDireD,amcsXap_______433U1) VALUES (#2013-04-12 10:49:43# AS QT,1910 AS Q0,1440 AS Q1,160 AS Q2,0 AS Q3,250 AS Q4) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 10:49:43# AS QT'.
4/12/2013 10:49:43 AM | 4/12/2013 10:49:43 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 10:55:52 AM | 4/12/2013 10:55:52 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint,aUnknown_WindSpeeW,aUnknown_WindDireD,amcsXap_______433U1) VALUES (#2013-04-12 10:55:52# AS QT,1920 AS Q0,1470 AS Q1,480 AS Q2,0 AS Q3,240 AS Q4) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 10:55:52# AS QT'.
4/12/2013 10:55:52 AM | 4/12/2013 10:55:52 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 10:57:55 AM | 4/12/2013 10:57:55 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint,aUnknown_WindSpeeW,aUnknown_WindDireD,amcsXap_______433U1) VALUES (#2013-04-12 10:57:55# AS QT,1920 AS Q0,1470 AS Q1,480 AS Q2,0 AS Q3,230 AS Q4) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 10:57:55# AS QT'.
4/12/2013 10:57:55 AM | 4/12/2013 10:57:55 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 11:00:39 AM | 4/12/2013 11:00:39 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint,aUnknown_WindSpeeW,aUnknown_WindDireD,amcsXap_______433U1) VALUES (#2013-04-12 11:00:39# AS QT,1920 AS Q0,1470 AS Q1,320 AS Q2,0 AS Q3,220 AS Q4) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 11:00:39# AS QT'.
4/12/2013 11:00:39 AM | 4/12/2013 11:00:39 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 11:02:42 AM | 4/12/2013 11:02:42 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint,aUnknown_WindSpeeW,aUnknown_WindDireD,amcsXap_______433U1) VALUES (#2013-04-12 11:02:42# AS QT,1930 AS Q0,1480 AS Q1,320 AS Q2,0 AS Q3,210 AS Q4) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 11:02:42# AS QT'.
4/12/2013 11:02:42 AM | 4/12/2013 11:02:42 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 11:04:45 AM | 4/12/2013 11:04:45 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint,aUnknown_WindSpeeW,aUnknown_WindDireD,amcsXap_______433U1) VALUES (#2013-04-12 11:04:45# AS QT,1950 AS Q0,1470 AS Q1,320 AS Q2,0 AS Q3,200 AS Q4) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 11:04:45# AS QT'.
4/12/2013 11:04:45 AM | 4/12/2013 11:04:45 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 11:17:44 AM | 4/12/2013 11:17:44 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint,aUnknown_WindSpeeW,aUnknown_WindDireD,amcsXap_______433U1) VALUES (#2013-04-12 11:17:44# AS QT,2010 AS Q0,1490 AS Q1,320 AS Q2,0 AS Q3,190 AS Q4) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 11:17:44# AS QT'.
4/12/2013 11:17:44 AM | 4/12/2013 11:17:44 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
4/12/2013 11:21:09 AM | 4/12/2013 11:21:09 AM | ExecuteCommand INSERT INTO tblHighRate (SampleDate,aUnknown_CurTemp_,aUnknown_DewPoint,aUnknown_WindSpeeW,aUnknown_WindDireD,amcsXap_______433U1) VALUES (#2013-04-12 11:21:09# AS QT,2040 AS Q0,1500 AS Q1,160 AS Q2,0 AS Q3,200 AS Q4) Line 171 Syntax error (missing operator) in query expression '#2013-04-12 11:21:09# AS QT'.
4/12/2013 11:21:09 AM | 4/12/2013 11:21:09 AM | Log_AnalogData SELECT Max(ID) FROM tblHighRate Line 560 Conversion from type 'DBNull' to type 'String' is not valid.
MCS Database ini:
PHP Code:
[DataCollection]
Background=White
Database=C:\Users\vmware\Downloads\xapmcsDatabase\Data\xapmcsDatabase\xapmcsDatabase.mdb
DataCollectionInterval=5
DataCollectionInterval2=15
DebugLog=
EndPointID=0
ForecastTable=tblForecast
HideRejected=
HTTPPort=8011
SegmentFilter1=""
SegmentFilter10=""
SegmentFilter11=""
SegmentFilter12=""
SegmentFilter2=""
SegmentFilter3=""
SegmentFilter4=""
SegmentFilter5=""
SegmentFilter6=""
SegmentFilter7="mcsXap_______433"
SegmentFilter8=""
SegmentFilter9=""
ShowOnlyAccepted=
SQLPassword=
SQLSource=
SQLUsername=
StyleSheet=StyleNoBody.css
TemperatureTable=tblPeriodic
TemperatureTable2=tblHighRate
UseSQL=0
[SensorType]
barometer=B
barotrend=K
dewpoint=5
distance=M
hubswitch=0
humidity=H
humidityrate=F
hvac=J
index=I
lightning=L
minutes=2
moisture=1
rainmonth=4
rainrate=E
raintoday=R
relay=Y
status=3
sunlight=@
switch=S
text=6
thermochron=Q
unknown=?
unused=A
user0=U
user1=X
user2=Z
user3=P
voltage=V
waterflow=N
waterflowrate=C
wattagerate=8
wattagetoday=7
winddirection=D
windgust=G
windspeed=W
x10=9
PHP Code:
[ASP]
Fridge=checked
Temp=checked
[GENERAL]
bca="#FFFFFF"
Client0="Default,0"
Client1=",0"
Client2=",0"
Client3=",0"
ClientChartAxisSize="8, 8, 8, 8, 8, 8, 8, 8, 8, 8"
ClientChartAxisTitleSize="8, 8, 8, 8, 8, 8, 8, 8, 8, 8"
ClientChartHeight="210, 280, 350, 420, 490, 560, 630, 700, 770, 840"
ClientChartLegendSize="8, 8, 8, 8, 8, 8, 8, 8, 8, 8"
ClientChartOverallHeight="300, 370, 440, 510, 580, 650, 720, 790, 860, 930"
ClientChartOverallWidth="600, 700, 800, 900, 1000, 1100, 1200, 1300, 1400, 1500"
ClientChartScreenSize="600, 700, 800, 900, 1000, 1100, 1200, 1300, 1400, 1500"
ClientChartUpdateTimeSize="7, 7, 7, 7, 7, 7, 7, 7, 7, 7"
ClientChartWidth="520, 620, 720, 820, 920, 1020, 1120, 1220, 1320, 1420"
CompatibilityMode=0
ConnectDots=true
Database="C:\Users\vmware\Downloads\xapmcsChart\Data\xapmcsChart.mdb"
DebugLog=false
DebugLog2=false
DefaultAggregate=
DefaultGraph=LinSel
DefaultLineColors=""
DefaultPeriod=24Hour
DiscreteSpacing="2"
excludeHeaderAndFooter=false
forceHumidityScale=false
GraphColorBase="motion/TEMP"
LegendHeight="35"
LegendLeft="55"
LineChartBorderColor=D0D0D0
LineChartCenterColor=FCFDCF
LineWidthOther="1"
LineWidthTemperature="1"
MaxVerticalPixels=16
MetricBaro=1
MetricRain=1
MetricTemp=1
MetricWind=1
ProviderOption=0
RetainSettingByClient=false
ReverseColorScale=0
SelectedGroup=Default
ServerPort="8012"
showTemperatureDataPoints=false
SQLSource=""
StyleSheet="StyleNoBody.css"
SymbolDeltaL="2"
SymbolDeltaR="2"
SymbolSizeL="2"
SymbolSizeR="5"
TableFontColor="gray"
TableFontColorSize=""
TCPDebug=false
TemperatureTable="Temperature"
TextColor="gray"
TextColorSize=""
UserDefinedLabel0=""
UserDefinedLabel1=""
UserDefinedLabel2=""
UserDefinedLabel3=""
UseSQL=0
[GROUP]
Default=,LinSel,,,,,Smooth,
[GROUP_DEFAULT]
amcsXap_______433U1=1,,Line,
Comment