Excel worksheets offer a familiar format in which to define your switching system. By converting Excel worksheets to Switch Executive, you can quickly construct a complex switch configuration using an Excel template. The template may contain data that is new or sourced from your existing Excel files. After converting, you can manage the switch configuration like any other configuration within Switch Executive.By converting Excel to Switch Executive, you can:
In order to ensure that the migration is a success, use the following best practices:
Consider the migration of Excel to NISE as a step-by-step process:
Select the Devices worksheet and type in the Virtual Device Name - the name of the virtual device that will be created in Switch Executive.
Select the devices worksheet and fill in a row of data for the IVI device you wish to add to the Switch Executive virtual device.
Select the channels worksheet and fill in a row of data for each channel you wish to override (define attribute values other than the defaults) in the Switch Executive virtual device.
Repeat these steps for each channel to override its defaults. Next, select the Exclusions worksheet and fill in a row of data for each channel exclusion you wish to add to the Switch Executive virtual device.Definition: A channel exclusion is a connection rule used to prevent specific channels from connecting to one another. Exclusions are predominately used for safety purposes.
Select the Hardwires worksheet and fill in a row of data for each hardwire you wish to add to the Switch Executive virtual device.Definition: A hardwire is any physical connection between switch channels such as wiring, analog buses, matrix expansion plugs, etc. A hardwire can have any number of channels attached to it.
Repeat each step for each hardwire you wish to add. Next, select the Buses worksheet and fill in a row of data for each bus you wish to add to the Switch Executive virtual device.Definition: A bus is a collection of hardwires spanned across adjacent channels on devices. Create a bus to quickly create a group of hardwires and associate them with a single named object. Buses are particularly helpful when hardwires are used for column or row expansion in a matrix where a series of channels are connected to another series of channels.
Select the Route Groups worksheet and fill in a row of data for each route group you wish to add to the Switch Executive virtual device.Definition: A route group allows you to group individual routes (and/or other route groups) and associate them with a single named object. Use a route group to set up simultaneous switching configurations quickly. A route group also enables NI Switch Executive to make better decisions about which resources to use when creating a route. When two or more routes are added to a route group, NI Switch Executive ensures these routes do not use conflicting resources.
Repeat each step for each route group you wish to add. Next, select the Routes worksheet and fill in a row of data for each route you wish to add to the Switch Executive virtual deviceDefinition: A route is a user-defined connection from one channel (row, column, COM, NO, etc.) to another.
Repeat each step for each route you wish to add. Save the workbook.
Open the Convert Excel to NISE.xls example program in Microsoft Excel. Select the template workbook that you completed in the previous step. Import the workbook.
Open Measurement and Automation Explorer (MAX) and select the configuration. Run the "Validate" command on the virtual device.
Validating the virtual device confirms that all the driver software, routes, route groups, and hardwires/buses are acceptable in their current configuration.
Open the test panel in the virtual device. Connect a route or route group to test the virtual device.
By connecting a route, you are demonstrating that the virtual device is controlling your system the way it is intended. For NI switch hardware, you can also open the NI-Switch Soft Front Panel to verify the routes in a graphical display of the hardware.
Collaborate with other users in our discussion forums
A valid service agreement may be required, and support options vary by country.