Why Tidy The Data?

The data comes from multiple sources

This means that not all fields are always filled consistently

It can also mean similar spellings of what is basically the same data

The majority of the data is in lists, so cleaning the lists makes the app easier to use




What Can I Tidy?

Each list can be manually tidied individually

The Title and Series Text can be cleaned for consistency

The Author Name Format can be adjusted for consistency




How Do I Tidy The Lists

settings screen

From The Settings Screen

clear lookups screen

This will remove all lookup values which are not currently used

settings screen

From The Settings Screen

fields screen

Choose Advanced Fields

listvalues screen

For the Field you want to tidy; choose Edit List Values

list values screen

Use the context menus on the List Values Screen to clean the values

You can delete unused values, merge values together or rename values


Remember, you cannot do anything with the 'Not Defined' value




How Do I Clean the Title and Series Text

list values screen

From The Settings Screen

capital title

remove words

capital series

ignore series

capital title

Set these clean options as required

apply settings

Apply all of these the clean settings to all Books in one go


Remember, you can also edit the individual Series List Values




How Do I Adjust The Author's Name Format

list values screen

From The Settings Screen

Authors option

Choose Click on the Reverse Authors Name option to change the format of the Author's Name

This will bring the names into alignment


Remember, you can also edit the individual Author's List Values




'Book Shelf' developed by Dion Hardy © 2011-2015, All rights reserved
These web pages use css, javascript and do not use cookies