vMix Forums
»
General
»
General Discussion
»
Help with Dynamic Database Setup in Vmix
Rank: Member
Groups: Registered
Joined: 3/3/2025(UTC) Posts: 24  Thanks: 2 times
|
Hello,
I am doing a lot of sports broadcasts with Vmix 29 and we always put individual player graphics on the screen during a game. Right now, I have all of the separate player graphics in a folder on my streaming computer. I have an Excel database set up with each graphic in a separate row. I just use the Data Sources manager to move row to row which fires the graphic via a GT Title graphic. It all works very well using a Stream deck to move up and down the rows and fire the title.
Now, we want to move to player graphics that have information that updates dynamically. My business associate made the graphics and updating information as individual URLs. These URLs have the graphic, text info fields as well as some in and out motion. I will have separate URLs for each player. So now the information will be in the cloud instead of stored locally on my computer.
This is a little beyond my expertise when it comes to Vmix and interfacing with external data sources/URLs. I tried adding the finished URL to my current database but nothing happens when I select it in the data sources manager.
I am hoping someone can give me some help on how Mvix would interface with multiple unique URLs. Does it still use the Data Sources Manager? I am kind of unsure how to proceed here. I was hoping I could use the same workflow with selecting a database row and it is done. :)
Thanks for your help!
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,504  Location: Belgium Thanks: 314 times
Was thanked: 1020 time(s) in 838 post(s)
|
Originally Posted by: Tim P. 
Now, we want to move to player graphics that have information that updates dynamically. My business associate made the graphics and updating information as individual URLs. These URLs have the graphic, text info fields as well as some in and out motion. I will have separate URLs for each player. So now the information will be in the cloud instead of stored locally on my computer.
This is a little beyond my expertise when it comes to Vmix and interfacing with external data sources/URLs. I tried adding the finished URL to my current database but nothing happens when I select it in the data sources manager.
WHat type of data source are you supposed to load (XML,Json,other) from your cloud? "separate URLs for each player" maybe i am reading this wrong but are you saying that each individuals info is a separate datasource/link "as well as some in and out motion" how is that supposed to be implemented from a datasource?
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 3/3/2025(UTC) Posts: 24 Thanks: 2 times
|
Hello,
Thanks for your reply. The URL for testing that was sent to me has a finished image that fades up on its own. That is how it behaves when I paste it into a web browser.
I am not sure about what kind I data source to use. I was hoping to be able to keep on using Excel.
Sorry for my lack of knowledge about the situation.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,504 Location: Belgium Thanks: 314 times
Was thanked: 1020 time(s) in 838 post(s)
|
Originally Posted by: Tim P. Hello,
Thanks for your reply. The URL for testing that was sent to me has a finished image that fades up on its own. That is how it behaves when I paste it into a web browser.
Then you will need a browse input instead but can not change the link then based on a datasource Kind of making things harder instead of using the title animation options on a data change You had things working locally so why not use the same way but with an external datasource and image location and keep it simple?
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 3/3/2025(UTC) Posts: 24 Thanks: 2 times
|
Thanks. Could you please explain "external datasource and image location and keep it simple"
Do you mean keep the data sources manager working as is but change out the underlying PNG files dynamically? Basically let all of the changes take place outside of anything Vmix?
What is confusing me is all of the changes need to come from the cloud. These can be a portion of the graphic (with the rest local) or even the entire graphic. But local seems like the easiest and best way to work with the graphics.
Thanks.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,504 Location: Belgium Thanks: 314 times
Was thanked: 1020 time(s) in 838 post(s)
|
Originally Posted by: Tim P. Thanks. Could you please explain "external datasource and image location and keep it simple"
Do you mean keep the data sources manager working as is but change out the underlying PNG files dynamically? Basically let all of the changes take place outside of anything Vmix?
What is confusing me is all of the changes need to come from the cloud. These can be a portion of the graphic (with the rest local) or even the entire graphic. But local seems like the easiest and best way to work with the graphics.
Thanks. Simple as in same principle as you are doing locally now but have your datasource and image location in the "cloud" or a combination of local and local. Each row in your datasource has all the data as well as the image details so by selecting a row you are changing the title content dynamically. A datasource will contain text data like a name and a reference link (local or cloud) for images Would advise to go trough some of the vMix tutorial videos (again) to get an understanding of titles and data source usage A real dynamic way would be for some other program (like a sport scoring program) create a one row datasource instead of a predefined list of data which vMix checks on regular interval for changes to change the title content
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 3/3/2025(UTC) Posts: 24 Thanks: 2 times
|
Thanks. I guess what is confusing me is if I can have a URL in the Excel file, why isn't my current URL doing anything?
We can break up the elements but I am not sure how to get the Excel file to access and deliver all of the information from a cloud source given my current URL is not showing anything in Vmix. (I added a / to the end of the URL which makes the entire field a link in Excel). If I cntrl click the link it opens in a browser.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,504 Location: Belgium Thanks: 314 times
Was thanked: 1020 time(s) in 838 post(s)
|
Originally Posted by: Tim P. Thanks. I guess what is confusing me is if I can have a URL in the Excel file, why isn't my current URL doing anything?
We can break up the elements but I am not sure how to get the Excel file to access and deliver all of the information from a cloud source given my current URL is not showing anything in Vmix. (I added a / to the end of the URL which makes the entire field a link in Excel). If I cntrl click the link it opens in a browser. Maybe an example of an existing link to the datasource file,its content and images that supposed to be retrieved (better than guessing)
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 3/3/2025(UTC) Posts: 24 Thanks: 2 times
|
I will work on that. The current test url is of a young athlete on a non-secure network for internal use.
So it sounds like what you are saying is that the Excel file should be able to reference a file on a cloud location and bring that image or text into GT titler as if local. Correct?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/23/2019(UTC)
Posts: 650
Thanks: 64 times
Was thanked: 153 time(s) in 137 post(s)
|
Not as elegant, but maybe another way is to - add a player link as a Browser input, - add a data source that holds all the links, - add a title input and map its text field to the data source, - use a small script to read the link from the text field and navigate the Browser input to this link Code:dim player as string
player = Input.Find("Text Middle Centre Left Right Sharp.gtzip").Text("Message.Text")
Sleep (50)
API.Function("BrowserNavigate",Input:=1,value:=player)
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 3/3/2025(UTC) Posts: 24 Thanks: 2 times
|
Thanks. I think I will have my associate make the links to the original files available and make a new title build around the items in GT Titler. That seems to be the way most are doing it in the videos I have watched. And I think what doggy is referring to. I can have the non-changing parts local and get the changing parts from an external link. I will let you know how it goes.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 3/3/2025(UTC) Posts: 24 Thanks: 2 times
|
Thanks for your responses. The associate I work with decided to lean on Bitfocus Companion + Stream Deck using a single web source input in Vmix. This is working although I prefer to have the spreadsheet to see more info on what you are selecting instead of just a number on the Stream Deck. But he needs the design to be more universal for users who do not use Vmix.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/23/2019(UTC)
Posts: 650
Thanks: 64 times
Was thanked: 153 time(s) in 137 post(s)
|
If the player graphics can be reached through individual URLs in this setup, you could still implement the workaround posted above.
|
|
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
Help with Dynamic Database Setup in Vmix
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
