Welcome, Guest
Please Login or Register.    Lost Password?

DF Inventory - questions for someone with DB experience
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: DF Inventory - questions for someone with DB experience
#23522
DF Inventory - questions for someone with DB experience 7 Years, 6 Months ago  
If anyone has experience with databases and would be willing to assist me (at least by pointing me in the correct direction) with converting my DF Invetory spreadsheet over to a new system, I'd appreciate it if you'd drop me a line at weaverjk2002@hotmail.com.

I am a computer guy (have been for 26 years). As I thought they would be boring (those are the decitions you make when you are 10-16), I stayed away from databases. Now I wish I had kept up with the DB technology as it grew. I'm looking at taking my Excel spreadsheet and doing something better with it. Access Database? User Front-end Excel but connected to the Access DB? XML? Something.

When I put the spreadsheet together, I couldn't find a way to keep it such that I could sort the pages and not screw up all the links. I tried naming cells, but one sheet couldn't refer to the named cell on another sheet (or that would have worked just perfectly). In the end, my spreadsheet works great, as long as you don't ever sort it other than how I have it when I "published" it to everyone. Users love to sort things their own way. I'd like to be able to provide this capability.

I'd appreciate being pointed in the best direction for what I'd like to do.


Per one request, I'll try to update the Excel spreadsheet this month.
I would, however, prefer to have a more user-friendly (and don't forget spiffy) database ready to go.


Thank you much,

John
JKW
weaverjk
1st & 2nd Edition D&D DM & Player
Orc
Posts: 449
User Offline Click here to see the profile of this user
Gender: Male Location: Garden City, MI USA Birthday: 01/01
The administrator has disabled public write access.
62 sets and counting. In addition, a boatload of individual pieces or sets of pieces.
 
#23523
DF Inventory - questions for someone with DB experience 7 Years, 6 Months ago  
John;

Didn't someone here post an Excel spreadsheet that worked wonders for them with tracking inventory?
I do a lot of Access db stuff at work (my classification is DB SpecII), and while an Access DB would be relatively easy to do, if someone out there has already done it, why duplicate effort?
For that matter, TileSystem allows you to both inventory your entire collection AND make maps for setups - and it works! The only problem is that LoneStarr, being in Germany, has a financial restriction on getting various pieces photographed and into the system.
I'd seriously recommend checking with pfworks and LoneStarr about TileSystem. You can find them up in the 'How Do I Use This Stuff' section of the forum.

Jim
jkratzer
Minotaur Lord
Posts: 2057
User Offline Click here to see the profile of this user
Location: Baltimore, MD
The administrator has disabled public write access.
Jim Kratzer, a/k/a The Mad Yank
Proud Vietnam Veteran, LOUD VFW Lifer
insane GM
 
Go to topPage: 1