ID Label Printing

There is a webapp for generating BPt and BSa numbers and printing barcodes for both using two Zebra printers.

The output for a 'pack' is three bag labels and eight sample labels.

As of 09 June 2011 the label printing application and the two printers are housed on the HOSPITAL network. Prior to this date, the system was on the University network. The database of used numbers was migrated at this point so continuity was maintained.

The URL for accessing the label webapp, which is delivered through tomcat on the same servers as Onyx, is:

​http://briccs.xuhl-tr.nhs.uk:8080/labels/

But it is also accessible, thanks to an Apache 'redirect' on briccs-3.rcs.le.ac.uk, at:

​http://services.briccs.org.uk/labels - which is the same address that we used before on the University network. Nice!

This database needs to be backed up alongside the Onyx database. This is accomplished using the hourlydbdump.sh script in /home/nrh11 on the app server.

There is a comparable set of files on the hospital dev and devdb VMs.

Technical info on printers

SAMPLE LABEL PRINTER ZBR3687851 When on University: 143.210.247.156 When on Hospital: 125.200.4.45

BAG LABEL PRINTER ZBR3688678 When on University: 143.210.247.187 When on Hospital: 125.200.4.46

University: Subnet Mask: 255.255.255.000 Default Gateway: 143.210.247.001 WINS server IP: 000.000.000.000

Hospital: Subnet mask: 255.0.0.0 Default Gateway: 125.100.100.100 WINS server IP: 10.147.126.165

Label Design and Test Printing

Instructions how to edit labels and print them out on a Zebra test printer can be found on BRU Shared Drive in a Word file at the address: X:\Cardiovascular Sciences\Webaccess\BRU\BRICCS\IT Solutions\Label Design\Label Editing and Test Printing.docx

MySQL configuration

+---------------------+ | Tables_in_briccsids | +---------------------+ | identifiers | | idranges | +---------------------+ 2 rows in set (0.01 sec)

mysql> describe identifiers; +-------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+-------+ | ID | varchar(32) | NO | PRI | NULL | | +-------+-------------+------+-----+---------+-------+ 1 row in set (0.02 sec)

mysql> describe idranges; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | PK | varchar(64) | NO | PRI | NULL | | | PREFIX | varchar(8) | NO | | NULL | | | FROMVALUE | bigint(20) | NO | | NULL | | | TOVALUE | bigint(20) | NO | | NULL | | | STATUS | varchar(8) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.00 sec)