How to prevent database pollution or how to clean up the insight-Live data. Your views please.

[Marina Reijsmeijer (Kleierij)]

My main reason to use Insight-Live is the chemistry calculation and comparison between recipes. Many recipes entered into the database fail to calculate chemistry, because the materials are misspelled, named differently or the colouring oxides are included. I cannot change the recipe when I am not the owner. So what should I do? Let's take Leach Clear as an example.

 

Material "frit,Ferro 3124" does not exist in the Materials data  and hence the calculation fails.

I could

1- copy the recipe and change it but that results in recipe pollution

2- ask the owner to change it, but I hate to bother him, especially since he entered very many recipes

3- add "frit, Ferro 3124" to  Our Materials with a reference to Ferro Frit 3124 and do something similar for "feldspar, Custer" and "kaolin, calcined".  This pollutes the Our Materials data.

On top of this solution 3 does not work when coloring oxides or eg. bentonite are specified as materials and not as additions.

And I still have to revert to solution 1 when I need to replace a material that I cannot buy here by one that I can get.

So, what do you think the best approach would be?

[Norm Stuart]

I have the "Our Managed Materials"

China Clay - linked to the chemistry for generic Kaolin

Wood Ash - linked to Digitalfire chemistry for Hardwood Ash

there's a huge variance in wood ash, but this is what "Wood Ash" will be unless otherwise specified.

There are others to choose from.

[Norm Stuart]

Unless I missed some, all of the glaze 708 recipes in our Insight-Live database contain only linked raw materials. A number of these glazes include one or more color variations.

The only remaining problems are glazes where the Additions are not separated from the recipe, primarily in the imported glazes. I won't be changing those unless I find some pressing need to do so on an individual basis.

[Marina Reijsmeijer (Kleierij)]

I never dreamt my post would lead to this spring cleaning :)  You did a lot of work, thanks very much. The recipes are so much more useful when it is easy to compare the chemistry.

Norm Stuart said:

Unless I missed some, all of the glaze 708 recipes in our Insight-Live database contain only linked raw materials. A number of these glazes include one or more color variations.

The only remaining problems are glazes where the Additions are not separated from the recipe, primarily in the imported glazes. I won't be changing those unless I find some pressing need to do so on an individual basis.