[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
Re: Floorplan
--Apple-Mail-5-339526424
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit
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 all the database components are correctly running/installed.
(Then put your old db back again!)
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?
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= 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 somewhere!
>
>
> 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
> 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.
> 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, 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 upgrade 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 find that it's not :-(
>>
>>
>>
>> Thanks,
>>
>> Martyn
>>
>
>
>
--Apple-Mail-5-339526424
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: 7bit
<html><body style="word-wrap: break-word; -webkit-nbsp-mode:
space; -webkit-line-break: after-white-space; ">
<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-newl
ine"><blockquote type="cite"><span
class="Apple-style-span" style="border-collapse: separate;
color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style:
normal; font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height: normal; orphans: 2; text-align: auto; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;
-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="width: 655px; position: relative;
font-size: 13px; font-family: arial, helvetica, clean, sans-serif;
"><div id="ygrp-msg" style="width: 470px;
margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;
padding-top: 0px; padding-right: 25px; padding-
bottom: 0px; padding-left: 0px; float: left; z-index: 1; line-height:
1.22em; "><div id="ygrp-text" style="line-height:
1.22em; font-family: Georgia; "><div style="line-height:
1.22em; margin-top: 0px; margin-right: 0px; margin-bottom: 1em;
margin-left: 0px; "><br
class="webkit-block-placeholder"></div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em; ">Hi
James,</font></div><div style="line-height: 1.22em;
"><font face="Arial" size="2"
style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em;
">It's version 1.5.</font></div><div
style="line-height: 1.22em; "><font face="Arial"
size=&quo
t;2" style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em; ">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 face="Arial" size="2"
style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em; ">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 face="Arial" size="2" style=
"line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em; ">Anything else
I can check?</font></div><div style="line-height:
1.22em; "><font face="Arial" size="2"
style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.
22em; "><font face="Arial" size="2"
style="line-height: 1.22em;
">Thanks,</font></div><div style="line-height:
1.22em; "><br style="line-height: 1.22em; ">Martyn
Wendon</div><blockquote style="border-left-color: rgb(0, 0,
0); border-left-width: 2px; border-left-style: solid; margin-top: 0px;
margin-right: 0px; margin-bottom: 0px; margin-left: 4px; line-height:
1.22em; "><div style="font: normal normal normal
10pt/normal arial; line-height: 1.22em; ">----- Original Message
-----</div><div style="background-image: initial;
background-repeat: initial; background-attachment: initial;
-webkit-background-clip: initial; -webkit-background-origin: initial;
background-color: rgb(228, 228, 228); font: normal normal normal
10pt/normal arial; line-height: 1.22em; background-position: initial
initial; "><b style="line-height: 1.22em;
">From:</b><span
class="Apple-converted-space"> </span><a
title="james.traynor@xxxxxxx" href="mailto:james.traynor@xxxxxxx";
style="line-height: 1.22em;
">James</a></div><div style="font: normal
normal normal 10pt/normal arial; line-height: 1.22em; "><b
style="line-height: 1.22em; ">To:</b><span
class="Apple-converted-space"> </span><a
title="xap_automation@xxxxxxx" href="mailto:xap_automation@xxxxxxx";
style="line-height: 1.22em; ">xap_automation@<wbr
style="line-height: 1.22em; ">yahoogroups.<wbr
style="line-height: 1.22em;
">.com</a></div><div style="font: normal normal
normal 10pt/normal arial; line-height: 1.22em; "><b
style="line-height: 1.22em; &quo
t;>Sent:</b><span
class="Apple-converted-space"> </span>Friday,
August 15, 2008 8:01 PM</div><div style="font: normal normal
normal 10pt/normal arial; line-height: 1.22em; "><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; ">&
lt;/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
type="cite" style="margin-top: 0px; margin-right: 0px;
margin-bottom: 0px; margin-left: 4px; line-height: 1.22em;
"><span class="Apple-style-span"
style="word-spacing: 0px; font: normal normal normal 12px/normal
Helvetica; text-transform:
none; color: rgb(0, 0, 0); text-indent: 0px; white-space: normal;
letter-spacing: normal; border-collapse: separate; line-height: 1.22em;
"><div style="background-color: rgb(255, 255, 255);
line-height: 1.22em; "><div id="ygrp-mlmsg"
style="font-size: 13px; font-family: arial, helvetica, clean,
sans-serif; line-height: 1.22em; "><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 face="Arial" size="2"
style="line-height: 1.22em;
">Hi,</font></div><div style="line-height:
1.22em; "><font face="Arial" size="2"
style="line-height: 1.22em; &quo
t;></font> </div><div style="line-height:
1.22em; "><font face="Arial" size="2"
style="line-height: 1.22em; ">Floorplan seems to have stopped
logging stuff to the Access database, any ideas
why?</font></div><div style="line-height: 1.22em;
"><font face="Arial" size="2"
style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em; ">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 face="Arial"
size="2" style="line-height: 1.22em;
"></font> </di
v><div style="line-height: 1.22em; "><font
face="Arial" size="2" style="line-height: 1.22em;
">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 face="Arial"
size="2" style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22e
m; ">Thanks,</font></div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em;
"></font> </div><div
style="line-height: 1.22em; "><font face="Arial"
size="2" style="line-height: 1.22em;
">Martyn</font></div><div style="line-height:
1.22em; "><br class="webkit-block-placeholder"
style="line-height: 1.22em; "></div></div><span
width="1" style="color: white; line-height: 1.22em;
"></span></div></div></div></span></blockquote></div><br
style="line-height: 1.22em; "></div><span
width="1" style="color: white; line-height: 1.22em;
"></span></blockquote><div style="line-height:
1.22em; margin-top: 0px; margin-right: 0px; margin-bottom: 1em
; margin-left: 0px; "><br
class="webkit-block-placeholder"></div></div><span
width="1" style="color: white; line-height: 1.22em;
"></span></div></span></blockquote></div><br></div>
<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=4054/stime=1219164910";
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=X3oDMTJmaTNpMGQyBF9TAzk3NDc2NTkwBGdycElkAzk2NzQzNDMEZ3Jwc3BJZAMxNzA1MDA3NzA5BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyMTkxNjQ5MTA-";>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=X3oDMTJkOTE0MjBvBF9TAzk3NDc2NTkwBGdycElkAzk2NzQzNDMEZ3Jwc3BJZAMxNzA1MDA3NzA5BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjE5MTY0OTEw";>
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>
--Apple-Mail-5-339526424--
xAP_Automation Main Index |
xAP_Automation Thread Index |
xAP_Automation Home |
Archives Home
|