Recent Changes Printable View Page History Edit Page

In version 0.7 the default material type is "book" and collection is "Adult Nonfiction".

If your library is not predominantly books or is books but is not predominantly Adult Nonfiction you may wish change the default material or collection type - which can be done by setting flags in the appropriate database table.

The "default_flg" column in table "material_type_dm" and the "default_flg" in "collection_dm" controls the default material and collection respectively.

Login into your OpenBiblio database using your database tool of choice and run the following SQL:

"select * from material_type_dm;" or "select * from collection_dm;" to see what your current default material or collection is (seen by 'Y' in the 'default_flg' column). Note the value in the 'code' column on the row of your new default material/collection as this is simplest way to update the appropriate rows.

As an example: you run a library lending mostly children's stories on CD - so you want to change the default material to "cd audio" and the collection to "Juvenile Fiction" from the default material type of "book" and collection of "Adult Nonfiction".

From the above SQL select statements you will see the code for "cd audio" is "3" in the material_type_dm table and for "Juvenile Fiction" is "7" in the collection_dm table and the default material type of "book" and collection of "Adult Nonfiction" the code is "2" in both cases.

For this example you would run the following SQL update statements:

To set remove the current default material type of "book" as a default: "update material_type_dm set default_flg = 'N' where code ='2';"

To set new default of "cd audio" as default: "update material_type_dm set default_flg = 'Y' where code ='3';"

To remove the current default collection type of "Adult Nonfiction" as a default: "update collection_dm set default_flg = 'N' where code ='2';"

To set new default of "Juvenile Fiction" as default: "update collection_dm set default_flg = 'Y' where code ='7';"

If you run the SQL select statements above again you can check this is now only one default material and collection type and it is set to your newly chosen defaults.

SourceForge.net Logo
Edit Page - Page History - Printable View - Recent Changes - Search
Page last modified on February 28, 2013, at 06:27 PM