Lots of database work today, which really helped me get books back into Barnes and Noble that I had pulled from a 3rd party… AND sets me up to move much more efficiently with the flood of new material I’ll be dealing with in 2012… Mandatory City Power Outage in the AM means I’ll be mobile for most of the day, then a flood of audio and video work tomorrow night…
I use Filemaker (don’t hate), and I’ve been working with an awkward database to track Brick Cave Media’s products, create product numbers and sort of act as a “master reference” whenever I needed information about a product. like, “What is the uRL of Joe’s book at Amazon?” kind of stuff.
Problem was, I hated it, because it was not particularly dynamic (in design, the software was fine). Years ago, when i had Anthology magazine, I had a sweet FM database setup to track submissions as they came in, got reviewed, and were accepted or rejected- it was sweet dynamic, we kept track of contacts and the whole nine yards.
This database was none of that, it was flat, and cumbersome to utilize the data I wanted when I wanted it. Since that time (2010), I have created a new database for keeping track of our relationships with bookstores in the country, and while it didn’t need to be all that, I pulled the two together because I wanted to access the BCM product numbers as choices to document what we sent to the bookstores, and I just felt sad for it. It was pathetic.
Pathetic no more.
I broke down today, because I needed to get a set of books back into B&N that I had pulled from Smashwords (nothing to do with Smashwords, they’re cool), and I know I just needed to spend the time and fix this database and make it right.
So I reformatted the whole thing, top to bottom, built in the dynamic fields to track ISBN’s by store and keep track of changes and updates. I can now pull up a list of the URL’s for each store a product is in. I reformatted my product Identifiers to make them more streamlined.
My next phase, which I did not get done today, but laid the ground work for, was tracking sales by store and breaking out reports based on whatever bat-shit crazy thing I decide I want to measure. Eventually, i would love to be able to import data form each store and have it populate the sales information for me, but that’s a bit above my pay grade at the moment
The best part, all the books got back into B&N lickety split, and it felt awesome…












