Upload the content of a database in standalone mode

The version of cablabel S3 Pro provides the possibility to upload the content of a database on a memory media (SD card, USB memory stick, internal memory IFFS…), to use it in standalone mode.

Attention: this feature is only available starting from X4 CPU printers.

Upload data

Before to perform this, you first have to create a label with a connection type of Access, Excel or OLE DB and a datasource used by the objects of the label, as if you want to print it from the software.

As an example, we will start from the label “printer_parts.stc” and its database “Devices.mdb”, available in the samples folder provided with cablabel S3 Pro.

Sample label

In this case, three steps are then necessary, in order to configure this label for the standalone mode:

  1. Create of a prompt field of standalone type, which will ask here for the article reference directly on the printer.
    The text object resulting from this prompt field can either be deleted or replace the original text linked to the article reference of the datasource.
Prompt field
  1. Change the query for the data used by the objects of the label and add a selection filter (SQL keyword WHERE) on the article reference.
    For this select in the list the previously created prompt field, to extract only the data matching to the entry in standalone mode.
Query builder
  1. Create a new query to specify all the data to be transferred in standalone mode.
    In this example you need just to select the same fields from the database, as those used in the first query.
    As this datasource is now the latest created in the label, the result of this one will then be transferred in standalone mode.
Database wizard

Finally save the label to a memory media of the printer as usually and check in addition the option to upload the data in standalone mode.

Upload window

Notice: the data transferred in standalone mode are saved in an SQLite file. This data file can for example be edited with the “DB Browser for SQLite” software.

Data file

Download example file for cablabel S3 Pro: