SimpleCoversheet Design

SimpleCoversheet provides an interface for designing, populating and printing barcode document separator sheets, sheets of sticky labels, and any other type of document that contains barcodes. These coversheets and other barcodes allow documents to be automatically indexed after capture. The scanning process is most efficient whenever such coversheets can be printed by the person generating the document.

Design and User Modes

SimpleCoversheet works via two modes; designer mode and user mode. Coversheet templates are laid out and linked to Data Sources in design mode, and, once designed, are ready for user mode.

In user mode, the operator is able to select field values and print coversheets. Designer options and other program elements are hidden or disabled to make the user interface as easy to use as possible.

You may switch between design and user modes via the toolbar, or via the Mode menu.

Designer Interface

SimpleCoversheet Designer Interface

In design mode you are presented with the coversheet background and a number of elements that you can put on the page. The placement and configuration of these elements will determine how your coversheet looks and behaves in user mode.

On the leftmost pane of the design mode interface is a list of elements you can place on to a coversheet.

In the middle pane is the coversheet designer.

On the rightmost pane the properties for the selected element are displayed.

When an element is selected, at the bottom of the properties panel are links for Edit… and Barcode Settings… that display the element settings wizard and barcode format properties respectively.

= Creating a New Coversheet

SimpleCoversheet New Coversheet

The coversheet object is the main container for fields and settings.

To create a new coversheet, click New on the toolbar or select New from the File menu.

On the New Coversheet dialog you may choose whether to create your coversheet from a blank sheet, or from a template.

If you create the coversheet from a template, the size, measurements, etc. will be pre-filled from the template.

If you create a new coversheet from a blank sheet, you will need to know what size paper you intend to print the coversheets. You are also able to configure the measurement units setting and the grid properties for the new coversheet.

• The measurement units control how the rulers are displayed, as well as the (X, Y) coordinates that determine the placement and size of elements placed on the coversheet.
• The paper sizes can be filtered based on different standards and locations. If you can’t find a size that you need, click the Add custom… link in order to add a custom size to the list.
• Select Align fields to grid to use the grid to help align fields. Uncheck if you need fine control over element positions. This option can be changed in the coversheet properties.
• Once you have everything setup as desired, click OK to have the program generate your new, blank, coversheet.

Avery Label Templates

SimpleCoversheet Avery Label Templates

SimpleCoversheet allows for the easy creation of sheets of barcodes on Avery Labels via a template system. A template is basically a saved coversheet configuration with empty values that are configured by the user directly after creating a new coversheet. This saves you time in that all you’re required to do is configure the database that the values will be pulled from. To begin creating a sheet of Avery Labels, choose to create a new coversheet from the file menu or the toolbar.

Template Configuration

The template configuration is fairly straight forward if you have previously created any coversheets. When creating a new coversheet from a template you will be presented with the configuration wizards for the elements in the template. Once you have finished configuring the template elements the program will switch to User Mode and allow you to print your configured coversheets.

Each sheet of barcodes created with the Avery Label templates gets its values from a Data Source. So in order to create a sheet of barcoded sticky labels you must configure the elements in the template with a Data Source containing the values to be used on the barcodes.

The first element to configure via the wizard in an Avery Label template will be the Data Source Connection. This determines the location of the data, whether it be from a database server such as an SQL Server, a file such as an MS Access database, an Excel spreadsheet, or any other ODBC compatible connection.

After configuring the Data Source Connection, you will need to configure the Data Source via the configuration wizard. When configuring a Data Source you will need to select a table in the database, and then you will need to select the columns of data that you wish to make available as values for the barcodes.

Lastly, in the final part of the configuration wizard, you will configure the barcodes by selecting the column of data you wish to use as values.

SimpleCoversheet Template Barcode Configuration

If everything has been properly configured, the program will switch to user mode and will display a sheet of barcoded sticky labels encoded with the values from your database. At this point you are now ready to print your newly created coversheet.

Be sure to save your new coversheet configuration to a file so it can be used again!

Elements

Elements are parts that make up your coversheet, and how they are configured determines how the operator will fill it out in user mode. To create a new element, select the element type from the list on the left panel and draw a box in the position you want to place the element on the page.

The types of element are:

• Pointer: select existing elements instead of creating new ones
• Barcode: a barcode label
• Label: a text element that can filled in either by typing in user mode or hand-writing on the page before scanning
• Text: a static text element that cannot be changed
• Data Source Connection: a connection to a database
• Data Source: a specific table or query from the database that can be used to fill in lists or fields

After drawing a new element, a wizard will be displayed that will allow you to configure the placed element.

Arranging Elements

SimpleCoversheet Arranging Elements

The toolbar contains buttons to add new Barcode and Label elements, Cut, Copy, Paste, and Delete elements, as well as automatically aligning elements on the page.

Select multiple elements by holding down the [Shift] or [Ctrl] keys and selecting the elements you wish to align. Use the alignment toolbar options to align them to the left, right, top, bottom or center of the page.

With 1D barcodes, the width of the element is determined by the number of characters in the data. In order to ensure that centered barcodes remain centered when the data changes, the Horizontal Anchor setting in the Layout properties must be set to “Anchor horizontal center.”

Element Hierarchy

Certain elements, namely the labels and barcodes, can depend upon other elements for their values and configuration. The hierarchy of the elements and their dependencies is as follows:

Barcode 
    Data Source 
        Data Source Connection 
 Label 
    Data Source 
         Data Source Connection 
 Text

Note that it isn’t necessary to have Data Source Connection and Data Source elements in order to create labels and barcodes, but if you want the barcodes and labels to have values from a database then you will need to create these elements.

Data Source Connections

SimpleCoversheet OBDC Source Connections

Data source connections tell the program how to connect to a database that you wish to retrieve values from. They are created, like all the other elements, by drawing them on to the coversheet. However, they are not directly visible on the coversheet; they will appear on the strip below the coversheet display.

After drawing the Data Source Connection on to the coversheet you will be presented with the Data Source Connection configuration wizard. This wizard will also be displayed if you created a new coversheet from a Template that uses a Data Source.

You have the options of using ODBC DSN connections (User, System, or File), Access database files, or a custom connection string. If you need to create a new DSN for your Data Source Connection, click the ODBC Administrator button to display the ODBC control panel application.

After selecting where the data will come from you can optionally enter a login and password to be used with the DSN. If no user and password is entered, Windows Authentication will be used.

After you click next, you can name the connection so it can be referred to later. After entering a name click Insert to add the connection.

Data Sources

SimpleCoversheet Data Source Configuration

Data Sources are dependent on Data Source Connections. The first step in setting up a Data Source in the Data Source configuration wizard is selecting one of these connections. If you are creating a new coversheet from a template, the Data Source Connection will be automatically selected.

If you have not yet created a Data Source Connection you may do so by clicking the Add... button to show the Data Source Connection configuration wizard.