Gamelist Excel export script

2Play

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

2Play

@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?

MrPacMan17

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

joesnow81

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?

mitu

@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 ?

kelvinator3300

@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?

mitu

@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.

nelsonchelini

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!

mitu

@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 ?

nelsonchelini

@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.