Page 1 of 1

Magic book list in excel?

Posted: February 13th, 2004, 11:25 am
by Jacky Kahan
Hello,

I'm looking for someone who has already a database or extensive list of magic books.....
(title, author, year, publisher etc...)
to be honest, I was hoping someone else already started a list (excel is ok)so i don't have to start from scratch...

can anyone help?

thanks a lot

jacky

Re: Magic book list in excel?

Posted: February 13th, 2004, 12:09 pm
by Jim Maloney_dup1
Best I can offer you is Doug Atkinson's Magic Reference Pages. He has a large list of books, with full table of contents listings. It no where near covers all magic books published, but it is a good list. There are a little over 350 books listed. Here's the link:

http://magicref.tripod.com/books.htm

-Jim

Re: Magic book list in excel?

Posted: February 13th, 2004, 3:50 pm
by Guest
If you're looking for contents, the above mentioned site is good, and I also have a few books listed on my site (around 30 or so, I believe).

http://www.obsolite.com/magic/

Re: Magic book list in excel?

Posted: February 13th, 2004, 5:10 pm
by Jeff Haas
Those sites are a good start, but someone still needs to copy all that info into a single Excel spreadsheet so it can be easily viewed and sorted.

No thanks, I do enough of that at work.

Jeff

Re: Magic book list in excel?

Posted: February 14th, 2004, 1:20 am
by Jacky Kahan
Hi All,

Thanks for all the replies, I knew those sites...but am still looking for other sources...
I'm working on an xls file right now and as soon as it's ready, (a few weeks) (I hope..)I'll let you know.

other links I've found for those that are interested :
http://www.wittuswitt.de/Biblio.html
http://www.magician.co.uk/magicbooks.htm
http://www.linkingpage.com/books.html

cheers

jacky

Re: Magic book list in excel?

Posted: February 14th, 2004, 3:01 am
by Philippe Noël
Jacky,
Just don't forget Uli Weigel fantastic books index: http://home.t-online.de/home/uli.weigel/ae_book.htm

Re: Magic book list in excel?

Posted: February 14th, 2004, 3:42 am
by Frank Yuen
Jim Molinari has a database of Marlo in print on his website at www.jimmycards.com .

Frank Yuen

Re: Magic book list in excel?

Posted: February 14th, 2004, 4:26 am
by CHRIS
My list of 160+ ebooks is also available online. And if you click through each individual ebook page you can also access the table of contents of each one.

Reverse chronological list by release date
http://www.lybrary.com/ebooks.php

Grouped by category
http://www.lybrary.com/browse.php

Clicking on a title and then on Table of Contents gives you access to the ToC.

I would assume that any of the bigger magic book publishers (Hermetic Press, L&L, Kaufman, ...) has their catalog and back list in a spread sheet or some other electronic form. Which suggests the question "why don't we have a magic books in print" somewhere?

Chris Wasshuber
preserving magic one book at a time.

Re: Magic book list in excel?

Posted: February 14th, 2004, 6:06 am
by Guest

Re: Magic book list in excel?

Posted: February 14th, 2004, 6:38 am
by Jacky Kahan
Thanks all for the excellent links!!!
i'll have my list faster than i thought...

cheers!

Re: Magic book list in excel?

Posted: February 14th, 2004, 9:05 am
by Guest
Also check out Micky Hades' website.

http://members.shaw.ca/mickyhades/

Re: Magic book list in excel?

Posted: February 14th, 2004, 5:12 pm
by Guest
I've got, on Filemaker, a list of about 900 books by Author, Pub date, Title, binding, number of pages, condition, value, and some comment on contents.

I checked the export function, and it saves to tab .csv, .slk, .dbf, .dif, .wk1, .bas, .dif, and .mer.

But I'm uncertain as to what you need -- just a huge list of magic books? Virtually all of my listing is card and close-up related.

--Randy Campbell

Re: Magic book list in excel?

Posted: February 14th, 2004, 5:40 pm
by Guest
Randy, I'd like to take a look at your list, just to see the variety of books published. Could you send the file, in whatever format convenient, to me at roatc@comcast.net ? I'll find whatever program is needed to view the file.

Re: Magic book list in excel?

Posted: February 15th, 2004, 6:21 am
by CHRIS
I don't want to hijack anybodies project here, but if a compiled list from the above mentioned resources is created, I would like to offer to publish this list of magic books on my website on its separate page. I could even put it in its separate database with forms to add, search and access this list, similar to my MLP (Magic Lineage Project http://www.lybrary.com/mlp/). Then we would have a way for others to contribute and add and keep the list updated.

Chris Wasshuber
preserving magic one book at a time.

Re: Magic book list in excel?

Posted: February 15th, 2004, 6:42 am
by Jacky Kahan
Hi Chris,

I've complied an Excel file with all the above mentioned, i'm still cleaning out this data.

I have nothing against such a project if:

a: the owners of the sites don't mind us to share it...
b: it's free :)

let me know...

cheers

jacky

ps: your MLP project is cool!!!

Re: Magic book list in excel?

Posted: February 15th, 2004, 6:58 am
by CHRIS
I am sure also Richard Hatch at H&R magic books has his list of thousands of second hand books in electronic form. All of the resources mentioned here put together should yield a formidable list.

Chris Wasshuber
preserving magic one book at a time.

Re: Magic book list in excel?

Posted: February 15th, 2004, 8:16 am
by Joe Pecore
Denny and Lee' also has a huge listing.
Sign up for his newsletter and you'll get a text version every once in a while.

(let me know if you want me to send you the last copy I got).

http://www.dennymagic.com/cgi-bin/hazel ... talog.html

- Joe

Re: Magic book list in excel?

Posted: February 15th, 2004, 8:30 am
by Jacky Kahan
Hi Joe,

thanks for the info,
please send me a copy of the list if possible...

:p cheers

jacky

Re: Magic book list in excel?

Posted: February 15th, 2004, 1:30 pm
by Joe Pecore
Be looking for it in your email.

I'd be interested in a copy of your final product or where it ends up online (even better, if it does).

- Joe


Originally posted by Jacky Kahan:
Hi Joe,

thanks for the info,
please send me a copy of the list if possible...

:p cheers

jacky

Re: Magic book list in excel?

Posted: February 20th, 2004, 7:10 am
by Barajista
Originally posted by Jacky Kahan:
Hello,

I'm looking for someone who has already a database or extensive list of magic books.....
(title, author, year, publisher etc...)
to be honest, I was hoping someone else already started a list (excel is ok)so i don't have to start from scratch...

can anyone help?

thanks a lot

jacky

Re: Magic book list in excel?

Posted: February 20th, 2004, 7:14 am
by Barajista
Originally posted by Jacky Kahan:
Hello,

I'm looking for someone who has already a database or extensive list of magic books.....
(title, author, year, publisher etc...)
to be honest, I was hoping someone else already started a list (excel is ok)so i don't have to start from scratch...

can anyone help?

thanks a lot

jacky
Hi Jacky, you may already have this, but Swann Galleries has auction lists posted on their website of the books and other magic items they've sold over the past few years. Please let me know if you make your list available, I would love to see it when done! Thanks, Patrick

Re: Magic book list in excel?

Posted: March 22nd, 2004, 7:33 am
by Jacky Kahan
Hi All,

First of all thanks to everyone for the help!!
Since we don't have 30 hours a day, the list is not finished yet...

I hope to have the project ready in a week or two... maybe earlier depending on timing...

all the best

jacky

Re: Magic book list in excel?

Posted: March 22nd, 2004, 12:10 pm
by Guest
Just noticed this thread. Here is a Zipped Excel file to a spreadsheet with almost 400 standard magic books that I built for my site:

Quality Magic Books

Feel free to use it and edit it.

Good luck,

andy

Re: Magic book list in excel?

Posted: March 22nd, 2004, 2:36 pm
by Jacky Kahan
Andy,

You have a very nice site!!! thanks for sharing!

All the best


Jacky

Re: Magic book list in excel?

Posted: May 5th, 2004, 9:27 am
by Guest
This may be a little off-topic but I hope you find it somewhat relevant.

If you are looking for a computer program which helps you organize your library (or any other collection, really), you should obtain a program called BookCat. It is a really wonderful program that can be customized and is a fully searchable relational database based on MS Access, and it is an absolute bargain.

To get more information, go to http://www.fnprg.com/bookcat/

Re: Magic book list in excel?

Posted: July 24th, 2004, 10:56 am
by Jacky Kahan
Hello,

Just wanted to let you know that our book project is finally online.

CLICK HERE

Please check it out and let us know what you think.

Jacky

Re: Magic book list in excel?

Posted: July 27th, 2004, 12:26 pm
by Bob Kentner
Originally posted by Clay Shevlin:
If you are looking for a computer program which helps you organize your library (or any other collection, really), you should obtain a program called BookCat. It is a really wonderful program that can be customized and is a fully searchable relational database based on MS Access, and it is an absolute bargain.
Clay,
How do you like BookCat. I have been using Collectorz. They looked pretty similar. But, I do like the idea of using the MS Access engine vice being written in XML. I understand bookcat will also allow you to catalog books that are part of a Volume of works. (i.e. all the works in The Secret Ways of Al Baker.)

Bob