The label printing software extra4<winIII> has an integrated, local database. Data for marking an item can be read out there and output as a label. This saves time and effort for repeated typing and ensures that contents are always printed in the same way. It is also possible to print a list of the stored items.
 
Item numbers as keys to the database
The label database of extra4<winIII> works on the basis of item numbers. If users already use item numbers, item data can be entered under the existing number. The item data can be retrieved via the item number and printed out as individual labels or via batch processing in serial printing.

If the user does not yet have a numbering system, extra4<winIII> automatically generates an item number when creating a new item via hierarchically structured item groups. The hierarchy of the item groups needs to be well thought out and is stored by the user according to his own structures in the program previously.
 

Space for additional information
The database of eXtra4<winIII> offers besides the item data for the label printing additional storage space for memo texts of any length, e.g. to note evaluations or further product descriptions.
A small product image (thumbnail) can also be stored in the data record for quick identification of an item. If a product is to be portrayed in more detail with photos, it is recommended to use the additional function "Image management".
 

 
The label printing software extra4<winIII> with its integrated, local database now has extended possibilities. In addition to the information required for labelling, stock levels of already created items can be managed and additional information can be stored. Even an inventory can be carried out with eXtra4<winIII>.

Individual expansion of master data
The extended item management of extra4<winIII> supplements the master data with a multitude of individually adaptable fields. They can be used e.g. for information on the purchase of an item (price, quantity, time, recommended sales price) or for evaluations and further descriptions.
The item number of the vendor is created as an additional key field. Items are now found in the database not only under the vendor's own item number, but also under the vendor's item number.
In the container management of the label printing program eXtra4<winIII> the storage locations of items can be recorded. Each container, like e.g. a tray or display and a drawer or a shop window receives a unique container code as storage location. The items are assigned to this code as content. This makes it easier to localise and check them.
 

 
The image management of the label printing software extra4<winIII> enables the management of several high-resolution images of an item. Whereas previously only a single small image (thumbnail) was used in item management to identify an item more quickly, image management uses the integrated item database to manage large, often confusing quantities of professional photo documents. Archived in this way, image files are easily searchable and easily accessible.
 

Photo documentation for items
The image management as a separate additional function links an item from the item master with an unlimited number of image files, even in the high resolution of current cameras. Thus, for example, several recording perspectives can be assigned to an item. The retrieval of the original image files is considerably facilitated, since the storage location is listed in the data record. The images can be sent together in one selection - by e-mail via the address management directly from the software eXtra4<winIII>.
 

 
Label printing from external databases is possible with the extra4<winIII> software. It directly accesses local databases and imports data from there directly into the label layout selected as the entry mask.
 

Databases in direct access
The software extra4<winIII> does not import data from the foreign database, but works directly with the information stored there. Field contents are read out via a search key, e.g. the item number, and transferred to the label on the basis of a defined field connection. The data transfer can be done for single items or by defined selection criteria as serial print for several items simultaneously in batch processing.
 
Desktop databases as data source
Suitable for direct access by the label printing software eXtra4<winIII> are desktop databases such as :
• Microsoft Access
• MS SQL-Server
• SQLite
• Postgre SQL
• Firebird
• My SQL
• and similar
• but also spreadsheet tables, such as Excel
 

In order to do justice to the complexity of each individual item, the most precise descriptions of all its individual components can be stored. For jewellery, for example, in addition to the metal alloy, all stones can be entered individually in stone type, shape, colour, cut and carat weight, as well as information on findings.

For watches in addition to the model and serial number, exact details of the watch case, bezel, crown, movement and strap can be entered. Additional documents such as deeds or certificates can also be archived with the item number as key.