DCM Download Site > What you can upload
COMICS STILL NEEDED FOR SCANNING LIST - OLD LINK
Yoc:
Hi Jon,
Welcome to DCM.
That's an interesting idea. I don't see it replacing these lists though.
It's handy to see all the missing numbers for a given title at a glance rather than searching for each individual number. True your idea would be easier to maintain once it were running.
That sounds so cool your mini-comics!
-Yoc
jonathangraham:
--- Quote from: Yoc on May 17, 2015, 12:14:13 AM ---That's an interesting idea. I don't see it replacing these lists though.
--- End quote ---
What I mean is once that information is in the DB you could easily write code to generate the lists on-the-fly. So we have the lists BUT nobody needs to maintain them as they would just be asking the database "list all the files flagged as 'needed' issues ordered by title". Once the issue is bought/scanned the flag is flipped and the next time someone loads that page the list is up-to-date.
Does that make sense?
--- Quote ---That sounds so cool your mini-comics!
--- End quote ---
Thanks. I print three two-page leafs on a single legal sized page. Making a twelve page book. I have a script which lets me select pages from various image files (We're working through "Animal Comics" right now - mostly Jigger and Rover) and it compiles them into a text file with the filenames. Then I have another script in Scribus (an open source page-layout software - like InDesign) which loads the template and puts all the images in the right order. I print it, fold the spine and then staple. With all the scripting I can produce one in about 8-10min and my costs are probably about 40 cents.
movielover:
Yes, but you can't just take a book off because it shows up. There books missing pages, pages damaged, part fiche/part GM, UK reprints, etc.
Truthfully, it's not hard to maintain now that strike through is gone and the constant cleaning required by that.
Yoc:
All good points ML.
Jon's script would have to be able to flag each book for multiple states.
A colour coded Google Spreadsheet for these lists is something that sounds attractive but would require so much time to setup it's not feasible.
-Yoc
jonathangraham:
--- Quote from: movielover on May 17, 2015, 09:05:53 AM ---Yes, but you can't just take a book off because it shows up. There books missing pages, pages damaged, part fiche/part GM, UK reprints, etc.
--- End quote ---
Thanks! That's very good information. Hmmm. Am I incorrect in assuming that you track a lot of those things in some kind of notes field? If so, then I think all you would need to do is keep that process and have a three state flag "Complete, Incomplete, Missing" the notes field would contain all the criteria that makes it incomplete. So now your list is generated by the query:
"Show me all the Missing or Incomplete issues in the database and their notes ordered by title"
I'm not sure exactly what is meant by "uk reprints". If we mean tracking a book with the same title and issue number but was published in a different country. IMHO you would track that as a separate item from the North American issue.
Also if you find it difficult to track books by the issue. You might consider tracking them by the page. A page could have a "problem code" - "missing", "low-quality", "damaged", etc.. it would also reference the parent issue. You could then issue a query like:
"Show me all the issues with pages with problems ordered by title"
I admit that setting that up would be complicated but it would allow for a number of pretty interesting criteria. For example if you wanted to mark pages containing racial epithets (for child-friendly filtering) or collect pages into a "feature". i.e. you could select out all the Archie issues that contained "little archie" or all the pages in "Animal Comics" that were a "Pogo" feature. Page numbers in a particular issue wouldn't even have to be unique allowing you to have alternates for example ones that had been digitally restored by volunteers.
Anyway, I'm just thinking out loud here. I really don't have any knowledge of the pitfalls of your data so don't make major changes on my account. However if you have been thinking about overhauling the data schema I'd be more than happy to help out.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version