Generalised codes

[Chris Kelleher]

Hi

MFGPRO 7.4F
Progress 7.3E

I would like to delete all generalised codes from a new database we are
cloning from our live db, are there any implications in doing this via
Progress.

i.e

for each code_mstr:
delete code_mstr.
end.

TIA


Richard Beveridge
Materials Manager
Solid State Logic Ltd
Tel; 01865 842300
Fax; 01865 841673
email; richardb@solid-state-logic.com

 

[Chris Kelleher]

Richard,

This will get rid of good things, as well as bad things.

For example, you will quickly clear out any and all things that you entered
that you no longer wish to be there.

You will also clear out many defaults that QAD sets up, such as A, B, and C
for ABC code and a list of transaction types.

I'd suggest looking for the specific fields where you'd like to get rid of
the generalized codes (code_fldname) and just blow those away.
Alternately, you could blow them all away and then reload the code master
.d file that we provide. The caveat is that you may lose any codes added
through a patch or other upgrade process, as well as any that you set up
and that should be there.

In any case, a good backup of the code master may be one of your best
friends....

Good luck.

Scott
===============================================================
Scott M. Dulecki /* 1998061901 */ +1 616 975 6322
Product Manager scott_dulecki@qad.com
QAD, Inc. http://www.qad.com
1188 East Paris SE Grand Rapids, MI 49546 USA

Next Michigan Progress Users Group: 19 January 2000
Next Midwest MFG/PRO Users Group: 13-14 March 2000

All opinions are my own, and don't necessarily reflect those of
any other living being.
===============================================================

 

[Chris Kelleher]

Hi Richard

The best way to handle this situation is

1. Dump the codes master from QAD's(mfg.db) standard database.

2. Delete code_mstr from your cloning db.

3. Load the code_mstr which you have dumped from QAD's standard
database.


With regards

Ramesh

 

[Chris Kelleher]

Hi

MFGPRO 7.4F
Progress 7.3E

I am cloning from our live db, selective records in order to set up a US
operational DB (we are UK). Are there any implications in doing this via
Progress using the export and import functions for static data like parts,
locations, customers, suppliers etc rather than creating cim load files, or
is there a "standard" method for this (not CIM !).

TIA


Richard Beveridge
Materials Manager
Solid State Logic Ltd
Tel; 01865 842300
Fax; 01865 841673
email; richardb@solid-state-logic.com

 

[Chris Kelleher]

I wouldn't do it any other way but CIM loads. For example, you're planning
to load customers & suppliers - did you include the list master file?
Non-CIM loading is learning by doing.

Dana Huse
Fungible Fungi

"Roof, oh, roof! Beautiful roof!"
- Aldous Huxley -