USER MANUAL
Range BEAT-Tr
Edition: January 2016
- MODE OF USE
Revision: No. 3
34
Ú
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_06.mdb provided by Acuster Global.
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-Tr.
Click Import
5.
In the Text Import Wizard which will appear, press 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 Semicolon is selected and 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.
The message Microsoft Access was unable to annex all the data to the table
and you will be asked Do you want to continue with this ? Click Yes
11.
Another message containing information will open. Click Accept.
12.
The table <name_file>_ImportErrors will have been created which can be
deleted. This is because the last line of the exported text file by BEAT-Tr contains
a line <END OF TRANSMISSION>.
If we have previously deleted this entire line in the text file, (the contents of the file
should end with the semicolon of the last line of data) the message indicated in step
10 will not appear nor will a table of import errors be created.
13.
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).
14.
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.
15.
When accessing Reports, you will be able to make the reports you wish or otherwise
use the provided ready made report Report with ISO12176-4 data.
