logo

Live Production Software Forums


Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Pumpkin  
#1 Posted : Wednesday, March 22, 2023 7:02:23 PM(UTC)
Pumpkin

Rank: Newbie

Groups: Registered
Joined: 3/22/2023(UTC)
Posts: 5
Korea, Republic Of

Thanks: 3 times
Hello,

I have some trouble with my streaming setup.
So basically I stream car racing video games. I have a few overlays that display informations about the game.
I would like to sum up all those info into an Excel file, and then use the vMix UTC to select the appropriate info.

So far, I managed to put the Excel file into vMix on the Data Sources.

On the vMix UTC, I managed to put a button to select the next row of data, it works well. But I would like to have an actual clickable list to choose from.

For example, I have a car info overlay, I want to be able to have a list in vMix UTC with all the car models, and I just click on which ever car is on the screen right now. I do realize I can create lists manually, but I would like the list to be liked to the excel file, because there is a lot of data to enter. Also, I would like the list in vMix UTC to automatically update when the info is changed in the Excel file.

Is this possible at all ?

Thank you very much !
doggy  
#2 Posted : Wednesday, March 22, 2023 7:32:37 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,124
Belgium
Location: Belgium

Thanks: 285 times
Was thanked: 928 time(s) in 767 post(s)
Originally Posted by: Pumpkin Go to Quoted Post
Hello,


So far, I managed to put the Excel file into vMix on the Data Sources.

But I would like to have an actual clickable list to choose from.



What is wrong with clicking on a row of the (open) datasource window ?
Pumpkin  
#3 Posted : Wednesday, March 22, 2023 7:58:27 PM(UTC)
Pumpkin

Rank: Newbie

Groups: Registered
Joined: 3/22/2023(UTC)
Posts: 5
Korea, Republic Of

Thanks: 3 times
Originally Posted by: doggy Go to Quoted Post
Originally Posted by: Pumpkin Go to Quoted Post
Hello,


So far, I managed to put the Excel file into vMix on the Data Sources.

But I would like to have an actual clickable list to choose from.



What is wrong with clicking on a row of the (open) datasource window ?


I installed the vMix UTC on an other computer, so it would be operated by someone else (and not from the vMix computer).
doggy  
#4 Posted : Wednesday, March 22, 2023 8:07:28 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,124
Belgium
Location: Belgium

Thanks: 285 times
Was thanked: 928 time(s) in 767 post(s)
Originally Posted by: Pumpkin Go to Quoted Post
Originally Posted by: doggy Go to Quoted Post
Originally Posted by: Pumpkin Go to Quoted Post
Hello,


So far, I managed to put the Excel file into vMix on the Data Sources.

But I would like to have an actual clickable list to choose from.



What is wrong with clicking on a row of the (open) datasource window ?


I installed the vMix UTC on an other computer, so it would be operated by someone else (and not from the vMix computer).


OK makes sense
We create/use small custom userfriendly apps (.net) to have a display of a selectable datasource sending the info through httprequests to the production machine
thanks 1 user thanked doggy for this useful post.
Pumpkin on 3/23/2023(UTC)
dmwkr  
#5 Posted : Wednesday, March 22, 2023 9:25:59 PM(UTC)
dmwkr

Rank: Advanced Member

Groups: Registered
Joined: 2/23/2019(UTC)
Posts: 524

Thanks: 62 times
Was thanked: 122 time(s) in 111 post(s)
To make it work in UTC, you would have to add the Excel file as External Data in UTC itself and use it as a Data Source on a List widget.
thanks 1 user thanked dmwkr for this useful post.
Pumpkin on 3/23/2023(UTC)
Pumpkin  
#6 Posted : Thursday, March 23, 2023 1:19:42 PM(UTC)
Pumpkin

Rank: Newbie

Groups: Registered
Joined: 3/22/2023(UTC)
Posts: 5
Korea, Republic Of

Thanks: 3 times
Originally Posted by: dmwkr Go to Quoted Post
To make it work in UTC, you would have to add the Excel file as External Data in UTC itself and use it as a Data Source on a List widget.


Thanks !
So I've done that, it works ! But, when I modify the Excel document and save it, UTC crashes and I have to re-open it. So yeah, I have to be careful of that if I need to change the information during the stream.

Also, the Excel widget in UTC doesn't seem to support different sheets on the same Excel file ? It just loads the first one. So I would have to make new Excel files with each sheet of info.
EDIT : Oh actually I saw that you can choose the sheet with the "Sheet number" thing, so it's perfect ! Thank again !
Pumpkin  
#7 Posted : Thursday, March 23, 2023 1:21:43 PM(UTC)
Pumpkin

Rank: Newbie

Groups: Registered
Joined: 3/22/2023(UTC)
Posts: 5
Korea, Republic Of

Thanks: 3 times
Originally Posted by: doggy Go to Quoted Post
Originally Posted by: Pumpkin Go to Quoted Post
Originally Posted by: doggy Go to Quoted Post
Originally Posted by: Pumpkin Go to Quoted Post
Hello,


So far, I managed to put the Excel file into vMix on the Data Sources.

But I would like to have an actual clickable list to choose from.



What is wrong with clicking on a row of the (open) datasource window ?


I installed the vMix UTC on an other computer, so it would be operated by someone else (and not from the vMix computer).


OK makes sense
We create/use small custom userfriendly apps (.net) to have a display of a selectable datasource sending the info through httprequests to the production machine



I see, do you have some examples of the apps you use ?
doggy  
#8 Posted : Thursday, March 23, 2023 8:28:23 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,124
Belgium
Location: Belgium

Thanks: 285 times
Was thanked: 928 time(s) in 767 post(s)
Originally Posted by: Pumpkin Go to Quoted Post

I see, do you have some examples of the apps you use ?


sorry not really (privacy)

But the basic is simple; creating window form (vb.net for example) that contains Datagridviews of your datasource responding to a roww selection sending that data to a vmix title

Google for vb.net and datagridview for simple examples
JAIRODJ  
#9 Posted : Friday, March 24, 2023 11:40:09 AM(UTC)
JAIRODJ

Rank: Advanced Member

Groups: Registered
Joined: 9/1/2015(UTC)
Posts: 126
Man
Location: Ecuador

Thanks: 2 times
Was thanked: 16 time(s) in 12 post(s)
excel con vMix

thanks 1 user thanked JAIRODJ for this useful post.
Pumpkin on 3/28/2023(UTC)
Pumpkin  
#10 Posted : Tuesday, March 28, 2023 7:12:31 PM(UTC)
Pumpkin

Rank: Newbie

Groups: Registered
Joined: 3/22/2023(UTC)
Posts: 5
Korea, Republic Of

Thanks: 3 times
Originally Posted by: doggy Go to Quoted Post
Originally Posted by: Pumpkin Go to Quoted Post

I see, do you have some examples of the apps you use ?


sorry not really (privacy)

But the basic is simple; creating window form (vb.net for example) that contains Datagridviews of your datasource responding to a roww selection sending that data to a vmix title

Google for vb.net and datagridview for simple examples


Noted, thank you very much!
Users browsing this topic
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.