AccuTrack/AccuSQL
Import "Media Stock"

12 September 2013
USED TO IMPORT MEDIA ITEMS THAT ARE LOANED TO STUDENTS AND TRACKED

CSV Mapped Columns:

# Field Name Type (Char Limit)
1 Media ID varchar(20)
2 (Media) Type int (max)
3 (Media) Title varchar(40)
4 Instructor (Full Name) varchar(25)
5 Notes varchar(30)
6 Lab ID varchar(10)

*Fields highlighted in yellow are required to import.

Explanation:

The Media ID is used to be able to scan in/out materials.

* The (Media) Type uses a (Media) Type such as a book, CD, DVD, etc., and converts each (Media) Type to an INT in the database after import.
IMPORTANT! Media Types must be created in AccuTrack or AccuSQL before importing.

The (Media) Title is the only required field to create a Media object.

The Instructor (Full Name) is an optional field that can be used to provide the Instructor's information so you know the ownership of the media checked out.

The Notes are an optional field that can be used to provide additional information about the Media.

* You must manually enter the Media Type(s) you will be importing in the Media Stock screen before importing or all of the Media Types for the media items will all be listed as "Unknown".

Example:

Download/View the example file (CSV)

Import Behaviors for this Import

When you run this particular import there are not any import behaviors. Import behaviors typically allow you to modify the way the import is run for different results than normal. If you have any ideas for adding an import behavior please submit them to AccuTrack/AccuSQL's User Voice.

BACK to List of Imports