USER MANUAL
BEAT HF
Edition: January 2016
- MODE OF USE
Revision: No. 4
44
Ú
Using Microsoft Access:
If the fusion records contain traceability data of ISO 12176-4 and the respective bar codes
need to be decoded, these can easily be transferred to Access (Microsoft Access 2000 or
higher). To do this, follow the instructions below:
1.
Open the data base file BEAT_HF.mdb provided by the Grupo Acuster.
2.
On the menu choose the option: File/Get external data/Import
3.
In the dialogue box which appears, change the Files of Type: to:
Text files (*.txt, *.csv, *.tab, *.asc)
4.
Choose the corresponding directory and select the text file exported from BEAT-
HF. Click Import
5.
In the Text Import Wizard which will appear, click Advanced...
Click Specs... and a box will open with a list with the beat specification selected.
Click Open.
Click Accept and that window will be closed.
6.
Check that the Delimited option is marked and click Next >
7.
In the next window, check that the delimiter is selected as Semicolon and the
qualifier as apostrophe text. Click Next >
8.
In the following window, select the option In and existing table: and select the
Electrofusion table. Click Next >
9.
On the next screen, check that the slot Import to table: indicates Electrofusion.
Check that the two lower options are unmarked and click Finish.
10.
An informative message will be open communicating that the importation is
finished. Click Accept.
11.
To manage the data of the data file, open the Electrofusion Table in which the
electrofusion data appears and whose columns are ordered in the same way as
that specified for the text file (see previous page).
12.
When accessing Queries we will find one created with the name DATA with
ISO12176-4, in which the same fields are listed as in the previous Table option
but in which the fields of the fitting and component’s traceability (if they should
exist) have been decoded with their description shown.
13.
When accessing Reports, you will be able to make the reports you wish or other-
wise use the provided ready made report Report with ISO12176-4 data.
