Using OnLocation

(available in  Professional.png Enterprise.png)

 

Spectra OnLocation is designed to allow studios to take Spectra on location for image capture and order entry. While the software operates for the most part like it does in the studio, there are some special considerations for managing your OnLocation database.

User licenses

A one-user OnLocation license allows you to check out one OnLocation database and take it to a remote location. If you need to take Spectra to two different locations at once, you'll need to purchase another single user license. If you want to be able to use Spectra with multiple computers at the same remote location, then you'll want to get a multi-user OnLocation license. In order to use multiple computers at your remote site, you would need to have all of the networking hardware and the computers set up to share resources over that temporary local area network (LAN). Spectra is not networkable over the internet, so to simply have wireless Internet access on each individual computer will not work. Wireless technology is advancing all the time, but networking Spectra over a wireless network is not advised.

Networking OnLocation

Spectra OnLocation uses a Microsoft Access formatted database that can be shared just like your main Spectra data in the studio. Consult the topic on Installing Spectra on a Network for more information. It is advisable to create an independent, shared drive location on the computer you intend to act as the Spectra "server" on location for both the database and your images. To avoid confusion or overlap, you will want to use different drive mapping letters on location. While the checkout process automatically sets the data path for the checked out database on the computer that actually performs the checkout, you will have to use the Database Utility to Attach to Different Data Files on any computer that you are taking with you to share Spectra OnLocation. Similarly, you will have to reconnect the additional computers when they are back in the studio (if they are used there) using the Database Utility.

Data Files

As you may have noticed already, the Spectra database file is named SamDB.mdb (you may not see the .mdb depending on the settings in your operating system). An OnLocation database is no exception. The important difference is where the database is located. When you check in an OnLocation database, the changes are synced to your main Spectra database in the studio. Once completed, the database is renamed. It still has SamDB in it's name, but now a long number date code is added. It is advisable to perform backups on OnLocation databases before checking them back in. Just be sure to not mix up an OnLocation backup with a main studio database backup. However, the database will be preserved by renaming just in case.

Managing Check Outs

When a database is checked out through OnLocation, it is stamped with the time and date it was checked out. Both the main studio data and the OnLocation data store this information. OnLocation was designed so that you can check out an OnLocation database more than once. However, this does not mean that you have two OnLocation databases that can be checked back in. Only the last database checked out can be checked back in. The intention behind this feature is so that if the database or laptop was lost for any reason, you could still use OnLocation again by simply checking out OnLocation again. Of course, you would still lose all the data from the lost database, but this is a worst-case scenario. You will need to make sure that no one back at the studio checks out the database before you bring back your remote one and sync it back in. If you have multiple OnLocation licenses, be extra careful about which database you are checking out to each computer. It may be useful to name the OnLocation entries in the maintenance for the computer that will usually be used for that OnLocation instance and only allow that computer to check out that instance. It may also be advisable to physically mark the computer with a post-it or label as to its OnLocation status.

Portable USB Drives

While it is possible to check out a Spectra OnLocation database to a portable USB drive, it is not wise to do so. It is important that if you are using a USB device to store your Spectra database, you properly "stop" the device before removing it. Consult this article from Microsoft for more information: Safely remove devices from your computer. Failing to do so could corrupt the database. A USB drive may be more difficult to manage and may be more easily lost or stolen.

SQL Considerations

A Spectra OnLocation database can be checked out from a Spectra SQL version as a SQL Server database or as a MS Access database. If the OnLocation is checked out as an MS Access database, it is important that you remember to use the Spectra Database Utility for the checked out Access database and the SQL Server Utility when you are connected to your main studio location. The checkout process will automatically set the path for the computer doing the checkout. However, any computers that you wish to take on location need to use the Database Utility to Attach to Different Data Files to connect to the checked out OnLocation database. Note that the database needs to be stored in a shared network folder in order to use a multi-user licensed OnLocation database. Because that is not required back at the studio, this may require a special setup on the OnLocation computer. Once you return to the studio, the check-in process will reset the database connection to SQL automatically on the checkout computer, but not for any additional computers. In this case, use the SQL Server Utility to re-enter the settings for your main studio database.

Reduced Menu and Features

Spectra is designed specifically for servicing groups like churches or schools and is streamlined so not all of the regular features are available in the checked out OnLocation database. Most notably, the Hub menu at the top no longer shows Production or Dashboard. There are a number of preferences and maintenance items that cannot be set in a checked out database. In addition, there are a number of reports and other features that are not available in a checked out database.

Session Folders

Spectra has the option to create session numbers when a session is created. Because an OnLocation database could potentially assign different session numbers in a checked out database, that feature is disabled in a Spectra database that contains an OnLocation license. It may also be desirable to turn off automatic session folder creation for a database that can be used OnLocation. When you check in an OnLocation database, you will also have the option to copy session image folders at the same time. However, to prevent any possibility of overwriting images with the same name back at the studio, the OnLocation check-in process will not copy folders that already exist in the main studio. You can copy them over manually in Windows Explorer after determining that no duplicate image names are going to cause overwriting of original images.

Using Studio Images on Location

The image copy process for OnLocation is one-way and occurs during check-in. Imagine how long it would take to copy all your studio images each time you check out OnLocation. Most likely, the laptop you are using for OnLocation does not have the same storage capacity for images that you have in the studio. However, you can manually copy session image folders over to your OnLocation computer to use in a sales presentation. Note that any network resources for music or images in the studio will not be available OnLocation unless you also copy those over and reset your slideshow settings for that session while on location. Keep in mind that any changes made to images while on location will need to be manually copied over as stated above.

Credit Card Processing

Because credit card processing integration in Spectra is dependent on an Internet connection, you will need to be connected to the Internet in order to take credit cards when on location. The settings for your account are stored in the database and can be used the same way you do back in the studio. Note that you will need properly configured hardware with you to swipe cards while you are at the remote location. If there is no Internet access at your remote location, you can still create and save payments and process them later when you get connected. The 3-digit security code that is contained in a credit card swipe cannot be stored. Those transactions will need to be processed without that code later.

Updating and Upgrading

It is important that the version, volume, and release of your OnLocation check out computer matches what you have in the studio. Most likely, you will not even be allowed to open Spectra to perform the check out if it doesn't. This is important to remember for any additional computers that you take with you, especially if those computers are not actively used in the studio. You will be unable to use additional computers if they are not on the same version and release, and most likely you will not be able to run a software update while in the field. If you do have Internet access while on location, you will be able to download those updates from our website. However, it is best if you do not perform updates or upgrades in the studio while you have an OnLocation database checked out. Wait until all OnLocation databases are checked in to perform any upgrades or updates.

 


Return to top    |