Thanks James, the XML you created works great.

Apologies for the confusion. To make the play movies macro work I went to the settings on the xMySQL plugin and in the OutPut (XML Payloads) section I modified the database myvideos75 for myvideos78 saved it and generated the XMLs again. Play Movie uses xbmcMoviesIDs.xml

The Find Movie Macro seems to use a different XML (xbmcMovies.xml) which on my file has these type of lines

Value
dav://user:pass@NAS_IP:port/Movies/2%20Guns.mp4

Pharases
2 Guns

From what little I understand at this point the macro seems to create a playlist 'on the fly' with the name of the movie you provide (attached picture). On that macro, if I replace the {2} by {1} the playlist gets created and finds the movie Ok, but If I leave it as {2} it doesn't seems to work.

Looking at the video I found that I had the Video DB set to myvideos75 and looking into the MySQL DB I found the highest number was myvideos78. After I modified that value and regenerating the XMLs I was able to play the movies by name.

The Find Movie macro was not working and the macro looks quite a bit more complex. It had this value in the first line

XJson.SmartPL smart\MoviebyName.xsp {2}

If I change the {2} by {1} the macro seems to work most of the time. Is that correct or I am doing something wrong by modifying that value?

I just installed VC. I have XBMC Gotham playing my movies from a Synology NAS and a central MySQL DB running on the main home computer.

I installed the MySQL plugin and I ran the GenXML and I can see that the xbmcMovieIDs.xml is now populated. When I say Play Movie The Avengers I get acknowledgment on the XBMC interface that the command was received correctly and displays "1 Play Movie {The Avengers}" at the top of the screen but nothing happens.

the movie plays fine manually. The macro shows XJason.Raw Player.Open "item": {"movieid": {1}} for that command

Any help will be much appreciated.