The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

RE: xAPlogger - launched


  • Subject: RE: xAPlogger - launched
  • From: "Sullivan, Glenn" <gsullivan@xxxxxxxxxxxxxx>
  • Date: Fri, 10 Jun 2005 11:03:49 -0400

I am trying to get this working with MSDE, and can't quite get it.

I created a database called xAPLogger

I modified the table setup script as shown at the bottom of this message

I create an ODBC Connection to the database called xAPLogger.

Now, when I fire up the logger app, I can see the raw messages, and
there are no errors, but there is no data inserted.

Any suggestions?

TIA,

Glenn Sullivan, MCSE+I  MCDBA
David Clark Company Inc.

#
# Table structure for table 'block_contents'
#

CREATE TABLE block_contents (
header_id int NOT NULL DEFAULT '0' ,
block_id int NOT NULL DEFAULT '0' ,
content_id int NOT NULL DEFAULT '0' ,
keyname varchar(255) NOT NULL DEFAULT '' ,
value varchar(255) NOT NULL DEFAULT '' ,
is_hex char(1) NOT NULL DEFAULT '')

CREATE CLUSTERED INDEX message on block_contents
(header_id,block_id,content_id)



#
# Table structure for table 'message_block'
#

CREATE TABLE message_block (
header_id int NOT NULL DEFAULT '0' ,
block_id int NOT NULL DEFAULT '0' ,
block_name varchar(255) NOT NULL DEFAULT '')

CREATE CLUSTERED INDEX Message on message_block (header_id,block_id)



#
# Table structure for table 'message_header'
#

CREATE TABLE  message_header (
header_id int NOT NULL DEFAULT '0' ,
date_entered datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
xap_version int NOT NULL DEFAULT '0' ,
hop_count int NOT NULL DEFAULT '0' ,
unique_identifier varchar(8) NOT NULL DEFAULT '' ,
class varchar(255) NOT NULL DEFAULT '' ,
source varchar(255) NOT NULL DEFAULT '' ,
target varchar(255))

CREATE UNIQUE CLUSTERED INDEX pk_Header_ID on message_header(header_id)
CREATE INDEX source ON message_header(source)


-----Original Message-----
From: mark_harrison_uk2 [mailto:mph@xxxxxxx]
Sent: Friday, May 21, 2004 9:38 AM
To: xap_automation@xxxxxxx
Subject: [xap_automation] xAPlogger - launched

xAPLogger 1.1 is now available at www.ascentium.co.uk\xap

xAPlogger records all xAP messages in a house, and logs all events
(except heartbeats) to a database. xAPlogger is database independant,
and uses any ODBC data source as the message store.

xAPlogger is used in the MI4.biz xAP Intranet project, thus maybe
something you want to install for that.

Mark






xAP_Automation Main Index | xAP_Automation Thread Index | xAP_Automation Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.