800.885.8886 sales@telvue.com
  • Facebook
  • Twitter
  • Facebook
  • Twitter
TelVue
  • Home
  • Products
    • Playback & Automation
      • HyperCaster®
      • ProVue®
        • ProVue® HD
        • ProVue® GFX
        • ProVue® CC
      • TelVue TeleCastTM 2
    • Streaming/Cloud
      • TelVue CloudCast™
      • TelVue Connect™
      • Media Exchange
      • Mobile & OTT Apps
      • TelVue SmartCaption™
    • Digital Signage
      • TelVue InfoVue™
    • Automatic Captioning
      • SmartCaption™
    • Ad Insertion
      • TelVue AdCaster™
  • Solutions
    • Cable/Telco
    • Community Media
    • Media Companies
  • Support
    • Knowledge Base
    • Webinars
    • Training Videos
    • Documentation
    • Contact Support
  • News
    • Blog
    • Press
    • Awards
  • Client Logins
    • Connect/CloudCast
    • InfoVue
  • Contact Us
    • General & Sales
    • Technical Support
Select Page

HyperCaster

HyperCaster User Manual
    HyperCaster Configuration
    • Config Tab
    • Channel Setup
    • Continuity
    • Live Streams
    • Feed Setup
    • NDI Access Manager
    • ProVue Decoder Configuration
    • Configure In/Out Ports
    • Encode Profiles
    • Manage TeleCasts
    • Streaming Destinations
    • Streaming Rules
    • User Management
    • Content Settings
    • Pro Transcoding
    • Schedule Configuration
    • InfoVue XML
    • Switch Configuration
    • Remote Server Configuration
    • TelVue Connect Configuration
    • Captioning Configuration
    • Server Management
    • NTP, NTP Configuration, and NTP Health
    • Security Configuration
    • Network and Security
    • Setting up SSL/HTTPS on the HyperCaster
    • Backup Settings
    • IPMI
    • Config – Utilities
    • Version and Configuration
    • SNMP Support
    • External Devices
    • Brightcove EPG Integration
    • Add an RTMP Stream
    • Set Up an RTMP Stream in a HyperCaster
    • Set Up an SRT Stream in a HyperCaster
    • Set Up an HLS Stream in a HyperCaster
    • Get Channel Schedule as XML (Detailed)
    HyperCaster Content Management
    • Organize and Add Content
    • Content Management
    • Thumbnail and Table Views
    • Show Content Page
    • Content File Actions
    • Add TBD Program
    • DVD Import
    • Replacement Files Hot Folder
    • How to Trim a Video File (Virtual Trimming)
    • Trim Content (Built-in, Multiple Trim Editing)
    • Tasks
    • Previews
    • Turn On Transcoding
    • Create a HyperCaster Playlist
    • Series & Series Scheduling
    • Record or Capture
    • Upload to Connect/CloudCast
    • Archiving
    • Archive.org integration
    • Content Workflow Rules
    • Preparing Content for the HyperCaster
    • Content RSS Feed
    • Export to CSV
    • Searching
    • Using Third-Party Editing Software
    HyperCaster Programming
    • The Dashboard
    • Programming
    • Calendar View
    • Classic View
    • Search Filters and Event Functions
    • Field Descriptions and Display Options
    • Program Playout Event
    • Program Stream Event
    • Program Record Event
    • Program Input Event (AIO Only)
    • Input Locking
    • Program Switch Event
    • Scheduling a Live Switch Event whose Actual Duration Varies
    • Program Playlist Event
    • Program Overlay Event
    • Program Slide Event
    • Program Ad Trigger Event
    • Unschedule an Event
    • Event Actions
    • Copy Program Blocks
    • Import and Export events
    • Native CSV Formatting
    • Scheduling Conflicts and Ripple
    • Recurring Events
    • Controlling What Appears in the Program Guide
    • Publishing Your Schedule
    • Schedule Ads
    HyperCaster Graphics
    • Graphic Overlays
    • Overlay Rules
    • Bugs
    • Tickers
    • How to Build RSS Tickers
    • Snipes
    • Clocks
    • Program Guides
    • Emergency Notification Console
    • Join in Progress Overlay
    HyperCaster Reports
    • Reports Tab
    • As Run Reports
    • Program Guide Report
    • Missing File Report
    • TelVue Connect Report
    HyperCaster Captioning
    • SmartCaption™ Automatic Captioning Integration
    HyperCaster Streaming
    • Configure In/Out Ports
    • Streaming Destinations
    • Encode Profiles
    • Manage TeleCasts
    • Streaming Rules
    HyperCaster Miscellaneous
    • System Health
    • Backups
    • Safety Requirements
    • Glossary
    HyperCaster Guide to CCMS Plus
    • Guide to CCMS Plus
    • CCMS Plus Setup
    • CCMS Schedule Remote Directory Folder Structures
    • Schedule and Media Imports
    • Verification File Export
    • Tasks Tab
    • E-Mail Notifications of Missing Content
HyperCaster FAQs
  • How do I access the UI for my HyperCaster?
  • What is the difference between, “enable continuity” and “continuity resume”?
  • Port Forwarding Rules to Allow External Access to the HyperCaster
  • How to Stream a Zoom Meeting to the HyperCaster
  • Extending an IP Capture without Re-Entering Metadata
  • YouTube Live
  • How do I set InfoVue as Continuity on the HyperCaster?
  • How do I embed a HyperCaster Program Guide in my website?
  • Facebook Live
  • What does “ripple” mean?
  • Does the preview player under edit show timecode or full length of video?
  • What is the RSS feed button in the HyperCaster?
  • How to Add a TriCaster Feed to the HyperCaster
  • Mapping the HyperCaster to Your Desktop
  • How to display NOAA weather RSS as HyperCaster Ticker
  • How to Stream a WebEx Meeting to the HyperCaster
  • Is it possible to run a PowerPoint through my HyperCaster?
  • Why is my NTP server showing a critical status?
  • How to Add a LiveU Solo Feed to the HyperCaster
  • TelVue Server LED Status Indicators
  • On the Channel Setup page, what are the “Website Guide Details” checkbox and the “TV Guide Station ID”?
  • Go LIVE from anywhere with a JVC GY-HM200 and a HyperCaster
  • How do I display Program guide?
  • What is MPEG?
  • Prepare Content for HyperCaster with Sorensen Squeeze
  • Use OBS to Live Stream Skype, GoToMeeting, or any Application Window to Your HyperCaster
  • On the “Health” page, was does NTP define?
  • Preparing Content for your HyperCaster Using Telestream Episode Pro
  • Is it possible to run two channels to the same IP address with different ports?
  • Is it possible to run two Ethernet connections out of the HyperCaster? (Additional Card Required)
  • Are 16:9 files automatically letterboxed?
  • Server rooms: some practical advice
  • Is it possible to run background audio from a stream that is different than the video scheduled (ex. Radio Feed)?
  • I am having issues with the overlays. They schedule but won’t play.
  • Loss-of-Video Failover Protection with This Easy Trick
  • On the “Edit Content” page, what does the “Private” checkbox, Location and Contributor fields define?
  • When using FTP are we able to change the password for psguser?
HyperCaster APIs
    HyperCaster API Content Workflow
    • Access All Content Metadata as CSV
    • Import Content (Hot Folder)
    • Uploading Files on Schedule
    HyperCaster API Content Methods
    • Get All Content Metadata
    • Get Content Metadata by Filename (REST)
    • Get Content Metadata by ID (REST)
    • Get Content Thumbnail (REST)
    • Add Content (REST)
    • Edit Content (REST)
    • Delete Content (REST)
    • Add Content (SOAP)
    • Edit Content (SOAP)
    • Delete Content (SOAP)
    HyperCaster API Schedule Workflow
    • Access Playback (As-Run) Log
    • Import Events (Hot Folder)
    HyperCaster API Schedule Methods
    • Get Channel Next Playing (REST)
    • Get Channel Now Playing (REST)
    • Get Channel Schedule as RSS (REST)
    HyperCaster API Channel Management
    • Get Channel Settings (REST)
    HyperCaster API System Management
    • Get System Health as RSS (REST)
    • Get Software Version (REST)
    • Get Network Settings (REST)
  • Home
  • Knowledge Base
  • HyperCaster Knowledge Base
  • HyperCaster
  • HyperCaster User Manual
  • HyperCaster Programming
  • Native CSV Formatting

Native CSV Formatting

The Native CSV format can be used to import a schedule via the programming tab or by way of the import/native hot folder on the server. It may also be exported from the server via the programming tab, modified, and re-imported.

Required:

  • Output – The server channel on which the video will be played.
  • Date – Date of event in MM/DD/YYYY format.
  • Time – Time of scheduled event in HH:MM:SS format.
  • Type – Options include PLAYOUT, PLAYLIST, SWITCH, STREAM, INPUT, NDI, OVERLAY, SLIDE, ADTRIGGER, CAPTURE (recording for IP Stream sources), ENCODE (recording for SDI Input and NDI sources).
  • Source ID – The unique ID of the content that resides on the server. Null this field if you wish to use the Source Name instead.
  • Source Name – The name of the content item on the server.
  • Offset – How far from the beginning of the file you want to start playing in seconds. 0 will start from the beginning of the file.
  • Duration– The length of time you want the playout to run in seconds.

Not Required:

These columns are not necessary for simple file plays. If any other action such as overlays or switch events are used each column should be present in the below order.

  • Output Name – The channel name
  • Program Code – If program codes are used in your workflow, enter a code that distinguishes what program this is. You can search on program codes in combination with a keyword search.
  • Episode Code – If episode codes are used at your installation, enter a code that distinguishes what episode of a program series this is.You can search on episode codes in combination with a keyword search.
  • Program – If this installation does not use program codes, enter the name of the program as it should appear in the Program Guide.
  • Title– Used for overlays.
  • Episode – If this installation does not use episode codes, enter the name of the episode as it should appear in the Program Guide, if applicable.
  • Description –  Enter a detailed description of the content as well as any keywords to be used to search for this content.
  • OSD – On-Screen Display & Emergency Notifications
  • OSD Path – Path to the OSD
  • OSD File – File name of the OSD
  • Include In Guide – If you want the program guide report to display this playout.
  • Track Content Attributes – If true the schedule will use the metadata stored for this content file.
  • Program Number – Use if program is many in a series. Found in the metadata of the file.
  • Switch Command – Example of a switch from source 2 to output 1 is ” B002->001″

Tips on using Excel to help in scheduling

Excel will recognize the date column (B) and time column (C) as date and time values. But when doing any calculations on them, you want them to behave as a combined date-time (so that, for example, you properly roll over any midnight boundaries).

So in each cell you want to do a calculation (for example, the next cell’s date and time cells), you will first combine the two values – just adding them will turn them into a combined date-time object. The duration column (H) is shown in seconds, so to do math with it, use the TIME function, passing in the H column as the third value (seconds).

Thus, to calculate a start date and time exactly after the previous program ends, the formula would look like this (example here assumes current values are in row 2):

=B2+C2+TIME(0,0,H2)

This will at first give you a full date-time (5/24/2011 14:22), but use Excel’s Extract functions to extract just the date (5/24/2011) or just the time with seconds (14:22:30) to match the column types as expected. For the date, use the INT function, and for the time, use the MOD function. If we follow the example above, they would be:
For the date, =INT(B2+C2+TIME(0,0,H2))
For the time, =MOD(B2+C2+TIME(0,0,H2),1)

You will repeat the exact same formula in both the B and C column, and may have to use Excle’s formatting options to display only the date or only the time.

This way, you could create a sheet where each start date and time is calculated from the row before, and you could enter whatever you want for the duration in each row.

Remember to empty the Source ID column if it does have values, as you want the import to match on filename, which it will do if Source ID is blank.

Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on December 5, 2022
Import and Export eventsScheduling Conflicts and Ripple

PRODUCTS

  • Playback & Automation
    • HyperCaster®
    • ProVue®
      • ProVue® HD
      • ProVue® GFX
      • ProVue® CC
    • TelVue® TeleCastTM 2
  • Streaming/Cloud
    • TelVue CloudCast™
    • TelVue Connect™
    • Media Exchange
    • Mobile & OTT Apps
    • TelVue SmartCaption™
  • Digital Signage
    • TelVue InfoVue™
  • Automatic Captioning
    • SmartCaption™
  • Ad Insertion
    • AdCaster™

SUPPORT

  • Contact Support
  • Knowledge Base
  • Training Videos
  • Product Documentation

ABOUT

  • Contact Us
  • TelVue News for Hyperlocal Broadcast, PEG news, and TV Technology
  • Press Releases
  • Executive Profiles
  • Sales Team
  • Company
  • Partners

BLOG POSTS

  • FreightWaves Taps HyperCaster AIO for Flexible Ad Integration with Brightcove
  • HyperCaster Integrated Streaming & Social Streaming Automation
  • Live Dual-language Captioning, Multiple Trim Editing, and Multistreaming Automation with HyperCaster™ 8.3
  • AIO Integrated Streaming, Program Guide & Clock Overlays with HyperCaster™ 8.2
  • Channel Streaming Rights Management with HyperCaster™ 8.1
  • Facebook
  • Twitter
16000 Horizon Way, Suite 100, Mt. Laurel, NJ 08054 - TelVue Corporation ® All Rights Reserved 2020