This content has been marked as final. Show 5 replies
One of the requirements to running the migrator was that each Process spec had at most one active Nutrient Profile. During migration the items within this active Nutrient Profile were copied to the Output's nutrient items collection one by one. These values became the values specified in the Override column of the Formulation output.
In addition to this, each Process spec had a list of inputs defined (either Ingredient's or other Process specs). Each one of these inputs was mapped to a Formulation Input; Ingredient's were added as raw material Inputs to the Formulation, Process specs were mapped to Formulation specs and in these cases the Output Material was used. When a Formulation spec is saved, theoretical data for the Output is generated based on input quantities for each material.
I'm not sure I understand your second question, but when a Formulation spec is marked as "Is Designable", then when a Formulation spec is saved the output values are pushed to the Output Material. If an override value is specified, then that value will get pushed. If not, then the theoretical value will be pushed to the Material. I don't know offhand what the Specification column is for, but I would guess that it's the value on the Output Material.
There is no quick, easy, and safe way to drop the theoretical values. However, if we are willing to drop the "safe" constraint, we could remove the override values from the database using scripts.
As for your final question, I don't really have a good response for you. Hopefully one of the other forum aficionados can take this one.
If we were willing to drop the "safe" constraint what would be involved with getting the scripts? If you could let me know the process and roughly how long it would take that would be great. I'm not sure we definitely need it yet but I just need an idea of timings if we do want to go ahead.
We add citric acid to the formula so our production people know they can use it to adjust the pH of the product. Due to the seasonal variation of our ingredients we sometimes need to adjust the pH. We don't specify an amount because it isn't always added and if it is needed it is just added as required to get the pH in spec.
In addition we add it to formulations because we want citric acid to come out in the LIO which I recently discovered will require a quantity to do so. We will need to look at this in house and will possibly assign a small quantity to this ingredient in the formulations.
Thanks for your answer.
We would not be able to provide a custom script to remove the override values. It's possible that a knowledgeable partner could do this.
If you do go down this path, please back up your DB and perform a lot of testing, since this is not something that is supported.