I want to thank all the people who weighed in on my post yesterday with comments about the Thursday Doors Recap page I am building. I appreciate the time you took to comment. I appreciate your encouragement and most of all, I appreciate the fact that so many of you were concerned about my time. I
threatened promised to explain how I am preparing the summary. Of course, there’s a little bit of a backstory.
Note: if you find any typos, The Editor may have fallen asleep while reading this. If it affects you the same way, there will be no hard feelings if you skip to the gallery.
Since taking over the management of Thursday Doors, I have been concerned that people looking for the other doors posts have to wade through a lot of comments. That concern is compounded by the fact that people can contribute to Thursday Doors until noon on Saturday, but I have a regularly scheduled feature on Saturdays.
I was uncomfortable saying, “you can contribute on Saturday morning, but no one is going to see your link unless they start poking around my blog.”
Back in January, I made a list of participants and the URL of their TD post. I liked the list, but it took too long to prepare. I might have the time in the dead of winter, but when it gets warm, I’m not going to want to be assembling this list link by link. I have a subscription to LinkyTools, but my experience with that service is that some people are uncomfortable registering with “one more thing” in order to participate. Posting a link, or a pingback to No Facilities works, people are used to the procedure, why change to provide a feature people might not even want.
Since I am in the proof-of-concept stage, I decided to move the raw list into Excel. I heard several of you groan. I will spare you the details, but these are the steps Excel helps me execute:
- I delete all of my reply comments and the comments without links
- I delete the links to everything that’s not a comment
- I extract the Domain name (i.e. NoFacilities.com) from the URL of the blog post being added
- I collect the title from links added by Pingback
- I match the domain name from step three with a list of “friendly names” I created for those domains
- I create a hyperlink from the Pingback text or friendly name and the URL of the Doors post
- I copy the list of hyperlinks and paste it into the Block Editor (creating a table)
I am going to leave this technical kludge in place for a few weeks. One think about running the process in Excel, is I get to see the things that send it off the rails and work out a way to tweak the process steps to accommodate those things.
On Thursday, I will have a survey with a few questions for Thursday Doors participants, the results of which should help me improve this list and the process. I’ll also have some doors from downtown Waterbury, Connecticut. Today’s gallery is just the usual suspects.