FilmStar supports industry-standard database software
for managing coating designs and quality assurance.

Why you need the FilmStar Database

There are numerous benefits:

  • Coating facilities with hundreds of designs can sort and retrieve designs according to user-definable criteria.
  • Quality-control departments can organize tens of thousands of spectral measurements and select them according to type, customer, etc. Imagine the convenience in saving all QA data in one place. (Only one file to back up!)
  • Management can evaluate trends in coating performance, identify problem areas, and perform what-if analyses based on previous coating performance.
  • Security! Of course, your company's technicians are trustworthy, but can you really afford to assume that no one would ever improve results (search the document for Plummer) in order to ship product?

FilmStar provides the programming examples you need to utilize database technology in your coating facility. With database technology FilmStar becomes an important tool for managing optical coatings and meeting quality requirements.

As an alternative (or supplement) to the solutions given below, the FilmStar Database also supports NTFS file properties. Click here to learn more.

Flash Video Demo

Why you need the FilmStar Database Take advantage of popular business software to organize, select, sort and interpret spectral data! It's easier than you think! (3.75 min)

Click for full size image
Spectra Database

User Privilege Dialog

Why FileMaker Pro?

FileMaker Pro provides means to store spectra and/or designs in a secure database environment. With about 20M users, FileMaker is an industry-standard workgroup solution which easily connects to your company's enterprise database. Click here to learn how the database is integrated into FilmStar programs.

FileMaker user-privileges can be password protected. Data can be stored directly in the database instead of in thousands of files. Examples for storing spectra (illustrated here) and coating designs are based on the following FileMaker advances:

  • FilmStar BASIC can run FileMaker scripts via ActiveX. Once you understand the included examples, you'll be amazed how simple and powerful this is. Measure a filter and the spectrum automatically appears in the database; it's that easy! FileMaker scripts can also be run by Excel VBA as in this important example.
  • FileMaker Pro includes the ability to customize menu commands according to user name and password. This feature is essential in ensuring that users and browsers do not alter results or modify database structures.
  • FileMaker Pro includes container fields which store data files as well as pictures. Thousands of spectra and pictures can be stored in a single database file. FileMaker Pro 12 added new support for saving PDF documents. FilmStar QA reports or coating data sheets can be reviewed and printed directly.
  • FileMaker Pro is far easier to implement than databases such as Microsoft Access. FilmStar users have found that student interns have been able to adapt FTG-supplied sample databases to their particular requirements.

Companies with multiple users should contact FileMaker to discuss their optimum configuration. One copy of FileMaker Pro Advanced is required in order to modify menus.

Click here for our flyer 'Two Methods for Managing Spectral Data'

Copyright 2018 FTG Software Associates
Last updated on January 01, 2018