Subject:
|
Re: Pause Set Lists
|
Newsgroups:
|
lugnet.admin.database
|
Date:
|
Wed, 17 Nov 1999 15:09:08 GMT
|
Viewed:
|
902 times
|
| |
|
|
I do mine a little differently. I just take the Pause list, print it and
then do a line by line compare with the Access database that I use and type
the additions in manually. But I don't do it weekly, I do it about once a
quarter. There are several problems that I have:
1) Set #'s are not unique. Todd has overcome this in the Lugnet databases
and must have some form of Key value.
2) My "goal" would be to keep the Pause/Lugnet database in a table of it's
own, and then use the Key value to link to a table of mine that has my
"Want", "Own", etc. fields in it. This way I can just replace the entire
Pause/Lugnet database once a quarter and have all the new data points, but
still have the data "connected" to my table.
The main reason I use Access instead of Excel ... I've not written any
reports or forms or any other Access features, I use Access just like you
use Excel in "spreadsheet" mode ... is because I have a utility that will
convert an Access database to a MobileDB database that I can put on my Palm
and take it with me where ever I go. Makes it much easier to remember if
you already have a set or want a set when you are at a new store
Mike
-----
mike at faunce dot com
Heather Patey <hpatey@nfld.com> wrote in message
news:FLCIqn.J6A@lugnet.com...
> In lugnet.admin.database, Mike Faunce writes:
> > Todd,
> >
> > Are the Pause set lists coming from your database now? If so, can you • add
> > the index key that you use to the comma delimited files? I download the
> > Pause set list and then use it to update a database that I use to track
> > which sets I have and which I am looking for. If the index key were
> > available I would be able to make this a much more automated process. • Now I
> > have to go through the new list and the old list and find the differences
> > and add the new sets manually as there isn't an easy way to pull it in • when
> > there are multiple sets with the same set number. I know that there are
> > 1999 sets that I don't have in my database. I dread doing it all again
> > manually for the 2000 sets.
>
> I do this too, to keep track of information like what sets I have, what I • paid
> for them, what I have instructions for, and what's missing pieces. (I • also
> split Theme and Subtheme so it's easier to filter on a whole theme.) I • keep it
> in Excel, and updating it, even every few weeks, is a real chore. I make • new
> columns, one for each field, to the left of the existing data, sort both • lists
> by number, and paste the new list into the blank space. I make an extra • column
> between them with a formula that compares the data in the "new" columns to • the
> data in the "old" columns for each row and flags any differences, so then • I can
> see which rows have mismatched data. If it's a new entry I push down the • cells
> in the "old" columns only (and my own info) and copy the data across from • the
> new to the blank cells in the old; if the entry requires changes, I copy • the
> changes across. When all the cells in the "check" column say "OK", I'm • done
> and can delete the "new" columns, since they're now the same as the "old" • ones.
>
> Whay system do you use, Mike? I'm not sure having an index key would • improve
> my current system a lot, but if yours is easier to use (or would be, if • you had
> an index) I'd jump on it!
>
> Heather Patey
> St. John's, Newfoundland, Canada
> Pirate Wench / Brick Detective
|
|
Message has 1 Reply:
 | | Re: Pause Set Lists
|
| Wow, manual updates sound even more painful and error-prone than my procedure. There are 3000+ lines in that thing, I can't imagine checking every line for changes in theme, piece count and whatnot. I see what you mean, that the linking is what (...) (27 years ago, 17-Nov-99, to lugnet.admin.database)
|
Message is in Reply To:
| | Re: Pause Set Lists
|
| (...) I do this too, to keep track of information like what sets I have, what I paid for them, what I have instructions for, and what's missing pieces. (I also split Theme and Subtheme so it's easier to filter on a whole theme.) I keep it in Excel, (...) (27 years ago, 17-Nov-99, to lugnet.admin.database)
|
4 Messages in This Thread:
 
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
Active threads in Database
|
|
