vMix Forums
»
General
»
General Discussion
»
Datasources and values used in variables
Rank: Advanced Member
Groups: Registered
Joined: 8/5/2017(UTC) Posts: 135 Location: UK
Thanks: 15 times Was thanked: 11 time(s) in 9 post(s)
|
Just looking into a way to integrate more automation into my live production. I'm looking for a way to use a google sheet to fire a number of different actions, not just titles. EG, select row, populate lower third, play/load video or web page, fire off a url to post a link to a discord channel with a link to the current topic so that it gets posted in the timed comments using Restream chat bot etc.
As far as I can see the values returned from datasources can only be accessed from Titles inputs. Would be SO useful to be able to push them into other actions too....
Am I dreaming or just going to have to get into some scripting stuff. Not sure I have enough brain left to learn another programming language.;-)
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,186 Location: Belgium Thanks: 288 times Was thanked: 946 time(s) in 781 post(s)
|
Originally Posted by: nowski As far as I can see the values returned from datasources can only be accessed from Titles inputs. Would be SO useful to be able to push them into other actions too....
Afraid you are going to have to resort to scripting Titles are often used as a variable container fed by a data source , they are just not visibly shown in the title display. pulled from the the title (easy) you can use them to your liking in a script from simple to complex Using external coded apps does n0t limit you to the vMix scripting language of vb.net and can send actions to vMix too.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/5/2017(UTC) Posts: 135 Location: UK
Thanks: 15 times Was thanked: 11 time(s) in 9 post(s)
|
Thanks for the help!
Are there any resoucres or examples where datasources are used in this way?I guess its not "the usual"method so searches have been fruitless so far.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,186 Location: Belgium Thanks: 288 times Was thanked: 946 time(s) in 781 post(s)
|
|
1 user thanked doggy for this useful post.
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 6/16/2020(UTC) Posts: 75 Thanks: 8 times Was thanked: 2 time(s) in 2 post(s)
|
Excuse me that it may not be on the subject, but from what you wrote, I could consult a possibility, having a spreadsheet in google activate a command to vmix ?, in google spreadsheets can be programmed so that when a change in a specific cell a command is sent? I understand that it is programmed in phyton it seems to me, is that possible doggy friend translated from spanish to english by google
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/5/2017(UTC) Posts: 135 Location: UK
Thanks: 15 times Was thanked: 11 time(s) in 9 post(s)
|
Doggy, thanks Scripting is easier than it seems, certainly for simple tasks. Was easy to pull values into a titles input then turn them into DynamicValues - I was able to open browser window with URL from datasource using the first example from your links
Papo - thats in interesting idea also run the show from a Google sheet, but worth thinking about the possibilities .What I want to do it select a topic, have it fire a video or URL, then post the link to the chat - Youtube preferable, but I will need to figure out how to turn my URL into a Youtube comment post via the API I think
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 4/23/2017(UTC) Posts: 1,186 Location: Germany Thanks: 3 times Was thanked: 167 time(s) in 149 post(s)
|
@nowski: You can use a QR code in the video to target your audiance to a link or reference. Just as an option.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/5/2017(UTC) Posts: 135 Location: UK
Thanks: 15 times Was thanked: 11 time(s) in 9 post(s)
|
Thanks Mavik, what I'm trying to get to is have 8 topics buttons. Each time I press one, I get either the web page or the video playing (yet to figure this - but using a datasource with a switch value will be part of it I think), a lower third - easy. And to post the link to the Youtube or Restream chat automatically.
The 8 topics are taken from a show spreadsheet, each with a link, and or a video, a switch to indicate whether to open a browser or play a video.
For a one man production this will save quite a lot of time and enable the show to be self contained so easy to run locally or from a cloud instance.
N
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/5/2017(UTC) Posts: 135 Location: UK
Thanks: 15 times Was thanked: 11 time(s) in 9 post(s)
|
Ok so now I'm in the realms of meta scripting - eg: I use scripts to pull variables from a datasource - check that works fine.
Now I'm finding I want to create dynamic scripts from these variables which would be API.Function("ScriptStartDynamic",Value:="newscript goes here that is a mix of strings and variables")
Is that even possible?
If so, how would I build the string to send from a mix of text and variables created from the datasource to send to the ScriptStartDynamic API call?
Nick
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,186 Location: Belgium Thanks: 288 times Was thanked: 946 time(s) in 781 post(s)
|
Originally Posted by: nowski how would I build the string to send from a mix of text and variables ?
https://www.dotnetperls.com/string-concat-vbnetAdditionally Code:Dim value1 As String = "Visual"
Dim value3 as string = value1 + "Basic"
Console.WriteLine(value3)
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/5/2017(UTC) Posts: 135 Location: UK
Thanks: 15 times Was thanked: 11 time(s) in 9 post(s)
|
Excellent, thanks Doggy,
Is this a wise/acceptable method for creating dynamic scripts? I want to be able to make the vmix doc portable. Also, I cant see a way to create shortcuts via API. Was thinking that I could build those from the number of topics. Eg set SetShortcut, value=Function, trigger=MIDI note or whatever But I'm not sure that is possible?
Nick
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,186 Location: Belgium Thanks: 288 times Was thanked: 946 time(s) in 781 post(s)
|
Originally Posted by: nowski Also, I cant see a way to create shortcuts via API. Was thinking that I could build those from the number of topics. Eg set SetShortcut, value=Function, trigger=MIDI note or whatever But I'm not sure that is possible?
Is there one in this list ? https://www.vmix.com/hel...utFunctionReference.html
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
Datasources and values used in variables
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