Rank: Newbie
Groups: Registered
Joined: 3/22/2023(UTC) Posts: 5 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 !
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,220 Location: Belgium Thanks: 291 times Was thanked: 953 time(s) in 788 post(s)
|
Originally Posted by: Pumpkin 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 ?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/22/2023(UTC) Posts: 5 Thanks: 3 times
|
Originally Posted by: doggy Originally Posted by: Pumpkin 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).
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,220 Location: Belgium Thanks: 291 times Was thanked: 953 time(s) in 788 post(s)
|
Originally Posted by: Pumpkin Originally Posted by: doggy Originally Posted by: Pumpkin 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
|
1 user thanked doggy for this useful post.
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/23/2019(UTC) Posts: 552
Thanks: 62 times Was thanked: 128 time(s) in 117 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.
|
1 user thanked dmwkr for this useful post.
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/22/2023(UTC) Posts: 5 Thanks: 3 times
|
Originally Posted by: dmwkr 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 !
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/22/2023(UTC) Posts: 5 Thanks: 3 times
|
Originally Posted by: doggy Originally Posted by: Pumpkin Originally Posted by: doggy Originally Posted by: Pumpkin 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 ?
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,220 Location: Belgium Thanks: 291 times Was thanked: 953 time(s) in 788 post(s)
|
Originally Posted by: Pumpkin 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
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 9/1/2015(UTC) Posts: 126 Location: Ecuador Thanks: 2 times Was thanked: 16 time(s) in 12 post(s)
|
|
1 user thanked JAIRODJ for this useful post.
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/22/2023(UTC) Posts: 5 Thanks: 3 times
|
Originally Posted by: doggy Originally Posted by: Pumpkin 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!
|
|
|
|
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