Export games list

[pasteko]

Hello,

Is there any easy way or a plugin to export my games list?

[Lordmonkus]

None that I am aware of but shouldn't be too difficult to do with the plugin system.

I have talked to @Nielk1 about a somewhat similar but different plugin recently, I asked him about making a plugin to export a list of rom files to a folder. This plugin would copy out a bunch of roms from their current location into a separate folder which you could then use as a streamlined set for something like a portable USB stick build.

He said this wouldn't be difficult to do at all so I would assume the same would true for outputting a simple list of games.

[cZ8tL]

LaunchBoxExport.zip

 

If you like to live dangerously, you can download this untested executable from total stranger. Put 'LaunchBoxExport.exe' in LaunchBox\Data\Platforms\, run it, unsorted results will land in List.txt.

Requires 64 bit Windows, I think.

[pasteko]

Just found something today, when you change the view to "List view" you can select all games with CTRL+A then with CTRL+C copy all the list to clipboard and paste it in Excel or any other spreadsheet software.

:-)

[Lordmonkus]

1 minute ago, pasteko said:

Just found something today, when you change the view to "List view" you can select all games with CTRL+A then with CTRL+C copy all the list to clipboard and paste it in Excel or any other spreadsheet software.

:-)

Good to know.

[Bumblebee]

@pasteko

Thanks pasteko, I will try that later. Copy/Paste game list.

Brian

[Hifihedgehog]

I just noticed today that there is some sort of hard limit in place preventing copying and pasting a list larger than about 1600 (messing with filters) or so of games. So if you are collector completionist like and want export an entire list of your 1000s of games to Excel, bear this in mind. @Jason Carr, is this something that I should submit in a bug report? I can confidently say that Windows at least can easily hold an export in the 10,000's in the clipboard as I copy and paste from SQL Server with tables much taller and wider in my day job.

[Retro808]

1 hour ago, Hifihedgehog said:

I just noticed today that there is some sort of hard limit in place preventing copying and pasting a list larger than about 1600 (messing with filters) or so of games. So if you are collector completionist like and want export an entire list of your 1000s of games to Excel, bear this in mind. @Jason Carr, is this something that I should submit in a bug report? I can confidently say that Windows at least can easily hold an export in the 10,000's in the clipboard as I copy and paste from SQL Server with tables much taller and wider in my day job.

There should not be a limit. Just ran a test and was able to copy 1,600, 4,500, and 10,500 lines from the audit tool into Excel. 

You mentioned messing with filters. What exact steps did you take to generate the audit list you are trying export?

[zorget]

On 11/21/2017 at 10:27 PM, pasteko said:

Just found something today, when you change the view to "List view" you can select all games with CTRL+A then with CTRL+C copy all the list to clipboard and paste it in Excel or any other spreadsheet software.

🙂

Thanks for the tip! It works nice, but I noticed that neither the wikipedia nor the video link are pasted when using this method. The column are here, but empty.

The other way is to directly import the XML datafile into a spreadsheet. See for instance the documentation for Libreoffice Calc : https://help.libreoffice.org/latest/en-ZA/text/scalc/01/xml_source.html

In the last case you can directly select the columns/data you want to import.

Edited August 18, 2023 by zorget
complementary solution