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]

Thanks for the heads-up. I deleted your Tenmoku Teadust photo from the Tenmoku Gold recipe.

We're all making good progress in cleaning up errors from the database.

I notice the Insight-Live photo for George Lewter's  C Harris Tenmoku I  of a pitcher is no longer in the photo database. I think I found what must be the correct replacement photo on our website using Google and uploaded it.

https://api.ning.com/files/SiPe6h2FC9f-6RIYGOytz6XH39q1S59d9lAfERh0...

_

_

[Norm Stuart]

I believe I've cleared up all of the glaze recipes owned by everyone other than George Lewter. This includes the recipes of current and former members.

If I had to take ownership of your glaze recipe to do this, please feel free to take back the corrected recipe by making a duplicate, linking all the photos to your new duplicate, and then eliminating my copy. Let me know of you spot any errors in "my recipes".

I've managed to make a small dent into the huge number of recipes George Lewter has imported. I've focused on fixing recipes with raw material terminology errors which prevent the glaze chemistry from being correctly calculated. Dear God George where did you import all these from.

I have also greatly reduced a huge number of "variation recipes" by adding the variations, and photos if available, to the base recipe. One example was something like 20 Jen's Juicy Fruit recipes reduced to three basic recipes with Variations: photos and ingredients of the 12 or so variations which can made with each of the three base recipes. Another are the two Tony Hansen's 20x5 and 20x5 Variation base glaze along with notes for many color variations.

All "Mastering Cone 6 Glazes" base and variations can be found by entering MC6G. I've left a couple of the variations of the most popular color variants, like Spearmint and Licorice, with notes and links to the base MC6G recipes fo the full overview which is very insightful for people new to making glaze.

I also finally added China Clay to "Our Materials" we manage with the chemistry borrowed by CC China Clay aka Devon China Clay as this avoided fixing a number of recipes. Digitalfire has a generic Ball Clay but no existing generic China Clay. In updating old recipes with discontinued feldspars I replaced them with the most nearly identical existing feldspar.

I hope others are also making progress taking ownership of George Lewter's imported recipes with terminology errors. He has another 340 recipes no one has reviewed for import errors yet. Just do an Advanced Search choosing his recipes. I stopped working part way through Group 3 of his 25 remaining Groups of 15 recipes each.

It will take steady progress by a number of people to validate our Insight-Live database which is such a great resource. I certainly appreciated the effort Alisa Clausen spent on he Flickr photos and recipes.

Thanks to everyone!

[Marina Reijsmeijer (Kleierij)]

Two questions: perhaps the recipe name needs to be changed into Krakowski (with 3 not 4 K) since Lili Krakowski is mentioned in the notes.

I think the 4% wood + 4%bone ash will be different from 8% bone ash, so it rather is a variation. Bone ash has a lot more phosphate than wood ash. 

[Marina Reijsmeijer (Kleierij)]

I noticed there is no type-code for oxidation or reduction firing. Perhaps this should be added during the cleaning?

[Marina Reijsmeijer (Kleierij)]

George Lewters group 25 is ok. I am fixing group 24. The Cushing base glazes have a fixed copy now. 

Digital fire has a generic kaolin alias China Clay

Norm Stuart said:

I believe I've cleared up all of the glaze recipes owned by everyone other than George Lewter. This includes the recipes of current and former members.

If I had to take ownership of your glaze recipe to do this, please feel free to take back the corrected recipe by making a duplicate, linking all the photos to your new duplicate, and then eliminating my copy. Let me know of you spot any errors in "my recipes".

I've managed to make a small dent into the huge number of recipes George Lewter has imported. I've focused on fixing recipes with raw material terminology errors which prevent the glaze chemistry from being correctly calculated. Dear God George where did you import all these from.

I have also greatly reduced a huge number of "variation recipes" by adding the variations, and photos if available, to the base recipe. One example was something like 20 Jen's Juicy Fruit recipes reduced to three basic recipes with Variations: photos and ingredients of the 12 or so variations which can made with each of the three base recipes. Another are the two Tony Hansen's 20x5 and 20x5 Variation base glaze along with notes for many color variations.

All "Mastering Cone 6 Glazes" base and variations can be found by entering MC6G. I've left a couple of the variations of the most popular color variants, like Spearmint and Licorice, with notes and links to the base MC6G recipes fo the full overview which is very insightful for people new to making glaze.

I also finally added China Clay to "Our Materials" we manage with the chemistry borrowed by CC China Clay aka Devon China Clay as this avoided fixing a number of recipes. Digitalfire has a generic Ball Clay but no existing generic China Clay. In updating old recipes with discontinued feldspars I replaced them with the most nearly identical existing feldspar.

I hope others are also making progress taking ownership of George Lewter's imported recipes with terminology errors. He has another 340 recipes no one has reviewed for import errors yet. Just do an Advanced Search choosing his recipes. I stopped working part way through Group 3 of his 25 remaining Groups of 15 recipes each.

It will take steady progress by a number of people to validate our Insight-Live database which is such a great resource. I certainly appreciated the effort Alisa Clausen spent on he Flickr photos and recipes.

Thanks to everyone!

[Marina Reijsmeijer (Kleierij)]

More on group 24. I copied and fixed 2 Cooper recipes. The Gartside Base Cone 6 gloss is very similar to your Gartside 28 Base but it has more notes.  

I did not delete the original recipes

Marina Reijsmeijer (Kleierij) said:

George Lewters group 25 is ok. I am fixing group 24. The Cushing base glazes have a fixed copy now. 

Digital fire has a generic kaolin alias China Clay

Norm Stuart said:

I believe I've cleared up all of the glaze recipes owned by everyone other than George Lewter. This includes the recipes of current and former members.

If I had to take ownership of your glaze recipe to do this, please feel free to take back the corrected recipe by making a duplicate, linking all the photos to your new duplicate, and then eliminating my copy. Let me know of you spot any errors in "my recipes".

I've managed to make a small dent into the huge number of recipes George Lewter has imported. I've focused on fixing recipes with raw material terminology errors which prevent the glaze chemistry from being correctly calculated. Dear God George where did you import all these from.

I have also greatly reduced a huge number of "variation recipes" by adding the variations, and photos if available, to the base recipe. One example was something like 20 Jen's Juicy Fruit recipes reduced to three basic recipes with Variations: photos and ingredients of the 12 or so variations which can made with each of the three base recipes. Another are the two Tony Hansen's 20x5 and 20x5 Variation base glaze along with notes for many color variations.

All "Mastering Cone 6 Glazes" base and variations can be found by entering MC6G. I've left a couple of the variations of the most popular color variants, like Spearmint and Licorice, with notes and links to the base MC6G recipes fo the full overview which is very insightful for people new to making glaze.

I also finally added China Clay to "Our Materials" we manage with the chemistry borrowed by CC China Clay aka Devon China Clay as this avoided fixing a number of recipes. Digitalfire has a generic Ball Clay but no existing generic China Clay. In updating old recipes with discontinued feldspars I replaced them with the most nearly identical existing feldspar.

I hope others are also making progress taking ownership of George Lewter's imported recipes with terminology errors. He has another 340 recipes no one has reviewed for import errors yet. Just do an Advanced Search choosing his recipes. I stopped working part way through Group 3 of his 25 remaining Groups of 15 recipes each.

It will take steady progress by a number of people to validate our Insight-Live database which is such a great resource. I certainly appreciated the effort Alisa Clausen spent on he Flickr photos and recipes.

Thanks to everyone!

[Norm Stuart]

Digitalfire describes bone ash as only two oxides, calcium and phospherous, which together make up the apatite structure of teeth and bones.

According to this reference wood ash is 5% to 7% potassium, 1.5% to 2% phosphorous, and 25% to 50% calcium compounds.

http://vric.ucdavis.edu/pdf/FERTILIZATION/fertilization_Woodashes.pdf

In Digitalfire terms this would be K2O 6% to 8.4%, P2O5 3.4% to 4.6%, and CaO 14% to 28%.

So I've entered "Our Material" Wood Ash as 7.2% K2O, 4% P2O5, 23% CaO. 

Tony Hansen has subsequently edited this so it works.  He doesn't provide a chemistry for wood ash due to the enormous variance in chemical makeup. 

As for the Lili Krakowski glaze, what is the current name of the glaze which needs changing?

Marina Reijsmeijer (Kleierij) said:

Two questions: perhaps the recipe name needs to be changed into Krakowski (with 3 not 4 K) since Lili Krakowski is mentioned in the notes.

I think the 4% wood + 4%bone ash will be different from 8% bone ash, so it rather is a variation. Bone ash has a lot more phosphate than wood ash. 

[Norm Stuart]

That's a good idea. Using an electric kiln I initially assumed all glaze would be oxidation, but I notice George Lewter has used the word Reduction as the first word of the title of some of his glazes, while other glazes have notes which describe them as good in oxidation or reduction.

If Tony Hansen were to add database additions for oxidation and reduction, I'd suggest by default initially adding oxidation to all glazes to minimize the number of later edits.

Marina Reijsmeijer (Kleierij) said:

I noticed there is no type-code for oxidation or reduction firing. Perhaps this should be added during the cleaning?

[Norm Stuart]

There's so many recipes which use the word China Clay, that adding that word to "Our Materials" with a link to a specific China Clay or generic kaolin saves a lot of editing by making the material China Clay a live ingredient. Perhaps generic kaolin is a better idealized China Clay chemistry as it lacks the oxides of the impurities.

Marina Reijsmeijer (Kleierij) said:

George Lewters group 25 is ok. I am fixing group 24. The Cushing base glazes have a fixed copy now. 

Digital fire has a generic kaolin alias China Clay

Norm Stuart said:

I believe I've cleared up all of the glaze recipes owned by everyone other than George Lewter. This includes the recipes of current and former members.

If I had to take ownership of your glaze recipe to do this, please feel free to take back the corrected recipe by making a duplicate, linking all the photos to your new duplicate, and then eliminating my copy. Let me know of you spot any errors in "my recipes".

I've managed to make a small dent into the huge number of recipes George Lewter has imported. I've focused on fixing recipes with raw material terminology errors which prevent the glaze chemistry from being correctly calculated. Dear God George where did you import all these from.

I have also greatly reduced a huge number of "variation recipes" by adding the variations, and photos if available, to the base recipe. One example was something like 20 Jen's Juicy Fruit recipes reduced to three basic recipes with Variations: photos and ingredients of the 12 or so variations which can made with each of the three base recipes. Another are the two Tony Hansen's 20x5 and 20x5 Variation base glaze along with notes for many color variations.

All "Mastering Cone 6 Glazes" base and variations can be found by entering MC6G. I've left a couple of the variations of the most popular color variants, like Spearmint and Licorice, with notes and links to the base MC6G recipes fo the full overview which is very insightful for people new to making glaze.

I also finally added China Clay to "Our Materials" we manage with the chemistry borrowed by CC China Clay aka Devon China Clay as this avoided fixing a number of recipes. Digitalfire has a generic Ball Clay but no existing generic China Clay. In updating old recipes with discontinued feldspars I replaced them with the most nearly identical existing feldspar.

I hope others are also making progress taking ownership of George Lewter's imported recipes with terminology errors. He has another 340 recipes no one has reviewed for import errors yet. Just do an Advanced Search choosing his recipes. I stopped working part way through Group 3 of his 25 remaining Groups of 15 recipes each.

It will take steady progress by a number of people to validate our Insight-Live database which is such a great resource. I certainly appreciated the effort Alisa Clausen spent on he Flickr photos and recipes.

Thanks to everyone!

[George Lewter]

I want to send out a big THANK YOU to those who have taken on the task of cleaning up our recipes so all ingredients are recognized by the database allowing chemistry to be correctly calculated. I am also working on the task..
Sorting all recipes by "most recently modified", the oldest unmodified recipes will display at the end of the list. Those are the most likely to have unrecognized ingredients. The few recipes that were 100% recognized at the time of posting are at the end, but two or three pages in, you will start seeing a pretty continuous list of recipes needing cleaning up.

[Marina Reijsmeijer (Kleierij)]

Group 23 (was already)  and 22 George Lewter done, details attached. No more time today.

[George Lewter]

It looks to me like we're down to only about 12 pages (15 recipes per page) of recipes with unrecognized ingredients. Out of a total of 52 pages. That should help a lot in comparing the chemistry of similar glazes side-by-side.