FilmStar supports industry-standard database software
for managing coating designs and quality assurance.
Why you need the FilmStar Database
Coating facilities with hundreds of designs can sort and retrieve designs according to
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. Calculations can be performed over selected data sets.
Security! Of course,
your company's technicians are trustworthy, but can you really afford to
assume that no one would ever
(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)
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
is. Measure a filter and the spectrum automatically appears in the
database; it's that easy!
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
adds new support for saving PDF documents. FilmStar QA reports or coating
data sheets can be reviewed and printed directly.
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.
A sample standalone database not requiring FileMaker Pro
can be downloaded
(11 MB). While this does not include ActiveX automation, it gives you a
good idea of how the FilmStar database works.
MDB Database Solution
FSPlot as Graphics Browser
Another possibility is to update
and edit Access-compatible .mdb files with FilmStar BASIC. While this requires programming
effort beyond that required for our FileMaker solution, it offers ultimate flexibility
for organizations committed to MS Access databases.
The relevant FilmStar BASIC
code is surprisingly straightforward with relatively few new keywords. An
example with documented code is provided with FilmStar. The example installs the
MS database engine and does not actually require MS Access. Another option is to
control the MS Access application with FilmStar BASIC.
Please note that we do not support
this solution beyond providing FilmStar BASIC sample code.
Click here for our
flyer 'Two Methods for Managing Spectral Data'