Bwired Googlemaps upload data webservice

Post by **RDNZL** » Thu Mar 19, 2009 9:11 pm

I also had to remove the ' from my data, otherwise Pieter's script failed, but that was before I add the utf-8 encoding to my xml, don't know if that fixed it or not.

Regards,
Ron.

Post by **Digit** » Thu Mar 19, 2009 9:15 pm

I use a single quote from the beginning, but also UTF-8 encoding:

Post by **Bwired** » Thu Mar 19, 2009 9:34 pm

Ok Lorenzo
I see the errors coming in but no valid XML.
I send you a sample, please try this and don't change a thing for now.

Post by **Bwired** » Thu Mar 19, 2009 9:36 pm

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by RDNZL
 I also had to remove the ' from my data, otherwise Pieter's script failed, but that was before I add the utf-8 encoding to my xml, don't know if that fixed it or not.

Regards,
Ron.
<hr height="1" noshade id="quote"></blockquote id="quote">Hi Ron
you're UTF-8 is coming in now so special characters should work now.

Post by **Bwired** » Fri Mar 20, 2009 11:45 pm

Sooty
I have your UK time up and running now.
Still have to work on the next day part, because I'm missing you for 1 hour in the Mysql select!
Can you help Drmacchi again, the script is not working, the part of filling the lamp status gives errors. If we deletet that Entry then the script is working. I think it has something to with variable type or so? Can you test this and see if it works on your side.
Thanks again!

Post by **drmacchi** » Fri Mar 20, 2009 11:57 pm

Sooty, Bwired :Thanks to both ! lorenzo

Post by **Sooty** » Sat Mar 21, 2009 12:26 am

Lorenzo,

The problem with the lamp status may be a difficult one. If the status string contains html or other strange characters then it may cause problems, thats why I went for the DeviceStatus in the script. That approach works fine at my end with the DeviceStatus.

I will add this to my script now an do an upload just to check that all is OK and we can go from there.

Paul..

Post by **Bwired** » Sat Mar 21, 2009 12:37 am

ok goes wrong
you need to fill the units

- <Entry>
<Name>Lamp 1</Name>
<ID>8</ID>
<Units />
<Value>ON</Value>
</Entry>

Post by **Bwired** » Sat Mar 21, 2009 12:47 am

What is going wrong? this is coming in but not processed on my side!
I will check this first.....???
Get back on this, thanks Sooty

- <Entry>
<Name>Lamp 1</Name>
<ID>8</ID>
<Units>.</Units>
<Value>ON</Value>
</Entry>

Post by **Sooty** » Sat Mar 21, 2009 12:49 am

Pieter,

I am pretty sure that everything is formatted OK. I also get an error at this end. I was just about to change the value in the lamp status to a manual string entry to see if that was the problem.

Paul..

Post by **Bwired** » Sat Mar 21, 2009 12:57 am

Hi Paul & Lorenzo
I found it, it's a variable type at my side

Running some tests now, will be online within 10 minutes.
The <unit> can be set to blank again.
Thanks!

Post by **Noel** » Sat Mar 21, 2009 1:07 am

<value> can only be numbers!
I found this problem when an anonymous caller cals me, and when I upload the data to your server.
I get a 500 (server) error back from you.

--

Post by **Sooty** » Sat Mar 21, 2009 1:14 am

Perhaps Peiter is going to change this?

On the Time Zone subject.
I suppose that each users data would need to be "Time Zoned" then "Today" calculated on a per user basis.

Paul..

Post by **Bwired** » Sat Mar 21, 2009 1:18 am

Right Paul & Noel I changed this, so it should be working now. Type is now Varchar for <Value>
@Noel: you can change your phonesettings if you want
@Lorenzo: Your lamp upload should work now also