BPCS / ERP LX Upload to Master File (data integrity assurance)

<vendor>



Al and Rob both contributed bulls-eye commentary about the data integrity
risks inherent in updating a crucial file from an Excel spreadsheet. Over the
decades we've traced many BPCS misfires back to "how in the world did that
get in there?" garbage sitting in some IIM or RCM or ECH field.



We've invented a product called "Needle in a Haystack" which finds odd-ball
data change/insertion errors and then immediately e-mails an alert to the
database guardian. If some element of data in Andry's spreadsheet was
abnormal or rare, Needle in a Haystack (T) would find it and report it while
his upload was underway.



More information:
<http://www.unbeatenpath.com/software/needle/in-a-haystack.pdf>
www.unbeatenpath.com/software/needle/in-a-haystack.pdf



The idea is to find data anomalies and fix them before garbage is propagated
into dozens or thousands of transactions. You don't need Sarbanes-Oxley
auditors looking over your shoulder to recognize the value of that.



Warm regards and peace to you,

Milt Habeck

Owner

Unbeaten Path International

(888) 874-8008

+262-681-3151





</vendor>











From: "Al" <macwheel99@xxxxxxxxxx>

To: "'BPCS ERP System'" <bpcs-l@xxxxxxxxxxxx>

Date: 01/25/2011 05:44 AM

Subject: Re: [BPCS-L] BPCS/ERPLX Upload File - Master



I assume when you say XLS you are referring to data from outside the
AS/400-i.



In theory data added to BPCS files can come from any source ... human

keying, mass dump from other files, modification inside or outside BPCS.

What is critical is that it come in a form or methodology which is

compatible with BPCS logic, that maintains the integrity of links between

the different files of BPCS, and the data within the files obey the rules

of alpha vs. numeric, valid date etc. of the files the data is going into.



In other words, if the usual program to populate the various fields

Imposes some logic on what is valid to put there, then any other approach you
use

To upload data must obey that same logic, or else you are placing BPCS at

Risk of data corruption and crash.



Al Mac







-----Original Message-----

From: Andry Elone

Sent: Monday, January 24, 2011 7:50 PM

To: bpcs-l@xxxxxxxxxxxx

Subject: [BPCS-L] BPCS/ERPLX Upload File - Master



Dear All,

Please advices, upload the data from xls to the BPCS/LX master file like

IIM, is allowed?

Thanks & Regards,

Andry