Gamelist Excel export script

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.