Legacy Data Migration

For some organizations and projects, a major obstacle to the successful implementation of a new system is getting legacy data (including database information, files, revision histories, custom properties, file relationships, etc.) into that new system quickly and in an organized manner with no loss of information. In situations like this, Hagerman & Company’s extensive experience and software tools can be the ideal solution to this challenge.

Legacy information which needs to be imported into a new system can exist in a variety of different formats and locations including:

  • Windows files and folders
  • File properties contained in the above files
  • Existing older data management systems to be replaced
  • Company ERP or other business systems
  • Microsoft Excel spreadsheets
  • Other in-house Access, SQL, Oracle or other databases

In all of the above cases, utilities used and in some cases developed by Hagerman & Company can be the solution to getting files and data into your new system accurately and in a cost and time efficient manner.  Hagerman’s tools and services can do all of the following and more:

  • Automated formatting of customer legacy into the intricate and specific format that may be required for importing into your new system
  • Automated analysis and correction of broken AutoCAD XRef/raster and Inventor assembly file relationships
  • Tools to scan all customer selected servers, users PC’s and folders and report all file data to a SQL database for analysis and performing of required file cleanup, merging, conversion, editing, renaming, deleting and moving of files prior to import into your new system
  • An “Update Properties from Spreadsheet” tool that can update custom file properties in mass based on spreadsheet data
  • An “Update Properties from Folders” tool that can update system properties in mass based on customer specified property/folder hierarchy mappings. The result then makes it easy for users to search and retrieve files from anywhere in the hierarchy based on property searches
  • Hagerman & Company has successfully used these above tools to perform legacy data migrations of up to 1MM file records from many different legacy data sources and systems for dozens across the United States and globally.  No other company matches our capabilities and experience in this area.

 

Hagerman & Company’s successful design automation projects have allowed:

  • A manufacturer of storage cabinets to automatically complete assembly and part designs, sheet metal flat blanks, generate bills of material and pass them to its ERP system eliminating mistakes and multiple entry of the same data
  • A manufacturer of refrigeration control valves to develop an automated CAD tool to be sent out to its customers giving them the capability to configure and draw valve assemblies and place them into their system layouts
  • The field sales staff and distributors of a manufacturer of moveable partitions for schools, convention centers, churches, etc. to automatically generate proposal drawings and quotes and synchronize all data with the home office
  • A manufacturer of bleacher and other seating systems to cut its turn around time for quotes and submittal drawings from up to (2) weeks to approximately (1) hour and its labor time per proposal from hours to minutes thus freeing up engineers’ time in order to develop new and better products and systems  
  • A manufacturer of emergency vehicles to automatically generate proposal drawings incorporating a nearly infinite variety of vehicle options

Examples of some of our other successful projects include:

  • Developing custom Autodesk menu’s and symbol libraries for many different clients and applications
  • Helping numerous customers upgrade their existing AutoCAD® customizations to be compatible with new versions of AutoCAD
  • Automatic batch processing software to allow customers to make mass changes and updates to current AutoCAD drawings
  • Automated software to assist a manufacturer of lawn and garden equipment to process accounts payable more efficiently and interface with its ERP system
  • Helping numerous customers pass item and bill of material information bi-directionally between CAD, MS-Office, PDM and ERP systems 
  • Developing solutions to assist numerous companies in processing ECO’s more efficiently including both local and remote users (via the web), sending e-mail notifications, parallel approvals, due dates, reminders, warnings, and logging of audit trails
  • Custom software for a large AEC firm to automate the setup and enforcement of CAD standards throughout the organization
  • Software to read work orders output from an ERP system in order to automatically batch print all drawings required by manufacturing personnel in the shop for production