Searching for and Opening Recipes in the Cone6pots group database

[George Lewter]

I have uploaded 476 Cone 6 recipes from the Sankey glaze list. About 1/5 of them I renamed to include Cone # and surface. This will need to be done to the rest of them. And all of the recipes will need three letter Typecodes and keywords added. This brings up several questions.

Typecodes -

 ASH - Ash or Fake Ash

 CLA - Clayart Import

 CN6 - Cone 6 glaze

 GLS - Gloss

 LIC - Lichen or Crawl

 MAT - Matte Glaze

 NTX - No Toxic Ingredients to Leach

 RGM - Imported GlazMaster recipes

 SKY - Sankey Glaze Imports

 TFS - Tested Food Safe

 TOX - Probable Toxic Leaching

 UST - Unstable Glaze - Decorative use only

 We will want more typecodes and will need to build consensus for what to include.

What keywords do we want to use and how do they work within the Insight-Live framework? 

How do we search for glazes in the database? I've noticed that search terms only work for words in the glaze title.

Can we make upgrading the documentation of the Sankey glazes our first group project?  Photos of tests or pots using a given glaze, better notes, leach test results, etc. 

To do this we need everything to be editable by the group, but no one should alter any recipe lines (and changing the recipe itself) without first discussing the change with the group. 

[Tony Hansen]

The keywords are simply searched in addition to the glaze name and optionally the notes (if you click the checkbox), a popup tip for the search blank points this out. I tried it and the recipe having the keyword in the description was found. I will make a more comprehensive advanced boolean search later. Make a description that uses keywords that might be searched  later. If you use descriptive titles, in many cases a description might not be necessary. Keep in mind that the codenumber is also searched, in my work that is almost always what I am looking for because I identify all test specimens using it. Code numbers must match searches exactly (the list can be put in code number order and the highest existing code is at the top to aid in assigning the next).

Ok, I will protect recipes against editing lines.

I added a "Recently Modified Last" order option, so if anyone wants to work on a glaze that has not been edited they could view the hitlist in this order.

[Tony Hansen]

Now, only the owner can edit the recipe lines. We can expand this to selected other fields later.

[George Lewter]

In addition to the 476 recipes I imported from the Sankey glaze list, you can view 473 more clayart recipes by searching batch -1.

[George Lewter]

A default search of the database happens when you log in and the resulting glaze list appears in the Home page left column. It orders the recipe names with the most recently added recipes first. If you click on the "Advanced Search" link, a number of search parameters will become available for you to use.

The Advanced search interface looks like the picture below. It has a number of variables that you can pick or input by typing.

The second drop-down box give you alternatives for sort order of the recipe display. The picture at the top of this page shows you the recently add first listings.

If you select alphabetically by name the list will display in alpha order, ignoring the preceding code numbers. (Any glaze names starting with numbers will display ahead of the Glaze names starting with "A"

Recently modified first will vary slightly from recently added first in that an older glaze that recently had notes or pictures added will move to the top of the list.

Order by code number puts the glazes in ascending code number order. It displays recipes with no code numbers ahead of the code numbered glazes so we have to page through the list to get to the code numbered glazes.

Notice in the list above how variations of Jen's Juicy Fruit all have the same code, but are appended with a variation number. This has to be done by adding an autonumber code to the glaze and then editing the code number manually.

The alternate search "Code number" reverses the order by code number list and lists the highest code numbers  first.

Typecode searches will find recipes with a selected Typecode to which you can add the order of display and even a specific ingredient all in the same search.

This is a search for any glazes containing the ingredient crocus martis. Note that just the word crocus was sufficient to select the resultant glazes.

Hopefully this posting will assist you in finding the glazes you are looking for. Please reply if you have further questions about searching for glazes.

[George Lewter]

Text of Message sent to members 2/22/2012 re: Glaze Recipe Variations

We now have a bit of experience with people adding glaze recipes to the database, and we need to rethink how variations of a particular glaze are added to the database. There is far too much redundant data to make each small variation a stand-alone glaze. We are going to find a way to add variations as added data within the original glaze record.
Until further notice, please do not post new recipes for minor variations of a glaze. (You can add variations later when we have a data structure in place to handle them). For now just add the original glaze recipe.

Please do continue posting new recipes, and adding your existing pictures and notes to existing glazes that you have already worked with.
For our future glaze research we need to have a discussion about standardizing test tiles and clay body types to use for testing.

Your responses are welcome.

Thanks,
George and Tony

[George Lewter]

Opening Recipes

When you find a recipe you want to open from your search results list, you click on the recipe name, which is a link to open that recipe. 

At this point you can change the batch to the size you want to mix and print a mix sheet for that custom batch. If you already use the glaze or have test tiles of that glaze, you can upload a picture of the fired glaze. (under the Picture base item, click "choose file" and navigate to the picture on your computer, select it and pick "upload". Then you can add picture notes about the particulars of your results. You also have the opportunity to append the notes about that recipe, or to create a variation of the given recipe.

[Wes Stack]

I'm a new member. Thanks much for the search advice/examples above. They really help.

As far as a group project, I think we might consider starting with a smaller first project as we will be learning the Insight software and db management in the beginning. Maybe doing something with Steven Hill's set of glazes for spraying would move us up the learning curve, then we might take on a larger project like the Sankey db. There are probably other smaller sets that we might tackle as well for a starter.