Custom Data Services
Precision Information Processing Utilities
Custom utilities can be used to efficiently automate a variety of different tasks...

  •  calculating and executing complex or multi-database SQL queries
  •  publishing database information to e-mail, HTML, PDF, or XML
  •  selecting, renaming, serializing, and copying files to new locations
  •  importing, cataloging, imprinting, resizing, thumb-nailing images
  •  parsing, cleaning, error-checking, validating, and repairing data
  •  extracting and refactoring data from e-mail messages or web pages
Past projects include...

...compressing 22,000+ scanned images for web distribution, removing illegal file name characters, imprinting each image with a unique identification code

...performing a multi-part SQL query to return a record set, performing error management on the returned record set, creating and executing a new SQL statement based on the results, e-mailing an add, modify, delete, error report to system administrators

...batch-printing 3,500+ documents from distributed network locations

...cataloging, thumb-nailing, indexing 7,500+ photos, replacing legacy system-generated file names with names required for target system

...reverse-engineering a proprietary security database, transforming 3,700 code-named photos stored in 10 numbered directories into 3,700 subject-named photos stored in 26 alphabetized directories

...converting 38,000+ mixed documents from Macintosh to Windows format, removing illegal file and folder name characters, adding correct file type suffixes to file names, retaining filing hierarchies