Bwired Googlemaps upload data webservice

Post by **Jfn** » Fri Mar 27, 2009 9:16 am

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.

Post by **Willem4ever** » Fri Mar 27, 2009 9:38 am

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by Jfn
 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.

Post by **Kroonen** » Fri Mar 27, 2009 9:49 am

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

I also don't sent last update entry not more

Post by **Willem4ever** » Fri Mar 27, 2009 10:04 am

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

Post by **Sooty** » Fri Mar 27, 2009 10:12 am

<blockquote id="quote">quote:<hr height="1" noshade id="quote">BTW: Pauls Homeseer Tool will handle this automatic.<hr height="1" noshade 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">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"></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..

Post by **Bwired** » Fri Mar 27, 2009 11:49 am

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!

Post by **Jeroen Bartels** » Fri Mar 27, 2009 12:31 pm

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

Post by **Bwired** » Fri Mar 27, 2009 1:06 pm

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.

Post by **Esteban** » Fri Mar 27, 2009 1:19 pm

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

Post by **Noel** » Sat Mar 28, 2009 9:51 am

I'm at the moment getting the following error when accessing http://www.bwired.nl/domoticaworld.asp<blockquote 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"></blockquote id="quote">

--

Post by **Digit** » Sat Mar 28, 2009 10:54 am

Me too.

Post by **Rebel** » Sat Mar 28, 2009 11:41 am

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)

Post by **RDNZL** » Sat Mar 28, 2009 12:55 pm

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.

Post by **Bwired** » Sat Mar 28, 2009 1:25 pm

I had a database crash last night, had to do some repairs

All is running now.

Post by **dutchnomad** » Sun Mar 29, 2009 1:28 am

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?