[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
Re: Floorplan
------=_NextPart_000_000C_01C8FF2E.EA4A5E60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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/0=
1/2007).
I whipped up a quick floorplan script that does a SetDBGlobal and then a
Ge=
tDBGlobal and it doesn't retrieve the value so something is amiss
somewhere=
!
Anything else I can check?
Thanks,
Martyn Wendon
----- Original Message -----=20
From: James=20
To: xap_automation@xxxxxxx=20
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 if yo=
u set up an ODBC driver. In which case the data may be going elsewhere.
Ano=
ther possibility is that the DB has either become too big >2gb or is
corrup=
t. 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 database, a=
ny ideas why?
Opending up the Access database and it seems to have stopped on 19/01/2=
007! Not sure what happened around that time, whether I installed an
upgrad=
e or something, it's a bit long ago to remember!
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
f=
ind that it's not :-(
Thanks,
Martyn
=20=20=20
------=_NextPart_000_000C_01C8FF2E.EA4A5E60
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>It's version
1.5.</FONT></DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV>
<DIV><FONT 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><FONT face=Arial
size=2></FONT> </DIV>
<DIV><FONT 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><FONT face=Arial
size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Anything else I can
check?</FONT></DIV>
<DIV><FONT face=Arial
size=2></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,</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>
Friday, August 15, 2008 8:01
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B>
Re: [xap_automation]
Floorplan</DIV>
<DIV><BR></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>what version of Floorplan is this btw?</DIV>
<DIV><BR></DIV>
<DIV>Thanks</DIV>
<DIV><BR></DIV>
<DIV>James</DIV>
<DIV><BR></DIV>
<DIV><BR>
<DIV>
<DIV>On 15 Aug 2008, at 11:48, 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,</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="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=4052/stime=1218839446";
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=X3oDMTJmaWRmaTVtBF9TAzk3NDc2NTkwBGdycElkAzk2NzQzNDMEZ3Jwc3BJZAMxNzA1MDA3NzA5BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyMTg4Mzk0NDY-";>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=X3oDMTJkcWx2cmRzBF9TAzk3NDc2NTkwBGdycElkAzk2NzQzNDMEZ3Jwc3BJZAMxNzA1MDA3NzA5BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjE4ODM5NDQ2";>
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_000C_01C8FF2E.EA4A5E60--
xAP_Automation Main Index |
xAP_Automation Thread Index |
xAP_Automation Home |
Archives Home
|