Converting Selector databases to GSelector

GSelector and Selector 12 and 15 differ in a number of ways. For a full overview of the differences, see the GSelector and Selector compared topic.  

This has a direct effect on a conversion from Selector databases to GSelector. Many GSelector screens (and the fields in them) are new or rethought; not all fields in Selector have a direct GSelector equivalent. So we will ask you to make some choices at different stages in the conversion process. If you have a very developed and detailed database, using a lot of fields to carry information, you many need to do some configuration work in your Selector database before converting up to GSelector. Your Selector database may be very complex, or it may be very straightforward. But we suggest you go through these notes in full before starting the import process.

The import process: an overview

Preparing your Selector database

Launching the Import wizard

Can I start over?

 

The Import Process

The Selector - GSelector import tool reads your Selector Database, or your multiple Selector Databases in sequence, and asks you, one window at a time, to make decisions that affect how we handle your data. This is not a difficult process, but it does involve detail work. The more complex your Selector database, the more you may need to take a little time to work out your best options. However, you may not need to change any settings in these windows, as the default settings we provide are designed to suit the majority of formats.  

The import tool will translate key Selector information - Clocks, Library, Category structures, Browse Requests. and Schedule History - from Selector to GSelector equivalents.  We ask you to select your most important Priority List and apply that as the basis for Goal settings, and we also ask you to review your Category and Level settings to reflect the GSelector structure. Other settings like multiple Policies, Last Play window, and many others are simply superseded by GSelector's powerful built in spread tools.

TIP:   If after completing the import procedure, you find your settings are horribly wrong, you can always start over. Follow the steps outlined here.

 

Preparing your Selector database

User Defined fields and Custom User Defined fields will need to be defined before the import process for the fields to show in the v12toGS field mapping window. Make sure your Selector data is present and correct. If Selector 12/15 song or link data is missing, those items are not imported, and are listed in a discrepancy list in the progress report pane. For most Selector users, the import process is straightforward.

However, be prepared copy or move data in the Conditional Changer/Changer window to a new source field. For example, many stations no longer use the Selector Album field for its original purpose. As it offers the ability to separate songs, this field is used in many innovative ways by Selector users. Moving this information to an unused Selector field (say Research Notes) and then importing from this source field lets your data be copied to a User-defined or Custom User Defined field in GSelector. It is recommended these fields be defined in the GSelector database prior to import. Once in GSelector, songs with this information can be browsed, and a new Sound Code or Attribute can be applied as required.

 

Import Wizard windows

Database Settings

Specifying Selector ID source fields for GSelector Media ID fields

Specifying Selector fields to GSelector User-defined fields

Artist Options

Station Song Attributes

Station Name, Research, Alternate Category and Scalar options

Assigning Categories to Groups

Progress Report

I already have a GSelector database - where does data go?

 

Launching the Import wizard

  1. Close GSelector.
  2. Navigate to the RCS/GSelector folder, and double-click v12toGS.exe to access the Import wizard start screen.
  3. The GSelector Database window allows you to confirm or modify server, security and database settings. GSelector will display your default settings, and under most conditions, you won't need to change these. If you are importing Selector to create or add one or more stations with the same GSelector library, you don't need to change these settings. The database name and server location are specified during the GSelector install process.
    NOTE: This topic covers importing to one GSelector database. If you want to create a separate further GSelector database, see the notes on adding a GSelector database.
  4. In this window, enter (or accept the default) Server and Database name details. You can run the import program from any GSelector machine, providing it is mapped to the appropriate server. Some GSelector sites have multiple databases, where mapping is required, but the default name is the most common option.
  5. Click Next.
  6. Select the Selector Version to Convert.
  7. Uncheck the Import using Wizard to manually select data folder.
  8. Click Next.
  9. If Import using Wizard was unchecked browse to the folders for the conversion.
  10. Otherwise, specify or accept the default RCSMenu drive, and where different, your Selector data drive. If required, map to these drives before launching the Import wizard.
    TIP: This image shows conversion windows for a V12 Selector database. The windows will always indicate the version of Selector you are converting. However they are largely the same, except where noted.
  11. Then check the boxes to pick databases to import. You can import multiple Selector databases to create individual stations in one GSelector library database.
  12. Multiple versions of the same song in different Selector databases will create one library entry in several stations, if the Selector 12/15 title, artist and Media ID field information is exactly the same.
  13. If the title and artist information is the same but the Media ID field is different from station to station, individual records are created for each station, with the Selector 12/15 Media ID written to the GSelector song information pane. See the notes below on Media ID configuration.
  14. Finally, click the Next button to move to the next window.

Specifying Selector ID source fields for GSelector Media ID fields

GSelector uses a single global Media ID for Songs in all stations in the GSelector database, and also allows a Local ID for each station if you need this.    

Here, you select the Selector source field for data to ID data to copy to the GSelector global ID field. We list the most commonly used Selector ID fields. If you use other Selector 12/15 fields, use the Selector 12/15 Conditional Changer Copy or Move tool to transfer this data to one of the fields below, and then import from that field. See the notes on preparing your Selector database in this topic.

  1. For both Songs and Links, select one of the Selector media fields to import. (Note: The Media ID option is a combination of these two Selector fields).
  2. Check the Station Specific Media Field box to enable the Station-specific ID field in the GSelector song window and copy ID information to this field as well as the Media ID field.
  3. Check the Linker breaknote check box to force all Breaknotes to Link category b.
  4. Check the Convert Stopset check box to change existing Selector Breaknotes specified as Stopsets - where these are used to mark Spotsets in Selector - to actual Spotsets in GSelector.

  1. If necessary, step back to the previous window and change any settings.
  2. Finally, click the Next button.

NOTE: If you are importing Selector songs into an existing GSelector database and you want you import a Selector database with different ID attributes, you will be asked to change your Selector parameters, or the settings in Setup section Station - Media IDs window. See the notes on this topic on working with existing Selector Databases.

 

Specifying Selector fields to GSelector User-defined fields

GSelector offers 10 User-defined fields and up to 89 Custom User Defined fields in the Song and Link Additional Information windows. They share common names and functions in both windows, but you define what data these fields can hold. Custom User Defined fields must be defined in the new GSelector database to show in this window.

In this conversion window you pick supplementary Selector 12/15 fields to copy their contents to the GSelector user defined fields; the selected fields are also renamed in GSelector, unless you set the associated field to blank. This process is library-wide, not station-specific. In this window we suggest the most-used supplementary fields in Selector.

TIP: If you already use User-Defined fields in the GSelector target database, you can protect these. Click the drop down arrow in any User-defined field to see the Selector 12/15 fields list, and scroll up so that the entry for this field is blank. This will prevent original GSelector data from being overwritten.

  1. Click any field's drop-down arrow to view the list of available Selector fields.
  2. Scroll up or down to select a different Selector field, or scroll up to the top to leave this field blank
  3. If necessary, step back to the previous window and change any settings.
  4. Finally, click the Next button.

TIP: For more information on this and other areas, see the GSelector and Selector compared topic.

 

Artist options

In Selector 12/15, you can have a maximum of four Artists per song, and you can convert all of Artist fields, or just the Artist fields you wish to convert into the Artist field in GSelector. In GSelector you can specify an unlimited number of Artists, called Participants, for any song. In GSelector, Participant roles are used to classify the contribution each Participant makes to the song. GSelector has Participant roles like Vocalist, Musician, Composer and more.

In GSelector a Participant can take on multiple roles: someone like John Mayer, for example, could have Vocalist, Musician, Producer and Composer roles. In the conversion process, you pick which Participant role should be assigned to the Artists in the four Selector Artist fields. In most Popular music formats, you will be categorizing just your Artist 1 and Artist 2 as Vocalists. Some users will opt to also Categorize Artist 3 and Artist 4 as well.

Any combination of the four Selector Artist fields can be combined into one GSelector Artist Name field.

  1. Check each Artist field to include that field's data as part of the GSelector Artist name field.
  2. Optionally select a Participant for each Artist field.

  1. For each Artist field, specify whether you wish the selected Participant to have Artist (all Songs by this Artist) or Song (individual Song) associations. The default setting is Artist. For more on this, see the Attributes and Participants tab notes in the Song window.
  2. If necessary, step back to the previous window and change any settings.
  3. Finally, click the Next button.

 

Station Song Attributes

The Station Song Attributes is used to map song attributes to be Global or Station specific attributes. If the attribute is set to Station, then the attribute can be set for the asset in the Station Song Attributes window from the Song Window for the station. If the attribute is set to Global, use the Song Coding window to set a Global attribute for the song.

  1. Use the Attribute Type drop-down to change the selected attribute to Global or Station.
  2. Click the Next button.

 

Station Name, Research, Alternate Category and Scalar options

This window allows you to select options for Station Name, Research and Alternate Categories areas. You can also set the scale range (5 or 9) you want in the Texture field.

Station Name

Research

Alternate Category

Scalars

Click any area in this pane for help

Click any area in this pane for help

Station Name

Click one of the three options here to specific what information is copied into the Station Name field in GSelector. You can select basic information (the Selector Call Letters field) or more detailed information (the Selector Slogan field, the folder name), or a combination.

Research

These two options allow you to decide how the information in the Selector rows is treated. If you always use the same score type (for example, you always do Auditorium research), then select the first option. But if you use different score types for one date (for example, Auditorium and Call-out), select the second option.

Alternate Category

TIP: Selector Alternate Category uses, especially the hours used in the defining Selector Station Dayparts, can vary enormously. If the Selector Station Daypart stretches across all hours of the day - for example with a checkerboard pattern - it is possible that any Songs with this Daypart will not be assigned to their target Category at all, but instead to their Alternate Category, especially if you select the Any Hours option. If you are such a user of Dayparts when working with Selector Alternate Category, you might wish to consider reviewing your use of Dayparts before converting up.   

In GSelector, you can have as many Alternate Categories as you have active Dayparts for any Song or Link. In Selector 12/15, you assign one Alternate Category to a Song or Link, in hours set by the Selector 12/15 Station Daypart (the equivalent of the GSelector Hour Restriction ) assigned to the song or link. So, in the import window, you decide where the existing Selector Alternate Category is to be allocated.

Select the default Majority of hours option to specify the Alternate Category in the GSelector Daypart that most closely matches the hours in the Selector Daypart.  The other option is to allow Any Hour to be used. Here, the conversion program assigns the Selector  Alternate Category in all GSelector Dayparts which have any hour assigned for the Selector Alternate Category.

Master Control fields

Where your source Selector database is used with Master Control, check the box if you wish to use GSelector Master Control Integration, and enter details for the XML Server and 15 Database.

Scalars

Scalar fields - Mood, Energy and others - are so called  because they work on a scale of, say , 1 to 5. GSelector offers two options, to match those available in Selector - a scale of 1 to 5 or 1 to 9.

 

Import Data

The final screen in the Convert process is Import. When satisfied with the selection made click the Import button.

 

I already have a GSelector database - where does the new data go?

TIP: This option is for advanced users. If you are installing for the first time, skip this section.

If you want to add new Selector stations to an existing GSelector library, you don't need to change your existing settings.

If you are importing Selector station databases to a new GSelector database, and you do not plan to share data between GSelector library databases, you must  create one (or more) new GSelector databases. To do this:

  1. In GSelector, select Tools from the GSelector menu.
  2. Select the Administration...  option, and log in.
  3. Though step 4 creates an emergency recovery backup, many users choose to take a regular backup as well.
  4. From the Administration window menu, select the Restore Empty Database option. This backs up the current database automatically (to the Oops directory ), and creates a new, empty database.
  5. License this database in the usual way.
  6. Then follow the steps listed below.
  7. When you reach the Database Settings window, specify the Server and Database Name to create the GSelector information in the new database, on the specified  server.
  8. If the Selector databases use different ID formats - for example Numeric or Alphanumeric - you may need to adjust settings in your source Selector database, or in the target GSelector database.

 

Category Groups, Category Assignment and Priority Lists

GSelector uses Category Groups which can have as many Categories as you want. Selector 12 allows up to three Levels per Category; Selector 15 up to nine. So this window offers you the option to reassign your old Selector levels to existing or new GSelector Category Groups. In many cases, however, you won't need to change your existing Selector structure; the import process will simply convert this to GSelector Category Groups and Categories.

The final decision is to select a Priority list. We suggest you select a list associated with a major Gold or Recurrent category. If you do need to change things, follow the instructions below.

TIP: GSelector uses a very different method of prioritizing rules: Dayparts handle Policy Assignments, and you have complete flexibility in adjusting demand in every daypart.

Features in the Category Groups/Category Assignment window

Working in the Category Groups/Category Assignment window

Click any area in this image for help

Click any area in this image for help

 

Features in the Category Groups/Category Assignment window

Group Name list

Pass Order list

Priorities selection field

Add Category Group button

Move buttons

Delete button

 

Group Name list  

In GSelector, Songs are organized into Categories, and Categories into Category Groups, which can hold as many Categories as you want.   

The import process assigns the old Selector Categories to GSelector Category Groups, and the old Selector Category Levels into Categories within those Groups. The window shows how your Selector Category structure will be converted into the GSelector Category Group structure. Click any Category Group node to view all Categories assigned to that Category Group.

In many cases, you will not need to edit the structure. However, where you call for a Selector Category Level Clock position (see the 9/1, 9/2 and 9/3 Groups shown in the list in the image), the GSelector Import wizard treats these Category Levels as single-Category Groups. This allows your Clock Structures to be precisely duplicated, with GSelector Category Groups clock positions taking the place of Selector Category and Category Level clock positions in all cases.

NOTE: You can view the content of each Group, and reassign Categories to different or new Category Groups. However, if your Selector Clocks have Category Level positions, you might have to edit your GSelector Clocks after conversion if you reassign your Selector Categories and Levels. If you do not explicitly call for Category Level Clock positions, this is not an issue.

Order list   

The Order list for Category Groups is taken from your Selector 12/15 Pass Orders, and is copied to the Category Group Importance window. You can edit the order by using the move Up and Down buttons.

Priorities selection field  

GSelector does not use separate Priority Lists, as does Selector. In this window, we ask you to pick the Selector Priority list that you feel is most representative of the type of control you want, and the GSelector import process will do the rest. Many users select a Selector Priority List that is associated to a high pass order Category, where their most important rules are assigned.

Editing pane    

This pane is used to move Categories between Groups, or to 'park' Categories that won't be imported; parked Categories do not copy across to GSelector during the import process.   

Category Move buttons

Click to move a Category from its original group to the Category Group Edit pane, and to reassign this Category to a different group. See the notes on reassigning Categories in this topic for full details.

Add Category Group button   

Click this button to create a new Category Group.

Move Up or Down buttons

Select a Category Group and click the Up or Down move buttons to change that Category Group's priority.  

Delete button

Click this button to delete a selected Category Group. You cannot delete a Category Group with assigned Categories; they have to be moved to the Edit pane first.

 

Working in the Category Groups/Category Assignment window

Viewing Category Group Content

Reassigning a Category

Creating a Category Group

Changing a Category Group's priority

The Process described

 

Viewing Category Group content

  1. Select a Category Group in the left hand Category Groups pane.
  2. Click the node to expand the Category Group.
  3. All Categories in this Group are displayed. They can then be moved to the edit pane for reassigning or parking

Reassigning a Category to a different Category Group
  1. Select a Category Group in the left hand Category Groups pane.
  2. Expand the node to view all Categories.
  3. Select a Category.
  4. Click the right-pointing Category Move button.
  5. The Category is displayed in the Edit Pane.
  6. Select or Create a Category Group.
  7. Select the Category in the Edit pane.
  8. Click the left-pointing Category Move button.
  9. The Category is reassigned to its new Category Group.

Creating a Category Group
  1. Click the add Button to open the New Category Group window.

  1. Enter a name for the Category Group and Click OK.
  2. The new Category Group is displayed in the Category Group list.
  3. You can assign categories to the new Group, and change the priority.  

Changing a Category Group's priority
  1. Select a Category Group.
  2. Click the Move Up and Down buttons to move the Category Group to a new priority. This information is copied to the Category Group Importance window in GSelector.  

The Process described
  1. Decide if you want to modify your Category Group structure from the default display shown.
  2. Optionally reassign one or more Categories to Category Groups.
  3. Optionally create one or more new Category Groups.
  4. Optionally delete Category Groups if required.
  5. Optionally change the Category Group priorities.
  6. Finally, click the OK button to start the import process.

 

Progress Report

Once the import process is complete, a copy status box is displayed. This will show any discrepancies in the source Selector database. This data will not have been coped across to the new GSelector station. In the unfortunate event of the window displaying a huge list of discrepancies - none of which will have been copied over - then the best option is to delete the station in GSelector, and start again. You should re-enter the Selector database, correct all discrepancies and start over. If, as here, there are a small number of inaccuracies, you also have the option to research these in the Selector database, and then enter the songs manually in GSelector.  

 

Can I start over?

Once the import process is complete, launch GSelector and schedule a few days. Then look (and listen) to the results. You may wish, after a few days, to make one or two adjustments. If so, the Getting Started with GSelector and Key processes notes are a good place to start.  

However, if you find that the conversion options you selected really aren't what you wanted, you can always start again from scratch.

  1. In GSelector, select the Stations Menu option.
  2. Click the close option.
  3. This will close the station you have been working in and return you to the GSelector launch window
  4. Now select the Tools menu option
  5. Select the Administration... option, and log in.
  6. Then go to the Stations window
  7. Select the station you have just created, and delete it.
  8. Now you can launch the Import wizard afresh.