Magic book list in excel?

Discuss the historical aspects of magic, including memories, or favorite stories.
Jacky Kahan
Posts: 393
Joined: March 16th, 2008, 4:55 pm
Location: Belgium
Contact:

Magic book list in excel?

Postby Jacky Kahan » February 13th, 2004, 11:25 am

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

Jim Maloney_dup1
Posts: 1709
Joined: July 23rd, 2001, 12:00 pm
Location: Northern New Jersey
Contact:

Re: Magic book list in excel?

Postby Jim Maloney_dup1 » February 13th, 2004, 12:09 pm

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

Guest

Re: Magic book list in excel?

Postby Guest » February 13th, 2004, 3:50 pm

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/

Jeff Haas
Posts: 957
Joined: January 17th, 2008, 12:00 pm
Location: San Mateo, CA

Re: Magic book list in excel?

Postby Jeff Haas » February 13th, 2004, 5:10 pm

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

Jacky Kahan
Posts: 393
Joined: March 16th, 2008, 4:55 pm
Location: Belgium
Contact:

Re: Magic book list in excel?

Postby Jacky Kahan » February 14th, 2004, 1:20 am

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

Philippe Noël
Posts: 456
Joined: March 13th, 2008, 10:43 am
Location: Belgium(Liège)
Contact:

Re: Magic book list in excel?

Postby Philippe Noël » February 14th, 2004, 3:01 am

Jacky,
Just don't forget Uli Weigel fantastic books index: http://home.t-online.de/home/uli.weigel/ae_book.htm

Frank Yuen
Posts: 594
Joined: January 17th, 2008, 12:00 pm
Location: Winfield, IL

Re: Magic book list in excel?

Postby Frank Yuen » February 14th, 2004, 3:42 am

Jim Molinari has a database of Marlo in print on his website at www.jimmycards.com .

Frank Yuen

CHRIS
Posts: 678
Joined: January 31st, 2008, 12:00 pm
Location: las vegas

Re: Magic book list in excel?

Postby CHRIS » February 14th, 2004, 4:26 am

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.


Jacky Kahan
Posts: 393
Joined: March 16th, 2008, 4:55 pm
Location: Belgium
Contact:

Re: Magic book list in excel?

Postby Jacky Kahan » February 14th, 2004, 6:38 am

Thanks all for the excellent links!!!
i'll have my list faster than i thought...

cheers!

Guest

Re: Magic book list in excel?

Postby Guest » February 14th, 2004, 9:05 am

Also check out Micky Hades' website.

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

Guest

Re: Magic book list in excel?

Postby Guest » February 14th, 2004, 5:12 pm

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

Guest

Re: Magic book list in excel?

Postby Guest » February 14th, 2004, 5:40 pm

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.

CHRIS
Posts: 678
Joined: January 31st, 2008, 12:00 pm
Location: las vegas

Re: Magic book list in excel?

Postby CHRIS » February 15th, 2004, 6:21 am

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.

Jacky Kahan
Posts: 393
Joined: March 16th, 2008, 4:55 pm
Location: Belgium
Contact:

Re: Magic book list in excel?

Postby Jacky Kahan » February 15th, 2004, 6:42 am

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!!!

CHRIS
Posts: 678
Joined: January 31st, 2008, 12:00 pm
Location: las vegas

Re: Magic book list in excel?

Postby CHRIS » February 15th, 2004, 6:58 am

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.

User avatar
Joe Pecore
Posts: 1914
Joined: January 17th, 2008, 12:00 pm
Favorite Magician: Paul Harris
Location: Northern Virginia

Re: Magic book list in excel?

Postby Joe Pecore » February 15th, 2004, 8:16 am

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
Share your knowledge on the MagicPedia wiki.

Jacky Kahan
Posts: 393
Joined: March 16th, 2008, 4:55 pm
Location: Belgium
Contact:

Re: Magic book list in excel?

Postby Jacky Kahan » February 15th, 2004, 8:30 am

Hi Joe,

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

:p cheers

jacky

User avatar
Joe Pecore
Posts: 1914
Joined: January 17th, 2008, 12:00 pm
Favorite Magician: Paul Harris
Location: Northern Virginia

Re: Magic book list in excel?

Postby Joe Pecore » February 15th, 2004, 1:30 pm

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
Share your knowledge on the MagicPedia wiki.

Barajista
Posts: 40
Joined: December 25th, 2008, 7:55 am

Re: Magic book list in excel?

Postby Barajista » February 20th, 2004, 7:10 am

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

Barajista
Posts: 40
Joined: December 25th, 2008, 7:55 am

Re: Magic book list in excel?

Postby Barajista » February 20th, 2004, 7:14 am

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

Jacky Kahan
Posts: 393
Joined: March 16th, 2008, 4:55 pm
Location: Belgium
Contact:

Re: Magic book list in excel?

Postby Jacky Kahan » March 22nd, 2004, 7:33 am

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

Guest

Re: Magic book list in excel?

Postby Guest » March 22nd, 2004, 12:10 pm

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

Jacky Kahan
Posts: 393
Joined: March 16th, 2008, 4:55 pm
Location: Belgium
Contact:

Re: Magic book list in excel?

Postby Jacky Kahan » March 22nd, 2004, 2:36 pm

Andy,

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

All the best


Jacky

Guest

Re: Magic book list in excel?

Postby Guest » May 5th, 2004, 9:27 am

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/

Jacky Kahan
Posts: 393
Joined: March 16th, 2008, 4:55 pm
Location: Belgium
Contact:

Re: Magic book list in excel?

Postby Jacky Kahan » July 24th, 2004, 10:56 am

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

Bob Kentner
Posts: 58
Joined: January 18th, 2008, 12:00 pm
Location: Davenport, NE

Re: Magic book list in excel?

Postby Bob Kentner » July 27th, 2004, 12:26 pm

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


Return to “Magic History and Anecdotes”