<vendor>
Dear Margareth,
Al Mac blessed us with a kind word about Locksmith Archiving software for
BPCS and ERP LX. Here's a link to more info:
http://www.unbeatenpath.com/software/locksmith/archiving.pdf
To the best of our knowledge, there is at least one competitive iSeries
archiving product that works well if you take the time to configure it
according to all the BPCS/ERP LX rules. We know of more than one BPCS user
that has gone down that path only to discover some time later that their
diligent configuration work was +/-85% complete. That's discovered only when
they trip over orphaned records in a few more files.
Locksmith arrives out of the box with all the BPCS / ERP LX rules memorized
... and it does handle master files. We call it Locksmith because it unlocks
response time from the effects of enormous files loaded with old
transactions.
Peace to you,
Milt Habeck
Unbeaten Path
(888) 874-8008
+262-681-3151
mhabeck@xxxxxxxxxx
</vendor>
From: Al Mac Wow
Sent: Tuesday, May 22, 2012 11:48 AM
To: 'BPCS ERP System'
Subject: [BPCS-L] Multi-language BPCS data transferred as CSV in document
folder
Several vendors have archiving software already available for BPCS.
You can find info on many of them, by searching BPCS-L archives.
I use the one from UPI, called Locksmith.
We only have the part which deals with transactions.
There's more we have not got, which deals with master files.
You are probably aware that a lot of BPCS files have pointers to records in
other files: order #; sequence #; line #. When removing records from this
system, because they are ancient; while keeping other records still in the
system, you do not want to mess up how BPCS correctly accesses the records
you decide to keep. The vendors with their archiving systems have already
worked this out.
This past weekend I used Locksmith to archive a pile of completed customer
orders, after which I ran their program which recovers disk space, which was
consumed by the now gone records. You are probably aware that BPCS files eat
more disk space, as needed, but never return it. This is part of the
responsibility of archiving software.
The basis for our archiving includes orders which have been fulfilled, and
this happened over a year ago. UPI's Locksmith lets us choose which date(s)
to use to determine this, and correctly gets the right records. I am sure
the other vendors likewise have similar solutions.
Maybe you want the data extracted to archives by a methodology where you can
access them again for some future need.
I recently had a hard disk crash, wiping out approx 300 Meg of stuff on my
personal computer. I had been working on some Word documents, which I had
uploaded to Internet share sites in PDF format, before my unexpected crash.
I now have on my PC, software which copies from Word doc to PDF, and from PDF
to Word doc. However, what I have so far, does not recognize footnotes as
being incremented, and there are other problems. So while I am able to
recover my doc so Word can edit again, there are hassles, so I must look into
alternative PDF to Word software to find out which has the least hassles.
Likewise, in your reality, you want to have a process which is reversible,
without introducing hassles when you try to access your archived records.
UPI Locksmith copies the archived records to a separate library, where they
continue to be in BPCS format.
When moving iSeries data to Microsoft and other formats, there are add-ons
from Microsoft, or those other vendors, to facilitate this. Some of these
add-ons come free with Client-Access Operations-Navigator, or available for
customers of Microsoft Office, PDF vendors, as part of a paid package, some
of them cost extra. MIDRANGE-L may be a better place to ask about such
options.
Al Mac (WOW) = Alister William Macintyre via WOW WAY.com ISP
From: Margareth Sere
Sent: Tuesday, May 22, 2012 4:48 AM
To: BPCS ERP System
Subject: [BPCS-L] Multi-language BPCS data transferred as CSV in document
folder
Dear ALL,
We are on the process of data archiving BPCS data. As there are volumes of
data files to archive, we wanted to create a CLP program to handle this.
Can anyone help share commands I need to use in order to create a shared PC
document file in QDLS in CSV format with field names as column headings that
can handle data coming from BPCS data with language characters from Korea,
Simplified Chinese, and Traditional Chinese. We have different BPCS
environment for each affiliate we have. I have never tried this before as I
usually work on 1-2 files and just use iSeries Data Transfer, this time it
will be used on 6 affiliates.
Thank you so much for your help and advise.
Regards,
Margie
midrange.com
