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".
 

Simple address management
The label printing software extra4<winIII> also uses its integrated database for address management. It generates shipping labels from entered address data. Once the sender line and other parameters have been defined, address labels can be printed individually.

Each registered address receives a unique address code as a search criterion, e.g. the customer or supplier number. The data record is created under this code and the addressee is recorded with his data. A categorization allows addresses to be sorted according to suppliers, customers and other categories

.

 
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.
 

Advantages for barcode users
Printed barcode labels from the item management of eXtra4<winIII> simplify the recording of goods movements and inventory. Instead of typing in item numbers by hand, you scan the barcode, get to the data record of the item and record the stock there. For example, barcode labels that were removed at the point of sale can be scanned later and posted as sales.
 
Purchases can be stored in the database particularly efficiently if suppliers also use barcodes. If you have entered the supplier's item number as an additional search key in the inventory data, you only have to scan the supplier barcode to jump to the relevant item in the database and the goods receipt can be posted.
 

Data evaluation and inventory
Users of the label printing software eXtra4<winIII> can use the data stock in their database for evaluations. The application provides standard lists that users can easily adapt to their individual requirements. A report generator generates screen previews or printouts, but also outputs the list formatted as PDF or XLS files.
Inventory is probably the most important form of data evaluation. With the help of inventory control, current item quantities can be easily recorded at any time in the eXtra4<winII> software, compared with target inventories and differences determined. Users call up the item to be checked via its item number, ideally via scanner and barcode, and enter the counted quantity. Integrated lists enable the output of corresponding overviews, so that a correction booking can be made if necessary.
 

 

 
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
 

Data evaluation via export
The software extra4<winIII> offers complete freedom in data evaluation to users of its integrated database with the export function. It transposes data into the Excel format: A specific selection combines any fields of the data records as an export job. The application delivers the selected data in an xls file or xlsx file, where users can conveniently edit them individually and compile them into lists.
 

 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.
This additional function is currently still under development.

 
The software extra4<winIII> uses the multi-user client/server database Firebird for label printing. It allows direct database access from any number of workstations. From there, data is directly imported into the label layout selected as the entry mask on a local computer.
Instead of on the local computer of a workstation, the data is stored on a centrally positioned computer that functions as a server. The database server can either be installed on a suitable, already existing computer or on a small LINUX computer, which eXtra4 pre-installs and provides.
 
This additional function is currently under development.