View Single Post
Old 11-10-2022, 12:37 PM   #7715
dailyalice
Geek of All Trades
dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!
 
dailyalice's Avatar
 
Posts: 55
Karma: 100878
Join Date: Aug 2012
Location: Minneapolis
Device: Kindle Oasis (3rd gen)
Quote:
Originally Posted by JimmXinu View Post
I try to standardized the values 'Completed' and 'In-Progress' for all sites, and those two cover the vast majority.

But there are sites that have additional states. Abandoned, Paused, Cancelled, etc. I don't have a complete list because some adapters use the site text directly.

Unless it's important to you to limit the values, I'd used a free form text field instead.
Thank you! I thought this might be the case, but wanted to be sure.

I actually have the following bit in the status column section of my guide already from when I was working on it a month ago:

An alternate method to use, which might be good if you know you'll be downloading from multiple archives and think they may have statuses available beyond "Complete" and "In-Progress," would be to go with a simple column like this:

This has no fixed values, when I used this column type with the works I downloaded from AO3, they showed up as "Complete" and "In-Progress." I set a default value of "Unknown" to use when an archive doesn't provide any sort of value for status.

This method probably future proofs the column for if you start downloading from a site that offers more status items or different ones than AO3. You won't have color coded words, but you will have whatever words an archive provides. (Whereas with a fixed set of values, those are the only available options.)

And attached is the screenshot of the column.

I'm working on a major revision to the guide (maybe one day I'll finish it) and I think I'll just use this as the status column suggestion and not bother with the fixed set of values thing. Unless, I suppose, I wanted to demonstrate that column type for some reason. Hmm.

(The guide so far has an AO3 focus, though of course much of it applies elsewhere.)
Attached Thumbnails
Click image for larger version

Name:	status text column.png
Views:	246
Size:	26.1 KB
ID:	197647  
dailyalice is offline   Reply With Quote