Locations

In order for Gateway to transfer files from one place to another, administrators need to define the Locations that Gateway will use. Each source and destination for file transfer will need to have a location configured. Typically Gateway will copy data from a primary server to a secondary server.

When creating locations, it is important to name each location a meaningful name that will properly represent what each location is. The name of the location will be displayed during the setup and configuration of rules within the Scanner.

There are three basic types of Locations. AUDIO, DATABASE and SQL. These Locations are described below.

LOCATION TYPE	DISPLAYED AS	USAGE
AUDIO	A	The AUDIO location is strictly used to define where the audio files will be received from or transferred to. One should define an AUDIO location for each drive they have either audio files or command cuts saved.
DATABASE	D	DATABASE is the normal default Library database DAD uses. This will be the choice for ALL users unless they are specifically using a SQL Database Server for DAD. One should create a DATABASE location for each of the 'DATA' locations one has.
SQL	S	One would only choose SQL if the either the primary or backup server is a SQL Database Server. Supported SQL Engines are MimerSQL, MySQL and SQLServer from Microsoft.

Locations that are already configured are displayed in the list area. When one highlights a location, four LED indicators below the location list area display whether:

A given location is operational ("up")
A DAD cuts folder exists at that location
A DAD Database and index file exist at that location

A green light by each of these indicates that the item exists at the highlighted location. A red light with 'n/a' indicates that the item does not exist at that location and is not applicable.

The location’s minimum space is met (Danger Limit). The actual space available on that location is also displayed.

A Warn Operator checkbox option is also available. When checked this option will display a message in the Main message window described above when the minimum space limit has been reached.

Configuring Locations

Before proceeding to create Locations, administrators should consider the following before adding ANY new Location.

Note: Make sure the Enable Scanner field on the Gateway/Dist window is unchecked. The scanner must be disabled in order to add, modify or delete locations.

Important: Administrators should verify that both the Source and Destination Locations have proper rights enabled for the machine which is running Gateway.

Caution: Do not use UNC naming for the local (C:) drive, as this places an unnecessary burden on network resources. One should use the local drive letter instead.

UNC naming is best for these situations:

Drive mappings that are missing or unknown
Two or more facilities, each with its own F: drive and G: drive will be working within the same Gateway configuration
Remote access connectivity

Gateway allows one to ADD either an AUDIO, DATABASE or SQL location. Each of these locations are slightly different from one another. The setup of these locations are as follows:

To add a new Audio location:

Note: The Audio Location type is the DEFAULT location for use with all Audio files and directories.

Database would be used for ALL DAD Library and Playlist data locations.

In general one will have either Database or Audio Location types.

One would ONLY have SQL if they are using a SQL Server in their system.

One should first use the menu to the right of the ADD button to select AUDIO. Once this has been done, one can click the Add button. The Add Audio Location window opens.

Enter the name of a Location Name into the Location Name field.

If the workstation the Gateway application is running on has an existing network drive mapping to the system or drive being added, enter that drive letter into the UNC Address field. For example if the server’s audio drive is mapped as G:, enter G:. If there isn't a mapping available, enter the Universal Naming Conventions (UNC) Address into the UNC Address field. An example of a UNC address is \\DADSERV\VOL1.

Enter the drive letter that will be used by the DAD application to access and play audio files into the LOCATION field.

This value will be entered into the Library database on the destination location. For example: If one is backing up audio to a local workstation with an additional ‘D:’ drive for audio, one would enter D:. This will allow that workstation to access the audio on the D: drive when that workstation plays audio in a backup role.

Note: The drive letters specified in the UNC Address and Drive Letter fields will occasionally be different for the same location depending on network settings.

Freespace Warning Limit (M) allows one to set a value in Megabytes for the amount of minimum space that is available for that location.

The AUDIO Path field will contain the directory path for where the audio resides. For most, \CUTS\ will be the default.

If one were using Multiple Libraries, then one would create a unique Location for each Audio Library Directory. The AUDIO Path would then be the name of the directory used by the Multiple Library.

Clicking the SAVE button will add the location.

To add a new Database location:

Note: The Database Location type is the DEFAULT location for use with DAD Libraries. In general one will have either Database or Audio Location types.

One would ONLY have SQL if they are using a SQL Server in their system.

One should first use the menu to the right of the ADD button to select DATABASE. Once this has been done, one can click the Add button. The Add Database Location window opens.

Enter the name of a Location Name into the Location Name field.

Enter the drive letter that will be used by the DAD application to access all database related files into the LIBLOC field.

This value will be entered into many areas such as Playlist's, User Setup files and other database on the destination location. For example: If one is backing up DAD Data to a local workstation's C: drive, one would enter C:. This will allow that workstation to access the data C: drive when that workstation loads a Playlist or a User Setup file.

Note: The drive letters specified in the UNC Address and Drive Letter fields will occasionally be different for the same location depending on network settings.

The Notify CutServer checkbox and Path options are used for facilities that are also running CutServer on their DESTINATION server. When the checkbox is enabled, Gateway will send a notification to CutServer for each audio file transferred. CutServer will then read this notification and relay the appropriate information to all of it's clients.

This option would ONLY be used if the DESTINATION location is using CutServer.

DATABASE Name is the name of the database to be used. For most, CUTS will be the default DAD Library database.

One would only use another name in a Multiple Library situation.

If one were using Multiple Libraries, then one would create a unique Location for each Library Name. The Database Name would then be the name of the directory used by the Multiple Library.

REBUILD Database allows one to rebuild the database on the location used.

Note: Currently one can ONLY rebuild a database for a Location if that location is using a Drive Letter in the UNC Address field. A Rebuild will not be performed if the UNC Address field contains either an IP Address or a valid UNC address. This means that one must assign a drive letter within Windows that allows access to the Locations DAD directory.

Clicking the SAVE button will add the location.

To add a new SQL location:

Note: One would ONLY use SQL if a SQL Server as either the Primary or Backup Server system.

One should first use the menu to the right of the ADD button to select SQL. Once this has been done, one can click the Add button. The Add SQL Location window opens.

Enter the name of a location name into the Location Name field.

Select the type of SQL Engine to be used. Options are MimerSQL, MySQL and SQLServer from Microsoft.

One would next enter the SQL User Name, Password and DSN for the SQL Server to be used. Gateway will use the User Name, Password and DSN to log into the server and access the data.

Enter the drive letter that will be used by the DAD application to access all database related files into the LIBLOC field.

Note: The drive letters specified in the UNC Address and Drive Letter fields will occasionally be different for the same location depending on network settings.

This option would ONLY be used if the DESTINATION location is using CutServer.

DATABASE Name is the name of the database to be used. For most, CUTS will be the default DAD Library database.

One would only use another name in a Multiple Library situation.

If one were using Multiple Libraries, then one would create a unique Location for each Library Name. The Database Name would then be the name of the directory used by the Multiple Library.

Clicking the SAVE button will add the location.

Modifying Locations

Select the location desired and press Modify.

After one has altered the the information such as the UNC Address or Location field one should press Save.

Any changes made to the location will now be used by Gateway. To exit the Modify Location window without saving changes, click the Cancel button.

One can NOT modify the Location Name field. This field can not be changed once it has been created. To change the Location Name, one must create a NEW Location.

Deleting Locations

Highlight the location to delete.

Click the Delete button. Gateway prompts to confirm the deletion.