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
nowski  
#1 Posted : Wednesday, September 8, 2021 8:23:29 AM(UTC)
nowski

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.;-)
doggy  
#2 Posted : Wednesday, September 8, 2021 4:50:29 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 288 times
Was thanked: 946 time(s) in 781 post(s)
Originally Posted by: nowski Go to Quoted Post

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.
nowski  
#3 Posted : Wednesday, September 8, 2021 10:20:52 PM(UTC)
nowski

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.
doggy  
#4 Posted : Wednesday, September 8, 2021 11:29:10 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 288 times
Was thanked: 946 time(s) in 781 post(s)
Originally Posted by: nowski Go to Quoted Post
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.


https://forums.vmix.com/...ng-for-Dummies#post80860

https://forums.vmix.com/...-color-change-using-data
thanks 1 user thanked doggy for this useful post.
nowski on 9/9/2021(UTC)
Papo  
#5 Posted : Thursday, September 9, 2021 5:36:17 AM(UTC)
Papo

Rank: Advanced Member

Groups: Registered
Joined: 6/16/2020(UTC)
Posts: 75
Peru

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
nowski  
#6 Posted : Thursday, September 9, 2021 10:59:30 PM(UTC)
nowski

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
mavik  
#7 Posted : Friday, September 10, 2021 11:40:48 PM(UTC)
mavik

Rank: Advanced Member

Groups: Registered
Joined: 4/23/2017(UTC)
Posts: 1,186
Man
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.
nowski  
#8 Posted : Monday, September 13, 2021 6:18:04 PM(UTC)
nowski

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
nowski  
#9 Posted : Tuesday, September 14, 2021 1:18:39 AM(UTC)
nowski

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
doggy  
#10 Posted : Tuesday, September 14, 2021 2:06:36 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 288 times
Was thanked: 946 time(s) in 781 post(s)
Originally Posted by: nowski Go to Quoted Post
how would I build the string to send from a mix of text and variables ?



https://www.dotnetperls.com/string-concat-vbnet

Additionally

Code:
Dim value1 As String = "Visual"
Dim value3 as string = value1 + "Basic"
Console.WriteLine(value3)
nowski  
#11 Posted : Tuesday, September 14, 2021 8:11:19 AM(UTC)
nowski

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
doggy  
#12 Posted : Tuesday, September 14, 2021 8:22:47 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 288 times
Was thanked: 946 time(s) in 781 post(s)
Originally Posted by: nowski Go to Quoted Post
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
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.