Home Automation Domotica Forum Europe, Bwired Forum

Fixed the ID numbers.

Btw, you should also change the XML example on page 1 of this thread. I used it as a reference for my XML data and all ID's in this example have a value of 1.

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Jfn</i>
<br />Fixed the ID numbers.
Btw, you should also change the XML example on page 1 of this thread. I used it as a reference for my XML data and all ID's in this example have a value of 1.

yes update the ID's but is time changed? This goes wrong?

I also don't sent last update entry not more

I see multiple occurrences of "Lichtsensor" also Inside Temperature was changed two days ago to Study ...

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">BTW: Pauls Homeseer Tool will handle this automatic.<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">

It currently does this in order that they are added, so it you have device No's 1-8 for example and delete device 6, then the next device added will take position No 6.

If I get time today, I will put in an option to sort the devices on the device list page, so that you can move them into any position.

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Suggestion:

Add a XML entry with Offset to UTC.
bwired's receive.asp converts time back to UTC and stores UTC based time and Offset in database.
XML uploads with no timezone set offset to 0 <hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">

I think the time zone is best done at Pieters end to minimise errors. It should be easy enough to do for incoming data The +- value from GMT can be calculated from the date time field and added to the data.

I suppose the more difficult part, will be getting the map to display properly based on the viewing users time zone.

Paul..

ok good ideas I will look into to it.
I changed the select query yesterday and something is wrong for Kroon040, its only the view, your data is received perfectly and stored with the right date. Get back on this!

I just discovered that my devices are not updated. Thee are value's shown and the last updated time is right, but the values are not.
Can anybody explain why?

I made no changes to my script that was hand made by pieter and myself.

Kind regards,

Jeroen

Thanks all for pointing out!
For now the old query is back, all is OK now.
Need to do a better job on the query
Again I never loose data, only the select is wrong.

Well Pieter, thanks to Paul's plugin setting up the map was as easy as cooking an egg (easier even) Everything is working smoothly as far as I can tell. [:)].

Ciao,
Esteban

I'm at the moment getting the following error when accessing http://www.bwired.nl/domoticaworld.asp<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/domoticaworld.asp, line 34 <hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">

--

Me too.

And this error in Homeseer:
Scripting runtime error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.WebException: The remote server returned an error: (500) Internal Server Error. at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) at scriptcode2.scriptcode2.Main(Object parms) --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at Scheduler.VsaScriptHost.Invoke(String ModuleName, String MethodName, Object[] Arguments)

Maybe a bug:
If you rename one of your sensors, the old one stays on the site too.
Current Power Usage -> Home Power Usage, everything else I left the same. It's a problem with the website code I guess.

Regards,
Ron.

I had a database crash last night, had to do some repairs
All is running now.

Hi I created a .net c# class to send data to Bwired. Not sure if the data will arrive, but I sent some.

Is there a description available of the data formats that can be send? Maybe an xsd, that would be the best?