Data Manager Export Documentation

Staff Web StaffWeb: UG | UW | WLU
Libraries: UG | UW | WLU
Campus: UG | UW | WLU

Home TUG Statistics & Reports

Documents Contacts Search

Impromptu Report Documentation

Search Reports Status Database

Report Title	Data Manager Export
Report Reference #
Revision Date	2011-05-19
Requestor	Ann Naese

Impromptu File Name	Directory	Catalogue Name
DMexport.imr	C:\Impromptu Web Reports\Circ_transactions	C:\Impromptu Web Reports\Circ_transactions\circ_transactions.cat

Web File Name ( login)	Web News Box
DMexport (see sample)	UW Reports and Cubes/Circulation/Inventory Reports

Report Description:

This report will list barcode, call number (sort and full) and title for the specified location and call number range. It is intended to be exported in delimited text format for use with the RFID Data Manager.

NOTE: it is very important that the call number be entered in the "normalized" format. The LC class must be followed by the LC number padded with spaces to 5 character positions. See the examples below where "-" represents a "space". It is recommended that call numbers only include the LC class and a whole LC number (no decimals or cutters). If a small collection is being inventoried the LC class only may be entered as the start and end call numbers.

B12 enter as B---12
QA1 enter as QA----1
H1234 enter as H-1234
GV123 enter as GV--123

Prompt	Type	Description
Choose location codes that start with:	Type in	Enter the start characters of the location codes that you want to choose from e.g. UWDAV
Select inventory location:	Picklist	Select the location name from the list
Enter Start Call number (e.g. B----1 or HA-1000)	Type in	Enter the LC class and LC number of the start call number - ensure that enough spaces precede the LC number to make 5 character positions for the LC number
Enter End Call number	Type in	Enter the LC class and LC number of the end call number - ensure that enough spaces precede the LC number to make 5 character positions for the LC number

Filters:

Item Location equals location selected in prompt

item status equals "Not Charged" or "Discharged"

Call number between call number range entered in prompts

Sort Order:

Call Number (ascending)

Data Elements:

Item barcode
Sort call number
Full call number
Title (100 characters)

Important Notes:

Call number sorting for volumes may not be correct.

Estimated run time:

5 - 30 minutes

Report Developer:

Gail Sperling