Querying AMR

highwinder · 21 October 2008, 15:42

Is there anyway to produce lists from the AMR? I am basicly looking for a list of every game reviewed by Amiga Power and the issue number it was reviewed in? Thanks in advance...

Codetapper · 21 October 2008, 23:37

That's not quite so easy at the moment, as the reviews table stores everything - reviews, previews, cheats, PD games etc. It might be easier to beg CodyJarrett for his Excel spreadsheet that just lists the commercial games reviewed if that is what you are after.

Incidentally, what's it for?

OddbOd · 22 October 2008, 08:28

Codetapper, do you have any objections to screen scraping for this sort of thing?

highwinder · 22 October 2008, 10:32

Thanks for the replies. It is just for cataloguing my personal collection of games, just out of interest really. No problem if its not a simple task, but thought it would be worth asking!

OddbOd · 25 October 2008, 09:18

Do you still need this to be done? If you do let me know exactly what information you require and what format you would like it in eg. text file, CSV text, excel sheet.

highwinder · 26 October 2008, 12:13

Yep that would be brilliant if you could. Basicly a excel list of all the games reviewed by Amiga Power and in what issue it was reviewed. Thanks in advance!

CodyJarrett · 26 October 2008, 12:47

Check your Private Messages - I've sent you my original spreadsheet of AP data.

21 October 2008, 15:42	#1
highwinder Registered User Join Date: Sep 2008 Location: Australia Posts: 21	Querying AMR Is there anyway to produce lists from the AMR? I am basicly looking for a list of every game reviewed by Amiga Power and the issue number it was reviewed in? Thanks in advance... Last edited by highwinder; 21 October 2008 at 15:57.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
has amr got all of these?	chiark	AMR news	13	01 June 2009 21:55
AMR is 1 and a little bit	Galaxy	AMR news	6	02 August 2008 23:12
AMR Res	BippyM	AMR suggestions and feedback	5	27 November 2007 21:50
My first contribution to AMR	ugopaliotto	AMR contributions	1	28 July 2007 13:41
AMR: Next Update(s)?	Basquemactee1	AMR news	5	16 July 2007 02:51

21 October 2008, 23:37	#2
Codetapper 2 contact me: email only! Join Date: May 2001 Location: Auckland / New Zealand Posts: 3,182	That's not quite so easy at the moment, as the reviews table stores everything - reviews, previews, cheats, PD games etc. It might be easier to beg CodyJarrett for his Excel spreadsheet that just lists the commercial games reviewed if that is what you are after. Incidentally, what's it for?

22 October 2008, 08:28	#3
OddbOd Registered User Join Date: Jul 2005 Location: Australia Age: 46 Posts: 666	Codetapper, do you have any objections to screen scraping for this sort of thing?

22 October 2008, 10:32	#4
highwinder Registered User Join Date: Sep 2008 Location: Australia Posts: 21	Thanks for the replies. It is just for cataloguing my personal collection of games, just out of interest really. No problem if its not a simple task, but thought it would be worth asking!

25 October 2008, 09:18	#5
OddbOd Registered User Join Date: Jul 2005 Location: Australia Age: 46 Posts: 666	Do you still need this to be done? If you do let me know exactly what information you require and what format you would like it in eg. text file, CSV text, excel sheet.

26 October 2008, 12:13	#6
highwinder Registered User Join Date: Sep 2008 Location: Australia Posts: 21	Yep that would be brilliant if you could. Basicly a excel list of all the games reviewed by Amiga Power and in what issue it was reviewed. Thanks in advance!

26 October 2008, 12:47	#7
CodyJarrett Global Moderator Join Date: Mar 2001 Location: UK Age: 46 Posts: 6,160	Check your Private Messages - I've sent you my original spreadsheet of AP data.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)