Gamelist Excel export script

mostym · 7 Mar 2019, 19:38

@mitu What are the permissions supposed to be? Are these set correctly?

drwxr-xr-x   4 pi   pi    69632 May 24  2018 mame-mame4all
drwxr-xr-x   2 pi   pi     4096 May 24  2018 markiii
drwxr-xr-x   2 pi   pi    20480 May 24  2018 mastersystem
drwxr-xr-x   4 pi   pi     4096 May 24  2018 megadrive
drwxr-xr-x   2 pi   pi     4096 May 24  2018 megadrive-japan
drwxr-xr-x   2 pi   pi     4096 May 24  2018 msk2+
drwxr-xr-x   2 pi   pi    36864 May 24  2018 msx
drwxr-xr-x   2 pi   pi    20480 May 24  2018 msx2
drwxr-xr-x   2 pi   pi    36864 May 24  2018 n64
drwxr-xr-x   2 pi   pi     4096 May 24  2018 nds
drwxr-xr-x   3 pi   pi    12288 May 31  2018 neogeo
drwxr-xr-x   8 pi   pi     4096 May 24  2018 nes
drwxr-xr-x   2 pi   pi     4096 May 24  2018 nesclassic
drwxr-xr-x   2 pi   pi     4096 May 24  2018 nesh
drwxr-xr-x   2 pi   pi     4096 May 24  2018 ngp
drwxr-xr-x   2 pi   pi    16384 May 24  2018 ngpc
drwxr-xr-x   2 pi   pi    12288 May 24  2018 oddyse
drwxr-xr-x   5 pi   pi     4096 May 24  2018 Oddysey2
drwxr-xr-x  45 pi   pi     4096 May 24  2018 pc
drwxr-xr-x   4 pi   pi     4096 May 31  2018 pcengine
drwxr-xr-x   2 pi   pi     4096 May 24  2018 pcenginecd
drwxr-xr-x   3 pi   pi     4096 May 24  2018 playchoice
drwxr-xr-x   8 pi   pi     4096 May 22  2018 ports
drwxr-xr-x   2 pi   pi     4096 May 22  2018 psp
drwxr-xr-x   2 pi   pi     4096 May 24  2018 pspminis
drwxr-xr-x 112 pi   pi     4096 May 24  2018 psx
drwxr-xr-x   2 pi   pi     4096 May 24  2018 psx (only use this if you have Scott's PBP set)
drwxr-xr-x   2 pi   pi     4096 May 24  2018 sc-3000
drwxr-xr-x  17 pi   pi     4096 May 24  2018 scummvm
drwxr-xr-x   2 pi   pi     4096 May 24  2018 sega32x
drwxr-xr-x   2 pi   pi     4096 May 24  2018 segacd
drwxr-xr-x   2 pi   pi     4096 May 24  2018 sfc
drwxr-xr-x   5 pi   pi     4096 May 24  2018 sg-1000
drwxr-xr-x   2 pi   pi     4096 May 24  2018 sgfx
drwxr-xr-x  10 pi   pi     4096 May 24  2018 snes
drwxr-xr-x   2 pi   pi     4096 May 24  2018 snesclassic
drwxr-xr-x   2 pi   pi     4096 May 24  2018 snesh
drwxr-xr-x   2 pi   pi    94208 May 24  2018 superfamicom
drwxr-xr-x   2 pi   pi     4096 May 24  2018 tg16
drwxr-xr-x   2 pi   pi     4096 May 24  2018 tg16cd
drwxr-xr-x   7 pi   pi     4096 May 24  2018 vectrex
drwxr-xr-x   2 pi   pi     4096 May 24  2018 vic20
drwxr-xr-x   2 pi   pi     4096 May 24  2018 videopac
drwxr-xr-x   2 pi   pi     4096 May 24  2018 videopac2
drwxr-xr-x   2 pi   pi     4096 May 24  2018 virtualboy
drwxr-xr-x   3 pi   pi     4096 May 24  2018 vs
drwxr-xr-x   2 pi   pi    12288 May 24  2018 wonderswan
drwxr-xr-x   2 pi   pi    12288 May 24  2018 wonderswancolor
drwxr-xr-x   2 pi   pi     4096 May 24  2018 zmachine
drwxr-xr-x  60 pi   pi     4096 May 24  2018 zxspectrum

mitu · 7 Mar 2019, 19:40

@mostym The permissions seem to be find on your ROM folders. How did you install your RetroPie system ?

mostym · 7 Mar 2019, 19:42

@mitu I installed it using rufus and the retropie image.

mitu · 7 Mar 2019, 19:46

@mostym Well, then beats me - the script will not work if your gamelist.xml are empty, so if you solve that, you'll make it work.

mostym · 7 Mar 2019, 19:47

@mitu I also just noticed that the PARSE GAMELISTS ONLY option is off. I don't know if that matters or not.

mitu · 7 Mar 2019, 19:51

@mostym That's ok, the option tells Emulationstation to ignore the ROMs folders contents and show only what you have registered in gamelist.xml. In your case, that would be nothing, since your files are empty.

mostym · 3 Jul 2019, 19:53

@mitu I see. What about

 -rwxr-xr-x  1 pi pi   35 May 22  2018 gamelist.xml

is that permission correct?

mitu · 7 Mar 2019, 20:02

@mostym The permission seems fine. Did you restart at least once Emulationstation since you installed it ? I see in the log the configuration of the controller, which usually happens on the 1st install.

mostym · 7 Mar 2019, 20:12

@mitu I just restarted it, and tried running the script and the same error occurred.

mitu · 7 Mar 2019, 20:15

@mostym Sorry, but the problem is somewhere else. Did you use the RetroPie supplied image from retropie.org.uk/download or another image ?

mostym · 7 Mar 2019, 20:19

@mitu I downloaded it from the retropie download page, yes.

ppuspfc · 21 Apr 2019, 18:03

I am interested in this work. Congratulations

FetusSandwich · 18 Apr 2020, 14:39

@mitu Hopefully you don't mind me resurrecting this thread, as this was an amazing tool when it was working for me and I think more people in the RetroPie need visibility into your awesome work.

Problem for me now is that: it was working for me, but now it has stopped running, and I'm completely unsure as to why.

Here is the error at the end of the script. It seems to get through all gamelists with no errors, then provides me with:

Traceback (most recent call last):
  File "export.py", line 583, in <module>
    systems = parse_systems()
  File "export.py", line 261, in parse_systems
    gamelist = et.parse(gamelist_path)
  File "/usr/lib/python2.7/xml/etree/ElementTree.py", line 1182, in parse
    tree.parse(source, parser)
  File "/usr/lib/python2.7/xml/etree/ElementTree.py", line 656, in parse
    parser.feed(data)
  File "/usr/lib/python2.7/xml/etree/ElementTree.py", line 1653, in feed
    self._raiseerror(v)
  File "/usr/lib/python2.7/xml/etree/ElementTree.py", line 1517, in _raiseerror
    raise err
xml.etree.ElementTree.ParseError: not well-formed (invalid token): line 564, column 32

Any troubleshooting or insight you could provide here would be greatly appreciated. Thanks!

mitu · 18 Apr 2020, 16:14

@FetusSandwich Run it with --debug and see where it stops. Looks like an issue with a malformed gamelist.xml file.

FetusSandwich · 12 Jun 2020, 13:47

@mitu Thanks for your help on this, mitu.

I was indeed able to get this script running eventually and found my way eventually with error logs to the problem child gamelist. What a lifesaver this thing is...

Thanks for the help.

bgennette · 21 Dec 2020, 23:55

Just one tiny (or two) things to add ...

You must 'cd' back to the /home/pi/retropie directory to run the 'export.py' script,
otherwise it won't be found.

And speaking of finding ... the list will be at /home/pi/retropie/RetroPie/roms/export_list.xlsx

bye.

2Play · 27 Jan 2021, 20:22

@mitu
thank you for the py script!

I got from git the latest gamelist.py . i fixed an error found in one list (had &)

my case the error is below

2021-01-27 20:19:47,680 INFO   Exporting to file /home/pi/RetroPie/roms/export_list.xlsx
Traceback (most recent call last):
  File "gamelist.py", line 600, in <module>
    xlsx_export_workbook(systems, output, collections)
  File "gamelist.py", line 416, in xlsx_export_workbook
    string="{0} ({1})".format(s.info['fullname'], s.info['name'])
UnicodeEncodeError: 'ascii' codec can't encode character u'\xd6' in position 1: ordinal not in range(128)

My locale is all set to US UTF8, latest Raspbian OS updates, pi4

mitu · 27 Jan 2021, 20:29

@2play If you provide the offending gamelist.xml, I can attempt to add a fix to the script.

2Play · 28 Jan 2021, 12:04

@mitu I cant find a bad xml
I also replaced few 'Ö' (no other 'Ö', 'ğ', 'Ş', Ç')
re run and get same result. I googled the error:
'ascii' codec can't encode character u'\xd6'
and most pointers relate to how python converts things. And that this was fixed on Python3!
Ive exported full run if helps
https://pastebin.com/11GS3ZS5

Lolonois · 28 Jan 2021, 16:31

@2play From the distance: I assume your ~/.emulationsstation/es_systems.cfg contains a non ASCII character (Ö). Have a look there.
If you want to keep your O-umlaut, maybe adding a declaration to the es_systems.cfg is honored by the XML parser(elementree), so add <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> and give it a try.

HTH