I must not of updated my plugin, I thought I was up to date as mine still works.  I like the new thumbs up command.  That is cool.  Glad you were able to get this figured out. 

Ahhh, well this Encode.URI could actually be very useful.  I'll have to give this a shot and toy around with it to see what I can come up with. 

nime5ster,

I will have to give this a try but yes when saying the number I got the word.  This may actually allow me to use a full dictation as a payload.  Though I don't think so, it resolves my two > 2 issue. I just would need to replace the spaces with %20 as well.

JitterJames,

I've adjusted and changed it to a phrase and made it so it sends the @ symbol.  I like it better then showing the at.  As far as what I meant with what to send was that I couldn't use a payload dictation with out it sending the time as words not numbers.  Then when sending the scrape if would send actual spaces and not %20 which is an issue since it caused incomplete info sent to the server. Sometimes the application would interpret as a weird character then cause the application to crash.  I believe that's something he's addressed in the latest version of the software to help with weird characters. 

Hello JitterJames,

I ended up making one of my optional payloads required, the word at, and then using the {#P} I compared it to either 5 or 6 giving it the correct string now to the program.  I wish I had a little more control over how to send but the application gets kind of weird if I send just a string, plus instead of 2PM it'll send over two PM.  The structured layout works better to keep it simple.  I"ll post a video and my command tree for anyone interested.

Thanks JitterJames,

I'll give this a test and try it tonight.  I have a folder with all my others, I just moved this outside of it since it was something I was working on.  Helps me know what was finished and whats not.  I did mean payloads .  I'll let you know what happens.

Hello guys,

So I'm using a program called MoviePosterApp, not sure if anyones heard of it but it basically runs through movie posters in your library or from TheMovieDB to show upcoming movies.  www.movieposterapp.com if you want to check it out. 

Anyway it uses basic http commands so I've gone ahead and have actually made a few different options for displaying different movie posters by name using voxcommando.  I"ll have a video of me doing this soon.  However I've come across a tricky one that I'm a little stumped on and looking for some ideas on how to make this work.  Here is my current command that I've created.


<?xml version="1.0" encoding="utf-16"?>
<!--VoxCommando 2.2.2.0-->
<commandGroup open="True" name="Show Times" enabled="True" prefix="" priority="0" requiredProcess="" description="">
  <command id="132" name="Add Showtime" enabled="true" alwaysOn="False" confirm="False" requiredConfidence="0" loop="False" loopDelay="0" loopMax="0" description="">
    <if ifBlockDisabled="False" ifNot="True">
      <ifType>(A)&lt;(B)</ifType>
      <ifParams>{5}&amp;&amp;</ifParams>
      <then>
        <action>
          <cmdType>Results.SetVar</cmdType>
          <params>
            <param>op1</param>
          </params>
          <cmdRepeat>1</cmdRepeat>
        </action>
      </then>
      <else>
        <action>
          <cmdType>Results.SetVar</cmdType>
          <params>
            <param>op1</param>
            <param>{5}</param>
          </params>
          <cmdRepeat>1</cmdRepeat>
        </action>
      </else>
    </if>
    <if ifBlockDisabled="False" ifNot="True">
      <ifType>(A)&lt;(B)</ifType>
      <ifParams>{6}&amp;&amp;</ifParams>
      <then>
        <action>
          <cmdType>Results.SetVar</cmdType>
          <params>
            <param>op2</param>
          </params>
          <cmdRepeat>1</cmdRepeat>
        </action>
      </then>
      <else>
        <action>
          <cmdType>Results.SetVar</cmdType>
          <params>
            <param>op2</param>
            <param>{6}</param>
          </params>
          <cmdRepeat>1</cmdRepeat>
        </action>
      </else>
    </if>
    <action>
      <cmdType>Scrape</cmdType>
      <params>
        <param>http://captainamerica:8082/showtimes.html?addShowtime({1},{2}%20{3}%20{4}%20{var.op1}%20{var.op2})</param>
      </params>
      <cmdRepeat>1</cmdRepeat>
    </action>
    <phrase>add poster showtime</phrase>
    <phrase optional="true">for</phrase>
    <payloadFromXML phraseOnly="False" use2partPhrase="False" phraseConnector="by" Phrase2wildcard="anyone" optional="False">XbmcPayloads\xbmcIMDB.xml</payloadFromXML>
    <payloadList>Tonight,Tomorrow,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday</payloadList>
    <payloadList optional="true">at</payloadList>
    <payloadRange>1,24</payloadRange>
    <payloadList optional="true">:15,:30,:45</payloadList>
    <payloadList>AM,PM</payloadList>
  </command>
</commandGroup>


I tried a few different ways of just passing the payload directly over in the command but the information wasn't passing along.  I've found that if I structure it this way I can get it to post almost 100% correct. Except when you don't use the option variables it tries to send stuff along that makes it break a bit.  Is there a way that if the variable isn't used that it just skips it?  Let me know if I am not explaining this correctly. 

Thanks @nime5ster

Yea, ever since I've gotten this installed and Ragnarok over at Cinemavision purchased this for me and I've purchased the beam I've been in integration heaven haha.  I have a few more things I'm working on and plan on doing the same with the writeup and video. 

I was unaware that I could hit that.  That will make doing these videos a lot easier if it gives me yellow so I don't have to keep trying . I don't get that very often but my luck it happened as I was recording haha. 

Anyway, thanks for the kind words and more to come!

My mistake, I thought you meant using the kodi music db which is the Music**.db file.

I see how you have simplified it. I appreciate that. Once I started digging into it originally the way I saw the data being used was with IDs which were not included so I needed to modify the file, once I figured out how to do it without the ID I didn't think to go back and change it.  I was happy it worked and wanted to share .  This is much more simplified and as you mentioned now requiring no need for modifications.  Seems I need to make an updated video.  I actually had been tweaking the phrases myself and came up with the same thing you did actually.  I originally tried to do phrase only but I must of done something wrong because it did not work.  I've updated that now and see it working. 

I never knew why the {1} was in the name but thanks for that little tidbit.  That is definitely a helpful piece of information.  I'm downloading the latest version of voxcommando now and installing it.  Thanks again for the help.  I've put your simplified info in the original post

Hey JitterJames,

Thanks for the compliments! It's fun

Thats my fault, I typed out the filenames and I'll go ahead and fix the original post.  Thanks for catching that.  I've posted to the plugin thread showing this.  I wonder if he would be willing to add the information to the local database that is created and update the GoogleMusicStorage.py .  I could possibly submit this to his github. 

I'd be curious if you find that out.  I think you can sync it to the local library.  I didn't play much with it but if you find something let me know.  I just know when I looked it was always pointing to its own database.  Any other tips you have for this stuff I'd be glad to hear it!  I have another integration I'm working on completing with a program called MoviePosterApp .

Hello Everyone,
**I want to preface this with thanking JitterJames for helping simplify this integration without the need for modifying the plugin like I originally thought**

Just thought I'd post up what I had been working on the past couple days.  I've been a huge user of google music and most recently using it within Kodi.  You can find the plugin for Kodi here:

http://forum.kodi.tv/showthread.php?tid=200640

While installing and setting up the plugin I noticed it had a local db called googlemusic.db .  Knowing that within the xSql plugin we can generate payloads using these database files an idea was born. 

Here is the SQL queries used to generate the 4 payload files needed. 

Custom   select playlist_id, name from playlists                                                    gmusicplaylist   False
Custom   select distinct album from songs                                                            gmusicalbum   True
Custom   select ('song_id='||song_id||'&artistart='||artistart), title from songs    gmusicsong   False
Custom   select distinct artist from songs                                                                    gmusicartist   True

The artist and album payloads are phrase only files while the other 2 are value / phrase.

If you are using the custom db field on the plugin update to the latest VoxCommando just recently uploaded by JitterJames which includes fixes to the xSql plugin. 

Once you generate your payloads here is the 4 commands to use.  Thanks to JitterJames again for making these a little more smooth.


<?xml version="1.0" encoding="utf-16"?>
<!--VoxCommando 2.2.2.0-->
<commandGroup open="True" name="Kodi GMusic" enabled="True" prefix="" priority="0" requiredProcess="" description="">
  <command id="434" name="Play Google Playlist {1}" enabled="true" alwaysOn="False" confirm="False" requiredConfidence="0" loop="False" loopDelay="0" loopMax="0" description="">
    <action>
      <cmdType>XJson.Raw</cmdType>
      <params>
        <param>Player.Open</param>
        <param>"item":{"file":"plugin://plugin.audio.googlemusic.exp/?action=play_all&amp;playlist_id={1}&amp;shuffle=true"}</param>
      </params>
      <cmdRepeat>1</cmdRepeat>
    </action>
    <phrase optional="true">play</phrase>
    <phrase>google playlist</phrase>
    <payloadFromXML phraseOnly="False" use2partPhrase="False" phraseConnector="by" Phrase2wildcard="anyone" optional="False">XbmcPayloads\gmusicplaylist.xml</payloadFromXML>
  </command>
  <command id="417" name="Play Google Artist {1}" enabled="true" alwaysOn="False" confirm="False" requiredConfidence="0" loop="False" loopDelay="0" loopMax="0" description="">
    <action>
      <cmdType>XJson.Raw</cmdType>
      <params>
        <param>Player.Open</param>
        <param>"item":{"file":"plugin://plugin.audio.googlemusic.exp/?action=play_all&amp;filter_type=artist&amp;filter_criteria={1}&amp;shuffle=true"}</param>
      </params>
      <cmdRepeat>1</cmdRepeat>
    </action>
    <phrase optional="true">play</phrase>
    <phrase>google artist</phrase>
    <payloadFromXML phraseOnly="True" use2partPhrase="False" phraseConnector="by" Phrase2wildcard="anyone" optional="False">XbmcPayloads\gmusicartist.xml</payloadFromXML>
  </command>
  <command id="407" name="Play Google Album {1}" enabled="true" alwaysOn="False" confirm="False" requiredConfidence="0" loop="False" loopDelay="0" loopMax="0" description="">
    <action>
      <cmdType>XJson.Raw</cmdType>
      <params>
        <param>Player.Open</param>
        <param>"item":{"file":"plugin://plugin.audio.googlemusic.exp/?action=play_all&amp;filter_type=album&amp;filter_criteria={1}"}</param>
      </params>
      <cmdRepeat>1</cmdRepeat>
    </action>
    <phrase optional="true">play</phrase>
    <phrase>google album</phrase>
    <payloadFromXML phraseOnly="True" use2partPhrase="False" phraseConnector="by" Phrase2wildcard="anyone" optional="False">XbmcPayloads\gmusicalbum.xml</payloadFromXML>
  </command>
  <command id="423" name="Play Google Song {1}" enabled="true" alwaysOn="False" confirm="False" requiredConfidence="0" loop="False" loopDelay="0" loopMax="0" description="">
    <action>
      <cmdType>XJson.Raw</cmdType>
      <params>
        <param>Player.Open</param>
        <param>"item":{"file":"plugin://plugin.audio.googlemusic.exp/?action=play_song&amp;{1}"}</param>
      </params>
      <cmdRepeat>1</cmdRepeat>
    </action>
    <phrase optional="true">play</phrase>
    <phrase>google</phrase>
    <phrase>song, track</phrase>
    <payloadFromXML phraseOnly="False" use2partPhrase="False" phraseConnector="by" Phrase2wildcard="anyone" optional="False">XbmcPayloads\gmusicsong.xml</payloadFromXML>
  </command>
</commandGroup>


Here is a video demonstration of how it is working. 

https://www.youtube.com/embed/-bu1DWaIdY0

Feel free to ask any questions!

Hey JitterJames,

Apologize, yea I meant to the plugin for google music. It wasn't pulling everything that I needed to the local database it creates.  There doesn't seem to be much rhyme or reason to how he has it.  There's 2 tables for songs.......so yea. 

Hey JitterJames, thanks for the new .dll, I've verified that this now works.  I'm close to finishing the integration and will post it up once I am done.  I had to also make some changes to the plugin itself but only one file to pull the required data but it's working great!!

Hello, so I've been playing around with the google music plugin on Kodi and it has a local database.  I'm looking to pull some information out of it however when I set it as a custom db using the xSQL plugin and pointed the custom line to that database. However it seems when I hit generate it doesn't work.  I verified that my select statement does work by placing the database in the music line of the plugin and then hit save and generate and it then generated with no issues.  Is there an issue with selecting custom from the dropdown? 

Once I have the googlemusic working I'll post it up for those who want it.  Right now I have it working and playing a playlist or a single song.   I'm working on submitting a search to display the results on the screen and playing albums but the plugin doesn't pull that information to its local db just yet.  I've reached out to the developer of the plugin to see if we can pull that information.  This will be a nice alternative to local media.

Hey Fuzzy, mind sharing what you did with me either here or PM?  If I can move this to one of my other VMs instead of running a full blown windows 10 machine like I have it running on now.  Still tweaking with the best way to run this.

Hello, if you are still looking for Beta testers I would be very very interested in becoming a tester.  This is actually something I was looking at doing with a group of friends but if this already created I'd love to support great work!