Easy way to add video and marquees tags in your gamelist for video support.

duiz

I'm not getting this to work unfortunately. I followed each step in the first post but powershell gives me this in return

"C:\Users\duiz.emulationstation\addvideos\addvideomarquees.ps1 : File C:\Users\duiz.emulationstation\addvideos\addvide
omarquees.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about_Exec
ution_Policies at http://go.microsoft.com/fwlink/?LinkID=135170.
At line:1 char:1

C:\Users\duiz.emulationstation\addvideos\addvideomarquees.ps1

  + CategoryInfo          : SecurityError: (:) [], PSSecurityException
  + FullyQualifiedErrorId : UnauthorizedAccess"

My ps1 file looks like this
$doc = [xml] (Get-Content -raw gamelist.xml)

foreach ($gameEl in $doc.DocumentElement.game) {

Use -replace to extract the filename without extension from the

path contained in the <path> element.

$gameName = $gameEl.path -replace '^./(.)..*$', '$1'

Append elements 'video' and 'marquee', but only if they don't already

exist.

if ($null -eq $gameEl.video) {
$gameEl.AppendChild($doc.CreateElement('video')).InnerText = "./videos/${gameName}.mp4"
}
if ($null -eq $gameEl.marquee) {
$gameEl.AppendChild($doc.CreateElement('marquee')).InnerText = "./marquees/${gameName}.png"
}
}
rename-item gamelist.xml -newname oldgamelist.xml
$writer = [System.IO.StreamWriter] "gamelist.xml"
$doc.Save($writer)
$writer.Close()

Nismo

@duiz Try this:

1- Open a text document and place this inside:

powershell -ExecutionPolicy ByPass -File addvideomarquees.ps1

Make sure the name of .ps1 file is the same than in the code above and save changes.

2- Rename the .txt extension to .bat

3- Place it in the same folder than addvideomarquees.ps1 and do right click on the .bat file and select " exec as administrator".

Tell me if it works. I hope so.

duiz

@Nismo It worked! Thanks! Now everything adds perfectly

Nismo

@duiz Nice, I'm glad to help. I'll add this to the first post.

matchaman

On Windows 7 I used your latest edit of the code and I'm getting this:

I tried on several different folders and it didn't work, the path is on F:\SNES 852, no "funny" characters.

Nismo

@matchaman
Why you edited the script? Why you don't use the default path of the script? Can you post your script?

matchaman

I didn't edit the script at all, the only thing different is that I named it generator.ps1

I have my gamelist.xml and my files located in F:\SNES 852 (should I use something else in particular?)

Here is the exact code I use:

$doc = [xml] (Get-Content -raw gamelist.xml)

foreach ($gameEl in $doc.DocumentElement.game) { 
  # Use -replace to extract the filename without extension from the 
  # path contained in the <path> element.
  $gameName = $gameEl.path -replace '^.*/(.*)\..*$', '$1'
  # Append elements 'video' and 'marquee', but only if they don't already
  # exist.
  if ($null -eq $gameEl.video) {
    $gameEl.AppendChild($doc.CreateElement('video')).InnerText = "./videos/${gameName}.mp4"
  }
  if ($null -eq $gameEl.marquee) {
    $gameEl.AppendChild($doc.CreateElement('marquee')).InnerText = "./marquees/${gameName}.png"
  }
}
rename-item gamelist.xml -newname oldgamelist.xml
$writer = [System.IO.StreamWriter] "gamelist.xml"
$doc.Save($writer)
$writer.Close()

As for my gamelist.xml file, it's formatted as:

<gameList>
	<game>
		<path>./2020 Super Baseball (USA).zip</path>
		<name>2020 Super Baseball (USA)</name>
		<image>./images/2020 Super Baseball (USA).png</image>
	</game>
	<game>
		<path>./3 Ninjas Kick Back (USA).zip</path>
		<name>3 Ninjas Kick Back (USA)</name>
		<image>./images/3 Ninjas Kick Back (USA).png</image>
	</game>
	<game>
		<path>./7th Saga, The (USA).zip</path>
		<name>7th Saga, The (USA)</name>
		<image>./images/7th Saga, The (USA).png</image>
	</game>
	<game>
		<path>./90 Minutes - European Prime Goal (Europe).zip</path>
		<name>90 Minutes - European Prime Goal (Europe)</name>
		<image>./images/90 Minutes - European Prime Goal (Europe).png</image>
	</game>
	<game>
		<path>./A.S.P. - Air Strike Patrol (USA).zip</path>
		<name>A.S.P. - Air Strike Patrol (USA)</name>
		<image>./images/A.S.P. - Air Strike Patrol (USA).png</image>
	</game>
	<game>
		<path>./ABC Monday Night Football (USA).zip</path>
		<name>ABC Monday Night Football (USA)</name>
		<image>./images/ABC Monday Night Football (USA).png</image>
	</game>
...and so on until </gameList>

When I run the script, I briefly get that error window I managed to capture (after many attempts) and a new gamelist.xml that's 0 bytes and of course the backup one untouched.

Nismo

@matchaman try to place your gamelist and the script at root o C: and run it there.

What operating system do you have?

matchaman

Same result when placed on C: :( I am using Windows 7

This is the error I'm getting on the root directory:

Edit: OK, after shortening the list to a few games, the output is normal. Some character within the ROM names is causing this! Tonight I'll do a lot of trial and error and locate the little devil!

matchaman

Sorry about the double post but I'll have to bump it in order to inform you that the symbol & in names causes the aforementioned problem.

Probably explains why some users experience difficulties with certain systems while others process without any issue. How can this be fixed?

Edit: I replaced &with & as this appears to give the same result while it's safe for the script. I hope I helped :)

PsyKos

Hello and thanks for this but... it doesn't work for me. I have test with Windows 7 Pro, Windows 8.1u1 and Windows 10 Pro.

Work with Windows 8.1u1, everything was OK but I install Windows 10 yesterday and it doesn't work now... :(

Error message :

0_1493456316812_Sans titre.jpg

Thanks for your help :)

Nismo

@PsyKos

I have windows 10 and it works perfectly for me, I don't understand very well the french message, but it seems there are some problem with one of your games in your original gamelist.

It's the entry after yumimi mix (japan).cue, try to take a copy of your original gamelist, then delete that entry after yumimi mix and test again if all it's working, if not, send me your gamelist and I'll try to do it here.

If it works, then enter that entry by hand.

Maybe, reading the name, you have japanesse characters??

Try what i said to you, if doesn't work upload your gamelist.xml somewhere so I can check what's the problem.

Regards.

PsyKos

Yes, it work perfectly :)

Sorry, it was my fault. On gamelist.xml, I have <rating>/rating> in line 1236 (like see in error code...). Replace with right arguments and work :)

Thousand sorry about this !!! And great works for this script help me very well !

brian_

Nismo: Thanks for making this, really helped along with the oldroom info.

If you get to the end of the process and either forgot to set up the proper paths for gamelist.xml or didn't know how or whatever you can still fix it after you copy the gameslist over to the pi by using sed like this in vim"

:%s/\.\//\~\/RetroPie\/roms\/nes\//g

Changes ./ into ~/Retropie/roms/nes/

Also to anyone new confused (like me) about fastscraper and fatmatch: fastscraper is referring to sselph's scraper. For fatmatch it doesn't seem to be included in anything. Just google it, you will see references to a 0.3 version. That's what he's talking about.

fabio78

This was a godsend. Thank you, Nismo!

lordhellbr

If your gamelist.xml have European characters like "ã ñ é ó ç", change the first line to this: (or your xml will be weird characters instead of the correct ones)

$doc = [xml] (Get-Content -raw -Encoding UTF8 gamelist.xml)

Anyway thanks @Nismo for this great script.

DocGoodsoup

I just subscribe to the forum to thanks @Nismo for this great script and also @lordhellbr (before that I was forced to change by hand every accent). You both save me a lot of time :)

paffley

Hi, I realise this is an old post but I thought I'd try to revive it by asking for a command help to run in windows PowerShell.

I've noticed some users on the forum asking for a 'release date' modification, changing the release date from, e.g 18/10/1985 to simply just 1985 and thought this could maybe be done with windows powershell.

Standard format for the gamelist.xml
<releasedate>19851018T000000</releasedate> (note the first 4 digits)

to be turned into...
<releasedate>1985</releasedate>

I just wondered if this was possible using WPS and maybe having the option of adding an if statement of 'if no date found' add '19xx' to the release date tag inside the xml?

Thanks :)