[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
Re: Floorplan
------=_NextPart_000_0015_01C9022A.5AA27CD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi James,
I stopped FP, renamed the .mdb and then started FP and it seems to be
worki=
ng fine now as I can see stuff going into the database. I guess that the
d=
atabase must have been corrupted way back at the beginning of 2007!
Where would the Log / Events page be?
I've got devices, maps, rooms, scripts....etc. There's a
"Logging" under d=
evices? Am I missing a hidden page somewhere that shows all the stuff
that=
's being logged?!?
Thanks for your help,
Martyn Wendon
----- Original Message -----=20
From: James=20
To: xap_automation@xxxxxxx=20
Sent: Tuesday, August 19, 2008 5:54 PM
Subject: Re: [xap_automation] Floorplan
Martyn,
Couple of things to try.
First even though the ODBC line looks empty even a space would cause it =
to activate. Just delete the line to be sure.
If you close floorplan the rename the .mdb and then restart Floorplan it=
should recreate a new mdb and recreate the tables. This will test that al=
l the database components are correctly running/installed. (Then put your
o=
ld db back again!)
I've tried the mdb loading and saving on my Floorplan here and it seems o=
k. Is anyone else using the database and not seeing logging happening?
On the homepage under Log / Events are you seeing any error messages?
James
On 15 Aug 2008, at 23:30, Martyn Wendon wrote:
Hi James,
It's version 1.5.
Northing in the ODBC=3D line and the DB seems ok - it's 157MB and opens=
in Access fine (that's how I saw it had stopped with the last entry being =
19/01/2007).
I whipped up a quick floorplan script that does a SetDBGlobal and then =
a GetDBGlobal and it doesn't retrieve the value so something is amiss
somew=
here!
Anything else I can check?
Thanks,
Martyn Wendon
----- Original Message -----
From: James
To: xap_automation@xxxxxxx
Sent: Friday, August 15, 2008 8:01 PM
Subject: Re: [xap_automation] Floorplan
The two things that spring to mind is check the config file and see i=
f you set up an ODBC driver. In which case the data may be going
elsewhere.=
Another possibility is that the DB has either become too big >2gb or is
co=
rrupt. See if it opens up in Access if you have a copy.
what version of Floorplan is this btw?
Thanks
James
On 15 Aug 2008, at 11:48, Martyn Wendon wrote:
Hi,
Floorplan seems to have stopped logging stuff to the Access databas=
e, any ideas why?
Opending up the Access database and it seems to have stopped on 19/=
01/2007! Not sure what happened around that time, whether I installed an
up=
grade or something, it's a bit long ago to remember!
I finally got some time to write some web charting stuff to make se=
nse of all the data that Floorplan had been logging for me over the years,
=
to find that it's not :-(
Thanks,
Martyn
=20=20=20
------=_NextPart_000_0015_01C9022A.5AA27CD0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html;
charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16608" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space;
-webkit-line-break: after-white-space"
bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi James,</FONT></DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I stopped FP, renamed the .mdb and
then started FP
and it seems to be working fine now as I can see stuff going into the
database. I guess that the database must have been corrupted way
back at
the beginning of 2007!</FONT></DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Where would the Log / Events page
be?</FONT></DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've got devices, maps, rooms,
scripts....etc. There's a "Logging" under
devices? Am I missing a
hidden page somewhere that shows all the stuff that's being
logged?!?</FONT></DIV></FONT></DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks for your
help,</FONT></DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV>
<DIV><BR>Martyn Wendon</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message -----
</DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
black"><B>From:</B>
<A title=james.traynor@xxxxxxx
href="mailto:james.traynor@xxxxxxx";>James</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=xap_automation@xxxxxxx
href="mailto:xap_automation@xxxxxxx";>xap_automation@xxxxxxx</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B>
Tuesday, August 19, 2008 5:54
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B>
Re: [xap_automation]
Floorplan</DIV>
<DIV><BR></DIV>
<DIV>Martyn,</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>Couple of things to try.
<DIV>First even though the ODBC line looks empty even a
space would
cause it to activate. Just delete the line to be sure.</DIV>
<DIV>If you close floorplan the rename the .mdb and then
restart
Floorplan it should recreate a new mdb and recreate the tables.
This
will test that all the database components are correctly running/installed.
(Then put your old db back again!)</DIV>
<DIV>I've tried the mdb loading and saving on my Floorplan here and
it seems
ok. Is anyone else using the database and not seeing logging
happening?</DIV>
<DIV>On the homepage under Log / Events are you seeing any
error
messages?</DIV>
<DIV><BR></DIV>
<DIV>James</DIV>
<DIV><BR>
<DIV>
<DIV>On 15 Aug 2008, at 23:30, Martyn Wendon wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite"><SPAN class=Apple-style-span
style="WORD-SPACING: 0px; FONT: 12px Helvetica; TEXT-TRANSFORM: none;
COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING:
normal; BORDER-COLLAPSE: separate; orphans: 2; widows: 2;
-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing:
0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: 0">
<DIV style="BACKGROUND-COLOR: rgb(255,255,255)">
<DIV id=ygrp-mlmsg
style="FONT-SIZE: 13px; WIDTH: 655px; FONT-FAMILY: arial, helvetica,
clean, sans-serif; POSITION: relative">
<DIV id=ygrp-msg
style="PADDING-RIGHT: 25px; PADDING-LEFT: 0px; Z-INDEX: 1; FLOAT:
left; PADDING-BOTTOM: 0px; MARGIN: 0px; WIDTH: 470px; LINE-HEIGHT: 1.22em;
PADDING-TOP: 0px">
<DIV id=ygrp-text style="LINE-HEIGHT: 1.22em; FONT-FAMILY:
Georgia">
<DIV style="MARGIN: 0px 0px 1em; LINE-HEIGHT:
1.22em"><BR
class=webkit-block-placeholder></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>Hi James,</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>It's version 1.5.</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>Northing in the ODBC= line and the DB seems ok - it's
157MB and opens in Access fine (that's how I saw it had stopped with the
last entry being 19/01/2007).</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>I whipped up a quick floorplan script that does a
SetDBGlobal and then a GetDBGlobal and it doesn't retrieve the value so
something is amiss somewhere!</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>Anything else I can check?</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>Thanks,</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><BR
style="LINE-HEIGHT: 1.22em">Martyn
Wendon</DIV>
<BLOCKQUOTE
style="MARGIN: 0px 0px 0px 4px; BORDER-LEFT: rgb(0,0,0) 2px solid;
LINE-HEIGHT: 1.22em">
<DIV style="FONT: 10pt/1.22em arial">----- Original Message
-----</DIV>
<DIV
style="FONT: 10pt/1.22em arial; BACKGROUND-COLOR: rgb(228,228,228);
-webkit-background-clip: initial; -webkit-background-origin:
initial"><B
style="LINE-HEIGHT: 1.22em">From:</B><SPAN
class=Apple-converted-space> </SPAN><A
title=james.traynor@xxxxxxx
style="LINE-HEIGHT: 1.22em"
href="mailto:james.traynor@xxxxxxx";>James</A></DIV>
<DIV style="FONT: 10pt/1.22em arial"><B
style="LINE-HEIGHT: 1.22em">To:</B><SPAN
class=Apple-converted-space> </SPAN><A
title=xap_automation@xxxxxxx style="LINE-HEIGHT: 1.22em"
href="mailto:xap_automation@xxxxxxx";>xap_automation@<WBR
style="LINE-HEIGHT: 1.22em">yahoogroups.<WBR
style="LINE-HEIGHT: 1.22em">.com</A></DIV>
<DIV style="FONT: 10pt/1.22em arial"><B
style="LINE-HEIGHT: 1.22em">Sent:</B><SPAN
class=Apple-converted-space> </SPAN>Friday, August 15,
2008 8:01
PM</DIV>
<DIV style="FONT: 10pt/1.22em arial"><B
style="LINE-HEIGHT: 1.22em">Subject:</B><SPAN
class=Apple-converted-space> </SPAN>Re: [xap_automation]
Floorplan</DIV>
<DIV style="LINE-HEIGHT: 1.22em"><BR
style="LINE-HEIGHT: 1.22em"></DIV>The
two things that spring to mind is check the config file and see if you set
up an ODBC driver. In which case the data may be going elsewhere. Another
possibility is that the DB has either become too big >2gb or is
corrupt. See if it opens up in Access if you have a copy.
<DIV style="LINE-HEIGHT: 1.22em">what version of Floorplan
is this
btw?</DIV>
<DIV style="LINE-HEIGHT: 1.22em"><BR
style="LINE-HEIGHT: 1.22em"></DIV>
<DIV style="LINE-HEIGHT: 1.22em">Thanks</DIV>
<DIV style="LINE-HEIGHT: 1.22em"><BR
style="LINE-HEIGHT: 1.22em"></DIV>
<DIV style="LINE-HEIGHT: 1.22em">James</DIV>
<DIV style="LINE-HEIGHT: 1.22em"><BR
style="LINE-HEIGHT: 1.22em"></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><BR
style="LINE-HEIGHT: 1.22em">
<DIV style="LINE-HEIGHT: 1.22em">
<DIV style="LINE-HEIGHT: 1.22em">On 15 Aug 2008, at 11:48,
Martyn Wendon
wrote:</DIV><BR class=Apple-interchange-newline
style="LINE-HEIGHT: 1.22em">
<BLOCKQUOTE style="MARGIN: 0px 0px 0px 4px; LINE-HEIGHT:
1.22em"
type="cite"><SPAN class=Apple-style-span
style="WORD-SPACING: 0px; FONT: 12px/1.22em Helvetica; TEXT-TRANSFORM:
none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal;
LETTER-SPACING: normal; BORDER-COLLAPSE: separate">
<DIV style="LINE-HEIGHT: 1.22em; BACKGROUND-COLOR:
rgb(255,255,255)">
<DIV id=ygrp-mlmsg
style="FONT-SIZE: 13px; LINE-HEIGHT: 1.22em; FONT-FAMILY: arial,
helvetica, clean, sans-serif">
<DIV id=ygrp-msg style="LINE-HEIGHT: 1.22em">
<DIV id=ygrp-text style="LINE-HEIGHT: 1.22em; FONT-FAMILY:
Georgia">
<DIV style="LINE-HEIGHT: 1.22em"><BR
class=webkit-block-placeholder
style="LINE-HEIGHT: 1.22em"></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>Hi,</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>Floorplan seems to have stopped logging stuff to the
Access database, any ideas why?</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>Opending up the Access database and it seems to have
stopped on 19/01/2007! Not sure what happened around that time,
whether I installed an upgrade or something, it's a bit long ago
to
remember!</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>I finally got some time to write some
web charting stuff to make sense of all the data that Floorplan
had
been logging for me over the years, to find that it's not
:-(</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>Thanks,</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2></FONT> </DIV>
<DIV style="LINE-HEIGHT: 1.22em"><FONT
style="LINE-HEIGHT: 1.22em"
face=Arial size=2>Martyn</FONT></DIV>
<DIV style="LINE-HEIGHT: 1.22em"><BR
class=webkit-block-placeholder
style="LINE-HEIGHT: 1.22em"></DIV></DIV><SPAN
style="COLOR: white; LINE-HEIGHT: 1.22em"
width="1"></SPAN></DIV></DIV></DIV></SPAN></BLOCKQUOTE></DIV><BR
style="LINE-HEIGHT: 1.22em"></DIV><SPAN
style="COLOR: white; LINE-HEIGHT: 1.22em"
width="1"></SPAN></BLOCKQUOTE>
<DIV style="MARGIN: 0px 0px 1em; LINE-HEIGHT:
1.22em"><BR
class=webkit-block-placeholder></DIV></DIV><SPAN
style="COLOR: white; LINE-HEIGHT: 1.22em"
width="1"></SPAN></DIV></SPAN></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV><SPAN
style="COLOR: white" width="1"></SPAN>
</BLOCKQUOTE>
<span width="1" style="color:
white;"/>__._,_.___</span>
<!-- Start Recommendations -->
<!-- End Recommendations -->
<!-- **begin egp html banner** -->
<img src="http://geo.yahoo.com/serv?s=97476590/grpId=9674343/grpspId=1705007709/msgId=4055/stime=1219167346";
width="1" height="1"> <br>
<!-- **end egp html banner** -->
<!-- **begin egp html banner** -->
<br>
<div style="font-family: verdana; font-size: 77%; border-top: 1px
solid #666; padding: 5px 0;" >
Your email settings: Individual EmailTraditional <br>
<a href="http://groups.yahoo.com/group/xap_automation/join;_ylc=X3oDMTJmMjJ1ZmVpBF9TAzk3NDc2NTkwBGdycElkAzk2NzQzNDMEZ3Jwc3BJZAMxNzA1MDA3NzA5BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyMTkxNjczNDY-";>Change
settings via the Web</a> (Yahoo! ID required) <br>
Change settings via email: <a href="mailto:xap_automation-digest@xxxxxxx?subject=Email
Delivery: Digest">Switch delivery to Daily Digest</a> <a
href = "mailto:xap_automation-fullfeatured@xxxxxxx?subject=Change
Delivery Format: Fully Featured">Switch to Fully Featured</a>
<br>
<a href="http://groups.yahoo.com/group/xap_automation;_ylc=X3oDMTJkMmE2dWlpBF9TAzk3NDc2NTkwBGdycElkAzk2NzQzNDMEZ3Jwc3BJZAMxNzA1MDA3NzA5BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjE5MTY3MzQ2";>
Visit Your Group
</a>
<a href="http://docs.yahoo.com/info/terms/";>
Yahoo! Groups Terms of Use
</a>
<a href="mailto:xap_automation-unsubscribe@xxxxxxx?subject=Unsubscribe";>
Unsubscribe
</a>
<br>
</div>
<br>
<!-- **end egp html banner** -->
<span style="color: white;"/>__,_._,___</span>
</BODY></HTML>
------=_NextPart_000_0015_01C9022A.5AA27CD0--
xAP_Automation Main Index |
xAP_Automation Thread Index |
xAP_Automation Home |
Archives Home
|