VoxCommando Forum

Help and Support (Using VoxCommando) => Kodi (XBMC) Frodo / Gotham / Isengard / Jarvis => Topic started by: bp_pbs on December 05, 2013, 11:53:30 AM

Title: XBMC Status
Post by: bp_pbs on December 05, 2013, 11:53:30 AM
Team, so I'm trying to get a status of all the information in my XBMC. Like movie count, album count, unwatched movie count, count of new movies , etc.
So I want to say "Vox give me XBMC Status | What's my XBMC Status for today"
Then I get a run down of all. Maybe have a pause in there where Vox ask me do I want to continue ( if she is giving me a lot of information)

I thought I could do this be querying Xsgl but I'm at a lost of how to retrieve it. Any Ideas?
Title: Re: XBMC Status
Post by: jitterjames on December 05, 2013, 01:08:53 PM
I suggest you ask on the XBMC forum if there is a way to do this using json
Title: Re: XBMC Status
Post by: bp_pbs on December 05, 2013, 01:39:56 PM
Ok I'll let you know how it goes. Thanks
Title: Re: XBMC Status
Post by: bp_pbs on December 05, 2013, 02:09:22 PM
James can I ask you this while I'm waiting on XBMC people to respond to my forum. I have added sql code in Xsql. SO all results are in separate payloads. Is there a way I can get the results of each individual payload. I was thinking PayloadXML.GetValue but not sure how it works.

example
SELECT COUNT (idActor) as count FROM actors (Payload: xbmcActorsCount)
Title: Re: XBMC Status
Post by: bp_pbs on December 05, 2013, 02:27:46 PM
Never-mind I think I figured it out  :bonk