Re: Multi-language BPCS data transferred as CSV in documentfolder

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
2012 April I had a serious PC melt down, from which I am still recovering
-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of 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
documentfolder

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


--
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.