• Recent
  • Tags
  • Popular
  • Home
  • Docs
  • Register
  • Login
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.0k 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.
  • M
    mitu Global Moderator @2Play
    last edited by 28 Jan 2021, 17:32

    @2play said in Gamelist Excel export script:

    Ive exported full run if helps
    https://pastebin.com/11GS3ZS5

    Unfortunately that doesn't hint me on what is wrong. Maybe @Lolonois has a point, check the systems' config and make sure it's properly XML formed.
    Alternatively, you could try running the script via python3 (instead of just python), but make sure you install the XLSX module with python-pip3 so it's available for python3 also.

    2 1 Reply Last reply 29 Jan 2021, 14:14 Reply Quote 0
    • 2
      2Play @mitu
      last edited by 2Play 29 Jan 2021, 14:14

      @Lolonois & @mitu
      First of all a big thank you for your kind replies!
      It is an amazing script @mitu

      • @Lolonois I have changed the xml header: Not working with python v2

      • @Lolonois You are correct on the Ö. It is in the LÖVE 2d Game Engine system name tag. If I remove command runs fine ( @mitu )

      • @mitu Since I have Python 3.7.3 installed, I did as you advised.
        Python 3 works and exports excel list without any changes (no removal of Ö from LÖVE)

      So if I may suggest to ppl do below:

      Check Python version 2 or 3

      python --version
      or
      python3 --version
      

      Install Python3 If No Result Above

      sudo apt-get install -y python3-dev python3-setuptools
      

      GET MITU GAMELIST LATEST FILE:

      wget -O export.py https://gist.githubusercontent.com/cmitu/73cf0783e9e1e4e02d8ce5c44f7a8984/raw/4a7a8176f8b73ee7bc41ec8d884a9820d84ab639/gamelist.py
      

      XLSXWRITER Installation:

      git clone --depth=1 https://github.com/jmcnamara/xlsxwriter
      cd xlsxwriter
      sudo python3 setup.py install
      

      RUN (normal):

      python3 export.py /home/pi/RetroPie/roms/export_list.xlsx
      

      RUN (debug):

      python3 export.py /home/pi/RetroPie/roms/export_list.xlsx -d
      

      Your friend,
      2Play!

      M 1 Reply Last reply 29 Jan 2021, 15:04 Reply Quote 0
      • M
        mitu Global Moderator @2Play
        last edited by 29 Jan 2021, 15:04

        @2play said in Gamelist Excel export script:

        @Lolonois You are correct on the Ö. It is in the LÖVE 2d Game Engine system name tag. If I remove command runs fine ( @mitu )

        I see. I'll try to see if it would work with Python2, otherwise I'll update the installation instruction on the first post.

        Thanks for the update.

        M 1 Reply Last reply 29 Jan 2021, 16:00 Reply Quote 0
        • M
          mitu Global Moderator @mitu
          last edited by mitu 29 Jan 2021, 16:00

          @mitu said in Gamelist Excel export script:

          It is in the LÖVE 2d Game Engine system name tag. If I remove command runs fine ( @mitu )

          I already had Love as a system, but RetroPie doesn't configure it with LÖVE, just Love. Did you modify the name of the system manually ?

          Nevertheless, I added a fix for the issue and also fixed the bug of exporting empty comments for games that don't have any description.

          2 2 Replies Last reply 29 Jan 2021, 18:33 Reply Quote 1
          • 2
            2Play @mitu
            last edited by 2Play 29 Jan 2021, 18:33

            @mitu welcome, yes and thank you :-)
            Tested and now python 2 also works ok with your fix!

            Your friend,
            2Play!

            1 Reply Last reply Reply Quote 0
            • 2
              2Play @mitu
              last edited by 1 Feb 2021, 11:47

              @mitu gm friend

              i was checking today my es reported arcade set at 340 and export xls reports 331
              I have to check what is missing. but later due to work
              do you think is name related or script uses name tag counting?

              Your friend,
              2Play!

              1 Reply Last reply Reply Quote 0
              • M
                MrPacMan17
                last edited by 9 Feb 2021, 08:19

                Wow, this script is awesome! Thank you very much for it. Much appreciated!

                1 Reply Last reply Reply Quote 0
                • J
                  joesnow81
                  last edited by 4 Jan 2022, 14:04

                  I know this thread is very old now but hoping someone may be able to assist. I have used this script in the past and it worked flawlessly but when I went to run it today I got the following error

                  2022-01-04 13:53:37,126 INFO Exporting to file /home/pi/RetroPie/roms/export_list.xlsx
                  Traceback (most recent call last):
                  File "export.py", line 599, in <module>
                  xlsx_export_workbook(systems, output, collections)
                  File "export.py", line 394, in xlsx_export_workbook
                  if len(custom_collections)>0 :
                  TypeError: object of type 'NoneType' has no len()

                  The file is not being saved. Any idea what the above means and how to resolve it?

                  M 1 Reply Last reply 4 Jan 2022, 16:36 Reply Quote 0
                  • M
                    mitu Global Moderator @joesnow81
                    last edited by 4 Jan 2022, 16:36

                    @joesnow81 Can you run the script with the debug flag enabled (-d) and post the output ? If it's large, use pastebin.com to post it.
                    Since it seems to crash during the collection parsing part, can you also run

                    ls -l $HOME/.emulationstation/collections
                    

                    and post the output ?

                    1 Reply Last reply Reply Quote 0
                    • K
                      kelvinator3300 @mitu
                      last edited by 5 Jan 2022, 04:23

                      @mitu
                      What are your thoughts on exporting to CSV (comma seperated values) so that any spreadsheet program can open?
                      Also, your thoughts on being able to edit the exported file and then export/convert to gamelist.xml?

                      M 1 Reply Last reply 5 Jan 2022, 05:10 Reply Quote 0
                      • M
                        mitu Global Moderator @kelvinator3300
                        last edited by 5 Jan 2022, 05:10

                        @kelvinator3300 said in Gamelist Excel export script:

                        What are your thoughts on exporting to CSV (comma seperated values) so that any spreadsheet program can open?

                        Exporting to CSV is easy enough that it doesn't need a special script - can be done with xmlstarlet without problems. However, this will produce one CSV per gamelist, whereas a spreadsheet can contain all the info.

                        Is there a spreadsheet program that can't open XLS(X) files ?

                        Also, your thoughts on being able to edit the exported file and then export/convert to gamelist.xml?

                        That's something that was asked before, but it's not something that I'm interested in particular - the script is meant just to produce a summary of your gamelist(s). If you want to edit your gamelists, use something like ARRM, which can do that without issues.

                        1 Reply Last reply Reply Quote 0
                        • M mitu referenced this topic on 5 Jan 2022, 05:10
                        • N
                          nelsonchelini
                          last edited by 17 Apr 2024, 14:29

                          Hi @mitu,

                          I'm sorry to post here something nothing to do with this topic, but I've being trying to submit a Help post and I can't because it requires a tag. However, I can't find the tag field to include them. Could you help me with that, please? No need to say I'm a newbie here... and not so good with these social media platform either. I tried to send a message to somebody asking, but didn't get that too. Since you are a moderator, I just gave it a shot here. Thanks a lot!

                          M 1 Reply Last reply 17 Apr 2024, 14:59 Reply Quote 0
                          • M
                            mitu Global Moderator @nelsonchelini
                            last edited by mitu 17 Apr 2024, 14:59

                            @nelsonchelini Some user had the same issue the other day - see https://retropie.org.uk/forum/topic/35266/import-roms-into-mame/37. What browser/OS/device are you using ? Isnt't the tags input sufficiently visible or explicitely shown ?

                            N 1 Reply Last reply 17 Apr 2024, 17:04 Reply Quote 0
                            • N
                              nelsonchelini @mitu
                              last edited by 17 Apr 2024, 17:04

                              @mitu I'm using Google Chrome at the PC and tried Microsoft Edge as well, but no lucky either.
                              But after seeing the link you sent, I got it. Such a simple thing that caused me a big headache. But thanks to you, it is fine now. Many thanks, dude.

                              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.

                                This community forum collects and processes your personal information.
                                consent.not_received