Don,
I have a CL that does a DSPOBJD of all files in a specified library to a workfile, complete with File Description and Number of records. It's then a simple task to drop it into Excel. I do it using Routeone software, but it's also easy via client/access data transfer.
I ran it over our BPCS file libraries (we are on Lx 8.3.2) and it's surprising how few of the hundreds of files actually have anything in them.
If you'd like the code, let me know offline:
Tom.Molyneux@xxxxxxx
----- Original Message -----
From: bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx <bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx>
To: bpcs-l@xxxxxxxxxxxx <bpcs-l@xxxxxxxxxxxx>
Sent: Thu Sep 17 16:27:11 2009
Subject: [BPCS-L] 405cd file name documentation
All.
Does anyone have a simple WORD or Excel document which contains file names and a short, one sentence description?
E.G.:
LCR - (ALL W/C's - capacity requirements detail) has about 20K records - incl. outside w/cs
LRF - (Rough Cut capacity detail - CRITICAL W/C's ONLY) has about 15K records- excl. ALL outside w/cs
LBR - has about 13K records - EXcl. outside w/cs - time per unit at each W/C - but under the "E" item types ONLY!
LWK - W/C Master file - one record for eack workcenter - Incl outside.
Thanks in Advance!
Don C.
Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063
"It's amazing what you can accomplish if you don't care who gets the credit." Harry S. Truman
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/bpcs-l.
Delivered-To: Tom.Molyneux@xxxxxxx
Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Martin Street, Audenshaw, Manchester. M34 5JA
midrange.com
