Here are the additions since last Sunday night. Spreadsheets linked in post #1 have been updated and reflect exactly what is in my database including of course the BLF user name
Thanks, thatâs an interesting look at how the interest list works. Maybe Iâm weird, but I think itâs fascinating to see how different people solve similar problems.
My solution was a bit different⌠Instead of a database, it used a plain text file⌠but thatâs relatively immaterial. The main differences seem to be in the rest of the system. When I wanted to update the list, my process was:
Run âgrab.shâ to download new posts.
Run âtkbot.pyâ to process the new posts. This involved a bit of manual input. Basically, itâd go through a loop like this:
Display the next postâs text content, minus any quoted parts.
Analyse the text and display the scriptâs best guess about what the post means (comment or request).
Give a text prompt, for manual categorization.
The user can then press enter (accept the scriptâs guess), or type a value. Like âcâ for a comment, or a number for a request. â1â for one light, â2â for 2 lights, etc. Also negative numbers for cancellations.
When thatâs done, run âinterest.pyâ to generate a new human-friendly copy of the interest list.
Copy/paste that into BLF.
So it mostly just required one or two keystrokes per post. And the text analyzer wasnât very accurate, so eventually I turned it off and just made the default action âcâ for âcommentâ. That way, it was just Enter for regular comments, or a number followed by Enter for requests.
If I ever do something like that again though, I want to make it fully automatic, using explicit bot control commands that people can do on their own. Managing the list manually was a lot of work even with the extra tools I made for it.
Since I already had Oracle up on a VM it was easy enough to create a schema and a few tables & other objects for the lantern project. It only takes me a few seconds to enter the BLF user name and post number into my insert script which then writes the request into a detail table and creates an entry in a master user name table if needed. I probably spend less than 5 minutes per day entering the requests so itâs not a big effort on my part. The same tables/objects are reusable for other projects if the need ever arises so thatâs a plus I guess.
I couldnât figure out a way to automatically and accurately analyze the postings so I thought about writing a front-end to let people enter them but I didnât want to expose my computer to the outside world
Im so freaking excited for this lantern. Ive had a Q8 with a warm flash gel and a diffuser running as a bedside candle for a good 8 months now. I cant wait to have something I dont have to mess with that has an adjustable tint.
This might be the first light I dont mess with at all.
There was someone that approached me while I was keeping this list, and he created a bot that would search the thread of folks who wanted to be added to the interest list. It seemed like he was close to making it work, then he disappeared.
I remember seeing that when he posted it. The problem as I recall was that it depended on the request being in the exact format required in order to scrub it from the post. Since it only takes me a few minutes each day to manually scan new postings itâs not a big deal for me to copy and paste the user name and post number into my table. Post number isnât really needed since each insert tags the row with an incrementing sequence number (in case it matters for sending out the PMâs) but I like to have it just as another data point.
I would like to get two more of these. That would make 3 in total for me.
I really hope the production of these goes in full swing soon with hurricane season starting out here in FL.
No matter when it does, I know theyâll totally be worth the wait with the dedication everyone has put in to it.
I was disappointed that he disappeared. It seemed like a really good start on something which could help a lot of people.
Iâve been tempted to build something too, but Iâve been way too busy. The only things Iâve automated here lately are things I needed directly for projects, like sending out a couple thousand private messages.