Command Line Support for Spectrum Importer

Overview:

Spectrum CMD is a stand-alone, command line driven implementation of the Spectrum Importer. Spectrum CMD can be used to schedule Spectrum Importer processing of existing Spectrum Importer profiles using the task scheduler or batch files with minimal to no user input or interaction. Procedural and process logs are created and maintained to track and audit the results.

SpectrumCMD.EXE is a separate program from the main vMedia software, but relies on the existing vMedia configuration to process files.

Deployment Prerequisites:

The computer upon which SpectrumCMD is run must be configured for vMedia. Even though SpectrumCMD can be run unattended, the account and login environment must be able to support vMedia (mapped drives as needed, rights to remote servers, rights to SQL Server, etc.)

The user account used to run SpectrumCMD must be an authorized vMedia user at the POWER USER tier or above.

A Spectrum Importer profile must be created using the Spectrum Importer in the vMedia Import module. It is advisable to use the regular Spectrum Importer to set all of the import options as needed and then save a named profile to be used with SpectrumCMD.

SpectrumCMD utilizes the Spectrum Importer engine. As such, the same database requirements for use apply, namely that the target vMedia database must be configured to use the vMedia SQL-based backend.

Usage Instructions

• Note: If any field has embedded spaces, it must be quoted.

• If a parameter should be skipped (remain at the default) a period can be used as a placeholder.

• The DB Prefix is the first 6 characters of the database CF table or DSN file name. (e.g. CLS000),

• A path can be prepended if the database is not located in the vMedia Main directory.

Ex. SpectrumCMD "User1" Import_Spectrum.ini CLS086

SpectrumCMD Defaults:

{Import Profile Name} Profile Name="Default"

{INI File Containing Profile} INI File= Import_Spectrum.INI is located in the vMedia home folder. (same as the UI-based SI uses)

{DB Prefix to Import into 6-char} DB= Default vMedia database as configured for this machine ID

Useful Debugging (Set in the vMedia INI file under the Station Group)

SICMD-DebugMode=1 (automatically un-hides the processing UI screen and leaves the UI running during and at the completion of the import until closed by the user.)

SICMD-DebugLog=FQFN of log file to append/create (provides logging of configuration and startup errors that occur prior to the time the exporter begins processing files.) Once file processing begins, a separate processing log defined in the profile contains processing exceptions and individual run statistics (same as in the SI UI Based Import).