Post by abraxas86 in Export collections to CSV comments

Viewing post in Export collections to CSV comments

Glad I was able to help you get your database back in action. I made it because I'd added so many cool looking games and had no idea how to pick one to play next... so I figured adding it to a database was the way to go. I was (and still am) surprised that Itch doesn't have any way to export collections.

As for separating by type, it may be a bit tricky if it isn't explicitly defined in the code. Games would be fairly easy to pull out as long as they have a "game_genre" set. But the rest might be a bit trickier. If you can give me a few of each type to put into a library of my own, I can see what I can do.

IntuitiveTinker163 days ago(+1)

Thank you for the prompt reply. I appreciate your still being interested in keeping tabs on this instead of abandoning it like so many folks do. That makes perfect sense. Staring at a (poorly designed) library interface can be mind-numbing, then you wind up spending more time looking through it instead of playing something. You have a point; for something that's been requested over and over for years, you'd think it would have been implemented to some degree by now.

Ah, that makes sense. Hopefully it doesn't look like a huge amount of effort. So far as samples, here's a couple from each category:

Games:

REQUIEM

A.O.O.F.A.D.: All of Our Friends Are Dead

Books:

The NPC with a Thousand Faces

The Corrupted Kingdom

Physical Games:

Cards: The Attackening!™

Poison for Beginners

Tools:

SuperShot: Screenshot Tool

PQ93

Game Assets:

Urban Nightscape

Outdoor Adventurer Tileset

Comics:

Philip K. Dick's Tony and the Beetles

Apple Quest Monsters DX

Soundtracks:

"CHILL VIBES" #1-10 Videogame Instrumentals Pack

SNES Original Soundtrack Small Collection

abraxas86163 days ago(+1)

Ah, a fellow "Equality Bundle" owner. The very collection that led me to making that script in the first place 🤣

I'll get a test library going now and see what I can find.

abraxas86163 days ago(+1)

I don't think there's really any way I can separate by type like that. There's no unique identifier in the code that separates one type from the next :( The only thing I can think of is adding it to the blurb. I can add that to the "blurb" to the export.

abraxas86163 days ago(+1)

I couldn't find any way to automate the ability to export the "type" of each item. There's nothing in the data that seems to differentiate one thing from another.

The best I could do was export the "blurb" part of the code... it would mean manually updating the blurb for each item, which I get sucks, but on the plus side if you accidentally wipe your database again, the manually-entered blurbs should still be in tact on the site so you can just export and run with it again.

Version 3.5 should be the version on the Gist page now. I did some testing and it seemed to work consistently. Let me know if it works okay for what you need if you use it.

IntuitiveTinker162 days ago(+1)

I downloaded 3.5, and the test run did work as expected. Adding blurbs to every item on the itch.io side may take a little while, but it will still save me a mountain of time instead of tailoring each entry on the other end, since the interface for the database software I use is kind of annoying, if I'm being honest.

And as you mentioned, if something happens to my database again (which it better not, I'm backing that thing up on two extra drives now), having all that information pre-set will expedite the process in the future. I think this was a good and dynamic solution.

Thank you for investigating, and for modifying your script to accommodate this request.

abraxas86162 days ago

No problem! It's kind of interesting that the "tags" don't seem to be publicly facing. They clearly exist because we can search for things like "music" and get relevant results back, but those tags don't seem to exist in any public-facing place.

I wish Itch put some effort into better ways for us to export and manage our library data.

You're welcome for the update, and thank you for putting my script to use and for the great suggestion!