logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Using Excel data with vMix UTC - Need help with some Excel link
Options
Go to last post Go to first unread
Previous Topic Next Topic
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 !
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
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,202
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 953 time(s) in 788 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 ?
Back to top
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).
Back to top
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,202
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 953 time(s) in 788 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
Back to top
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: 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.
Back to top
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 !
Back to top
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 ?
Back to top
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,202
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 953 time(s) in 788 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
Back to top
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
Back to top
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!
Back to top
Users browsing this topic
Guest
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.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.156 seconds.