Announcement

Collapse
No announcement yet.

Lost with XAP

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Lost with XAP

    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:
    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(sC:\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(IDFROM 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(IDFROM 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_DewPointVALUES (#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(IDFROM 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_WindSpeeWVALUES (#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(IDFROM 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_______433U1VALUES (#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(IDFROM 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_______433U1VALUES (#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(IDFROM 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_______433U1VALUES (#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(IDFROM 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_______433U1VALUES (#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(IDFROM 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_______433U1VALUES (#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(IDFROM 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_______433U1VALUES (#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(IDFROM 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_______433U1VALUES (#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(IDFROM 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_______433U1VALUES (#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(IDFROM 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
    =
    Mcs Chart ini:
    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
    HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

    Facebook | Twitter | Flickr | Google+ | Website | YouTube

    #2
    The data is not being entered into the database so without data then no charts are possible. Special logic exists for SQL format for Access, but this seems to not be needed. I removed it with V2.0.0.9 and was then able to store to an empty Access database. http://mcsSprinklers.com/xapmcsDatabase.zip

    Comment

    Working...
    X