Page 6 of 22
Bwired Googlemaps upload data webservice
Posted: Thu Mar 19, 2009 9:03 pm
by Digit
Yep.
Bwired Googlemaps upload data webservice
Posted: Thu Mar 19, 2009 9:11 pm
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.
Bwired Googlemaps upload data webservice
Posted: Thu Mar 19, 2009 9:15 pm
by Digit
I use a single quote from the beginning, but also UTF-8 encoding:

Bwired Googlemaps upload data webservice
Posted: Thu Mar 19, 2009 9:34 pm
by Bwired
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.
Bwired Googlemaps upload data webservice
Posted: Thu Mar 19, 2009 9:36 pm
by Bwired
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by RDNZL</i>
<br />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"></font id="quote"></blockquote id="quote">Hi Ron
you're UTF-8 is coming in now so special characters should work now.
Bwired Googlemaps upload data webservice
Posted: Fri Mar 20, 2009 11:45 pm
by Bwired
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!
Bwired Googlemaps upload data webservice
Posted: Fri Mar 20, 2009 11:57 pm
by drmacchi
Sooty, Bwired :Thanks to both ! lorenzo
Bwired Googlemaps upload data webservice
Posted: Sat Mar 21, 2009 12:26 am
by Sooty
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..
Bwired Googlemaps upload data webservice
Posted: Sat Mar 21, 2009 12:37 am
by Bwired
ok goes wrong
you need to fill the units
- <Entry>
<Name>Lamp 1</Name>
<ID>8</ID>
<Units />
<Value>ON</Value>
</Entry>
Bwired Googlemaps upload data webservice
Posted: Sat Mar 21, 2009 12:47 am
by Bwired
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>
Bwired Googlemaps upload data webservice
Posted: Sat Mar 21, 2009 12:49 am
by Sooty
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..
Bwired Googlemaps upload data webservice
Posted: Sat Mar 21, 2009 12:57 am
by Bwired
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!
Bwired Googlemaps upload data webservice
Posted: Sat Mar 21, 2009 1:07 am
by Noel
<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.
--

Bwired Googlemaps upload data webservice
Posted: Sat Mar 21, 2009 1:14 am
by Sooty
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..
Bwired Googlemaps upload data webservice
Posted: Sat Mar 21, 2009 1:18 am
by Bwired
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