digital data manager data reference guide - multimedia.3m.com · digital data manager . model 747 ....

Digital Data Manager

Model 747

Data Format Guide Version 3.xx Software

3M Library Systems 3M Center, Building 225-4N-14

St. Paul, MN 55144-1000 www.3M.com/library

© 3M 2011. All rights reserved.

Data Format Guide Contents

Overview......................................................................................... 1

Step 1 – Define barcode validation parameters............................. 2

Overview..........................................................................................................................................2 Barcode validation process...........................................................................................................3 List barcode validation parameters..............................................................................................4

Testing barcode-validation parameters .......................................................................................4 Barcode validation processing example......................................................................................5

Step 2 – Select a list-file format type............................................. 6

Introduction.....................................................................................................................................6 Procedure ........................................................................................................................................6 File encoding...................................................................................................................................6 Selecting a format type ..................................................................................................................7

Format 1 - Delimited fields/records format type ..........................................................................7 Format 2 - Multi-line records........................................................................................................7 Format 3 - Fixed-length fields format...........................................................................................7

List-file data requirements.............................................................................................................8 Shelf-order lists............................................................................................................................8 Location lists ................................................................................................................................8 Search lists ..................................................................................................................................8 Pull Lists ......................................................................................................................................8 Item records.................................................................................................................................9 Location records ........................................................................................................................10

Step 3 – Create export formats .................................................... 11

Exported data fields .....................................................................................................................12 Primary information field ............................................................................................................12 Secondary information field .......................................................................................................12 Location information field...........................................................................................................12 Barcode field..............................................................................................................................12

Display planning...........................................................................................................................13 Determining what information to display ...................................................................................13 DLA display widths ....................................................................................................................14 Conversion station display widths .............................................................................................14 Combining information...............................................................................................................15 Adding field labels to Primary and/or Secondary Info fields......................................................15

Testing export formats.................................................................................................................16

Export format parameters and examples .................................... 17

Format 1 - Delimited fields/records ............................................................................................17 Delimited fields/records parameters..........................................................................................17 Example 1 - Delimited fields/records.........................................................................................20 Example 2 - Delimited fields/records.........................................................................................21 Example 3 - Delimited fields/records.........................................................................................22 Example 4 - Delimited fields/records format (weeding application) ..........................................23

Format 2 - Multi-line records .......................................................................................................24 Line Numbers ............................................................................................................................24 Multi-line record parameters......................................................................................................24 Example 1 - Multi-line records ...................................................................................................28 Example 2 - Multi-line records ...................................................................................................29 Example 3 – Multi-line records ..................................................................................................30 Example 4 – Multi-line records (weeding application)...............................................................31

Format 3 - Fixed-length fields format .........................................................................................33 Fixed-Length fields parameters .................................................................................................34 Example 1 – Fixed-length fields record .....................................................................................36 Example 2 - Fixed-length fields record......................................................................................37 Example 3 – Fixed-length fields format (weeding application)..................................................38

Step 4 - Define import formats ..................................................... 40

Input format parameters ..............................................................................................................40 Import format example.................................................................................................................41 Adding Primary/Secondary/Location info to imported data ....................................................42 Date/timestamp formatting..........................................................................................................44

3M Service .................................................................................... 45

Information to gather ...................................................................................................................45 3M Service phone numbers.........................................................................................................45 3M Library Systems Web Site .....................................................................................................45

Overview The primary function of 3M™ Digital Data Manager Model 747 software (Data Manager) is to transfer data back and forth between your circulation system and various 3M RFID equipment. The type of data used can vary depending upon the tasks you are performing.

Data Manager software runs on a computer equipped with a memory-card drive. (See the Digital Data Manager Model 747 Installation and Setup Guide for system requirements.)

Data Manager software does not directly interface with your circulation system.

Export operations - Data Manager converts text files (shelf-order lists, pull lists, search lists) generated by your circulation system and exports them to a memory card used by various 3M products. These lists always include a barcode (Item ID) for each item.

Import operations - Data collected by 3M devices (e.g., inventory, pull results) are saved to memory cards and imported by Data Manager. Data Manager converts these data to text files that you can use to update your circulation system. These text files always include a barcode (Item ID) for each item.

Related Documents

This document focuses on data formats and data requirements. In addition, you should be familiar with the functions of Data Manager software as described in the following documents:

3M™ Digital Data Manager Model 747 Installation and Setup Guide includes instructions on how to set up data format parameters, specify barcode validation parameters, and export data for use in the 3M™ Digital Library Assistant (DLA) and other 3M RFID equipment.

3M™ Digital Data Manager Model 747 Staff Guide includes instructions on how to manage and export the list files used by the DLA and other equipment.

3M™ Digital Library Assistant User Guide describes how to use the DLA, which uses data exported by Data Manager.

3M™ Barcode Filters User Guide explains how to set up and use barcode filters.

3M™ Staff Workstation Model 795 User Documentation describes how the Staff Workstation uses search lists.

3M™ Conversion Station User Guide describes how Conversion Station software uses search and order lists.

Customizing Data Manager for your library

This guide explains how to set up the various import and export parameters that determine which data are exported and how the data are displayed. These settings allow you to customize Data Manager for your particular circulation system and tasks.

Before you can use Data Manager software:

You may want to use the Digital Data Manager Data Format Worksheet to record the information necessary to set up Data Manager software.

Step 1 Determine the barcode validation parameters necessary to extract valid barcode

data from list files generated by your circulation system. (See Step 1 – Define barcode validation parameters on page 2.

Step 2 Determine the file formats for the list files that you will generate from your circulation system. (See Step 2 – Select a list-file format type on page 6.)

Step 3 Specify what fields will be exported from these list files for display on the DLA or other 3M RFID equipment. (See Step 3 – Create export formats on page 11.)

Step 4 Determine the import formats required by Data Manager to convert collected Item IDs imported from a memory card and save them as formatted text files. (See Step 4 - Define import formats on page 40.)

© 3M 2011. All rights reserved. 1

Step 1 – Define barcode validation parametersStep 1 – Define barcode validation parameters Overview When Data Manager uses the text files from your circulation system, it must find a valid barcode for each record.

Data Manager performs barcode validation so that only records with valid barcodes are exported for use with other 3M equipment.

Barcode validation can:

Find errors in your circulation records (such as missing barcodes, incomplete barcodes, etc.).

Help ensure that the barcode extracted from your circulation system will match the barcode on the item’s tag.

Procedure

1 Determine the barcode-validation parameters required for your circulation data. See Barcode validation process on page 3 for details on how Data Manager uses these parameters to validate barcodes.

2 Record your selections on the Data Format Worksheet -or- enter these settings in the List Barcode Validation Parameters dialog box (see the Installation and Setup Guide for details).

Figure 1: List Barcode Validation Parameters.

Barcode Filters

Barcode filters are necessary only when the item identifier (barcode data) on a library item does not match the corresponding item identifier that Data Manager extracts from your lists. (See Barcode validation process on page 3.)

When this occurs, it is necessary to modify (filter) the barcode data to match the identifier stored on the memory card. This filtering can include adding characters, removing characters, substituting characters, etc.

Data Manager exports the barcode filter to the memory card along with the other data.

Filtering occurs on the 3M equipment that uses the exported data (e.g. the DLA). For example, when the DLA reads a RFID tag, it applies the barcode filter to the item identifier read from the tag so that it matches the item identifier on the memory card.

Refer to the Barcode Filters User Guide for instructions on how to set up barcode filters.

2 © 3M 2011. All rights reserved.

Barcode validation process During the export process, Data Manager performs the following barcode validation procedure to help ensure that the barcode exported to the memory card matches the one on the RFID tag. (During the tagging process, the barcode (Item ID) read from each item is saved to the memory chip on the RFID tag.)

1 Data Manager locates and extracts each barcode from each record’s barcode field. A user-defined Data Manager export format determines where in the record (in what field) the barcode is located.

2 Data Manager extracts all the valid characters from the barcode field. (Valid characters are user-defined in the List Barcode Validation Parameters dialog box.) This removes any invalid characters such as text strings, spaces, or hyphens that would prevent a match with the Item IDs that you programmed on RFID tags.

3 Data Manager tests the final length (with valid characters only) to ensure that the final length is within the user-defined Valid Length parameters. If the barcode length is valid, a record is created in the exported data (even if other information is missing or incorrectly formatted).

If the barcode length is invalid, the record is not exported and the invalid barcodes appear in the Data Manager Export Log.

Invalid barcodes (export errors)

During initial setup, incorrect barcode validation settings can cause export errors.

Incorrect barcode validation settings - check which characters you defined as valid and make sure that the final barcode length is correct.

Incorrect export format settings – make sure the barcode-field parameters extract the complete barcode from the record. (See Step 3 – Create export formats on page 11 for information on export parameters.)

Once your Data Manager settings (barcode validation, export formats) have been tested and proven stable, most of your export errors will be caused by problems with circulation records.

These problems include errors in your circulation records, such as missing barcodes, incomplete barcodes, incorrect barcodes, etc.



List barcode validation parameters

Specify the parameters that you want Data Manager to use for validating barcodes. Data Manager uses these parameters to validate barcodes from all the list files that it exports.

Refer to the Installation and Setup Guide for instructions on how to enter these parameters.


Parameter Description Legal Values Comments Minimum Barcode Length

The minimum length of a valid barcode.

1 - 20 This parameter is mandatory.

When all barcodes in a library are a fixed length, the Minimum Barcode Length should be the same as the Maximum Barcode Length.

Maximum Barcode Length

The maximum length of a valid barcode.

1 - 20 This parameter is mandatory.

When all barcodes in a library are a fixed length, the Minimum Barcode Length should be the same as the Maximum Barcode Length.

Valid Characters

The valid characters allowed in the barcode.

Digits (0-9) and/or

Lower case letters (a – z) and/or

Upper case letters (A-Z) and/or

Additional valid characters (any additional string of characters can be specified).

This parameter is mandatory.

Testing barcode-validation parameters After you install and set up Data Manager software, you can start testing your export formats and barcode-validation settings. Some export-format settings (barcode start positions and field length) can interact with the barcode-validation settings. After some initial trial and error, daily Data Manager operation becomes routine. See the Installation and Setup Guide for testing procedures.


Barcode validation processing example To process a barcode, Data Manager first removes any invalid characters from the barcode field and then checks it to make sure that the final length is within the valid length settings.

Parameter Settings

In this example, you would specify the following barcode validation parameters:

Minimum Barcode Length: 14

Maximum Barcode Length: 14

Valid Characters: Digits only (0-9)

In this example, assume that the library uses 14-digit barcodes (all numeric).

Export results

Original Barcode Field (as it appears in the list file)

Processed Barcode (after removing the invalid characters)

Analysis Result

12345678901234 12345678901234 All characters in the barcode are valid.

The barcode is the correct length.

VALID

“12345 6789 01234” 12345678901234 All non-numeric characters are removed.

After removing the spaces and quotation marks, the barcode is the correct length.

VALID

1234A 678B 0123% 12346780123 All non-numeric characters are removed.

After removing the spaces and the non-numeric characters, the barcode is not the correct length.

ERROR

Records that contain invalid barcodes (errors) are not exported. Barcode errors are reported in the Summary and Export Logs. Data Manager exports all records that have valid barcodes (even if they

are missing Primary, Secondary, or Location information).


Step 2 – Select a list-file format type Introduction A list file is a list of item records created by generating reports from your circulation system. The list files that you generate from your circulation system must be text files that match one of the three basic formats described in this section.

Data Manager uses list files (shelf-order lists and search lists) to support the functions of the DLA and other 3M RFID products.

The list files generated from your circulation system must match one of the three basic format types supported by Data Manager.

Procedure

1 Select a list-file format that you can easily generate from your circulation system. The list-file format must match one of the three basic format types supported by Data Manager.

2 If desired, record your selection on the Data Format Worksheet.

3 Generate test files from your circulation system.

4 Use Data Manager software to set up list folders for your list files. See the Installation and Setup Guide for instructions.

File encoding Data Manager will only accept list files that use the following character-set encoding:

ASCII Unicode UTF-8 Numeric code page values


Selecting a format type

Format 1 - Delimited fields/records format type This format uses designated characters to separate fields within a record and to separate records from each other. This format also allows variable-length fields and can include line-delimited records.

To simplify formatting, set up your list files with the item identifier (barcode) as the first field in a record.

33333000240016 tab 1942 tab TP967 Am3 1971 tab Recent advances in adhesion

See Format 1 - Delimited fields/records on page 17 for more information and examples.

Format 2 - Multi-line records This format type allows several lines for each record, often with a different field corresponding to each line. This format is useful for removing label text or handling lines that contain more than one field.


33333000240016 TP967 Am3 1971 Recent advances in adhesion

See Format 2 - Multi-line records on page 24 for more information.

Format 3 - Fixed-length fields format This format uses fixed-length fields. The export format(s) that you create allows you to define which fields are exported by specifying field position and length. Item records of this type can be delimited by either total character count or by the end of a line.


Any long or variable-length field (such as the item title) should occur at

the end of each record. Records are delimited by a total character count (fixed-length records)

or an end-of-line character. Data Manager export formats define the field lengths and offset

positions for the barcode, Primary info field, and Secondary info field.

33333000240016· TP967· Am3· 1971· · · · · · · · · · Recent· advances· in· adhesion

In this example, the dot (·) represents the space character and is used to illustrate the fixed length.

See Format 3 - Fixed-length fields format on page 33 for more information.


List-file data requirements List-file data requirements Data Manager creates usable data files by exporting user-defined information from the list files (shelf-order and search lists) generated by the circulation system.

Shelf-order Lists and Search lists are text files. Data Manager exports data files to a memory card

that can be used by another 3M application (e.g., DLA, Conversion Station, etc.).

User-defined export formats specify what information is displayed in various 3M applications.

Each list file must conform to one of the format types supported by Data Manager.

Data Manager software does not extract data directly from a library’s automated circulation system.

Figure 4: Files in their designated folders.

Shelf-order lists The DLA uses shelf-order lists to check shelf order and perform shelving functions. The 3M Conversion Station uses shelf-order lists to assist with programming tags.

These lists must contain item records in shelf order (the order in which the items are physically shelved).

Location lists If your library uses a location-based shelving system, your circulation system must also generate Location Lists that identify each designated location in the library with a location record consisting of a location ID (which can be a barcode) and a location description. Note that location list files must be included with shelf-order lists for export from Data Manager to the DLA or other 3M equipment.

Search lists Certain 3M equipment (such as the DLA and Conversion Station) use search lists to help find items. Each list identifies a group of items that a device can search for as it reads RFID tags.

Purposes for search lists include: items on hold, lost or missing items, claimed returned items and items to be weeded.

You can include the same item record on more than one Search list.

The item records in a search-list file can be listed in any order.

Search lists are given user-defined names (e.g., hold, lost) that are exported along with the data. This allows 3M equipment that use search lists to display the search-list name when an item on the list is found.

Pull Lists The DLA uses pull lists. A pull list is similar to a search list (items you want to find). The DLA tracks which items were removed (pulled) from each pull list and which items remain (not pulled) on each pull list.

The DLA saves “pull-list results” on the memory card.

The item records in a pull-list file should be listed in the order that you wish to display and pull them using the DLA.

After you have pulled all the items that you could locate, use Data Manager to import the pull-list results as text files.


Item records A list file (shelf-order, pull, or search list) contains a number of item records. An item record includes information for a single item in the library, such as a book, video, CD, DVD, etc.

The item’s barcode uniquely identifies an item record. Data Manager export formats allow you to specify what item-record

information appears on various 3M equipment (such as the DLA).

Each item record contains a number of data fields that may include:

Barcode Title Call number Publication date

Circulation activity Other data that you want to display

on the DLA or other equipment. Location ID


Example

Two records that might appear in a shelf-order or search list:

33333000240016,TP967 Am3 1971,Recent advances in adhesion

33333000240027,TP967 Am4 1978,Sticky Situations in the Laboratory

Some information (e.g., call number and publication date) may be included in the same data field.

Item record requirements

Each record must contain the complete barcode as a separate field. All information that is associated with a particular item must be included

in a single item record. Unused data fields may be included in the item record. An item record should only occur once in a list file. If Data Manager

exports a list file where the same record occurs more than once, only the first occurrence of the record is exported.

For libraries using sets, only a single record is expected regardless of how many RFID tags are used in the set. Example: If sets are used for videos by placing an RFID tag on both a video and the video case, only one record should appear in the list file for that video.

If location records are used by your library, see the following page for detailed information.


Location records Location tags are used by many libraries, especially larger facilities, to clearly identify specific areas in a building such as individual shelving units, groups of units, and areas located on different floors or wings throughout the facility.

If location tags are used with 3M Digital Data Manager software and the DLA, Data Manager export-format parameters are used to prepare location records (IDs and descriptions) for display on the DLA.

Formatted similar to the item records described on the previous page, a location file contains a number of location records. Each location record identifies a single designated location in the library with two data fields:

Location ID (which can be a barcode) Location description

Important: Location IDs must be unique, and must not duplicate any item IDs used by the system.

The DLA displays item location information near the top of the screen (Shelf 6, first and second examples) and/or directly below an item’s primary and secondary information as shown in the third example:

Primary Information: The Age of Reason Secondary Information: 641.76 Location Description: Floor 2 Shelf 10

Each item record may contain a location ID, which corresponds to a record in the location list. If an item’s location record is not found or no location description is found in the location record, the location ID is displayed in parentheses as shown in the second example.

Location list format includes the following elements:

Barcode: may be text or barcode location ID Primary information: description (could be the

location ID in a second language)

There are no Secondary or Location fields in a location list.

Three DLA function screens designed specifically for location-based processing are:

Check Location screen Check Location+Order screen Inventory Location screen

Important: If location records are used by your library, staff must scan a location tag first, before scanning items on the shelves.

Figure 5: Location description displayed on second line from the top of the screen.

Figure 6: Location ID displayed in parentheses indicates a) no location record found, or b) no location description found in location record.

DLA_067c

0/1 Press Trigger To Begin

Clear .

The Age of Reason641.76Floor 2 Shelf 10

HomeSave

Figure 7: Location description displayed below Primary and Secondary item information.


Step 3 – Create export formats Define the Export-format parameters for the format type that you selected in Step 2.

1 Determine the information that you want to include in the user-defined Primary and Secondary information fields exported from the list files. (This is the information displayed on the DLA and other equipment.) See Display planning on page 13.

See Exported data fields on page 12 for descriptions of these user-defined fields.

2 Define an export format that specifies the information that you want to export and how that information will appear on the DLA or other equipment.

Export-format parameters are described in the following sections:

Format 1 - Delimited fields/records (page 17) Format 2 - Multi-line records (page 24) Format 3 - Fixed-length fields format (page 33)

3 If desired, record your export-format parameters on the Data Format Worksheet (included in this binder).

4 Once you have defined export-format parameters, you can use Data Manager software to create and test your export formats. See the Installation and Setup Guide.

Export-format parameters

Each of the three list-file formats has a unique set of export-format parameters that allow you to specify:

The format type list files created by your circulation system.

The barcode field (the field in the item record that contains the barcode information).

The portions of the item record that will be displayed (on the DLA or other equipment) as Primary and Secondary information fields.

Any labels that you want to include in the Primary and Secondary Information fields. (These labels appear on the DLA and other equipment to help you interpret the displayed data.)

Assigning export formats to List Files

You must assign an export format to each list file that you export. See the Staff Guide for instructions.

Each export format that you create has a unique format name.

You can specify default export formats.

Figure 8: You can create different export formats for different tasks.

Figure 9: Each Format Type has a unique set of export-format parameters.


Exported data fields Exported data fields Data Manager can export the following user-defined fields from each item record. The export format that you assign to the list file defines what portions of each item record appear as Primary and Secondary information fields.

Primary information field This is a user-defined text field that is displayed on the DLA (or other equipment) to help you identify an item.

You can set up an export format to extract information from one or more record fields (or portions of these fields) to be exported and displayed as the Primary information field.

The Primary information field can contain up to 40 characters, although the DLA displays approximately 25. (See DLA display widths on page 14.)

Export formats allow you to add user-defined labels to portions of the Primary information field.

You can use import formats to add Primary information to each record in an imported text file (e.g., data collection or pull results). See Adding Primary/Secondary/Location info on page 42.

Figure 10: The DLA displays Primary and Secondary information fields to help you identify the item.

Primary Info field

Secondary Info field

Secondary information field This is a user-defined text field that is displayed on the DLA (or other equipment) to help you identify an item.

You can set up an export format to extract information from one or more record fields (or portions of these fields) to be exported and displayed as the Secondary information field.

The Secondary information field can contain up to 40 characters, although the DLA displays approximately 29. (See DLA display widths on page 14.)

Export formats allow you to add user-defined labels to portions of the Secondary information field.

You can use import formats to add secondary information to each record in an imported text file (e.g., data collection or pull results). See Adding Primary/Secondary/Location info on page 42.

Figure 11: The “convert from list” function on the Conversion software displays Item ID, primary, and secondary field information.

Location information field If your library uses location tags, set up your Location information field as described above for the Secondary information field. See page 10 for more information.

Barcode field Each record must contain the complete barcode as a separate field.

This field is mandatory. The barcode field is not displayed on the DLA, but it

appears in the Convert from List dialog box on the Conversion Station.


12 © 3M 2011. All rights reserved. 3M 2011. All rights reserved.

Display planning

Determining what information to display The type of information that you display in the Primary and Secondary information fields may vary depending on the task. You can create different export formats for different tasks.

If the DLA (or other equipment) is using a shelf-order and search list that both contain the same item:

The display will show the Primary and Secondary fields that you defined in the export format that you assigned to the shelf-order list.

Shelf-order lists

The export format that you create for shelf-order lists should display information that helps you to quickly identify the item and its correct shelf location.

The title is typically used as the Primary information field.

The call number is typically used as the Secondary information field.

In libraries using location tags, the location ID is provided to enable display of the location description on the DLA.

You can use field labels to identify information in the Primary information field. See Adding field labels to Primary and/or Secondary Info fields on page 15 for more information.

Lists used for the Convert from List function on the Conversion Station display the item identifier (barcode) and the Primary and Secondary information fields.

Search lists (hold items, etc.)

For special tasks (such as finding hold or missing items), you may want to create an export format that combines various fields from the item record (usually displayed in the Secondary info field).

Libraries often create a separate export format for weeding applications.

User-defined field labels are often used to identify information in the Secondary info field. See Adding field labels to Primary and/or Secondary Info fields on page 15 for more information.

The search-list name appears when the DLA or other equipment reads the RFID tag for a search item.

Figure 12: You can create different export formats for different tasks.

Figure 13: Typical shelf-order list display.

Figure 14: Field labels identify the information displayed on the DLA or other equipment.

Search-list Name

Field Labels


DLA display widths DLA display widths Data Manager can export up to 40 characters of Primary information and 40 characters of Secondary information.

Data Manager can export up to 40 characters of Primary information and 40 characters of Secondary information.

The compact size of the DLA limits the actual number of characters that it displays. The compact size of the DLA limits the actual number of characters that it displays.

Primary Info field width Approximately 25 characters. Primary Info field width Approximately 25 characters.

Primary information appears in a large, bold font.

Primary information appears in a large, bold font.

Secondary Info field width Approximately 29 characters. Secondary Info field width Approximately 29 characters.

Secondary information is displayed in a smaller font.

Secondary information is displayed in a smaller font.

Location Info field width Approximately 29 characters. Location Info field width Approximately 29 characters.

If used, Location information is displayed in the same size font as Secondary information.

If used, Location information is displayed in the same size font as Secondary information.

The DLA uses proportionally spaced fonts, so the actual number of characters displayed may vary. The display width may be less for non-

Roman fonts and will vary depending upon the data and language.

Figure 15: Approximate DLA field widths. If used, Location Info field directly below the Secondary Info field is approx. 29 characters (not shown).

Primary Info field Approximately 25 characters

Secondary Info field Approximately 29 characters

Conversion station display widths Lists used for the Convert from List function on the Conversion Station can display the item identifier (barcode), plus all 40 characters of the Primary and Secondary information fields.

If the library uses location tags, the Location information field also can be included and displayed.

Figure 16: The “convert from list” function on the Conversion software displays the barcode and all 40 characters of the primary and secondary information fields. If used, the location information field also can be included and displayed.


Combining information You can set up an export format to combine information from various fields in a record.

When Primary or Secondary Info fields include information from more than one data field, the fields are concatenated (combined) and displayed on a single line of the DLA display or other equipment.

Data Manager allows you to specify up to 15 fields (or portions of 15 fields) to be combined into Primary or Secondary information fields.

Combining information and the use of labels are particularly useful for export formats used for weed lists.

Figure 17: In this example, the Secondary Info Field combines information from three different fields. Each of these fields includes a user-defined label (see below).


Adding field labels to Primary and/or Secondary Info fields Export formats include parameters that allow you to add labels to portions of the Primary and Secondary information fields. (See Figure 17.)

Field labels that include circulation statistics are useful for weeding applications.

Library branch labels may be helpful for “lost” or “hold” search lists.

To save display space, abbreviate the words in your field labels. (P: for publication date, C: for times circulated, LC: for date last circulated.)

The example shown in Figure 18 uses the following Secondary Info Field Labels:

Pub: = the item’s publication date

C: = the number of times the item has been checked out.

See Example 4 – Multi-line records (weeding application) on page 31 for more information on setting up labels for specific tasks such as weeding.

Figure 18: Field labels help identify the information displayed on the DLA or other equipment.

Testing export formats As you create export formats, Data Manager allows you to preview the exported data to help you fine-tune the formatting. The final test requires viewing the exported data on the DLA or other equipment.

See the Installation and Setup Guide for information on creating and testing export formats.

Figure 19: The Data Manager Preview File Export function allows you to check the export-format settings. If Location records are used, this preview displays Location information to the right of the Secondary Information Field column (not shown).


Export format parameters and examples

Format 1 - Delimited fields/records This format uses designated characters to separate fields within a record and to separate records from each other. This format also allows variable-length fields and can include line-delimited records.


33333000240016 tab 1942 tab TP967 Am3 1971 tab Recent advances in adhesion

Field 1 = barcode

Field 2 = the year of publication

Field 3 = Secondary information (call number)

Field 4 = Primary information (title)

Field delimiter = tab (represents the tab character) Record delimiter = end-of line character

Delimited fields/records parameters


Parameter Description Legal Values Comments Number of Lines to Skip

Number of lines to skip before the first record.

0 – 2,000,000 This parameter is used if your list file has a header at the beginning of the file. If you included a three-line header, you would enter 3. Data Manager will not attempt to export data from the three lines that were skipped. Only used when the Record Delimiter parameter is set

to line. Field Delimiter

The character used to separate the fields contained in a record.

tab 0 – 255 ASCII

code A single,

non-numeric character

The field delimiter must not occur within a field, with the exception of a comma. If a comma is used as the field delimiter, fields

containing commas must be enclosed in quotations. Any desired quotation marks must be included twice.

Extra quotation marks are removed during export. A value of tab indicates that the tab character is used to

separate fields. A numeric value is interpreted as an ASCII code.

Record Delimiter

The character used to separate records.

line 0 – 255 ASCII

code A single,

non-numeric character

The record delimiter must not occur within a field. A numeric value is interpreted as an ASCII code. line = CR, LF, FF, or CR-LF terminated lines.

Barcode Field

The field within a record that contains the barcode.

1 - 100 Typically, the barcode-validation process exports the complete barcode field (minus invalid characters) in a form that matches the barcode on the RFID tag.

Barcode Start Position

The start position of the portion of the barcode field that you want to export.

1-1000

This parameter is typically set to 1 (first character of the field).

Barcode The length (number of characters) of the portion

1-1000 This length is measured from the Barcode Start Position.


Parameter Description Legal Values Comments Field Length of the barcode field that

you want to export. 0 = export all data from the field-start position to the end of the field.

This parameter is typically set to 0. Note: this length may be longer than your actual

barcode length if spaces and /or additional characters are included in the barcode field.

Primary Info Field

The field(s) within a record that contains the desired Primary information. This information is displayed on the DLA or other equipment.

1-1000 Separate multiple field values with commas to combine fields. 0 = no Primary info field is exported.

You can designate a single field (e.g., Title) as the item record’s Primary info field. Combining fields - Up to 15 comma-separated field-positions can be specified. In this case, those fields are concatenated in the order listed with a single space (or user-defined label) separating them. Spaces and quotes are removed from the beginning

and end of these fields. Primary Info Field Start Position

The start position of the portion of the field(s) that you want to export as Primary information.

1-1000 Separate each field-start position with a comma.

Enter comma-separated field-start positions for each Primary info field.

Enter field-start parameters in the same order that you specified for Primary Info fields.

The DLA display width is limited to about 25 characters of Primary information.

Primary Info Field Length

The length (number of characters) of the field(s) that you want to export as Primary information.

1-1000 Separate multiple field-length values with commas to combine fields. 0 = export all data from the field-start position to the end of the field.

The data exported as the Primary Info field consists of the characters specified in the field length (starting with the character specified as the field-start position). If you combine multiple Fields: Enter comma-separated field lengths for each Primary

info field. Enter field lengths in the same order that you specified

for the other Primary Info field information parameters.

Primary Info Field Label

Label text that the DLA or other equipment will display before the Primary Info field(s).

Type the label text in brackets {}. Separate multiple labels with commas: {Title:},{ Author:}

Multiple labels must be entered in the same order that you specified for the other Primary Info field information parameters.

To insert a space between the previous value and the next label, type a space character at the beginning of the label string.

Brackets {} cannot be used as characters.

Secondary Info Field

The field(s) within a record that contains the desired Secondary information. This information is displayed on the DLA or other equipment.

1-1000 0 = no Secondary Info field is exported.

You can designate a single field (e.g., call number) as the item record’s Secondary info field. Combining fields - Up to 15 comma-separated field-position values can be specified. In this case, those fields are concatenated in the order listed with a single space (or user-defined label) separating them. Spaces and quotes are removed from the beginning

and end of these fields.

Secondary Info Field Start Position

The start position of the portion of the field(s) that you want to export as Secondary information.

1-1000 Separate multiple field-start positions with commas to combine fields.

Enter comma-separated field-start positions for each Secondary info field.

Enter field-start parameters in the same order that you specified for Secondary Info fields.

The DLA display width is limited to about 29 characters of Secondary information.

Secondary Info Field Length

The length (number of characters) of the field(s) that you want to export as Secondary information.

1-1000 Separate multiple field-length values with commas to combine fields. 0 = export all data

The data exported as the Secondary Info field consists of the characters specified in the field length (starting with the character specified as the field-start position). Enter comma-separated field lengths for each

Secondary info field. Enter field lengths in the same order that you specified


Parameter Description Legal Values Comments from the field-start position to the end of the field.

for the other Secondary Info field information parameters.

Secondary Info Field Label

Label text that the DLA or other equipment will display before the Secondary Info field(s).

Type the label text in brackets {}. Separate multiple labels with commas: {Title:}, { Author:}

If you desire custom labels for information taken from multiple fields, separate each label with a comma.

Multiple labels must be entered in the same order that you specified for the other Secondary Info field information parameters.

Brackets {} cannot be used as characters. To insert a space between the previous value and the

next label, type a space character at the beginning of the label string.

Location Info Field

The field(s) within a record that contains the Location ID. This information is used as a key to look up the description displayed on the DLA or other equipment.

1-1000 0 = no Location Info field is exported.

You can designate a single field as the item record’s Location info field. Combining fields - Up to 15 comma-separated field-position values can be specified. In this case, those fields are concatenated in the order listed with a single space (or user-defined label) separating them. Spaces and quotes are removed from the beginning

and end of these fields. Location Info Field Start Position

The start position of the portion of the field(s) that you want to export as the Location ID.

1-1000 Separate multiple field-start positions with commas to combine fields.

Enter comma-separated field-start positions for each Location info field.

Enter field-start parameters in the same order that you specified for Location Info fields.

The DLA display width is limited to about 29 characters of Location information.

Location Info Field Length

The length (number of characters) of the field(s) that you want to export as the Location ID.

1-1000 Separate multiple field-length values with commas to combine fields. 0 = export all data from the field-start position to the end of the field.

The data exported as the Location Info field consists of the characters specified in the field length (starting with the character specified as the field-start position). Enter comma-separated field lengths for each Location

info field. Enter field lengths in the same order that you specified

for the other Location Info field information parameters.

File Encoding

The character-set encoding used in the list file.

ASCII, Unicode, UTF-8, or a numeric code page value.

Typically, the character set is ASCII. Data Manager will check for valid, numeric-code-page values.


Example 1 - Delimited fields/records

File Format

33333000240016 tab TP967 Am3 1971 tab Recent advances in adhesion↙

3333 30002 40027. tab tab Sticky Situations↙

TP967 Am5 1981 tab To stick, or not to stick↙

tab represents a tab character and an arrow (↙) represents the end-of-line character.

Parameter Settings

Parameter Value Comments Number of Lines to Skip 0 There are no additional lines before the first record in the text file.

Field Delimiter tab This list file uses the tab character as a field delimiter.

Record Delimiter line This file uses an end-of-line character (↙) as a record delimiter.

Barcode Field 1 Field number 1 is exported as the barcode.

Barcode Start Position 1 1 = the export starts from the beginning of the field (position 1).

Barcode Field Length 0 Export all data from the field-start position to the end of the field.

Primary Info Field 3 Field 3 (Title) is exported as the Primary Info Field.

Primary Info Field Start Position 1 The export starts from the beginning of the field (position 1).

Primary Info Field Length 0 Export all data from the field-start position to the end of the field.

Primary Info Field Label Not used.

Secondary Info Field 2 Field 2 (call number) is exported as the Secondary info field.

Secondary Info Field Start Position 1 The export starts from the beginning of the field (position 1).

Secondary Info Field Length 0 Export all data from the field-start position to the end of the field.

Secondary Info Field Label Not used.

File Encoding ASCII The list file is ASCII-character encoded. Export Results

Record Barcode Primary Information Secondary Information Record 1 (OK) 33333000240016 Recent advances in adhesion TP967 Am3 1971

Record 2 (Warning)* 33333000240027 Sticky Situations Warning: Missing Secondary information.

Record 3 (Error)** 96751981

Error: Invalid barcode (assuming only numeric barcodes with a length of 14 are valid).

N/A N/A

* In record 2, after the non-numeric characters are removed from the barcode, it is valid. Therefore, the record is exported even though it is missing Secondary information.

** Record 3 did not contain a valid barcode. An error is included in the Export Log and that record is not exported.



File Format 33333000240016,TP967 Am3 1971,Recent advances in adhesion

“3333 30002 40027”,”TP967 Am4”,”Sticky Situations, in the Laboratory”

Parameter Settings

The library wants to export the title as the Primary Info field and the call number as the Secondary Info field.

There are no additional lines before the first record in the text file. When a comma (,) is used as the field delimiter, you must place

quotation marks (“) around any field that contains a comma. If desired, all fields can be quoted. The export process removes

quotation marks whenever a comma (,) is specified as the field delimiter. Parameter Value Comments Number of Lines to Skip 0 There are no additional lines before the first record in the text file.

Field Delimiter , This list file uses a comma as a field delimiter.

Record Delimiter line This file uses the end-of-line character as a record delimiter.

Barcode Field 1 Field number 1 is exported as the barcode.

Barcode Start Position 1 1 = the export starts from the beginning of the field (position 1)

Barcode Field Length 0 Export all data from the barcode start position to the end of the field.

Primary Info Field 3 Field 3 (Title) is exported as the Primary info field.




Secondary Info Field 2 Field 2 (call number) is exported as the Secondary info field.

Secondary Info Field Start Position 1 The export starts from the beginning of the field (position 1).

Secondary Info Field Length 0 Export all data from the field-start position to the end of the field.


File Encoding ASCII The list file is ASCII-character encoded.

Export Results

Record Barcode Primary Information Secondary Information Record 1 (OK) 33333000240016 Recent advances in adhesion TP967 Am3 1971

Record 2 (OK)* 33333000240027 Sticky Situations, in the Laboratory TP967 Am4

Both records are successfully exported without any errors or warnings in the Export Log.

* The Primary information from record 2 includes the comma (,) because the list file included quotation marks (“) around the field.

* The quotes are removed from the fields of record 2 when the data are exported.



File Format

36903000957699⎢20063⎢341.212 32 QUE⎢⎢The European Question⎢SHELF6

36903001451791⎢20093⎢341.211 ESP⎢⎢⎢SHELF6

⎢20097⎢341.211 ESP⎢

Parameter Settings

Primary information = title

Secondary information = call number

The call number is found in both field positions 2 and 3.

The character with ASCII code value 124 ( ⎢) is used to delimit fields.

Parameter Value Comments Number of Lines to Skip 0 There are no additional lines before the first record in the text file. Field Delimiter ⎢ The vertical line field delimiter could be entered as ASCII code 124. Record Delimiter line This file uses an end-of-line character as a record delimiter. Barcode Field 1 Field number 1 is exported as the barcode. Barcode Start Position 1 1 = the export starts from the beginning of the field (position 1) Barcode Field Length 0 Export all data from the field-start position to the end of the field. Primary Info Field 5 Field 5 (Title) is exported as the Primary info field. Primary Info Field Start Position 1 The export starts from the beginning of the field (position 1). Primary Info Field Length 0 Export all data from the field-start position to the end of the field. Primary Info Field Label Not used. Secondary Info Field 2,3 Call number in two fields. Secondary Info Field Start Position 1,1 The export starts from the beginning of the field (position 1). Secondary Info Field Length 0,0 Export all data from the field-start position to the end of the field. Secondary Info Field Label Not used. Location Info Field 6 Field 6 is location ID. Location Info Field Start Position 1 The export starts from the beginning of the field (position 1). Location Info Field Length 0 Export all data from the field-start position to the end of the field. File Encoding ASCII The list file is ASCII-character encoded.

Export Results

Record Barcode Primary Info Secondary Info Location ID Record 1 (OK) 36903000957699 The European Question 20063 341.212 32 QUE SHELF6

Record 2 (Warning)* 36903001451791 Warning: Missing Primary information

20093 341.212 ESP SHELF6

Record 3 (Error)** Error: “No barcode found”

N/A N/A N/A

The Secondary information was specified as two fields, so the contents of those fields are combined when creating the Secondary information for these records.

* Record 2 is missing Primary information but is still exported because it has a valid barcode.

** Record 3 is not exported because no barcode was found in this record.


Example 4 - Delimited fields/records format (weeding application) File Format This example uses a tab-delimited file format. The notation tab is used to represent the <tab> character to show the delimiter between the data fields.

34567000228815tabBlohm,· Hans.tabPebbles· to· computers· :· the· threadtab609· Blotab126tab12/09/1999tab3tab1986 34567000229136tabFriedel,· Robert· D.· (Robert· Douglas),· 1950-tabZipper· :· an· exploration· in· noveltytab609· Friedeltab126tab12/09/1999tab12tab1994 34567000229334tabMumford,· Lewis,· 1895-tabTechnics· and· civilization,tab609· Mumtab126tab11/16/1999tab6tab1990

Parameter Settings To assist in weeding, this example exports both item identification information and circulation data in the Primary and Secondary Information Fields. The title is the Primary information. For the Secondary information, the library wants the number of times circulated, last circulation activity (month), last circulation activity (year), date of publication, and the last four digits of the item identifier.

Parameter Value Comments Number of Lines to Skip 0 There are no additional lines before the first record in the text file. Field Delimiter tab This list file uses the tab character as a field delimiter. Record Delimiter line This file uses an end-of-line character as a record delimiter. Barcode Field 1 Field 1 is exported as the barcode. Barcode Start Position 1 1 = the export starts from the beginning of the field (position 1) Barcode Field Length 0 Export all data from the field-start position to the end of the field. Primary Info Field 3 Field 3 (Title) is exported as the Primary info field. Primary Info Start Position 1 The export starts from the beginning of the field (position 1). Primary Info Field Length 0 Export all data from the field-start position to the end of the field. Primary Info Field Label Not used. Secondary Info Field 7,6,6,8,1 Field 7 = Times Circulated.

Field 6 = Last Circulation Activity (month). Field 6 = Last Circulation Activity (year). Field 8 = Date of Publication. Field 1 = Item Barcode.


1,1,9,1,11 Times Circulated starts at position 1 within its field. Last Circulation Activity (month) starts at position 1. Last Circulation Activity (year – YY) starts at position 9. Date of Publication starts at position 1. Last 4 characters of Item Barcode start at position 11.


0,2,2,4,4 Because “Times circulated” could be 1, 2, or 3 chars, use 0 to export to end of field. Last Circulation Activity (month) = 2 characters. Last Circulation Activity (year – YY) = 2 characters. Date of Publication = 4 characters. 4 = export 4 characters of Item Barcode.

Secondary Info Field Label {C:},{ LC:},{/},{ P:},{ B:} Labels: C: = Times Circulated LC: = Last Circulation Activity / to separate MM from YY in Last Circulation Activity P: = Date of Publication B: = the portion of the Item Barcode


Export Results

Record Barcode Primary Information Secondary Information Record 1 (OK) 34567000228815 Pebbles to computers : the thread C:3 LC:12/99 P:1986 B:8815 Record 2 (OK) 34567000229136 Zipper : an exploration in novelty C:12 LC:12/99 P:1994 B:9136 Record 3 (OK) 34567000229334 Technics and civilization C:6 LC:11/99 P:1990 B:9334

Format 2 - Multi-line records This format type allows several lines for each record, often with a different field corresponding to each line. This format is useful for removing label text or handling lines that contain more than one field.



Line 1 = barcode Line 2 = Secondary information (call number) Line 3 = Primary information (title)

Each field appears on a separate line. Records are separated by blank lines so each record may have a

variable number of lines. A single record must not have a blank line in the middle. Blank lines may include spaces and tab characters. The library can select an entire line for a field or select sections of a line

by setting start position and field length parameters appropriately.

Line Numbers Export formats for multi-line records use line numbers to designate where barcode, Secondary, and Primary information are located. Line numbers are relative to either the beginning (top) or the end (bottom) of the record.

Positive line numbers - count down from the top of the record

Line number 2 = the 2nd line of the record

Negative line numbers - count up from the bottom of the record.

Line number –2 = 2nd to last line of the record

Negative line numbers are useful if the number of lines above the desired field varies (e.g., title fields that may require one, two, or three lines).

Multi-line record parameters Parameter Description Legal Values Comments Number of Lines to Skip


0 – 2,000,000 This parameter is used if your list file has a header at the beginning of the file. If you included a three-line header, you would enter 3. Data Manager will not attempt to export data from the three lines that were skipped.

Only used when the Record Delimiter parameter is set to line.

Barcode Line Number

The line within a record that contains the Item ID (barcode).

-1 to -100; 1 to 100

Positive numbers count down from the beginning of the record

Negative numbers count up from the end of the



Parameter Description Legal Values Comments record.


you want to

-1000

rameter is typically set to 1 (first character of the field).

The start position of theportion of the barcodefield that export.

1 This pa

BarcoField

de

Length

hat you want to export.

art

end of the field.

is measured from the Barcode Start

arcode nal characters are

The length (number of characters) of the portionof the barcode field t

1-1000

0 = export all data from the field-stposition to the

This length Position.

This parameter is typically set to 0.

Note: this length may be longer than your actual blength if spaces and /or additioincluded in the barcode field.

Primary Info Line Number

ed

r other equipment.

to 100; an

ry

exported.

ine (e.g., Title) as the item

bers count down from the beginning of

numbers count up from the end of the

removed from the beginning

The line(s) within a recordthat contains the desired Primary information. Thisinformation is displayon the DLA o

-1 to -100;

1 d 0. record’s Primary info field.

Positive num

0 = no Primainfo field is

You can designate a single l

the record.

Negativerecord.

Combining fields - Up to 15 comma-separated field-positions can be specified. In this case, the information from those lines is concatenated in the order listed with a single space (or user-defined label) separating them.

Spaces and quotes are and end of these lines.

Primary Info Field Start Position

e

rt as Primary information.

wicomma.

rated field-start positions for each

e order that

pproximately 25

The start position of thportion of the fields(s) that you want to expo

1-1000

Separate mfield-start positions

ultiple Primary info field.

Enter field-start parameters in the sam

th a you specified for Primary Info fields.

The DLA display width is limited to a

Enter comma-sepa

characters of Primary information.

Primary Info Field Length rt as

Primary information. s

end of the field.

th the character specified as the field-start

rated field lengths for each

you mary Info field

The length (number of characters) of the field(s) that you want to expo

1-1000

Separate multiple field-length valuewith commas to combine fields.

0 = export all data from the field-staposition to the

rt Primary info field. Enter field lengths in the same order that

specified for the other Pri

The data exported as the Primary information field consists of the characters specified in the field length (starting wiposition).

If you combine multiple fields:

Enter comma-sepa

information parameters. Primary Info Field Label

A or

field(s).

{Title:},{ Author:}

rder that r Primary Info field

space character at the beginning of

Label text that the DLother equipment will display before the Primary information

Type the label text in brackets {}.

Separate mlabels with

ultiple information parameters.

To insert a space between the previous value and the next label, type acommas:

Multiple labels must be entered in the same oyou specified for the othe

the label string.


SecondaryInfo Line

Number the

ed

to 100; and 0.

all Number) as

s

The field(s) within a record that containsdesired Secondaryinformation. This information is display

-1 to –100;

1

You can designate a single field (e.g., Cthe item record’s Secondary info field.

Combining fields - Up to 15 comma-separated field-position values can be specified. In this case, those field


Parameter Description Legal Values Comments on the DLA or other equipment.

ondary info field is exported.

a single space

re removed from the beginning and

0 = no Sec are concatenated in the order listed with (or user-defined label) separating them.

Spaces and quotes aend of these fields.

SecondaryInfo FStart

ield

Position

at

Secondary information.

fields.

ed field-start positions for each

order that

ut 29

The start position of the portion of the field(s) thyou want to export as

1-1000

Separate mfield-start positions with commas to

ultiple Secondary info field.

Enter field-start parameters in the same

combine

Enter comma-separat

you specified for Secondary Info fields.

The DLA display width is limited to abocharacters of Secondary information.

SecondaryInfo Fiel

d

Length s Secondary information.

f with

ed field lengths for each

u condary Info field

information parameters.

The length (number of characters) of the field(s) that you want to export a

1-1000

Separate multiple field-length valuewith commas to

s the character specified as the field-start position).

Enter comma-separatcombine fields.

0 = export all data from the field-stposition to the

art

Secondary info field.

Enter field lengths in the same order that yospecified for the other Se

end of the field.

The data exported as the Secondary info field consists othe characters specified in the field length (starting

SecondaryInfo Fie

ld

Label

A or

Secondary info field(s). ultip

{Title:}, { Author:}

m

r that r Secondary Info field

space character at the beginning of

Label text that the DLother equipment will display before the


Separate mlabels with

le

multiple fields, separate each label with a comma.

Multiple labels must be entered in the same ordeyou specified for the othe

commas:

If you desire custom labels for information taken fro

information parameters.


To insert a space between the previous value and the next label, type athe label string.

Location Info Line Number

s the

as a

ed on ther

equipment.

to 100; and 0.

tion

exported.

a single field as the item record’s

s a single space

re removed from the beginning and

The field(s) within a record that containLocation ID. This information is usedkey to look up the description displaythe DLA or o

-1 to –100;

1

0 = no Locainfo field is

You can designate Location info field.

Combining fields - Up to 15 comma-separated field-position values can be specified. In this case, those fieldare concatenated in the order listed with (or user-defined label) separating them.

Spaces and quotes aend of these fields.

Location Info FStart

ield

Position xport as the

Location ID.

fields.

ated field-start positions for each

e order that

bout 29

The start position of the portion of the field(s) that you want to e

1-1000

Separate mfield-start positions with commas to

ultiple Location info field.

Enter field-start parameters in the sam

combine

Enter comma-separ

you specified for Location Info fields.

The DLA display width is limited to acharacters of Location information.

Location Info Field Length xport as

the Location ID.

position to the

with

ated field lengths for each

he other Location Info field information parameters.

The length (number of characters) of the field(s) that you want to e

1-1000

Separate multiple field-length valuewith commas to

s the character specified as the field-start position).

Enter comma-separcombine fields.

0 = export all data from the field-start

Location info field.

Enter field lengths in the same order that you specified for t

The data exported as the Location info field consists of the characters specified in the field length (starting


Parameter Description Legal Values Comments end of the field.

File Encoding


ASCII, Unicode, UTF-8, or a numeric code page value



Example 1 - Multi-line records

File Format

Assume the file contains the following records. The dot (· ) is used to represent the space character to show the number of characters between the publication year and the author.

31147003808559 1925 SONG AND DANCE MAN / BY KAREN ACKERMAN ; ILLUSTRATED BY STEPHEN GAMMELL.

· · · · Ackerman, Karen

3114 700912 6234. 1987· · · · Yablonsky, Michael E. 1978· · · · Shneiderman, Linda P. THE ART AND SCIENCE OF COMPUTER GRAPHICS

Parameter Settings

The library wants the title to be the Primary information and author to be the Secondary information. The author field begins in the 9th character position of the second line of each record. Here are the parameters the user would set up:


Barcode Line Number 1 Line 1 of each item record contains the barcode.

Barcode Start Position 1 1 = the export starts from the beginning of the line (position 1)

Barcode Field Length 0 Export all data from the line start position to the end of the line.

Primary Info Line Number 3 Line 3 (Title) is exported as the Primary info field.

Primary Info Field Start Position 1 The export starts from the beginning of the line (position 1)

Primary Info Field Length 0 Export all data from the field-start position to the end of the line.


Secondary Info Line Number 2 Line 2 (call number) is exported as the Secondary info field.

Secondary Info Field Start Position 9 The export starts from character position 9.

Secondary Info Field Length 0 Export all data from the field-start position to the end of the line.



Export Results

Record Barcode Primary Information Secondary Information Record 1 (OK) 31147003808559 SONG AND DANCE MAN / BY

KAREN ACKERMAN ; (max 40 characters exported)

Ackerman, Karen

Record 2 (Warning)* 31147009126234 Warning: Missing Primary info Yablonsky, Michael E.

Record 3 (Error)** 1978 Error: Invalid barcode (assuming only 14 digit, numeric barcodes are valid).

N/A N/A

* In record 2, after the non-numeric characters are removed from the barcode, it is valid. Therefore, record 2 is exported even though it is missing Primary information (the title).

** Record 3 is not exported because it does not have a valid barcode. Data Manager took the 1st line of the record (1978· · · · Shneiderman, Linda P.) and tried to validate it as a numeric barcode of length 14.


Example 2 - Multi-line records

File Format

The dot (· ) is used to represent the space character to show the number of characters between the start position of the actual barcode and the space between the publication year and the author.

Item Barcode:· · 31147003808559 1925· · · · Ackerman, Karen SONG AND DANCE MAN / BY KAREN ACKERMAN; ILLUSTRATED BY STEPHEN GAMMELL AND SUSAN NORMANDY

Item Barcode:· · 31147009126234 1987· · · · Yablonsky, Michael E and Zabotinsky, Demitri R. THE ART OF SCIENCE

Parameter Settings

The title is the Primary information. For the Secondary information, the library wants the author and year of publication. The

author field begins in character position 9 in the second line of each record. If there is not room for both, the author is more important. The barcode is preceded with a label. The actual barcode begins in position 16. Parameter Value Comments Number of Lines to Skip 0 There are no additional lines before the first record in the text file.

Barcode Line Number 1 Line 1 of each item record contains the barcode.

Barcode Start Position 16 The export starts at position 16. This removes the 15-character “Item· Barcode:· · “ label that is placed before each barcode in the list file.

Barcode Field Length 0 Export all data from the line start position to the end of the line.


Primary Info Field Start Position 1 The export starts from the beginning of the line (position 1).



Secondary Info Line Number 2,2 The Secondary info field consists of two fields from line 2.


9,1 The author portion of the Secondary info field starts at position 9; the date portion starts at position 1.

Secondary Info Field Length 0, 4 0 = export the author from the start position (position 9) to the end the line. 4 = export 4 characters for the date (start with position 1).



Export Results

Record Barcode Primary Information Secondary Information Record 1 31147003808559 SONG AND DANCE MAN / BY KAREN ACKERMAN ; Ackerman, Karen 1925

Record 2 31147009126234 THE ART OF SCIENCE Yablonsky, Michael E and Zabotinsky, Dem

In record 1, the date is appended to the author with a single space separating them. Only the first 40 characters of the Primary information are exported.

In record 2, there was not enough room for the full author field and publication date. Only the first 40 characters are exported for this record’s Secondary information, so the date will not be displayed for this item on the DLA.

If you wanted to always display the date, you could specify the year first or you could limit the Secondary Info Field Length for the Author portion of the Secondary information field.


Example 3 – Multi-line records

File Format

The dot (· ) is used to represent the space character to show the start position of the actual barcode and the space between the publication year and the author.

SONG AND DANCE MAN / BY KAREN ACKERMAN ; ILLUSTRATED BY STEPHEN GAMMELL Location:· · SHELF6 Item Barcode:· · 31147003808559 1925· · · · Ackerman, Karen A STUDY OF THE MODERN DANCE IN THE ANCIENT WORLD: NOTHING NEW UNDER THE SUN Location:· · SHELF6 Item Barcode:· · 3114 700912 6234. 1987· · · · Yablonsky, Michael E and Zabotinsky, Demitri R. THE ART OF SCIENCE Location:· · SHELF7 Item Barcode:· · 31141625190452 1978· · · · Shneiderman, Linda P.

Parameter Settings

As with example 2, the title is the Primary information. For the Secondary information, the library wants the author and year of publication. If there is not room for both, the date is more important. Notice that the title is the first item in each record and the number of lines for the title varies. Therefore, the barcode, year of publication and author are referenced from the end of the record using negative line numbers.


Barcode Line Number -2 -2 = 2nd to last line of each record.

Barcode Start Position 16 16 = the export starts from character position 16 in line –2.

Barcode Field Length 0 Export all data from the start position to the end of the line.

Primary Info Line Number 1 Line 1 = title.

Primary Info Field Start Position 1 The export starts from the beginning of the line (position 1)



Secondary Info Line Number -1, -1 Two fields are exported from the last line of each record.

Secondary Info Field Start Position 1,9 Export the date starting at position 1, the author starting at position 9.

Secondary Info Field Length 4,0 4 = export 4 characters for the date (starting with position 1), 0 = export to the end the line for the author.


Location Info Line Number 2 Line 2 is location ID.

Location Info Field Start Position 11 11 = the export starts from character position 11 in line 2.

Location Info Field Length 0 0 = export to the end the line for the location ID.



Export Results

Record Barcode Primary Info Secondary Info Location ID Record 1 31147003808559 SONG AND DANCE MAN /

BY KAREN ACKERMAN ; (max 40 characters exported)

1925 Ackerman, Karen SHELF6

Record 2 31147009126234 A STUDY OF THE MODERN DANCE IN THE ANCIE (max of 40 characters exported)

1987 Yablonsky, Michael E and Zabotinsky (max of 40 characters exported)

SHELF6

Record 3 31141625190452 THE ART OF SCIENCE 1978 Shneiderman, Linda P. SHELF7

All records are successfully exported without any errors or warnings in the Export Log.

Example 4 – Multi-line records (weeding application)

File Format

The dot (· ) is used to represent the space character to show the start position of the actual barcode and the other data fields.

Blohm,· Hans. Pebbles· to· computers· :· the· thread Item· Barcode:· 3· 4567· 00022 8815 Item· Call· No.:· 609· Blo Item· Format:· Books Loan· Category:· B Stat.· Cat.:· 126 Last· Activity:· 09/22/1992· 00:00:00· Last· Circulation· Activity:· 12/09/1999· 13:41:50· Status:· · On· Shelf· Times· Circulated::· 3 Date of Publication: 1986 Friedel,· Robert· D.· (Robert· Douglas),· 1950- Zipper· :· an· exploration· in· novelty Item· Barcode:· 3· 4567· 00022· 9136 Item· Call· No.:· 609· Friedel Item· Format:· Books Loan· Category:· B Stat.· Cat.:· 126 Last· Activity:· 07/20/1994· 00:00:00· Last· Circulation· Activity:· 12/09/1999· 13:41:47· Status:· · On· Shelf· Times· Circulated::· 12 Date of Publication: 1994 Mumford,· Lewis,· 1895- Technics· and· civilization, Item· Barcode:· 3· 4567· 00022· 9334 Item· Call· No.:· 609· Mum Item· Format:· Books Loan· Category:· B Stat.· Cat.:· 126 Last· Activity:· 03/21/1991· 00:00:00· Last· Circulation· Activity:· 11/16/1999· 16:53:30· Status:· · On· Shelf· Times· Circulated::· 6 Date of Publication: 1990


Parameter Settings

To assist in weeding, this example exports both item identification information and circulation data in the Primary and Secondary Information Fields. The title is the Primary information. For the Secondary information, the library wants: the total number of circulations on record, the date of last circulation as MM/YY, the year of publication, and the last four digits of the item identifier.


Barcode Line Number 3 The 3rd line of each record contains the barcode.

Barcode Start Position 15 The barcode export starts from character position 15.

Barcode Field Length 0 Export all data from the field-start position to the end of the field.





Secondary Info Line Number

11,9,9,12,3 Line 11 = Times Circulated Line 9 = Last Circulation Activity (month) Line 9 = Last Circulation Activity (year) Line 12 = Date of Publication Line 3 = Item Barcode


20,28,36,22,28 Times Circulated starts at position 20 Last Circulation Activity (month) starts at position 28 Last Circulation Activity (year – YY) starts at position 36 Date of Publication starts at position 22 Last 4 characters of Item Barcode start at position 28

Secondary Info Field Length 0,2,2,4,4 Because “Times circulated” could be 1, 2, or 3 chars, use 0 to export to end of field. Last Circulation Activity (month) = 2 characters Last Circulation Activity (year – YY) = 2 characters Date of Publication = 4 characters 4 = export 4 characters of Item Barcode.

Secondary Info Field Label {C:},{ LC:},{/},{ P:},{ B:} Labels:

C: = Times Circulated LC: = Last Circulation Activity / to separate MM from YY in Last Circulation Activity P: = Date of Publication B: = the portion of the Item Barcode


Export Results

Record Barcode Primary Information Secondary Information Record 1 (OK) 34567000228815 Pebbles to computers : the thread C:3 LC:12/99 P:1986 B:8815

Record 2 (OK) 34567000229136 Zipper : an exploration in novelty C:12 LC:12/99 P:1994 B:9136

Record 3 (OK) 34567000229334 Technics and civilization C:6 LC:11/99 P:1990 B:9334

All records are successfully exported without any errors or warnings in the Export Log.

Format 3 - Fixed-length fields format This format uses fixed-length fields. User-defined fields are exported by specifying field position and length. Item records of this type can be delimited by either total character count or by the end of a line.


Any long or variable-length field (such as the item title) should occur at

the end of each record. Records are delimited by a total character count (fixed-length records)

or an end-of-line character. Parameters are used to set the field lengths and offset positions for the

barcode, Primary Info field, and Secondary Info field.

33333000240016· TP967· Am3· 1971· · · · · · · · · · Recent· advances· in· adhesion

In this example, the dot (·) represents the space character and is used to illustrate the fixed length.

Barcode = character position 1 and length 14

Secondary information (call number) = position 16, length 23

Primary information (title) = position 40, length 40



Fixed-Length fields parameters Parameter Description Legal Values Comments Number of Lines to Skip


0 – 2,000,000 This parameter is used if your list file has a header at the beginning of the file. If you included a three-line header, you would enter 3. Data Manager will not attempt to export data from the three lines that were skipped.

Only used when the Record Delimiter parameter is set to line.

Record Length

Fixed length of entire record (in bytes) or “line” for records ending with an end-of-line character (variable-length records).

1 – 4095, or “line” for line delimited records.

A value of “line” may include CR, LF, FF, or CR-LF terminated lines.

If “line” is not specified, all records must have the same length (same number of bytes).


The start position of the portion of the barcode field that you want to export.

1-1000

This parameter is typically set to 1 (first character of the field).

Barcode Field Length

The length (number of characters) of the portion of the barcode field that you want to export.

1-1000

0 = export all data from the field-start position to the end of the field.

This length is measured from the Barcode Start Position.

This parameter is typically set to 0.

Note: this length may be longer than your actual barcode length if spaces and /or additional characters are included in the barcode field.

Primary Info Field Start Position

The start position of the portion of the fields(s) that you want to export as Primary information.

1-1000

Separate multiple field-start positions with a comma.

Enter comma-separated field-start positions for each Primary info field.

Enter field-start parameters in the same order that you specified for Primary Info fields.

The DLA display width is limited to about 25 characters of Primary information.

Primary Info Field Length

The length (number of characters) of the field(s) that you want to export as Primary information.

1-1000

Separate multiple field-length values with commas to combine fields.


The data exported as the Primary info field consists of the characters specified in the field length (starting with the character specified as the field-start position).

If you combine multiple Fields:

Enter comma-separated field lengths for each Primary info field.

Enter field lengths in the same order that you specified for the other Primary Info field information parameters.

Primary Info Field Label

Label text that the DLA or other equipment will display before the Primary information field(s).


Separate multiple labels with commas:

{Title:},{ Author:}

Multiple labels must be entered in the same order that you specified for the other Primary Info field information parameters.




Parameter Description Legal Values Comments Secondary Info Field Start Position

The start position of the portion of the field(s) that you want to export as Secondary information.

1-1000

Separate multiple field-start positions with commas to combine fields.

Enter comma-separated field-start positions for each Secondary info field.

Enter field-start parameters in the same order that you specified for Secondary Info fields.

The DLA display width is limited to about 25 characters of Secondary information.


The length (number of characters) of the field(s) that you want to export as Secondary information.

1-1000



The data exported as the Secondary info field consists of the characters specified in the field length (starting with the character specified as the field-start position).

Enter comma-separated field lengths for each Secondary info field.

Enter field lengths in the same order that you specified for the other Secondary Info field information parameters.

Secondary Info Field Label

Label text that the DLA or other equipment will display before the Secondary info field(s).


Separate multiple labels with commas:

{Title:}, { Author:}

If you desire custom labels for information taken from multiple fields, separate each label with a comma.

Multiple labels must be entered in the same order that you specified for the other Secondary Info field information parameters.



Location Info Field Start Position

The start position of the portion of the field(s) that you want to export as the Location ID.

1-1000

Separate multiple field-start positions with commas to combine fields.

Enter comma-separated field-start positions for each Location info field.

Enter field-start parameters in the same order that you specified for Location Info fields.

The DLA display width is limited to about 25 characters of Location information.

Location Info Field Length

The length (number of characters) of the field(s) that you want to export as the Location ID.

1-1000



The data exported as the Location info field consists of the characters specified in the field length (starting with the character specified as the field-start position).

Enter comma-separated field lengths for each Location info field.

Enter field lengths in the same order that you specified for the other Location Info field information parameters.

File Encoding


ASCII, Unicode, UTF-8, or a numeric code page value



Example 1 – Fixed-length fields record

File Format

This is an example of a fixed-length field format where the records are separated with an end-of-line character. The dot(· ) represents a space and an arrow (↙) represents the end of a line character.

158.1· L57· · · · · · · · · · 32087021028906· LIVING· IN· BALANCE:· · A· DYNAMIC· APPRO ACH· FOR· CREATING· HARMONY· &· WHOLENESS· IN· A· CHAOTIC· WORLD ↙ 158.1· L58· · · · · · · · · · 32087021069921 ↙ 158.1· M2· · · · · · · · · · · ANOTHER· VIEW· OF· THE· INNER· SELF:· · A· METHOD· OF· SELF-ANALYSIS ↙

Parameter Settings

The library wants the title to be the Primary information and the call number to be the Secondary information. The call number begins in the 1st character position, the barcode begins in the 20th character position, and the title begins in the 35th character position.


Record Length line Each record ends with an end-of-line character.

Barcode Start Position 20 The barcode begins at the 20th character position.

Barcode Field Length 14 Export 14 barcode characters starting from position 20.

Primary Info Field Start Position 35 The export starts from position 35.

Primary Info Field Length 0 Export all data from the field-start position (35) to the end of the line.



1 The export starts from position 1.

Secondary Info Field Length 19 Export 19 characters starting from position 1.



Export Results

Record Barcode Primary Information Secondary Information Record 1 (OK) 32087021028906 LIVING IN BALANCE: A

DYNAMIC APPROACH F (max 40 characters exported)

158.1· L57

Record 2 (Warning)* 32087021069921 Warning: Missing Primary information

158.1· L58

Record 3 (Error)** Error: Invalid barcode Record not exported. Record not exported.

*Record 2 has a valid barcode and is exported even though it is missing Primary information.

**Record 3 is not exported because it does not have a valid barcode. Data Manager took the characters specified for the barcode (ANOTHER· VIEW· O) and tried to validate it as a numeric barcode of length 14.


Example 2 - Fixed-length fields record

File Format

The dot(· ) represents a space and an arrow (↙) represents the end of a line character.

158.1· L57· · · · · · · · · · 32087021028906· 1982· SHELF6· LIVING· IN· BALANCE:· · A· DYNAMIC· APPROA CH· FOR· CREATING· HARMONY· &· WHOLENESS· IN· A· CHAOTIC· WORLD ↙ 158.1· L58· · · · · · · · · · 32087021069921· 1948· SHELF6· ANOTHER· VIEW· OF· THE· INNER· SELF ↙

Parameter Settings

The library wants the title to be the Primary information; and the publication date and call number to be the Secondary information. The call number begins in the 1st character position, the barcode begins in the 20th character position, the date begins in the 35th, and the title begins in the 40th character position.



Barcode Start Position 20 The barcode begins at the 20th character position.

Barcode Field Length 14 Export 14 barcode characters starting from position 20.


Primary Info Field Length 40 Export 40 characters starting at position 40.


Secondary Info Field Start Position 35,1 The date field starts at position 35; the call number field starts at position 1.

Secondary Info Field Length 4,19 Export 4 date characters and 19 call number characters.


Location Info Field Start Position 40 The location ID starts at position 40.

Location Info Field Length 6 Export 6 characters.


Export Results

Record Barcode Primary Info Secondary Info

Location ID

Record 1 (OK)* 32087021028906 LIVING IN BALANCE: A DYNAMIC APPROACH F (max 40 characters exported)

1982 158.1 L57 SHELF6

Record 2 (OK)** 32087021069921 ANOTHER VIEW OF THE INNER SELF 1948 158.1 L58 SHELF6

Both records are exported successfully without any warnings or errors.

*In record 1, only the first 40 characters of the title are exported.

** In both records, there is enough room for both the date and call number to be exported as part of the Secondary information.


Example 3 – Fixed-length fields format (weeding application)

File Format

The dot(· ) represents a space and an arrow (↙) represents the end of a line character.

34567000228815· Blohm,· Hans.· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · Pebbles· to· computers· :· the· thread· · · · · · · 609· Blo·· · · · · · 126· 12/09/1999· 3· · · 1986· SHELF6↙

34567000229136· Friedel,· Robert· D.· (Robert· Douglas),· 1950· · · · Zipper· :· an· exploration· in· novelty· · · · · · 609· Friedel· · · 126· 12/09/1999· 12· · 1994· SHELF6↙

34567000229334· Mumford,· Lewis,· 1895· · · · · · · · · · · · · · · · · · · · · · · · · Technics· and· civilization,· · · · · · · · · · · · · · 609· Mum· · · · · · · 126· 11/16/1999· 6· · · 1990· SHELF7↙

Parameter Settings

To assist in weeding, this example exports both item identification information and circulation data in the Primary and Secondary Information Fields. The title is the Primary information. For the Secondary information, the library wants the last four digits of the item identifier, the date of last circulation as MM/YY, the total number of circulations on record, and the year of publication.

Parameter Parameter Value Comments Number of Lines to Skip 0 There are no additional lines before the first record in the

text file.


Barcode Start Position 1 The barcode begins at position 1.

Barcode Field Length 14 Export 14 barcode characters starting at position 1.


Primary Info Field Length 40 Export 40 characters of the title starting at position 61.


Secondary Info Field Start Position 130,119,127,134,11 Times Circulated = position 130 Last Circulation Activity (month) = position 119 Last Circulation Activity (year) = position 127 Date of Publication = position 134 Last 4 characters of Item Barcode are at position 11

Secondary Info Field Length 3,2,2,4,4 Times circulated could be 1, 2, or 3 chars, so use 3 Last Circulation Activity (month) is 2 characters Last Circulation Activity (year – YY) is 2 characters Date of Publication is 4 characters We are showing 4 characters of Item Barcode

Secondary Info Field Label {C:},{ LC:},{/},{ P:},{ B:} Labels:

C: = Times Circulated LC: = Last Circulation Activity / = separate MM from YY in Last Circulation Activity P: = Date of Publication B: = the portion of the Item Barcode

Location Info Field Start Position 139 The location ID starts at position 139.

Location Info Field Length 0 The location ID extends to the end of the record.



Export Results

Record Barcode Primary Info Secondary Info Location ID Record 1 (OK) 34567000228815 Pebbles to computers :

the thread C:3 LC:12/99 P:1986 B:8815

SHELF6

Record 2 (OK) 34567000229136 Zipper : an exploration in novelty

C:12 LC:12/99 P:1994 B:9136

SHELF6

Record 3 (OK) 34567000229334 Technics and civilization C:6 LC:11/99 P:1990 B:9334

SHELF7

Step 4 - Define import formats Each time you import a collection category, Data Manager saves the collected Item IDs from that category in a separate, formatted text file. An Import Format defines how these text files are formatted.

Data Manager saves these files in the Import File Destination folder.

Each file name includes the import date. The import format must match a format supported

by your circulation system. This format may have to emulate an import file as collected by a barcode scanner.

Figure 20: Import Formats dialog box.

Input format parameters Use the import format parameters to add any header strings, command codes, and date/time stamps required by your circulation system. In addition, you can add Primary, Secondary, and/or Location information to each record in an imported text file. NOTE: Location information is used only for libraries that use Location tags. See page 10 for more information.

See Date/timestamp formatting on page 44 for a listing of date/time stamp characters.

See Adding Primary/Secondary/Location info on page 42 for a listing of Primary, Secondary, and Location format characters.

Data Manager automatically adds carriage-return and line-feed characters to the end of each barcode in the text file.

Input Format Parameter

Description

Import Format Name The import-format name that will appear in the Import Formats dialog box. This name will appear on the drop-down list in the main window’s Format column.

Header String Any header text, command codes, or date/timestamp characters that must appear in the first line of each text file. Header information may include: Time Date Staff ID Organization ID

You can add delimiter characters between the various codes and date/time stamps.

Barcode Prefix Any text string, command codes, or date/timestamp characters that must be added to the front of every Item ID. Some circulation systems may require a “transaction type” command code. You can add delimiter characters between the various codes and date/time stamps.

Barcode Suffix Any necessary text or date/timestamp characters that must be added to the end of every Item ID. Data Manager automatically adds carriage-return and line-feed barcode suffixes to each Item

ID. If required, you can change these.

Footer String Any footer text or date/timestamp characters that will appear in the last line of each text file.

Special Cases These characters can be added anywhere: To add a carriage return, type <CR>. To add a line feed, type <LF>. If you do not want a line feed or carriage return, type <NONE>. <TAB> (must be uppercase)


Import format example

In this example, the circulation system requirements included:

Header String

The header string must include:

A session ID A date and time stamp A delimiter character (|) between each

component of the header string

Item ID

Each Item ID must be on a separate line and must include a barcode prefix:

A transaction type (in this example: 6=inventory)

A time stamp A delimiter character (|) between each

component of the barcode prefix

See Date/timestamp formatting on page 44 for a listing of date/time stamp characters.

Your import formats may look quite different depending upon your circulation system requirements.

Figure 21: Import Format Parameters.

Figure 22: Preview the import format to ensure that the formatting meets your circulation system’s requirements. The abc123456790x characters represent the collected Item IDs.


Adding Primary/Secondary/Location info to imported data Adding Primary/Secondary/Location info to imported data The following import format parameters allow you to add Primary, Secondary, and/or Location information to each record in an imported text file.

The type of primary, secondary, and location information that you can add depends on the file that was used to create the import data.

Pull-list results files – the Primary and Secondary information that can be added to the resulting text file depends upon what Primary and Secondary information was exported with the original pull list.

Collected data text files - the Primary, Secondary, and Location information that can be added to the resulting text file depends upon which Primary, Secondary, and Location information was exported with the shelf-order list that contains each collected Item ID.

Items that do not appear on a shelf-order list but appear on a search list will use the Primary, Secondary, and Location information exported with the search list.

Items that do not appear on a shelf-order list or a search list (not-in-database items) will have no Primary, Secondary, or Location information and will only be listed with an Item ID.

Format for tabs

<TAB> This will insert a tab into the line. You must type TAB in all uppercase letters.

Format for Primary Information

<P> This will insert all the Primary information.

<P,X> This will insert the Primary information starting at character position X .

<P,X,Y> This will insert the Primary information starting at character position X with length of Y characters. NOTE: P must be in upper case.

Format for Secondary Information

<S> This will insert all the Secondary information.

<S,X> This will insert the Secondary information starting at character position X .

<S,X,Y> This will insert the Secondary information starting at character position X with length of Y characters. NOTE: S must be in upper case.

Format for Location Information

<L> This will insert all the Location information.

<L,X> This will insert the Location information starting at character position X .

<L,X,Y> This will insert the Locationinformation starting at character position X with length of Y characters. NOTE: L must be in upper case.


Example

In this example, Primary and Secondary information were added as a barcode suffix (after the barcode). A tab character was inserted to separate the various fields.

The resulting text file includes the Item ID (barcode), Primary information (title) and Secondary information (call number), all separated with a tab character.



Date/timestamp formatting

Examples:

Stamp Formatting Codes Result Date/time %Y%m%d%H%M 199904021406

Time/date %H:%M|%m/%d/%Y 14:13|04/03/2001

Time |%H:%M:%S| |14:13:06|

The % character is used to designate a substitution code for a date and time value:

Format Code Value %a Abbreviated weekday name

%A Full weekday name

%b Abbreviated month name

%B Full month name

%c Date and time representation appropriate for locale

%d Day of month as decimal number (01 – 31)

%H Hour in 24-hour format (00 – 23)

%I Hour in 12-hour format (01 – 12)

%j Day of year as decimal number (001 – 366)

%m Month as decimal number (01 – 12)

%M Minute as decimal number (00 – 59)

%p Current locale’s A.M./P.M. indicator for 12-hour clock

%S Second as decimal number (00 – 59)

%U Week of year as decimal number, with Sunday as first day of week (00 – 53)

%w Weekday as decimal number (0 – 6; Sunday is 0)

%W Week of year as decimal number, with Monday as first day of week (00 – 53)

%x Date representation for current locale

%X Time representation for current locale

%y Year without century, as decimal number (00 – 99)

%Y Year with century, as decimal number

%z, %Z Time-zone name or abbreviation; no characters if time zone is unknown

%% Percent sign

The # character may be used to modify a format code.

Format Code Modification %#a, %#A, %#b, %#B, %#p, %#X, %#z, %#Z, %#%

# flag is ignored

%#c Long date and time representation, appropriate for current locale

For example: “Tuesday, March 14, 1995, 12:41:29”

%#x Long date representation, appropriate to current locale

For example: “Tuesday, March 14, 1995”

%#d, %#H, %#I, %#j, %#m, %#M, %#S, %#U, %#w, %#W, %#y, %#Y

Remove leading zeros (if any)


3M Service Information to gather Before you call for service, please have the following information available:

• The name, address, and telephone number of your facility

• A description of the problem or the issue you want addressed

• The model number and serial number of the equipment (located on the serial label), if the call is in regard to a system problem

Model Number __________________________________

Serial Number __________________________________

3M Service phone numbers For questions regarding your system, call one of the following numbers.

In the United States In Canada In other countries

1-800-328-0067 English 1-800-268-6235 Call your local 3M office. Francais 1-800-567-3193

3M Library Systems Web Site The 3M Library Systems Web site can be located at http://www.3M.com/library.

For additional information in the United States about 3M SelfCheck systems, go to http://www.3M.com/us/library.

http://www.3m.com/library

http://www.3m.com/us/library