Re: Data Conversion

[DAsmussen@xxxxxxx]

Anthony,

In a message dated 11/1/00 10:42:04 PM Eastern Standard Time, 
Anthony_Perera@csl.com.au writes:

> We are currently running BPCS 405CD and implementing 6.1.1.   I have been
>  running data conversions and looking at discrepancies. Our current KMR,KFP
>  files have due dates of 2001/01/01 and these dates are getting converted as
>  1901/01/01. We are doing a multistep conversion and tracked down the 
problem
>  to when the database is converted from 5.2.2 to 6.0.0. I had a look at the
>  conversion programs for this step and found that the 6 digit date 10101 is
>  hard coded in all the programs and if any file date fields hit this then 
the
>  date is updated with 1901/01/01 which is the default century begin date in
>  the convert command. If I change this to 2001/01/01 it will fix the problem
>  but I'm not sure whether it will have any other repercussions since I 
cannot
>  find any logical reason for this begin date to be used in the first place.
>  any ideas? please help.

Don't know about KMR, but if I step into the "wayback machine" to when we 
were upgrading from 5.1.01 to 6.1.01 at another client two or so years ago, I 
seem to recall similar date issues even prior to Y2K for KFP.  I believe that 
the "answer" was that this file gets rebuilt during a regenerative MRP, so 
run one after you convert.  Yeah, right.  We were supposed to run a 
conversion that barely fit into a four day weekend, then turn around and run 
something other than a net change MRP before third shift showed up.  We ended 
up writing our own "date fix" program for KFP...

Regards,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-mail:  DAsmussen@aol.com

"My life has no purpose, no direction, no aim, no meaning, and yet I'm happy. 
 What am I doing wrong?" -- Charles M. Schulz
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---