Developing Quality Metadata: Building Innovative Tools and Workflow Solutions

by Wootton; Cliff

• ISBN13: 9780240808697
• ISBN10: 024080869X
• Format: Hardcover
• Copyright: 2007-07-31
• Publisher: Routledge

Summary

With the explosion of new audio and video content on the Web, its more important than ever to use accurate and comprehensive metadata to get the most out of that content. Developing Quality Metadata is an advanced user guide that will help you improve your metadata by making it accurate and coherent with your own solutions. This book is designed to get you thinking about solving problems in a proactive and productive way by including practical descriptions of powerful programming tools and user techniques using several programming languages. For example, you can use shell scripting as part of the graphic arts and media production process, or you can use a popular spreadsheet application to drive your workflow. The concepts explored in this book are framed within the context of a multimedia professional working on the Web or in broadcasting, but they are relevant to anyone responsible for a growing library of content, be it audio-visual, text, or financial. *Solutions to build your own tools instead of buying off-the-shelf software solutions *Real-world examples and case studies explore the usefulness of the tools *Author Cliff Wootton has been building tools and applications for producing and delivering multimedia content for the last 25 years

Author Biography

Cliff Wootton was the technical systems architect in the BBC News Interactive TV group

Table of Contents

Acknowledgments	p. xi
Introduction	p. xiii
Framing the Problem	p. 1
Metadata	p. 11
Object Modeling Your Data	p. 35
Transfer and Conversion	p. 59
Dealing With Raw Data	p. 73
Character Mapping and Code Sets	p. 81
Data Fields	p. 93
Fields, Records, and Tables	p. 97
Times, Dates, Schedules, and Calendars	p. 107
Names, Addresses, and Contacts	p. 127
Spatial Data and Maps	p. 139
Paint Me a Picture	p. 157
Roll Tape!	p. 165
Rights Issues	p. 185
Integrating with Enterprise Systems	p. 191
Data Exchange Formats	p. 197
XML-Based Tools and Processes	p. 213
Interfaces and APIs	p. 233
Scripting Layers	p. 247
UNIX Command Line Tools	p. 255
Power Tools	p. 263
Automation with Shell Scripts	p. 273
Automation with AppleScript	p. 281
Script Automation in Windows	p. 287
Compiled and Interpreted Languages	p. 299
GUI Tools and Processes	p. 309
Building Tools	p. 313
Keep It Moving	p. 323
Publishing Systems	p. 343
Adding Intelligence and Metrics	p. 347
Lateral Thinking	p. 353
The Bottom Line	p. 359
Tutorials	p. 365
Calling Shell Commands from AppleScript	p. 369
Calling AppleScript from Shells	p. 370
Calling Visual Basic from AppleScript	p. 372
Calling Visual Basic from UNIX	p. 373
Calling UNIX Shell Commands from C,	p. 374
Calling Java from C Language	p. 375
Calling C from Java	p. 376
What Your Web Server Log Can Tell You	p. 377
Monitoring Your Operating System Logs	p. 378
Measuring and Monitoring Disk Usage	p. 380
Wrapping FTP Transfers in a Script	p. 385
Wrapping gzip in a Shell Script	p. 389
Many-to-Many Relationships	p. 390
Phonetic Searches	p. 391
Fuzzy Searching and Sorting	p. 393
Finding Buffer Truncation Points	p. 394
Cleaning Unstructured Data	p. 395
Sorting Out Address Data	p. 396
Time Data Cleaning	p. 400
Removing Duplicates	p. 401
Converting TSV to XML	p. 402
Removing Macros from Word Documents	p. 404
Removing all Hyperlinks from Word	p. 405
Recognizing U.S. Zip Codes	p. 406
Recognizing UK Postal Codes	p. 407
Finding Variable Names in Source Codes	p. 408
Finding Double-Quoted Strings	p. 409
Finding Single-Quoted Strings	p. 410
Finding Currency Values	p. 411
Finding Time Values	p. 412
Recovering Text from Corrupted Documents	p. 413
Extracting Text from PDF Files	p. 415
Mail and HTTP Header Removal	p. 417
ISO 8601 Date Format Output	p. 419
Relative Date Tool (the Date)	p. 421
Zip/Postal Code-to-Location Mapping	p. 423
Shortest Distance Between Two Towns	p. 424
Dealing with Islands	p. 425
Calculate Centroid of Area	p. 427
Extracting Text from Illustrator	p. 428
Generating Candidate Keywords	p. 430
Extracting Metadata from Word Documents	p. 432
Extracting Metadata from Image Files	p. 433
Extract Metadata from a QuickTime Movie	p. 434
Discovering Formats with File Magic	p. 437
Extracting Hyperlinks from Word Documents	p. 438
Extracting URLs from Raw Text	p. 439
Testing URL Hyperlinks	p. 440
Dictionary Lookups via Did.org	p. 441
Lookup the Online Dictionary from a Web Page	p. 442
Check for Editorial Integrity	p. 443
Publish a Spreadsheet SYLK File	p. 444
Publish a Word RTF Document	p. 447
Publish an Adobe SVG	p. 452
Converting XML to HTML with XSLT	p. 454
Making Excel Spreadsheets with AppleScript	p. 456
Making Word Documents with AppleScript	p. 457
Scripting Alpha Channels in Photoshop	p. 458
Searching and Editing Word Docs	p. 459
Creating a Script Wrapper for Microsoft Word	p. 462
Putting It on the Desktop	p. 468
Remote Renderers and Compilers	p. 470
Data Exchange Containers	p. 473
Metadata Standards	p. 481
A Simple Metadata Dictionary	p. 495
Code Sets	p. 499
Regular Expressions 101	p. 503
Glossary	p. 507
Bibliography	p. 513
Webliography	p. 515
Index	p. 524
Table of Contents provided by Ingram. All Rights Reserved.