210 likes | 307 Views
Data Cleaning with EMu. Warren Hindley. Why Bother?. Minimise data replication, EMu is relational. Speed. Data entry sorting and selecting records. Processing of large numbers of records For reports or labels. Lookup Lists are populated from data in records.
E N D
Data Cleaning with EMu Warren Hindley
Why Bother? • Minimise data replication, EMu is relational. • Speed. • Data entry sorting and selecting records. • Processing of large numbers of records • For reports or labels. • Lookup Lists are populated from data in records. • Quality Data – Turn data into information
How long does it take? • Ages! • Make all users aware. • Find commonalities. • Don’t rush, keep narrowing your result set. • Save Groups of Records
Results Duplicate Records
Sort Sort results for easier viewing
Sort Summary Duplicated Records
Why not? • Worried about deleting records. • Export the data (backup). • Change record status. • Change record permissions. • Easy to corrupt data. • Use a small numbers of records. • Experiment with test data, most institutions have training or test systems.
Changing the Record Status Summary Data and Record Status updated.
Attachments Search every attachment field in every module for this particular record.
Attachments 870 Attachments To the catalogue.
Global Replace • Replace a value in one or more fields with another. It can be used to: • Correct spelling mistakes. • Change the case of text. • Replace Attachments. • Remove Spaces from between text.
Regular Expressions • Special text string for describing a search pattern. • Advanced wildcards. • They are ugly.
Global Replace Simple Task: Replace: Ben with Benjamin
Regular Expressions ^ = Start of the line $ = End of the line
Support We are here to help, email us: support@man.kesoftware.com