10 Index ...........................................................................................................98
VA Database 2.0
1 Introduction
1.1 Purpose of program
VA Database 2.0 is a database tool for archiving and administration of determinations and methods of the 746 VA Trace Analyzer
and the 693 VA Processor.
Up to four 746 VA Trace Analyzers can be connected to one PC.
All measurement data sent by the 746 VA Trace Analyzer is
stored in a database. This data can be sorted and filtered with
the help of different criteria. All curves and reports can be displayed and printed out. With the VA Report Generator it is possible to create format reports for single determinations and also table reports for a summary of sample series.
1 Introduction
VA Database 2.0 can also be used for saving determination and
method files on the PC. All other file types created by the 746 VA
Trace Analyzer like sample tables and rack definitions can also
be saved.
1.2 Installation
Hardware requirements for the PC
ComputerPentium with 133 MHz or higher
Operating systemWindows 95 or Windows NT
Free space on hard disk5 MB for program files
Working memory RAMWindows 95: 16 MB
50 MB recommended for data files
Windows NT: 32 MB
VA Database 2.0
RS232 Interfaces1 for each 746 VA Trace Analyzer
Graphics resolution640×480, better 1024×768 or more
PrinterAny printer supported by
Windows 95/NT
1
1 Introduction
Full program and demo version
Hardware Installation
The 6.2145.030 Dongle is part of the standard equipment of the
6.6016.103 Full Program version and 6.6016.901 Update
version. Install this dongle into LPT port 1 or 2 (see Hardware In-
stallation).
The 6.6016.108 Demo version of VA Database contains only
the software without dongle. This version can be used for 100
days. After this 100 days you may continue to use the program
without the possibility to store determinations to a database. You
can upgrade your demo version at any time if you install a
6.2145.030 Dongle into the LPT port.
1. Connect the RS232 interface 1 or the RS232 interface 2 on
the rear side of the 746 VA Trace Analyzer or the 693 VA
Processor to one of the serial COM ports of your PC with the
6.2125.060 RS interface cable (often COM port 1 is already
used by a serial mouse). If the PC has only 9 pin connector,
the 6.2125.010 adapter cable (25 pin to 9 pin) has to be used
in addition.
2. If the PC has one LPT port, install the 6.2145.030 Dongle
into the LPT1 printer port and the printer cable into the
dongle.
3. If the PC has two LPT ports, install the printer cable into the
LPT1 port and the 6.2145.030 Dongle into the LPT2 printer
port.
Software Installation
Insert setup disk 1 into drive "A:", click on <Start> and Run. Enter
"A:\setup.exe". Follow the instructions given in the setup program.
The software package will be installed in the desired directory. In
addition to the program files, the following folders are installed:
DataFolder for storage of databases and filters,
BackupFolder for storage of backup files with an exam-
contains a demonstration database Demo.* for
first exercises and some example filtering criteria
files *.vaf
ple (Test747.*)
TemplatesFolder for storage of custom report files *.vat,
contains some example templates
2
VA Database 2.0
Configure Windows 95 for VA Database
It is recommended to install the COM port driver with FIFOBuffers. Proceed as follows:
1. <Start>→Settings→Control panel→System
2. In SYSTEM PROPERTIES window choose the tab Device Man-
ager.
3. In the tree expand Ports by clicking on + and mark COM1 or
COM2 depending to which port the 693/746 is connected.
4. Click on Properties, choose tab Port settings and click on
<Advanced>.
5. Change the settings as follows.
1 Introduction
6. Click on <OK> in each window.
Configuration of 746 VA Trace Analyzer
On page "VA TRACE ANALYZER" the following settings are recommended:
Baud rate9600
Data bits8
Stop bit1
Paritynone
HandshakeHW Short
Receive Modeon
Printer Typenone
Printer Width1.0
Remote keyboardoff
When the configuration of the interface has to be changed, it is
important to save the new parameter by pressing the softkey
<Save Ifc.par.> (F7) before leaving the page.
VA Database 2.0
Note: The COM port settings on both the 746 VA Trace Analyzer
and the PC have to be the same.
3
1 Introduction
Compatibility with 693 VA Processor
Registration
The compatibility of the VA Database 2.0 program with a 693 VA
Processor depends on the program version used:
• Program 5.693.0010
Not compatible with VA Database 2.0. Ask your local representative for a program upgrade.
• Program 5.693.0020, 5.693.0021, 5.693.0022
Not all functions of the VA Database 2.0 software are active.
From substance views only the first replication (VR = *0) is
available. Calibration curves are not available at all.
• Program 5.746.0100
Full compatibility with VA Database 2.0.
Please send us your 8.746.8017 Registration card as soon as
possible so we can register you as an official user. Only registered users will get updated program versions at a special price.
1.3 Overview of program windows
VA Database 2.0 consists of different windows whose functionality is linked together. The different windows are:
MAIN WINDOWAdministration of databases,
Display of reports and curves
VA DATABASE TABLETabular view of database,
Sorting and filtering possibilities
VA DATABASE EXPLORERFile manager view of database
VA COMMUNICATIONTransfer of data between 746 VA
Trace Analyzer and PC
VA REPORT GENERATORUser definable reports
Not all of the existing windows have to be used at the same time.
Some of them can be closed.
1.4 Overview of file types
File types of 746 VA Trace Analyzer
The following file types are produced by the 746 VA Trace Analyzer and the 693 VA Processor:
*.dtmDetermination file (binary file)
Contains determination data and method.
Determination files can be sent from the 746 VA
4
VA Database 2.0
Trace Analyzer to the backup directory specified
in the VA Database program and vice versa.
The *.dtm file is stored automatically in the database if a determination is added to the database.
*.mthMethod file (binary file)
Contains the method.
Method files can be sent from the 746 VA Trace
Analyzer to the backup directory specified in the
VA Database program and vice versa.
*.smpSample data file (ASCII file)
Contains data of the sample data table.
Sample data files can be sent from the
"SAMPLES" page of the 746 VA Trace Analyzer to
the backup directory specified in the VA Database program and vice versa.
*.autRack data file (binary file)
Contains data for racks of 695 Autosampler.
Rack data files can be sent from the data card of
the 746 VA Trace Analyzer to the backup directory specified in the VA Database program and
vice versa.
1 Introduction
*.rptReport file (ASCII file)
Contains all information about determination or
method in ASCII format.
By sending an actual determination report Report
ActDetm, the contents of the *.rpt file are stored
automatically in the database together with the
corresponding binary file *.dtm. Additionally, the
*.rpt file can be stored in the backup directory
specified in the VA Database program together
with the corresponding binary file *.dtm.
By sending an actual method report Report Act-
Meth, the *.rpt file is stored in the backup direc-
tory specified in the VA Database program together with the corresponding binary file *.mth.
File types of VA Database
The following file types are produced automatically by the VA
Database program when a new database is created:
*.vadConfiguration file
Contains all current settings of the VA Database
program and its windows.
Note: These 4 files on the hard disk should never be renamed
with the Windows Explorer or another file manager tool. For this
purpose the function Save Database As... should be used.
The following file types are produced by the VA Database program when saving templates or filter definitions:
*.vatDatabase template
Template file for VA Report Generator.
*.vafFiltering criteria file
Special file for storing defined filtering criteria
(see Filtering determinations, page 32).
Export file types
The following file types can be exported by the VA Database program:
*.txtASCII text file
*.wmfWindows metafile
*.emfEnhanced Windows metafile
*.bmpBitmap file
*.datMeasurement data file
ASCII text file format for export of database table
contents (see Export of table text, page 30).
Graphic file format for export of curve subwindows (see Export of curves, page 13).
Graphic file format for export of curve subwindows (see Export of curves, page 13).
Graphic file format for export of curve subwindows (see Export of curves, page 13).
Data file format for export of measurement points
(see Export of measurement points, page 31).
1.5 Context sensitive menus
Most of the menu functions of the program windows or subwindows are also accessible by clicking on the desired window or
item and pressing the right mouse button. The pop up windows
have different contents and functions depending on the selected
active window or item type.
6
VA Database 2.0
2 Main window
2.1 Main Window overview
The MAIN WINDOW is the center of the VA Database software.
From here the current working database is opened. In the window detailed information about the stored determinations
(reports, voltammograms, and calibration curves) can be displayed in subwindows. The content of the displayed subwindows
can be printed and exported. The other VA Database windows
are also opened from the MAIN WINDOW.
2 Main window
2.2 Starting/closing the program
Starting the VA Database program
Start the Program
Double-click the VA Database icon or the
VADB.EXE file to start the VA Database 2.0 pro-
gram. The WELCOME TO VA DATABASE window
appears. Select the desired option for creating a
new, open the last or open an existing database
and click <OK>.
VA Database 2.0
7
2 Main window
Note: If you start the program after dongle installation for the first
time, you are asked to restart Windows 95/NT to complete the
dongle installation.
Closing the VA Database program
2.3 Databases
Database organization
Each database consists of the 4 files *.vad, *.mb, *.db, *.px, which
are created automatically when a new database is created (see
also File types of VA Database, page 5). All changes in the database will be stored immediately to this 4 files on the hard disk.
MAIN WINDOW / File / Exit
Quit the VA Database 2.0 program. The current
database will be closed and saved (the same
function can be done by pressing the button
of the MAIN WINDOW).
Note: These four files on the hard disk should never be renamed
with the Windows Explorer or another file manager tool. For this
purpose the function Save Database As... should be used.
The current working database may be different from databases
opened in background for data transfer (see Data transfer, page
54).
Handling of databases
In order to handle measurement data sent by a 746 VA Trace
Analyzer these data must be stored in a database.
MAIN WINDOW / File / New Database
MAIN WINDOW / File / Open Database...
Create a new database. The CREATE NEW VA
DATABASE window appears where the name of
the database configuration file *.vad and its directory have to be entered. Then the new database will be opened.
Open an existing database. The OPEN VA DATA-
BASE window appears where the name of the
database configuration file *.vad and its directory
have to be selected.
8
VA Database 2.0
MAIN WINDOW / File / Save Database As...
Save the current database under a new name.
The SAVE VA DATABASE window appears where
the name of the database configuration file *.vad
and its directory have to be entered.
MAIN WINDOW / File / Close Database
Close the current database.
MAIN WINDOW / File / 1 … #
The list of the previous opened databases. When
an entry of the list is clicked on the corresponding database will be opened.
Import VA determinations
MAIN WINDOW / File / Import VA Determinations
Import determinations which had been transferred to the PC with the 6.6017.000 «VA Back
Up» program. In the appearing IMPORT VA DE-
TERMINATIONS window the list of existing *.rpt
files (ASCII reports) is shown.
2 Main window
VA Database 2.0
Select the file(s) which should be imported and
click the <Open> button.
Note: It is necessary that a Report ActDtm has been transferred
from the page "DOCUMENTATION" of the 746 VA Trace Analyzer
to the PC. Then two files with the same file name but with the two
extensions *.dtm and *.rpt respectively are present. If one of those
is missing the import will not be carried out. With the function
<Copy to><RSIfc.1> on the page "METHODS"or "DETERMINA-
TIONS" of the 746 VA Trace Analyzer only the binary file (*.dtm)
will be transferred.
9
2 Main window
Backup database files
Changes in the database will be stored immediately to the 4 database files *.vad, *.mb, *.db, *.px on the hard disk and can not be
canceled by an undo function. So if you want to return to a former
version of the database, this database must have been copied
before by means of the function Save Database As... under a new
name. This backup copy can then be opened again and stored
under the original name with Save Database As... .
Note: These 4 files on the hard disk should never be renamed
with the Windows Explorer or another file manager tool. For this
purpose the function Save Database As... should be used.
2.4 Printing of text and curves
Document printing
MAIN WINDOW / File / Print... (Ctrl+P)
Print the content of the selected subwindow. The
number of prints and the pages to be printed
can be selected in the appearing PRINT window
which depends on the selected printer.
Document print preview
MAIN WINDOW / File / Print Preview
The PRINT PREVIEW window appears. The content of the current window is shown in the appearance formatted for the desired printer. The
following functions are available by pressing the
corresponding buttons or selecting the menu
items in the PRINT PREVIEW window or in the
context sensitive menu:
10
First PageGo to first page
Previous PageGo to previous page
Next PageGo to next page
VA Database 2.0
Document page setup
MAIN WINDOW / File / Page Setup...
2 Main window
Last PageGo to last page
Print...see Document printing
Page Setup...seeDocument page setup
CloseClose preview window
The format of the page to be printed can be
changed in the appearing PAGE SETUP window
which contains up to three tabs:
Page layout
The printer, the paper size, the page
margins, and the page orientation are
adjustable.
VA Database 2.0
Text properties (only for text windows)
Font, font style, font size and line spacing for text printing can be changed.
With Interline space set to Exactly, the
space can be adjusted exactly to the
desired point value.
11
2 Main window
Note: The selected settings is not saved permanently and reset
to the default values if a new text report is opened. These default
settings can be changed in the GENERAL PREFERENCES window
(see Text report settings, page24).
Documentation (only for text windows)
The type of text report to be printed can
be specified. The formats of the text reports are identical to the formats available on the 746 VA Trace Analyzer.
Note: The selected Report type is not saved permanently and reset to All if a new text report is opened. This default setting can
be changed in the GENERAL PREFERENCES window (see Text re-port settings, page24).
12
VA Database 2.0
2.5 Export of text and curves
Copy text or curves to clipboard
MAIN WINDOW / Edit / Copy (Ctrl+C)
Text report: Copy the selected text in the text
subwindow to the clipboard. If no text is selected, the whole content of the subwindow is
copied.
Curves: Copy substance, segment or calibration
curve to the clipboard.
Note: With VA Database under Windows 95, curves are copied to
the clipboard in square size. If you import the curves into other
programs from the clipboard, always resize the graphic window
to its initial aspect ratio, otherwise axes, labels, and texts are not
displayed correctly. Alternatively, export and import the curve in
the *.emf, *.wmf or *.bmp format where the aspect ratio is retained.
2 Main window
Export of curves
MAIN WINDOW / Edit / Export as Metafile... (*.wmf)
MAIN WINDOW / Edit / Export as Enhanced Metafile... (*.emf)
MAIN WINDOW / Edit / Export as Bitmap... (*.bmp)
Note: Some programs (e.g. Microsoft Word 6 and 7) cannot im-
port of files in the *.emf format. In this case, export and import the
curve in the *.wmf or *.bmp format.
For exporting curves to graphic files it is recommended to use
the *.wmf or *.emf format for better resolution and the possibility to
rescale the graphics.
The content of the current curve subwindow will
be saved as a graphics file on the hard disk. The
destination directory and the file name have to
be entered in the appearing EXPORT window.
The graphics file can be imported into other programs like Microsoft Word or Excel.
VA Database 2.0
13
2 Main window
2.6 Display of curves
Display of substance and segment curves
MAIN WINDOW / Edit / Options...
The display of substance and segment curves
can be changed in the appearing OPTIONS window with the tab Curves:
VR Selection
Selection of curves to be displayed by means of
the two fields Var (Variation) and Rep (Replication). Selections have to be done in the same
way as in the 746 VA Trace Analyzer.
Note: With determinations recorded by the 693 VA Processor
(program version 5.693.0022 or older) only the replications "0“
(VR = *0) are available for display of substance curves.
List of curves
The list shows all existing curves. The not selected curves of the determination are marked
with "not visible“.
Line Pattern
Make line visible or not and change color.
Marker Pattern
Make measurement points visible or not and
change style and colors.
14
VA Database 2.0
Display of overlay curves
MAIN WINDOW / Edit / Options...
The display of substance or segment overlay
curves can be changed in the appearing OP-
TIONS window with the tab Curves:
2 Main window
List of curves
The list shows all overlay curves. Single curves
can be deleted with . New curves can
be added by drag and drop of curve symbols
from the VA DATABASE EXPLORER.
Line Pattern
Make line visible or not and change color.
Marker Pattern
Make measurement points visible or not and
change style and colors.
Remove selected curve.
VA Database 2.0
15
2 Main window
Display of calibration curves
MAIN WINDOW / Edit / Options...
The display of calibration curves (single or overlay curves) can be changed in the appearing
OPTIONS window with the tab Curves:
Note: With determinations recorded by the 693 VA Processor
(program version 5.693.0022 or older) no calibration curves can
be displayed.
List of curves
The list shows all overlay calibration curves. Single curves can be deleted with . New
curves can be added by drag and drop of curve
symbols from the VA DATABASE EXPLORER.
Pattern
Switch display of measured values, deviation
markers and calibration curve on/off, change line
colors.
Remove selected calibration curve from overlay
curves.
16
VA Database 2.0
Appearance of curves
MAIN WINDOW / Edit / Options...
2 Main window
The appearance of all types of curves can be
changed in the appearing OPTIONS window with
the tab Appearance:
Main Title
Subtitle
Y Axis
X Axis
The main title can be disabled, changed or set to
the default value (Auto).
The subtitle can be disabled, changed or set to
the default value (Auto).
Ticks, grids, labels, and axis lines can be enabled or disabled.
Ticks, grids, labels, and axis lines can be enabled or disabled.
VA Database 2.0
17
2 Main window
Scaling of curve axes
MAIN WINDOW / Edit / Options...
The scaling of curve axes can be changed in the
appearing OPTIONS window with the tab Scale:
X Axis Scale
The start and end value of the x axis can be
changed manually. The default settings are
made according to the method of the 746 VA
Trace Analyzer. With Auto enabled the lower or
upper border of the whole segment will be used
for the display.
Y Axis Scale
The start and end value of the y axis can be
changed manually. The default settings are
made according to the method of the 746 VA
Trace Analyzer. With Auto enabled the y axis is
scaled automatically so that all measurement
points are visible. The potential range of the predefined substance scale may be exceeded.
Note: The stored numerical values are displayed with automatically calculated prefixes. Entries can also be done using prefixes
(m, u, n, p).
18
Invert orientation of y or x axis.
VA Database 2.0
Set start and end values back to the original
borders defined in the 746 VA Trace Analyzer.
This function is also available with the Set Default
Scale option of the context sensitive menu or by
pressing the <F8> key.
Zooming of curve windows
ZoomCurve regions can be enlarged by zooming the
desired section while pressing the left mouse
button.
Reset zoomThe curve display is set back to the original bor-
ders defined in the 746 VA Trace Analyzer by
pressing the <F8> key or selecting the Set De-
fault Scale option of the context sensitive menu
opened by clicking the right mouse button.
2 Main window
2.7 Settings
Sweep settings
MAIN WINDOW / Settings / General Preferences...
In the GENERAL PREFERENCES window the default curve styles for substance and segment
curves can be defined with the Sweeps tab:
VA Database 2.0
19
2 Main window
Calibration settings
Active Sweep Pattern
Parameters for line and marker patterns of the
active (selected) substance or segment curve.
Default Sweep Pattern
Parameters for line and marker patterns of the
non-active substance or segment curves.
Line Pattern
Make line visible or not and change color.
Marker Pattern
Make measurement points visible or not and
change style and colors.
MAIN WINDOW / Settings / General Preferences...
In the GENERAL PREFERENCES window default
curve styles for substance and segment curves
can be defined with the Calibrations tab:
20
Default Calibration Pattern
Switch on/off display of measured values, deviation markers and calibration curve, change color.
VA Database 2.0
Export settings
MAIN WINDOW / Settings / General Preferences...
2 Main window
In the GENERAL PREFERENCES window the default settings for text export can be defined with
the Export tab:
Data Delimiter
Definition of data delimiter: tab, space, semicolon, comma or other character (user-defined).
Report generator settings
MAIN WINDOW / Settings / General Preferences...
In the GENERAL PREFERENCES window the default settings for the report generator can be defined with the Report Generator tab:
VA Database 2.0
Selection of measurement unit, grid size, grid
display and snapping of items to grids.
21
2 Main window
Templates settings
MAIN WINDOW / Settings / General Preferences...
In the GENERAL PREFERENCES window method
associated templates can be defined with the
Templates tab:
List of methods with associated template
The list shows all methods with a defined associated report template. New methods are added
with and deleted with .
Method name
Name of the method used by the 746 VA Trace
Analyzer. Enter this name for a new entry.
Associated custom report template
Selection of a report template for the method.
For adding a new entry or changing an existing
entry, press the button and select the desired
template (*.vat file) in the SELECT CUSTOM RE-
PORT TEMPLATE window.
Update the list after changing the template.
Add a new entry to the list.
Delete an entry of the list.
22
VA Database 2.0
Default locations settings
MAIN WINDOW / Settings / General Preferences...
In the GENERAL PREFERENCES window default
directories for storage of files and templates can
be defined with the Default Locations tab:
2 Main window
VA Databases
Selection of the directory for storage of VA Database files (*.vad, *.db, *.mb, *.px), filter definition
files (*.vaf) and export files (*.txt, *.bmp, *.wmf,
*.emf, *.dat).
For adding a new entry or changing an existing
entry, press the button and select the desired
directory in the CHANGE DIRECTORY window.
Backup directory
Selection of the directory for storage of the *.rpt,
*.dtm, *.mth, *.smp and *.aut files sent by the 746
VA Trace Analyzer.
For adding a new entry or changing an existing
entry, press the button and select the desired
directory in the CHANGE DIRECTORY window.
Custom report templates
Selection of the directory for storage of custom
report template files (*.vat).
For adding a new entry or changing an existing
VA Database 2.0
entry, press the button and select the desired
directory in the CHANGE DIRECTORY window.
23
Loading...
+ 77 hidden pages
You need points to download manuals.
1 point = 1 manual.
You can buy points or you can get point for every manual you upload.