Klara, chemical inventory, database and product registry

Short user guide

Link: https://secure.port.se/alphaquest/app%5Fkth

Manual for Klara (in swedish).


Without logging in your are allowed to browse the database (Produktregister) for chemicals, there are some 15000 products in the database.


When you have logged in your are presented with some options depending on what function you have. The main function is "Kemikaliehantering", where you do the inventory.

Since these screen shots are taken from an administrative account there are more options shown than for an account for inventory.


Next page is showing some introductory text. The menu buttons are at the top, click "Kemikaliehantering" to activate a sub menu.


Here the submenus are shown, click on "Inventering/Registrering " to get to where you can enter chemicals.


First check that the year is correct for the ongoing period of inventory. You cannot do inventory for some other year.
Then in the main area, select the department you should do inventory for. Normally you only see the single department that you are assigned to do inventory for.


Below is the page you get at the very first start of a new inventory period. See to it that "Kopiera produkter från föregående inventering och börja inventera" is selected and click OK. In this way all previous products are already in place when you start. You only have to enter the amounts for them.

Of course new products have to be added and products that are no longer in your storage should be deleted from the database.

This screen shot is from a previous version of the software.


Now you are at the page for your department. You have to expand the building/room/cabinet you have created to be able to see the actual chemical products. In this screen shot you click on "Huvudbyggnad" to start expanding.


Below is the page where the actual inventory is made. The page is subdivided into three columns.

To make rooms, storage, cabinets and shelves is a good way to structure the many chemicals you have in your labs.

In the center column you can reduce the number of chemicals shown by clicking on one of the cabinets or shelves. In this screen shot all the chemicals in the "C1:3052 Process lab" are displayed, this can be a bit impractial if there are many chemicals.


Here only "hylla 1" in "ventilerat skåp höger" is expanded, resulting in much fewer chemicals.

All chemicals from the previous inventory are present but the amounts are all cleared. To make an inventory for an existing chemical, click on the name of the product.


A new sub-window pops up with several fields to be filled out. The most important ones are

The field "Lagring" is the storage designation, i.e. which cabinet, shelf etc. the chemical is stored in/on. There are also fields for comment "Fritext", expiration date "Bäst före", etc.

This screen shot is from a previous version of the software.


Here is what it looks like when the inventory is partly filled out.
You save the inventory of this chemical by clicking "Spara".

This screen shot is from a previous version of the software.


If you find a chemical in your lab that is not present in the list in the middle column, you try to find it in the database. Here a search has been made of all chemicals containing the text "difenyl" in their names.
You click on the name that corresponds to your chemical and a sub-window pops up similar to the one in the previous screen shot. You then fill out the inventory form.

If you absolutely not can find your special chemical in the database, you have to make a "new" chemical. You can do this with the button "Ej listad produkt", unlisted product. You should not do this lightly, be very sure that you cannot find the product or a synonym for it in the database.

In the following forms to enter an unlisted product, try to give as much information as possible. Look in the Materials Safety Data Sheet (MSDS) for the product, enter CAS-numbers of ingredients, names of separate chemicals listed in the MSDS, percentage amounts etc.

Anders Liljeborg Nanostructure Physics, KTH.