Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Creating an index (not portfolio related)
Old 07-04-2014, 11:16 AM   #1
Moderator Emeritus
braumeister's Avatar
Join Date: Feb 2010
Location: Flyover country
Posts: 13,198
Creating an index (not portfolio related)

ER members seem to have an inexhaustible wealth of information and experience, so here's a question.

A company in a small niche business is friendly to local hobbyists, so I would like to help them with a project they have had on the drawing board for years, so any suggestions would be welcome.

They have a large stock of magazines on the subject, going back quite a few years. They also have a large stock of books, going back decades.

None of this material is organized, just crammed on available shelf space, and none of it exists in electronic format -- only paper. That makes it nearly impossible to look up a topic and get the really valuable information contained in the publications.

I want to create an index to the material. I see the first step as creating a spreadsheet with the relevant bits (title, publication, date, etc.) and then sorting it various ways to produce useful files. Of course, a relational database would also be an option.

Has anyone ever tackled this sort of task?

braumeister is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 07-04-2014, 12:04 PM   #2
Thinks s/he gets paid by the post
Join Date: Jul 2012
Location: Mississippi
Posts: 1,894
I did some thing similar back in the mid '80s. We had a bunch of instruments that had to be tracked/inventoried. It was all paper stored in files cabinets. I used a DOS flat file DB that allowed fields to be created for things like serial numbers, type, location, date checked in/out, disposal etc. It would create reports, labels and could be searched. But this was before spreadsheets.

MS SQL server express is free, and there is a list of opensource DBMs, Download Free Windows Database Open Source Software - SourceForge

rbmrtn is offline   Reply With Quote
Old 07-04-2014, 05:25 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 22,373
I used RBase back in the 1980s, but I suspect what you need could easily be done using an Excel spreadsheet as a database and then various lookups and reports.

I've often used Excel as a database, and pivot tables for reports, but more for summarizing data.
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.

Retired Jan 2012 at age 56...60/35/5 AA
pb4uski is offline   Reply With Quote
Old 07-05-2014, 08:00 AM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
MRG's Avatar
Join Date: Apr 2013
Posts: 8,041
Yes I did some of this in my career.

The first step is defining how the data are related. I'm kind of guessing as what you want to do. Do you have many topics? Are they related to 0-many articles in 0-many magazines or books? The location of where the article is, in what magazine or book and its physical location is an attribute of the book or magazine.

The tools are out there and as suggested many are free. You may want to start very simple, many people are familiar with Excell. Assuming they will self serve, it may be a great front end tool and can serve as a database. Start small you can always change the database later. Of course you'll want some type of backup too.

Let my know your billing address, an invoice will be sent, thanks for your business.
MRG is online now   Reply With Quote
Old 07-05-2014, 08:12 AM   #5
Thinks s/he gets paid by the post
photoguy's Avatar
Join Date: Jun 2010
Posts: 2,301
My wife had an app where you could take a pic of the bar code and it would download all of the book information.

I think this should work for at least the newer material.

Sent from my Nexus 5 using Early Retirement Forum mobile app
photoguy is offline   Reply With Quote
Old 07-05-2014, 08:19 AM   #6
Thinks s/he gets paid by the post
Senator's Avatar
Join Date: Feb 2014
Location: Eagan, MN
Posts: 3,507
I have done quite a bit of database work. DB2, SQL Server, Oracle, Access, etc.

You need to be able to reference the material by whatever people might search for it. And be able to find the actual physical piece, once you find it in the reference table.

Title, Author, subject and even some key words. You may be able to do it in Access (or Excel), it seems small. Both are is cheap.

List all of the attributes that you need to reference. Also other information that may help, like article date, master publication, etc. Maybe a spot on the shelf where the material can be found.

Then, it's just data entry. Once the date is in Excel, you can slice/dice/sort/import it most anywhere.
FIRE no later than 7/5/2016 at 56 (done), securing '16 401K match (done), getting '15 401K match (done), LTI Bonus (done), Perf bonus (done), maxing out 401K (done), picking up 1,000 hours to get another year of pension (done), July 1st benefits (vacation day, healthcare) (done), July 4th holiday. 0 days left. (done) OFFICIALLY RETIRED 7/5/2016!!
Senator is offline   Reply With Quote
Old 07-05-2014, 10:29 AM   #7
Moderator Emeritus
braumeister's Avatar
Join Date: Feb 2010
Location: Flyover country
Posts: 13,198
Thanks, everyone.
I've done enough stuff like this that I understand all about the mechanics of it; was just hoping there might be some nifty new tool available that I didn't know about.

Sounds like there isn't, so the grunt work begins.
braumeister is offline   Reply With Quote
Old 07-05-2014, 02:37 PM   #8
Recycles dryer sheets
Join Date: Dec 2013
Posts: 366
You should consider converting some of the items to PDF files. Someone might have a suggestions as to how to best accomplish that too.
springnr is offline   Reply With Quote
Old 07-05-2014, 04:02 PM   #9
Thinks s/he gets paid by the post
growing_older's Avatar
Join Date: Jun 2007
Posts: 2,657
It seems to me that the bigger part of this job is getting the material into digital format. I have not done such a large scanning job, but I would expect that any scanners capable of doing the digitizing likely also have features to help with the indexing and cataloging.

growing_older is offline   Reply With Quote

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

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Not related to FIRE, but inspirational bondi688 Other topics 2 06-28-2013 01:07 AM
Creating an S-Corp 1/2 way through divorce... thefed FIRE and Money 3 04-12-2012 08:42 AM
Creating a 'holding company' to shield assets thefed FIRE and Money 13 12-16-2010 06:05 PM
Creating American Jobs? HFWR Other topics 3 07-02-2010 12:52 PM
TIPs index vs. Total Bond index kevink FIRE and Money 3 04-15-2005 04:45 AM

» Quick Links

All times are GMT -6. The time now is 09:12 AM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2019, vBulletin Solutions, Inc.