INPUT magazine metadata and extracts

feedback, questions and discussion relating to the Complete BBC Games Archive (beta site now open!)
Post Reply
occularis
Posts: 15
Joined: Wed Aug 30, 2017 3:56 pm
Contact:

INPUT magazine metadata and extracts

Post by occularis » Fri Apr 13, 2018 8:05 pm

Hi all,

I just had a long train journey from Berlin back to the UK so I got round to doing something I'd occasionally thought of: capturing metadata about articles in INPUT magazine. The data is in a spreadsheet, see attached photo for a sample.

The nice thing about the metadata is that it then allows me to use a python script and qpdf to extract series of related articles into a single PDF.

For example, here's a PDF containing just the articles on 3D graphics: (8MB)

https://www.dropbox.com/s/27t3icjh740eq ... s.pdf?dl=0

And here's a PDF containing all the articles for the first adventure game: (20MB)

https://www.dropbox.com/s/ticqewj1tt8kw ... e.pdf?dl=0

Is this INPUT metadata of interest to the archive? Or extracted PDFs? I find that if you're interested in a certain series of articles in INPUT, it's *much* easier to study/use if you have all the related articles in a single PDF.

I noticed a few random things while doing this thing; for instance, that the Peripherals articles are not numbered for some reason (all the other series are numbered); and the 2nd machine code article in INPUT is actually about basic programming, not m/c.
Attachments
Input contents spreadsheet.png

User avatar
pau1ie
Posts: 552
Joined: Thu May 10, 2012 9:48 pm
Location: Bedford
Contact:

Re: INPUT magazine metadata and extracts

Post by pau1ie » Fri Apr 13, 2018 8:38 pm

This is really interesting, and useful.

The bbcmicro.co.uk website is rather limited (By design). I can't think of a way to incorporate this (Can you?). I think we have all the input magazine games, though Lee is the expert here.

Could you create a website to incorporate this, or put the data in github or similar?
I'm working on http://bbcmicro.co.uk

occularis
Posts: 15
Joined: Wed Aug 30, 2017 3:56 pm
Contact:

Re: INPUT magazine metadata and extracts

Post by occularis » Sat Apr 14, 2018 10:30 am

Hi, yes I did think about putting the db onto a public repo on github. Maybe as a Libre Office spreadsheet, or SQLite database (or both). I could add the python script that makes the PDF extracts too.

As for the extracted PDFs (see two linked examples above), I could put them on archive.org.

occularis
Posts: 15
Joined: Wed Aug 30, 2017 3:56 pm
Contact:

Re: INPUT magazine metadata and extracts

Post by occularis » Sat Apr 14, 2018 6:04 pm

Got some cute little visualisations going too. This image shows the occurence of the Languages articles across all pages of Input.

Think I might make an infographic style thing, just for fun.

(Issue 1 at the left side; issue 51 at the right)
Screen Shot 2018-04-14 at 19.02.06.png

User avatar
richardtoohey
Posts: 3589
Joined: Thu Dec 29, 2011 5:13 am
Location: Tauranga, New Zealand
Contact:

Re: INPUT magazine metadata and extracts

Post by richardtoohey » Sun Apr 15, 2018 1:01 am

I enjoyed skimming the adventure PDF, so thanks for that. =D>

Must have taken them some effort to code for so many machines. :-k

occularis
Posts: 15
Joined: Wed Aug 30, 2017 3:56 pm
Contact:

Re: INPUT magazine metadata and extracts

Post by occularis » Mon Apr 16, 2018 8:55 am

pau1ie wrote:... though Lee is the expert here.
Which user is Lee? Interested in chatting to him.

User avatar
richardtoohey
Posts: 3589
Joined: Thu Dec 29, 2011 5:13 am
Location: Tauranga, New Zealand
Contact:

Re: INPUT magazine metadata and extracts

Post by richardtoohey » Mon Apr 16, 2018 9:25 am

leenew ... not sure what he did to the leeold ... :shock:

User avatar
leenew
Posts: 3657
Joined: Wed Jul 04, 2012 3:27 pm
Location: Doncaster, Yorkshire
Contact:

Re: INPUT magazine metadata and extracts

Post by leenew » Mon Apr 16, 2018 9:26 am

Hi,
I'm Lee :D
Actually, all the Input magazine games are here http://www.stardot.org.uk/forums/viewto ... ne#p187927
At present, there are hundreds of magazine games that have been located, or typed in, but have not yet been uploaded to bbcmicro.co.uk
Things are a little slow at present :(

Lee.
p.s. if it is a question you have regarding games, then ask away.... if it is about backend website work....... ask Paul! :lol:

Post Reply