[Metadata Source Plugin] DriveThruRPG

[theducks]

Originally Posted by OldeMusicke

I'm new to this forum so apparently I did something wrong in my earlier detailed reply because it vanished as soon as I tried to post it.
.

You tripped the new user moderation review, either because of rapid fire posts or the attachment. I have released the posts. Usually, just wait a few hours. All the Mods are volenteers, so they only slightly live on the forums

[maddz]

I'm guessing you're on Windows with MS Office? I'm on a Mac with Google Sheets.

And are you scraping from the DTRPG site or from the app? Or from the library the app makes for you? (Which is one of the worst file structures I've ever seen - what use is storing files by publisher not the actual RPG?)

I also never got the collections functionality working properly in the app - it multiplied across the 3 devices I was using it on.

[OldeMusicke]

Originally Posted by maddz

And are you scraping from the DTRPG site or from the app? Or from the library the app makes for you? (Which is one of the worst file structures I've ever seen - what use is storing files by publisher not the actual RPG?)

Github has dtrpg_convert.py. The instructions in comments in that file are:
# How to use
# 1. Go to DriveThruRPG site and login
# 2. Open: https://www.drivethrurpg.com/api/pro...draw=9&columns[0][data]=null&columns[0][name]=&columns[0][searchable]=false&columns[0][orderable]=false&columns[0][search][value]=&columns[0][search][regex]=false&columns[1][data]=product.title&columns[1][name]=name&columns[1][searchable]=true&columns[1][orderable]=true&columns[1][search][value]=&columns[1][search][regex]=false&order[0][column]=1&order[0][dir]=asc&start=0&length=-1&search[value]=&search[regex]=false&show_archived=false&show_all=0&show_new=&sh ow_updated=0&filter_string=&oneclick=true
# 3. Copy and paste json response into data.json file
# 4. Run: `python dtrpg_convert.py data.json export.json`
# 5. Your data is in `export.csv` file

I followed those instructions except that export.json should be export.csv.

I used the resulting CSV file as I described earlier, extracting the product number from the URL column. I saved the result as a new CSV file (that is, with the product numbers).