Post Match - From BarTV

From BarTV – Post Match

Requirements

• Video – Innings for one day cricket, session for multi-day cricket
• Time (in seconds) that first delivery happened in video
• CSV of one delivery (event) per line with the following columns (can have additional cols)
  • seconds – the number of seconds after the first event that the event happened
  • clip_length – how long the output clip for that delivery will go for
  • video_output_filename – filename (excluding extension) of the video to output for that delivery. For Analyzer, format to match 5461061A100101
  • delivery_text – free text field that is typically used to help identify what should be in the clip

Process

• Run Video Cricket Reviewer.exe (new version released on Company Portal) 
  
• Select the relevant video file and CSV file
• Enter the number of seconds into the video that the first event happens. If the first delivery is at 10:53, enter 653
• Click Load Files, and first clip should play 
  
• Move the clip forward and back using the left and right arrows, then space to start playing the clip again
• Clip length can be adjusted with the buttons
• Use up and down to move between clips
• Once happy with them all, click split and enter the folder name to start cutting 
  

Queries

• TEMPLATE QUERY FOR ONE INNINGS AT A TIME
• TEMPLATE QUERY FOR ONE SESSION/DAY AT A TIME
• Change the matchid, plus specs for day + session (multi day), or innings (one day)
• Change the ‘seconds’ column to reflect the best time stamp for your match – coded (video_start_time_local), Hawkeye/Virtualeye/Cricviz (third_party_date_time_utc_0)  
  
• Query uses a subquery to get the first ball time for the session/innings, and then comparing each ball time to that. Ball 1 should be 0 seconds, and following from there 
  
• You can manipulate the query to get what you want – if you want more run up included, subtract from the start time of each clip and add length

Summary Video