themgineer/Ultrix-Audio-Shuffling-Generator
1
0
Fork 0
Code Issues Pull requests Projects Releases 9 Packages Wiki Activity Actions
Python script that is designed to take a list of inputs from an Ultrix router and generate audio breakout labels.
149 commits 2 branches 9 tags 757 KiB
  • Python 100%
Find a file
Exact
Anthony Thompson 9e7bcbd8d8
 Added check to see if next source in Guess End ID is a disconnect
2025-09-26 21:45:09 -04:00
Icons moved to expected location 2025-06-26 17:23:09 -05:00
readme_resources updated screenshot with new UI options 2025-07-03 18:06:44 -05:00
Sample Data Included samples for both Ultrix and Ultrix Acuity databases 2025-07-03 17:09:01 -05:00
UI updated UI to include new features 2025-07-03 17:09:32 -05:00
.gitignore ignore testing folder 2025-07-03 17:09:40 -05:00
audio_shuffling_generator.py Added check to see if next source in Guess End ID is a disconnect 2025-09-26 21:45:09 -04:00
icons_rc.py moved to expected location 2025-06-26 17:23:09 -05:00
LICENSE Updated copyright to 2025 2025-02-10 00:57:58 -08:00
pyInstaller.md added newline to end of file 2025-07-03 18:44:21 -05:00
README.md included description of menu options 2025-07-14 14:40:35 -05:00
requirements.txt updated to include pyinstaller 2025-06-26 17:12:25 -05:00

README.md

Audio Shuffling Generator for Ultrix Database

This is a small application that will take an Excel export from Ross Video Ultrix or Ultricore BCS Sources tables and append audio shuffling sources.

The GUI interface is pretty straightforward. It asks for a source file, an ending index number, a number of audio channels, how you want your audio grouped, and an output filename. Once all of those are provided, just hit the Shuffle button and it should generate an Excel file that can be directly imported back into the Sources table in Dashboard.

Screenshot of the interface.

Operation

  1. Use the Source File field to enter or Browse to the file path of an Excel file that contains the data you wish to use. This should be a direct export from the Sources page for the Ultrix or BCS in Dashboard.
  2. If you wish to start at a source other than the first source, enable the Start ID checkbox and enter the number from the ID column of the source you want to start using to generate audio sources. The status bar at the bottom will tell you the source name associated with that index number.
  3. Choose the last source by entering the End ID value of the last source you want to use to generate audio sources. The status bar at the bottom will tell you the source name associated with that index number.
  4. By default, audio shuffling will be generated with 16 channels of audio. If you would like to change that, use the Channels dropdown and choose the number of audio levels in your database (2, 4, 8, or 16).
  5. By default, audio shuffling with use each channel as a discrete mono audio channel. If you would like to group channels, use the Grouping dropdown and choose how you want the audio channels grouped (Mono, Stereo, Quad, or Octo)
  6. Enable the Leading Zeroes checkbox if you want channel numbers 1-9 to be displayed with a leading zero (01-09)
  7. The Output File field will automatically update based on the file name defined earlier in Source File. You can also manually enter or Browse to the file you wish the output to save as. If the chosen file already exists, it will be overwritten. If the chosen file does not exist, it will be created.
  8. Press the Shuffle button to generate the output Excel file at the path defined in Output File.

Menus

  • File
    • Open: Opens a source file
    • Shuffle: Functions the same as clicking the Shuffle button
    • Quit: Exits the application
  • Options
    • Guess End ID: Attempts to find the most logical End ID based on either naming or audio levels
    • Move Disconnect: If there is a Disconnect source in your sources table, it will attempt to move the source to the bottom of the table after creating the shuffling sources.
  • View:
    • Light: Sets the interface to light mode, regardless of OS setting
    • Dark: Sets the interface to dark mode, regardless of OS setting
    • System: Follows the mode set in the operating system

Input Data Structure

The source file is intended to be an Excel file exported from the Sources table of a Ross Video Ultrix or Ultricore BCS. The application expects a sources worksheet and the internal data to follow the form generated by the export.