Rank: Advanced Member
Groups: Registered
Joined: 12/14/2018(UTC) Posts: 81  Was thanked: 17 time(s) in 6 post(s)
|
Hi, we are a livestreaming company, started as a one man band. Now we are mostly two man crew. Me and my wife. We mostly do ice hockey - but also all other events were our services are needed. As we grew over the past few years, so did our production. I am a self learned streamer/broadcaster with self written software for onAir graphics, switching (ATEM & vMix controllers), replays, ... I was very happy when we upgraded our gear and bought a Decklink card. It opened a new world for us. Now we are able to use fill/key outputs from vMix to ATEM. Atem will be solely hardware based switcher and vMix as a graphics source. I have made several templates for vMix XAML Lower3rds connected to CSV database. Now I have hit a brick wall, not knowing how to get XAML template to vMix and to have Table data dynamics (for team lineups/rosters). I hope some of you could point me to the right direction? Maybe you have any Template/sample to share? This is our latest broadcast of a Slovenian Ice hockey derby between Olimpija and Jesenice. Best regards grega
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,243  Location: Belgium Thanks: 294 times
Was thanked: 960 time(s) in 794 post(s)
|
you will first need to use the convert "row to columns" options in your data tables
there are quite a few posts in the forum regarding "convert row to columns"
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/14/2018(UTC) Posts: 81 Was thanked: 17 time(s) in 6 post(s)
|
I can format Database as I want... Do you mean I would need to have each teamroster on its own row and 20+ coloumns for each?
Like Team | HomePlayer | HomePlayer2 | HomePlayer3... and not like:
Team | HomePlayer1
Team | HomePlayer2
Team | HomePlayer3
?
Is there any TeamRoster/Team lineup sample availible?
Grega
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 10/10/2015(UTC) Posts: 322   Location: Siroki Brijeg Thanks: 8 times
Was thanked: 27 time(s) in 24 post(s)
|
Originally Posted by: gre2gor  I can format Database as I want... Do you mean I would need to have each teamroster on its own row and 20+ coloumns for each?
Like Team | HomePlayer | HomePlayer2 | HomePlayer3... and not like:
Team | HomePlayer1
Team | HomePlayer2
Team | HomePlayer3
?
Is there any TeamRoster/Team lineup sample availible?
Grega Hi I was doing SEHA league over Excel file, I copy-paste home teamlist in excel with stats on first sheet, on second sheet there is a guest teamlist, on third there are stats (produced from first two sheets), and on fourth and five sheet there are one row teamlist names from first and second sheet (ako hoćeš možemo i na naški :)) ) So, I just set excell to copy names from rows to columns and everything is filled automatic. Datasource in excel is reading rows so you need to do just like you said, write names of players in each column. Best regards
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,243 Location: Belgium Thanks: 294 times
Was thanked: 960 time(s) in 794 post(s)
|
Originally Posted by: gre2gor I can format Database as I want... Do you mean I would need to have each teamroster on its own row and 20+ coloumns for each?
Like Team | HomePlayer | HomePlayer2 | HomePlayer3... and not like:
Team | HomePlayer1
Team | HomePlayer2
Team | HomePlayer3
Yes in practice not really need to change the database itself as the "row to columns" option can do this for you so you can use the same file again lets say for individual player details in a standard title just assign the data to the appropriate fields in the xaml title FYI if you name the title fields the same as the column headers you can automate the settings of the fields in your title https://forums.vmix.com/posts/m56583-Data-Sources#post56583
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/14/2018(UTC) Posts: 81 Was thanked: 17 time(s) in 6 post(s)
|
So basically I need to create a Textblock for every Player and place it on the background? So every Player position is fixed? If you look at what I am doing now with Powershell you can see I justify the display of the Players to fill up the screen. With fixing the positions in XAML file there will be a noticeable difference between Team A and Team B. Now I am creating this PNG files trough Powershell script and .Net Libraries. I count all the players in a team and I am able to set line height to fill up the space. If I need to fix a spot for every Player to have its own TextBlock in MS Blend and XAML I will try to make something. I will post the result. I also notice a decreased performance in vMix using gradients and effects (drop-shadow, alpha). Is there anything to optimize it? The production that we make is covered by 2-3 people. I do switching, main camera, closeup camera on top of the main camera, graphics, replays, sound and stream monitoring. My wife usually takes care of the scoreboard & clock. If our son is available to help, then he overtakes scoreboard and my wife goes by the ice rink boards with wireless camera on gimbal. She provides shots to switch to in the intermissions and mid/post game interviews. Now when we bought a Decklink card I am on a mission to convert our PNG workflow in ATEM to more sophisticated graphics with vMix. This needs to be automated and controlled from my main Powershell script. I already did the goal scorer, penalties for Lower3rds which are great. Data is coming from live database (online scoring from the venue). Fully automated replay system with vMix graphics. I just push two buttons on my MIDI device, wait replays to end and I have this file to upload. You can see Team Roster on start (static PNG file) and animated Lower3rds from vMix. Replays and all graphics are automatically mixed in. vMix Lower3rds are from a database (controlled trough vMix WEB API) P.S. Široki: Zdravo Široki - mogli bi i po "našem" ;) kad sam več biu rođen u Yugi ali onda drugi ne razumije šta mi pišemo... Grega
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,243 Location: Belgium Thanks: 294 times
Was thanked: 960 time(s) in 794 post(s)
|
Quote:
I also notice a decreased performance in vMix using gradients and effects (drop-shadow, alpha). Is there anything to optimize it?
yes is best to not use to much drop-shadows especially with text
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
