Now you can read your favorite Drabblecast story!

For any and all info or discussion of podcasts and podcasting. Also community related miscellanea.
User avatar
Algernon Sydney is Dead
Moderator
Posts: 3497
Joined: Thu Oct 16, 2008 11:22 pm
Location: PRK (California)

Re: Now you can read your favorite Drabblecast story!

Postby Algernon Sydney is Dead » Sun Jul 21, 2013 3:14 pm

Okay, created a Google Fusion table on Google Drive.

Anyone can see/read it by clicking that link. PM me with your Google email or userID if you want to edit it.

User avatar
Varda
Connor Choadsworth Defender
Posts: 1383
Joined: Wed Apr 10, 2013 5:41 pm
Location: Athens, Georgia
Contact:

Re: Now you can read your favorite Drabblecast story!

Postby Varda » Sun Jul 21, 2013 5:13 pm

I've added a dozen-ish entries. A couple of notes:

1. I'm including all episodes, even the ones without drabbles, on the list so that we don't end up doing double work later, wondering if an episode with a drabble got skipped.

2. This unique chicken is working in reverse, starting with most recent episodes, as I know drabbles didn't become a thing until later in the 'Cast's debauched youth. Plus it's always more fun to count down to things, amiright?

3. ASID, if I'm doing it wrong, now's your chance to correct me. I'm leaving entries blank if I can't find the data, or if it's missing. Let me know if you prefer something more detailed ("not on forums", etc.).

4. As an added service, I'll note any major typos in the main episode entries in the "remarks" column. Just because I'm that anal. :mrgreen:
Medical Microfiction: Stories about Science

Drabblescout Badges:
Merits: Twabble Author (5), Drabble Author (4), DRIP Slave Volunteer (2), Whittling (1), Macaroni Crafts (2)
Demerits: Redd*t Rouser (2), Whittler's Mother (6)

User avatar
Algernon Sydney is Dead
Moderator
Posts: 3497
Joined: Thu Oct 16, 2008 11:22 pm
Location: PRK (California)

Re: Now you can read your favorite Drabblecast story!

Postby Algernon Sydney is Dead » Sun Jul 21, 2013 8:48 pm

Looks like a good start, thanks. Doing every episode helps because, believe it or not, almost all of the forum posts don't have a direct link to the episode page. :?

Only thing I'd change:
If an episode does not have a drabble, it would be helpful, to confirm that by setting the drabble title to "no drabble". It's fine to leave the other stuff blank.

Gotta dash again, but I should have a script for you by tomorrow.

Again, thanks for doing this.

User avatar
Varda
Connor Choadsworth Defender
Posts: 1383
Joined: Wed Apr 10, 2013 5:41 pm
Location: Athens, Georgia
Contact:

Re: Now you can read your favorite Drabblecast story!

Postby Varda » Sun Jul 21, 2013 11:00 pm

No problem - glad to help! I'll add the "no drabble" tag, and glad to know that a full episode list will tidy up all the data. Always good to knock out extra cleanup as a bonus. :)
Medical Microfiction: Stories about Science

Drabblescout Badges:
Merits: Twabble Author (5), Drabble Author (4), DRIP Slave Volunteer (2), Whittling (1), Macaroni Crafts (2)
Demerits: Redd*t Rouser (2), Whittler's Mother (6)

User avatar
Algernon Sydney is Dead
Moderator
Posts: 3497
Joined: Thu Oct 16, 2008 11:22 pm
Location: PRK (California)

Re: Now you can read your favorite Drabblecast story!

Postby Algernon Sydney is Dead » Tue Jul 23, 2013 11:54 am

I put a Greasemonkey/userscript at http://twitfic.net/utilities/DrabbleDetailsScrape.user.js. It works with both FF and Chrome.

To use it, install Tampermonkey on your Chrome browser, then click on the link above.

The script fires on DC episode pages and scrapes whatever relevant data is there, to make it easier for you to copy.

For example, if you go to http://www.drabblecast.org/2013/06/01/drabblecast-284-turning-point/, you will see a "Scrape" button:

Image

Click that button (or press the F9 key) and a dialog will popup with all the relevant information that the script could find for that episode. EG:

Image

Verify the info (It's scraping from pages that can vary in untested ways), and fill in the missing bits as best you can. Then paste into the Google table.




Version 2 of the script will allow you to submit the form directly to the Google table at the press of a button. That's a few days away.

User avatar
Varda
Connor Choadsworth Defender
Posts: 1383
Joined: Wed Apr 10, 2013 5:41 pm
Location: Athens, Georgia
Contact:

Re: Now you can read your favorite Drabblecast story!

Postby Varda » Tue Jul 23, 2013 2:31 pm

[KeanuReeves]....Whoa.[/KeanuReeves]

Installed and working in under 30 seconds... this is gonna make everything much, much easier. Really appreciate it, ASID. I was just prepared to shrug and accept the masochism of what I'd volunteered for. :mrgreen:
Medical Microfiction: Stories about Science

Drabblescout Badges:
Merits: Twabble Author (5), Drabble Author (4), DRIP Slave Volunteer (2), Whittling (1), Macaroni Crafts (2)
Demerits: Redd*t Rouser (2), Whittler's Mother (6)

User avatar
Algernon Sydney is Dead
Moderator
Posts: 3497
Joined: Thu Oct 16, 2008 11:22 pm
Location: PRK (California)

Re: Now you can read your favorite Drabblecast story!

Postby Algernon Sydney is Dead » Tue Jul 23, 2013 3:10 pm

Yeah, volunteering can really bite one in the posterior. :)   Of course, they never tell you what NAVY means until after you've signed up.

Anyway, let me know if the script chokes on any pages or if you want the scraping to fire automatically (or other changes).

That script is version 1. Here's the plan, since I had back-burner intentions to do this kind of cleanup anyway:
  1. Script, version 2, adds a button and that dialog becomes a form to post new table entries.
  2. Script, version 3, expands the data that is auto collected to include other fields needed to bring the forum posts up to snuff.
  3. Once enough data is collected, a Cleanup script will take the info and help me edit the forum posts.
  4. {Some TBD process occurs here.}
  5. World domination achieved!

The real value is in sussing-out the drabble and author links, since that kind of Google-Fu is hard to automate in a cost-effective way.

Thanks for your masochism work!

User avatar
Varda
Connor Choadsworth Defender
Posts: 1383
Joined: Wed Apr 10, 2013 5:41 pm
Location: Athens, Georgia
Contact:

Re: Now you can read your favorite Drabblecast story!

Postby Varda » Tue Jul 23, 2013 3:33 pm

Algernon Sydney is Dead wrote:Yeah, volunteering can really bite one in the posterior. :)   Of course, they never tell you what NAVY means until after you've signed up.

Tell me about it! One day you're trying to think up a 6-letter synonym for "bawdy", and the next day you're wearing a Sea Org uniform and worshiping Tom Cruise. :lol:

I just had to know what'd happen if I played "Jelly Park" backwards...
Algernon Sydney is Dead wrote: (or other changes).

Well, since ya asked...!

From a data entry standpoint, it'd be nice to have the "Drabble Link" field on both the table and the script moved to underneath "Drabble Author Link". That way, I enter and double-check all fields from the main entry first, then go forum-diving for the link without losing my place on the form.

If it's complicated to change it, don't sweat it. Just a personal preference.
Medical Microfiction: Stories about Science

Drabblescout Badges:
Merits: Twabble Author (5), Drabble Author (4), DRIP Slave Volunteer (2), Whittling (1), Macaroni Crafts (2)
Demerits: Redd*t Rouser (2), Whittler's Mother (6)

User avatar
Algernon Sydney is Dead
Moderator
Posts: 3497
Joined: Thu Oct 16, 2008 11:22 pm
Location: PRK (California)

Re: Now you can read your favorite Drabblecast story!

Postby Algernon Sydney is Dead » Tue Jul 23, 2013 11:42 pm

Varda wrote:From a data entry standpoint, it'd be nice to have the "Drabble Link" field on both the table and the script moved to underneath "Drabble Author Link". That way, I enter and double-check all fields from the main entry first, then go forum-diving for the link without losing my place on the form.

Done.

Update the script by clicking its install link again.

User avatar
Varda
Connor Choadsworth Defender
Posts: 1383
Joined: Wed Apr 10, 2013 5:41 pm
Location: Athens, Georgia
Contact:

Re: Now you can read your favorite Drabblecast story!

Postby Varda » Wed Jul 24, 2013 1:01 am

Much appreciated!
Medical Microfiction: Stories about Science

Drabblescout Badges:
Merits: Twabble Author (5), Drabble Author (4), DRIP Slave Volunteer (2), Whittling (1), Macaroni Crafts (2)
Demerits: Redd*t Rouser (2), Whittler's Mother (6)

sandrilde
Member
Posts: 153
Joined: Tue Mar 12, 2013 8:45 pm

Re: Now you can read your favorite Drabblecast story!

Postby sandrilde » Tue Oct 29, 2013 8:18 pm

I really appreciate this. I sometimes really need to look at the text to fill in some blank that my brain just wouldn't process.


Return to “Podcasts and suchforth”



Who is online

Users browsing this forum: No registered users and 2 guests