RetroPie forum home
    • Recent
    • Tags
    • Popular
    • Home
    • Docs
    • Register
    • Login

    Gamelist Excel export script

    Scheduled Pinned Locked Moved Ideas and Development
    emulationstatioexportgamelist
    126 Posts 19 Posters 30.1k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • D
      detron
      last edited by

      @mitu

      I decided to run your amazing export tool again (have not ran it since you first made it), and it seems to be failing.

      not sure if you still work on this or not.

      below is what returned, and I did try it with and without a "sudo".

      thank you either way.

      pi@retropie:~ $ python export.py /home/pi/RetroPie/roms/export_list.xlsx
      2019-01-01 23:28:33,368 INFO Emulationstation systems file used: /etc/emulationstation/es_systems.cfg
      2019-01-01 23:29:11,228 INFO System RetroPie is skipped as configured
      Traceback (most recent call last):
      File "export.py", line 591, in <module>
      systems = parse_systems()
      File "export.py", line 264, 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 9062, column 24

      1 Reply Last reply Reply Quote 0
      • D
        detron
        last edited by

        @mitu

        I should add this is a new 4.4 build on a raspberry Pi 3B+
        any other data that might be useful, I will happily grab it for you

        mituM 1 Reply Last reply Reply Quote 0
        • mituM
          mitu Global Moderator @detron
          last edited by

          @detron I'm certainly interested in fixing any errors, so can you please run the export with the -d option and then paste the error log on pastebin.com ? It must be something in one of the gamelist.xml that's unhandled.

          1 Reply Last reply Reply Quote 0
          • D
            detron
            last edited by

            @mitu

            thank you. I will do that later today.

            I appreciate your help

            1 Reply Last reply Reply Quote 0
            • D
              detron
              last edited by

              @mitu

              error (link to pastebin)

              error text

              2019-01-02 17:08:18,944 DEBUG  Analyzing system: Super Famicom Disk System (sfc)
2019-01-02 17:08:18,945 DEBUG  Gamelist for sfc is read from /home/pi/RetroPie/roms/sfc/gamelist.xml
Traceback (most recent call last):
  File "export.py", line 591, in <module>
    systems = parse_systems()
  File "export.py", line 264, 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 9062, column 24


I looked all over for a log file, but found none.  if there is one and you want it, just let me know where it is.

thank you for your help.
              mituM 1 Reply Last reply Reply Quote 0
              • mituM
                mitu Global Moderator @detron
                last edited by mitu

                @detron said in Gamelist Excel export script:

                parse_systems

                I think your gamelist.xml file for the SFC system is not a well formed XML document. The error is at line 9062. You can upload the file also to pastebin.com (if it's not too large for them) or pastebin.ubuntu.com so I can take a look.

                1 Reply Last reply Reply Quote 0
                • D
                  detron
                  last edited by

                  @mitu

                  I do not even have any sfc roms, so I removed it, and it worked as expected.

                  it was too big for pastebin, but here is a link to the prebuilt sfc gamelist file if you are curious

                  sfc gamelist on google drive

                  again, thank you for your help.

                  mituM 1 Reply Last reply Reply Quote 0
                  • mituM
                    mitu Global Moderator @detron
                    last edited by

                    @detron OK, glad it worked. For the record, at line 9062 is an incorrect XML fragment

                    <path>./Dragon Quest I & II (Japan) (Translated En).7z</path>

                    The & character is a special character in XML and cannot be used as is.

                    D 1 Reply Last reply Reply Quote 0
                    • D
                      detron @mitu
                      last edited by

                      @mitu said in Gamelist Excel export script:

                      @detron OK, glad it worked. For the record, at line 9062 is an incorrect XML fragment

                      <path>./Dragon Quest I & II (Japan) (Translated En).7z</path>

                      The & character is a special character in XML and cannot be used as is.

                      Ahh,

                      thank you for your help. I love this script!

                      I understand how csv can be exported, but how do you create an Excel tab? that to me is just magic. lol

                      1 Reply Last reply Reply Quote 0
                      • papinistP
                        papinist
                        last edited by

                        In excel, click on 'data' tab, then'load external data" "from text", select your .csv file and then choose if you have a delimiter character or fixed lenght data.
                        (I'm not sure about the exact command names since my excel is not in english :) )

                        D 1 Reply Last reply Reply Quote 0
                        • D
                          detron @papinist
                          last edited by

                          @papinist said in Gamelist Excel export script:

                          In excel, click on 'data' tab, then'load external data" "from text", select your .csv file and then choose if you have a delimiter character or fixed lenght data.
                          (I'm not sure about the exact command names since my excel is not in english :) )

                          @papinist

                          thank you, but I mean make Excel tabs when not in Excel, like this script does.

                          1 Reply Last reply Reply Quote 0
                          • papinistP
                            papinist
                            last edited by

                            Oh, I just forgot that the script outputs directly excel tabs! You are right, seems like magic :)

                            D 1 Reply Last reply Reply Quote 0
                            • D
                              detron @papinist
                              last edited by

                              @papinist

                              I still appreciate the willingness to help.

                              thank you.

                              (yes, it is like magic)

                              1 Reply Last reply Reply Quote 0
                              • M
                                mostym
                                last edited by mostym

                                Hey there. I'm getting the following error:

                                2019-03-02 18:36:09,330 INFO   Exporting to file /home/pi/RetroPie/roms/export_list.xlsx
Traceback (most recent call last):
  File "export.py", line 600, in <module>
    xlsx_export_workbook(systems, output, collections)
  File "export.py", line 342, in xlsx_export_workbook
    raise "Exported system list is empty"
TypeError: exceptions must be old-style classes or derived from BaseException, not str
                                mituM 2 Replies Last reply Reply Quote 0
                                • mituM
                                  mitu Global Moderator @mostym
                                  last edited by

                                  @mostym It's probably because of you have an empty collection. I'll take a look - should be fixable.

                                  1 Reply Last reply Reply Quote 0
                                  • mituM
                                    mitu Global Moderator @mostym
                                    last edited by

                                    @mostym I checked and the error is raised when no ES systems are detected on your installation. Are you running Emulationstation or Attract Mode ?

                                    M 1 Reply Last reply Reply Quote 0
                                    • M
                                      mostym @mitu
                                      last edited by

                                      @mitu I'm running Emulationstation. Sorry for the late response, I didn't get notified of a response.

                                      mituM 1 Reply Last reply Reply Quote 0
                                      • mituM
                                        mitu Global Moderator @mostym
                                        last edited by

                                        @mostym That's weird then - can you post your es_systems.cfg file ? What version of Emulationstation are you running ?

                                        1 Reply Last reply Reply Quote 0
                                        • M
                                          mostym
                                          last edited by mostym

                                          @mitu i'm running version 4.4.1

                                          <?xml version="1.0"?>
<systemList>
  <system>
    <name>amiga</name>
    <fullname>Commodore Amiga</fullname>
    <path>/home/pi/RetroPie/roms/amiga</path>
    <extension>.adf .adz .dms .ipf .uae .zip .sh .ADF .ADZ .DMS .IPF .UAE .ZIP .SH</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ amiga %ROM%</command>
    <platform>amiga</platform>
    <theme>amiga</theme>
  </system>
  <system>
    <name>amstradcpc</name>
    <fullname>Amstrad CPC</fullname>
    <path>/home/pi/RetroPie/roms/amstradcpc</path>
    <extension>.cdt .cpc .dsk .CDT .CPC .DSK</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ amstradcpc %ROM%</command>
    <platform>amstradcpc</platform>
    <theme>amstradcpc</theme>
  </system>
  <system>
    <name>apple2</name>
    <fullname>Apple II</fullname>
    <path>/home/pi/RetroPie/roms/apple2</path>
    <extension>.po .dsk .nib .PO .DSK .NIB</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ apple2 %ROM%</command>
    <platform>apple2</platform>
    <theme>apple2</theme>
  </system>
  <system>
    <name>arcade</name>
    <fullname>Arcade</fullname>
    <path>/home/pi/RetroPie/roms/arcade</path>
    <extension>.7z .fba .zip .7Z .FBA .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ arcade %ROM%</command>
    <platform>arcade</platform>
    <theme>arcade</theme>
  </system>
  <system>
    <name>atari2600</name>
    <fullname>Atari 2600</fullname>
    <path>/home/pi/RetroPie/roms/atari2600</path>
    <extension>.a26 .bin .rom .zip .7z .gz .A26 .BIN .ROM .ZIP .7Z .GZ</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ atari2600 %ROM%</command>
    <platform>atari2600</platform>
    <theme>atari2600</theme>
  </system>
  <system>
    <name>atari5200</name>
    <fullname>Atari 5200</fullname>
    <path>/home/pi/RetroPie/roms/atari5200</path>
    <extension>.a52 .bin .A52 .BIN</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ atari5200 %ROM%</command>
    <platform>atari5200</platform>
    <theme>atari5200</theme>
  </system>
  <system>
    <name>atari7800</name>
    <fullname>Atari 7800 ProSystem</fullname>
    <path>/home/pi/RetroPie/roms/atari7800</path>
    <extension>.a78 .bin .zip .7z .A78 .BIN .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ atari7800 %ROM%</command>
    <platform>atari7800</platform>
    <theme>atari7800</theme>
  </system>
  <system>
    <name>atari800</name>
    <fullname>Atari 800</fullname>
    <path>/home/pi/RetroPie/roms/atari800</path>
    <extension>.bas .bin .car .com .xex .atr .xfd .dcm .atr.gz .xfd.gz .BAS .BIN .CAR .COM .XEX .ATR .XFD .DCM .ATR.GZ .XFD.GZ</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ atari800 %ROM%</command>
    <platform>atari800</platform>
    <theme>atari800</theme>
  </system>
  <system>
    <name>atarilynx</name>
    <fullname>Atari Lynx</fullname>
    <path>/home/pi/RetroPie/roms/atarilynx</path>
    <extension>.lnx .zip .7z .LNX .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ atarilynx %ROM%</command>
    <platform>atarilynx</platform>
    <theme>atarilynx</theme>
  </system>
  <system>
    <name>atarist</name>
    <fullname>Atari ST/STE</fullname>
    <path>/home/pi/RetroPie/roms/atarist</path>
    <extension>.st .stx .img .rom .raw .ipf .ctr .ST .STX .IMG .ROM .RAW .IPF .CTR</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ atarist %ROM%</command>
    <platform>atarist</platform>
    <theme>atarist</theme>
  </system>
  <system>
    <name>c64</name>
    <fullname>Commodore 64</fullname>
    <path>/home/pi/RetroPie/roms/c64</path>
    <extension>.crt .d64 .g64 .prg .t64 .tap .x64 .zip .7z .vsf .CRT .D64 .G64 .PRG .T64 .TAP .X64 .ZIP .7Z .VSF</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ c64 %ROM%</command>
    <platform>c64</platform>
    <theme>c64</theme>
  </system>
  <system>
    <name>classicnes</name>
    <fullname>NES Classic</fullname>
    <path>/home/pi/RetroPie/roms/nesclassic</path>
    <extension>.7z .nes .zip .7Z .NES .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ nes %ROM%</command>
    <platform>nes</platform>
    <theme>nesclassic</theme>
  </system>
  <system>
    <name>classicsnes</name>
    <fullname>SNES Classic</fullname>
    <path>/home/pi/RetroPie/roms/snesclassic</path>
    <extension>.7z .bin .smc .sfc .fig .swc .mgd .zip .7Z .BIN .SMC .SFC .FIG .SWC .MGD .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ snes %ROM%</command>
    <platform>snes</platform>
    <theme>snesclassic</theme>
  </system>
  <system>
    <name>coco</name>
    <fullname>TRS-80 Color Computer (CoCo)</fullname>
    <path>/home/pi/RetroPie/roms/coco</path>
    <extension>.cas .wav .bas .asc .dmk .jvc .os9 .dsk .vdk .rom .ccc .sna .CAS .WAV .BAS .ASC .DMK .JVC .OS9 .DSK .VDK .ROM .CCC .SNA</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ coco %ROM%</command>
    <platform>coco</platform>
    <theme>coco</theme>
  </system>
  <system>
    <name>coleco</name>
    <fullname>ColecoVision</fullname>
    <path>/home/pi/RetroPie/roms/coleco</path>
    <extension>.bin .col .rom .zip .BIN .COL .ROM .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ coleco %ROM%</command>
    <platform>colecovision</platform>
    <theme>colecovision</theme>
  </system>
  <system>
    <name>colecovision</name>
    <fullname/>
    <path>/home/pi/RetroPie/roms/colecovision</path>
    <extension>.bin .col .rom .zip .7z .BIN .COL .ROM .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ colecovision %ROM%</command>
    <platform>colecovision</platform>
    <theme>colecovision</theme>
  </system>
  <system>
    <name>cps1</name>
    <fullname>Capcom Play System I</fullname>
    <path>/home/pi/RetroPie/roms/cps1</path>
    <extension>.zip .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ mame-libretro %ROM%</command>
    <platform>arcade</platform>
    <theme>cps1</theme>
  </system>
  <system>
    <name>cps2</name>
    <fullname>Capcom Play System II</fullname>
    <path>/home/pi/RetroPie/roms/cps2</path>
    <extension>.zip .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ mame-libretro %ROM%</command>
    <platform>arcade</platform>
    <theme>cps2</theme>
  </system>
  <system>
    <name>daphne</name>
    <fullname>Daphne</fullname>
    <path>/home/pi/RetroPie/roms/daphne</path>
    <extension>.daphne .DAPHNE</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ daphne %ROM%</command>
    <platform>daphne</platform>
    <theme>daphne</theme>
  </system>
  <system>
    <name>dragon32</name>
    <fullname>Dragon 32</fullname>
    <path>/home/pi/RetroPie/roms/dragon32</path>
    <extension>.cas .wav .bas .asc .dmk .jvc .os9 .dsk .vdk .rom .ccc .sna .CAS .WAV .BAS .ASC .DMK .JVC .OS9 .DSK .VDK .ROM .CCC .SNA</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ dragon32 %ROM%</command>
    <platform>dragon32</platform>
    <theme>dragon32</theme>
  </system>
  <system>
    <name>dreamcast</name>
    <fullname>Dreamcast</fullname>
    <path>/home/pi/RetroPie/roms/dreamcast</path>
    <extension>.cdi .chd .gdi .CDI .CHD .GDI</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ dreamcast %ROM%</command>
    <platform>dreamcast</platform>
    <theme>dreamcast</theme>
  </system>
  <system>
    <name>famicom</name>
    <fullname>Famicom System</fullname>
    <path>/home/pi/RetroPie/roms/famicom</path>
    <extension>.nes .fds .zip .7z .NES .FDS .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ famicom %ROM%</command>
    <platform>famicom</platform>
    <theme>famicom</theme>
  </system>
  <system>
    <name>fba</name>
    <fullname>Final Burn Alpha</fullname>
    <path>/home/pi/RetroPie/roms/fba</path>
    <extension>.fba .zip .7z .FBA .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ fba %ROM%</command>
    <platform>arcade</platform>
    <theme>fba</theme>
  </system>
  <system>
    <name>fds</name>
    <fullname>Famicom Disk System</fullname>
    <path>/home/pi/RetroPie/roms/fds</path>
    <extension>.nes .fds .zip .7z .NES .FDS .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ fds %ROM%</command>
    <platform>fds</platform>
    <theme>fds</theme>
  </system>
  <system>
    <name>gameandwatch</name>
    <fullname>Game and Watch</fullname>
    <path>/home/pi/RetroPie/roms/gameandwatch</path>
    <extension>.mgw .MGW</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ gameandwatch %ROM%</command>
    <platform>gameandwatch</platform>
    <theme>gameandwatch</theme>
  </system>
  <system>
    <name>gamegear</name>
    <fullname>Sega Gamegear</fullname>
    <path>/home/pi/RetroPie/roms/gamegear</path>
    <extension>.gg .bin .sms .zip .7z .GG .BIN .SMS .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ gamegear %ROM%</command>
    <platform>gamegear</platform>
    <theme>gamegear</theme>
  </system>
  <system>
    <name>gb</name>
    <fullname>Game Boy</fullname>
    <path>/home/pi/RetroPie/roms/gb</path>
    <extension>.gb .zip .7z .GB .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ gb %ROM%</command>
    <platform>gb</platform>
    <theme>gb</theme>
  </system>
  <system>
    <name>gba</name>
    <fullname>Game Boy Advance</fullname>
    <path>/home/pi/RetroPie/roms/gba</path>
    <extension>.gba .zip .7z .GBA .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ gba %ROM%</command>
    <platform>gba</platform>
    <theme>gba</theme>
  </system>
  <system>
    <name>gbc</name>
    <fullname>Game Boy Color</fullname>
    <path>/home/pi/RetroPie/roms/gbc</path>
    <extension>.gbc .zip .7z .GBC .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ gbc %ROM%</command>
    <platform>gbc</platform>
    <theme>gbc</theme>
  </system>
  <system>
    <name>intellivision</name>
    <fullname>Intellivision</fullname>
    <path>/home/pi/RetroPie/roms/intellivision</path>
    <extension>.int .bin .INT .BIN</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ intellivision %ROM%</command>
    <platform>intellivision</platform>
    <theme>intellivision</theme>
  </system>
  <system>
    <fullname>Kodi</fullname>
    <name>kodi</name>
    <path>~/RetroPie/roms/kodi</path>
    <extension>.sh .SH</extension>
    <command>bash %ROM%</command>
    <platform>kodi</platform>
    <theme>kodi</theme>
  </system>
  <system>
    <name>macintosh</name>
    <fullname>Apple Macintosh</fullname>
    <path>/home/pi/RetroPie/roms/macintosh</path>
    <extension>.txt .TXT</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ macintosh %ROM%</command>
    <platform>macintosh</platform>
    <theme>macintosh</theme>
  </system>
  <system>
    <name>mame-advmame</name>
    <fullname>Multiple Arcade Machine Emulator</fullname>
    <path>/home/pi/RetroPie/roms/mame-advmame</path>
    <extension>.zip .7z .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ mame-advmame %ROM%</command>
    <platform>arcade</platform>
    <theme>mame</theme>
  </system>
  <system>
    <name>mame-libretro</name>
    <fullname>Multiple Arcade Machine Emulator</fullname>
    <path>/home/pi/RetroPie/roms/mame-libretro</path>
    <extension>.zip .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ mame-libretro %ROM%</command>
    <platform>arcade</platform>
    <theme>mame</theme>
  </system>
  <system>
    <name>mame-mame4all</name>
    <fullname>Multiple Arcade Machine Emulator</fullname>
    <path>/home/pi/RetroPie/roms/mame-mame4all</path>
    <extension>.zip .7z .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ mame-mame4all %ROM%</command>
    <platform>arcade</platform>
    <theme>mame</theme>
  </system>
  <system>
    <name>markiii</name>
    <fullname>Sega Mark III</fullname>
    <path>/home/pi/RetroPie/roms/markiii</path>
    <extension>.sms .bin .zip .7z .SMS .BIN .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ markiii %ROM%</command>
    <platform>markiii</platform>
    <theme>markiii</theme>
  </system>
  <system>
    <name>mastersystem</name>
    <fullname>Sega Master System</fullname>
    <path>/home/pi/RetroPie/roms/mastersystem</path>
    <extension>.sms .bin .zip .7z .SMS .BIN .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ mastersystem %ROM%</command>
    <platform>mastersystem</platform>
    <theme>mastersystem</theme>
  </system>
  <system>
    <name>megadrive</name>
    <fullname>Sega Mega Drive</fullname>
    <path>/home/pi/RetroPie/roms/megadrive</path>
    <extension>.smd .bin .gen .md .sg .zip .7z .SMD .BIN .GEN .MD .SG .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ megadrive %ROM%</command>
    <platform>megadrive</platform>
    <theme>genesis</theme>
  </system>
  <system>
    <name>megadrive-japan</name>
    <fullname>Sega Mega Drive Japan</fullname>
    <path>/home/pi/RetroPie/roms/megadrive-japan</path>
    <extension>.smd .bin .gen .md .sg .zip .7z .SMD .BIN .GEN .MD .SG .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ megadrive-japan %ROM%</command>
    <platform>megadrive-japan</platform>
    <theme>megadrive-japan</theme>
  </system>
  <system>
    <name>msx</name>
    <fullname>MSX</fullname>
    <path>/home/pi/RetroPie/roms/msx</path>
    <extension>.rom .mx1 .mx2 .col .dsk .zip .7z .ROM .MX1 .MX2 .COL .DSK .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ msx %ROM%</command>
    <platform>msx</platform>
    <theme>msx</theme>
  </system>
  <system>
    <name>msx2</name>
    <fullname>MSX2</fullname>
    <path>/home/pi/RetroPie/roms/msx2</path>
    <extension>.rom .mx1 .mx2 .col .dsk .zip .7z .ROM .MX1 .MX2 .COL .DSK .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ msx2 %ROM%</command>
    <platform>msx2</platform>
    <theme>msx2</theme>
  </system>
  <system>
    <name>msx2+</name>
    <fullname>MSX2+</fullname>
    <path>/home/pi/RetroPie/roms/msx2+</path>
    <extension>.rom .mx1 .mx2 .col .dsk .zip .7z .ROM .MX1 .MX2 .COL .DSK .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ msx2+ %ROM%</command>
    <platform>msx2+</platform>
    <theme>msx2+</theme>
  </system>
  <system>
    <name>n64</name>
    <fullname>Nintendo 64</fullname>
    <path>/home/pi/RetroPie/roms/n64</path>
    <extension>.z64 .n64 .v64 .Z64 .N64 .V64</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ n64 %ROM%</command>
    <platform>n64</platform>
    <theme>n64</theme>
  </system>
  <system>
    <name>nds</name>
    <fullname>Nintendo DS</fullname>
    <path>/home/pi/RetroPie/roms/nds</path>
    <extension>.nds .zip .NDS .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ nds %ROM%</command>
    <platform>nds</platform>
    <theme>nds</theme>
  </system>
  <system>
    <name>neogeo</name>
    <fullname>Neo Geo</fullname>
    <path>/home/pi/RetroPie/roms/neogeo</path>
    <extension>.fba .zip .7z .FBA .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ neogeo %ROM%</command>
    <platform>neogeo</platform>
    <theme>neogeo</theme>
  </system>
  <system>
    <name>nes</name>
    <fullname>Nintendo Entertainment System</fullname>
    <path>/home/pi/RetroPie/roms/nes</path>
    <extension>.nes .zip .7z .NES .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ nes %ROM%</command>
    <platform>nes</platform>
    <theme>nes</theme>
  </system>
  <system>
    <name>ngp</name>
    <fullname>Neo Geo Pocket</fullname>
    <path>/home/pi/RetroPie/roms/ngp</path>
    <extension>.ngp .zip .7z .NGP .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ ngp %ROM%</command>
    <platform>ngp</platform>
    <theme>ngp</theme>
  </system>
  <system>
    <name>ngpc</name>
    <fullname>Neo Geo Pocket Color</fullname>
    <path>/home/pi/RetroPie/roms/ngpc</path>
    <extension>.ngc .zip .7z .NGC .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ ngpc %ROM%</command>
    <platform>ngpc</platform>
    <theme>ngpc</theme>
  </system>
  <system>
    <name>nintendoplaychoice</name>
    <fullname>Nintendo PlayChoice System</fullname>
    <path>/home/pi/RetroPie/roms/playchoice</path>
    <extension>.zip .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ mame-libretro %ROM%</command>
    <platform>arcade</platform>
    <theme>playchoice</theme>
  </system>
  <system>
    <name>nintendovs</name>
    <fullname>Nintendo VS. System</fullname>
    <path>/home/pi/RetroPie/roms/vs</path>
    <extension>.zip .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ mame-libretro %ROM%</command>
    <platform>arcade</platform>
    <theme>vs</theme>
  </system>
  <system>
    <name>pc</name>
    <fullname>PC</fullname>
    <path>/home/pi/RetroPie/roms/pc</path>
    <extension>.bat .com .exe .sh .conf .BAT .COM .EXE .SH .CONF</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ pc %ROM%</command>
    <platform>pc</platform>
    <theme>pc</theme>
  </system>
  <system>
    <name>pcengine</name>
    <fullname>PC Engine</fullname>
    <path>/home/pi/RetroPie/roms/pcengine</path>
    <extension>.pce .ccd .cue .zip .7z .PCE .CCD .CUE .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ pcengine %ROM%</command>
    <platform>pcengine</platform>
    <theme>tg16</theme>
  </system>
  <system>
    <name>pcenginecd</name>
    <fullname>PC Engine-CD</fullname>
    <path>/home/pi/RetroPie/roms/pcenginecd</path>
    <extension>.ccd .cue .CCD .CUE</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ pcenginecd %ROM%</command>
    <platform>pcenginecd</platform>
    <theme>pcenginecd</theme>
  </system>
  <system>
    <name>ports</name>
    <fullname>Ports</fullname>
    <path>/home/pi/RetroPie/roms/ports</path>
    <extension>.sh .SH</extension>
    <command>bash %ROM%</command>
    <platform>pc</platform>
    <theme>ports</theme>
  </system>
  <system>
    <name>psp</name>
    <fullname>PlayStation Portable</fullname>
    <path>/home/pi/RetroPie/roms/psp</path>
    <extension>.iso .pbp .cso .ISO .PBP .CSO</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ psp %ROM%</command>
    <platform>psp</platform>
    <theme>psp</theme>
  </system>
  <system>
    <name>pspminis</name>
    <fullname>PlayStation Portable Minis</fullname>
    <path>/home/pi/RetroPie/roms/pspminis</path>
    <extension>.iso .pbp .cso .ISO .PBP .CSO</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ pspminis %ROM%</command>
    <platform>pspminis</platform>
    <theme>pspminis</theme>
  </system>
  <system>
    <name>psx</name>
    <fullname>PlayStation</fullname>
    <path>/home/pi/RetroPie/roms/psx</path>
    <extension>.cue .cbn .img .iso .m3u .mdf .pbp .toc .z .znx .CUE .CBN .IMG .ISO .M3U .MDF .PBP .TOC .Z .ZNX</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ psx %ROM%</command>
    <platform>psx</platform>
    <theme>psx</theme>
  </system>
  <system>
    <name>retropie</name>
    <fullname>RetroPie</fullname>
    <path>/home/pi/RetroPie/retropiemenu</path>
    <extension>.rp .sh</extension>
    <command>sudo /home/pi/RetroPie-Setup/retropie_packages.sh retropiemenu launch %ROM% &lt;/dev/tty &gt;/dev/tty</command>
    <platform/>
    <theme>retropie</theme>
  </system>
  <system>
    <name>sc-3000</name>
    <fullname>Sega SC-3000</fullname>
    <path>/home/pi/RetroPie/roms/sc-3000</path>
    <extension>.sg .sc .bin .zip .7z .SG .SC .BIN .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ sc-3000 %ROM%</command>
    <platform>sc-3000</platform>
    <theme>sc-3000</theme>
  </system>
  <system>
    <name>scummvm</name>
    <fullname>ScummVM</fullname>
    <path>/home/pi/RetroPie/roms/scummvm</path>
    <extension>.sh .svm .SH .SVM</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ scummvm %ROM%</command>
    <platform>scummvm</platform>
    <theme>scummvm</theme>
  </system>
  <system>
    <name>sega32x</name>
    <fullname>Sega 32X</fullname>
    <path>/home/pi/RetroPie/roms/sega32x</path>
    <extension>.32x .smd .bin .md .zip .7z .32X .SMD .BIN .MD .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ sega32x %ROM%</command>
    <platform>sega32x</platform>
    <theme>sega32x</theme>
  </system>
  <system>
    <name>segacd</name>
    <fullname>Mega CD</fullname>
    <path>/home/pi/RetroPie/roms/segacd</path>
    <extension>.iso .cue .ISO .CUE</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ segacd %ROM%</command>
    <platform>segacd</platform>
    <theme>segacd</theme>
  </system>
  <system>
    <name>sfc</name>
    <fullname>Super Famicom Disk System</fullname>
    <path>/home/pi/RetroPie/roms/sfc</path>
    <extension>.bin .smc .sfc .fig .swc .mgd .zip .7z .BIN .SMC .SFC .FIG .SWC .MGD .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ sfc %ROM%</command>
    <platform>sfc</platform>
    <theme>sfc</theme>
  </system>
  <system>
    <name>sg-1000</name>
    <fullname>Sega SG-1000</fullname>
    <path>/home/pi/RetroPie/roms/sg-1000</path>
    <extension>.sg .bin .zip .7z .SG .BIN .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ sg-1000 %ROM%</command>
    <platform>sg-1000</platform>
    <theme>sg-1000</theme>
  </system>
  <system>
    <name>sgfx</name>
    <fullname>Super Grafx</fullname>
    <path>/home/pi/RetroPie/roms/sgfx</path>
    <extension>.pce .cue .zip .7z .PCE .CUE .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ supergrafx %ROM%</command>
    <platform>sgfx</platform>
    <theme>sgfx</theme>
    <directlaunch/>
  </system>
  <system>
    <name>snes</name>
    <fullname>Super Nintendo</fullname>
    <path>/home/pi/RetroPie/roms/snes</path>
    <extension>.bin .smc .sfc .fig .swc .mgd .zip .7z .BIN .SMC .SFC .FIG .SWC .MGD .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ snes %ROM%</command>
    <platform>snes</platform>
    <theme>snes</theme>
  </system>
  <system>
    <name>superfamicom</name>
    <fullname>Super Famicom</fullname>
    <path>/home/pi/RetroPie/roms/superfamicom</path>
    <extension>.7z .bin .smc .sfc .fig .swc .mgd .zip .7Z .BIN .SMC .SFC .FIG .SWC .MGD .ZIP</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ snes %ROM%</command>
    <platform>snes</platform>
    <theme>superfamicom</theme>
  </system>
  <system>
    <name>tg16</name>
    <fullname>TurboGrafx 16</fullname>
    <path>~/RetroPie/roms/tg16</path>
    <extension>.pce .zip .7z .cue .PCE .ZIP .7Z .CUE</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ tg16 %ROM%</command>
    <platform>tg16</platform>
    <theme>tg16</theme>
  </system>
  <system>
    <name>tg16cd</name>
    <fullname>TurboGrafx 16-CD</fullname>
    <path>~/RetroPie/roms/tg16cd</path>
    <extension>.ccd .cue .pce .CCD .CUE .PCE</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ tg16cd %ROM%</command>
    <platform>tg16cd</platform>
    <theme>tg16cd</theme>
  </system>
  <system>
    <name>vectrex</name>
    <fullname>Vectrex</fullname>
    <path>/home/pi/RetroPie/roms/vectrex</path>
    <extension>.vec .gam .bin .zip .7z .VEC .GAM .BIN .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ vectrex %ROM%</command>
    <platform>vectrex</platform>
    <theme>vectrex</theme>
  </system>
  <system>
    <name>videopac</name>
    <fullname>Odyssey/Videopac</fullname>
    <path>/home/pi/RetroPie/roms/videopac</path>
    <extension>.bin .zip .7z .BIN .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ videopac %ROM%</command>
    <platform>videopac</platform>
    <theme>videopac</theme>
  </system>
  <system>
    <name>videopac</name>
    <fullname>Odyssey 2</fullname>
    <path>/home/pi/RetroPie/roms/videopac2</path>
    <extension>.bin .zip .7z .BIN .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ videopac %ROM%</command>
    <platform>videopac</platform>
    <theme>videopac</theme>
  </system>
  <system>
    <name>virtualboy</name>
    <fullname>Virtual Boy</fullname>
    <path>/home/pi/RetroPie/roms/virtualboy</path>
    <extension>.vb .zip .7z .VB .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ virtualboy %ROM%</command>
    <platform>virtualboy</platform>
    <theme>virtualboy</theme>
  </system>
  <system>
    <name>wonderswan</name>
    <fullname>Wonderswan</fullname>
    <path>/home/pi/RetroPie/roms/wonderswan</path>
    <extension>.ws .zip .7z .WS .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ wonderswan %ROM%</command>
    <platform>wonderswan</platform>
    <theme>wonderswan</theme>
  </system>
  <system>
    <name>wonderswancolor</name>
    <fullname>Wonderswan Color</fullname>
    <path>/home/pi/RetroPie/roms/wonderswancolor</path>
    <extension>.wsc .zip .7z .WSC .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ wonderswancolor %ROM%</command>
    <platform>wonderswancolor</platform>
    <theme>wonderswancolor</theme>
  </system>
  <system>
    <name>zmachine</name>
    <fullname>Z-machine</fullname>
    <path>/home/pi/RetroPie/roms/zmachine</path>
    <extension>.dat .zip .7z .z1 .z2 .z3 .z4 .z5 .z6 .z7 .z8 .DAT .ZIP .7Z .Z1 .Z2 .Z3 .Z4 .Z5 .Z6 .Z7 .Z8</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ zmachine %ROM%</command>
    <platform>zmachine</platform>
    <theme>zmachine</theme>
  </system>
  <system>
    <name>zxspectrum</name>
    <fullname>ZX Spectrum</fullname>
    <path>/home/pi/RetroPie/roms/zxspectrum</path>
    <extension>.sna .szx .z80 .tap .tzx .gz .udi .mgt .img .trd .scl .dsk .zip .7z .SNA .SZX .Z80 .TAP .TZX .GZ .UDI .MGT .IMG .TRD .SCL .DSK .ZIP .7Z</extension>
    <command>/opt/retropie/supplementary/runcommand/runcommand.sh 0 _SYS_ zxspectrum %ROM%</command>
    <platform>zxspectrum</platform>
    <theme>zxspectrum</theme>
  </system>
</systemList>
                                          mituM 1 Reply Last reply Reply Quote 0
                                          • mituM
                                            mitu Global Moderator @mostym
                                            last edited by mitu

                                            @mostym This looks correct. Do you have any empty custom collection in your ~/.emulationstation/collections folder ? Can you run the script with the -d flag

                                            python gamelist.py -d /home/pi/RetroPie/roms/export_list.xlsx

                                            and post the output ?

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post

                                            Contributions to the project are always appreciated, so if you would like to support us with a donation you can do so here.

                                            Hosting provided by Mythic-Beasts. See the Hosting Information page for more information.