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 Actor Name Format can be adjusted for consistency


How Do I Tidy The Lists

Remove unused values

From The Settings Screen
Choose Clean Text Options
Choose Remove unused Values
This will remove all lookup values which are not currently used


Edit List Values

From The Settings Screen
Choose Advanced Fields
For the Field you want to tidy; choose Edit List Values
list values screen
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

Apply Clean Options

From The Settings Screen
Choose Clean Text Options
Change one of the various clean options:

Capitalise title

Remove series words

Capitalise series

Ignore series text

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

Remember, you can also edit the individual Series List Values


How Do I Adjust The Actor's Name Format

Reverse Actor Name

From The Settings Screen
Choose Clean Text Options
Choose Reverse Actors Name option to change the format of the Actor's Name

This will bring the names into alignment

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



Developed by Dion Hardy © 2011-2020
These web pages do not use cookies     (Apps Privacy Policy)