SCOOP Consulting  

Information Management and Custom Databases

Skip Navigation Links
Home
About Us
Our Services
Our Clients
Databases
Contact Us
SuccessesExpand Successes
Site Map

www.innotool.com   

Innovative Tool & Die - Design document database

Innovative Tool & Die is one of Vancouver's leading design shops and completes hundreds of jobs for clients each year.  The jobs were tacked and invoiced using an industry standard system called Jobboss.  Outside that system, Innovative have literally thousands of job designs stored in folders on their server, on backup media and in paper copies throughout the office.

Main Issue

Innovative needed a simple way to search and retrieve their designs based on job number, design number or location of the file. 

Solution

SCOOP created a system that retained lists of jobs, storage locations and design documents.  The database was intialled filled with data from the existing list of designs.  A bridge to Jobboss was built so that project data could be retrieved from the master database and interrogated and searched in the design database.  To that was added cross-references between the jobs, designs and storage locations.  The designs can be viewed in detail or searched and accessed from lists of jobs, lists of locations, lists of designers or lists of designs.     

Outcome

Innovative can quickly locate and retrieve information about their design documennts.  They  have a permanent repository of the design documents that are the core of their business sucess.