logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Help with Dynamic Database Setup in Vmix
Options
Go to last post Go to first unread
Previous Topic Next Topic
Tim P.  
#1 Posted : Monday, March 23, 2026 7:12:35 AM(UTC)
Tim P.

Rank: Member

Groups: Registered
Joined: 3/3/2025(UTC)
Posts: 25
United States

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!
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 : Monday, March 23, 2026 7:25:33 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 314 times
Was thanked: 1020 time(s) in 838 post(s)
Originally Posted by: Tim P. Go to Quoted Post

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?
Back to top
Tim P.  
#3 Posted : Monday, March 23, 2026 7:38:26 AM(UTC)
Tim P.

Rank: Member

Groups: Registered
Joined: 3/3/2025(UTC)
Posts: 25
United States

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.
Back to top
doggy  
#4 Posted : Monday, March 23, 2026 7:50:53 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 314 times
Was thanked: 1020 time(s) in 838 post(s)
Originally Posted by: Tim P. Go to Quoted Post
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?
Back to top
Tim P.  
#5 Posted : Monday, March 23, 2026 8:06:37 AM(UTC)
Tim P.

Rank: Member

Groups: Registered
Joined: 3/3/2025(UTC)
Posts: 25
United States

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.
Back to top
doggy  
#6 Posted : Monday, March 23, 2026 8:29:33 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 314 times
Was thanked: 1020 time(s) in 838 post(s)
Originally Posted by: Tim P. Go to Quoted Post
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
Back to top
Tim P.  
#7 Posted : Monday, March 23, 2026 8:36:44 AM(UTC)
Tim P.

Rank: Member

Groups: Registered
Joined: 3/3/2025(UTC)
Posts: 25
United States

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.
Back to top
doggy  
#8 Posted : Monday, March 23, 2026 8:48:16 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 314 times
Was thanked: 1020 time(s) in 838 post(s)
Originally Posted by: Tim P. Go to Quoted Post
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)
Back to top
Tim P.  
#9 Posted : Monday, March 23, 2026 11:03:08 AM(UTC)
Tim P.

Rank: Member

Groups: Registered
Joined: 3/3/2025(UTC)
Posts: 25
United States

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?
Back to top
dmwkr  
#10 Posted : Monday, March 23, 2026 8:18:32 PM(UTC)
dmwkr

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)
Back to top
Tim P.  
#11 Posted : Monday, March 23, 2026 10:51:06 PM(UTC)
Tim P.

Rank: Member

Groups: Registered
Joined: 3/3/2025(UTC)
Posts: 25
United States

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.
Back to top
Tim P.  
#12 Posted : Tuesday, March 24, 2026 1:27:28 PM(UTC)
Tim P.

Rank: Member

Groups: Registered
Joined: 3/3/2025(UTC)
Posts: 25
United States

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.
Back to top
dmwkr  
#13 Posted : Wednesday, March 25, 2026 6:31:06 AM(UTC)
dmwkr

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.
Back to top
Tim P.  
#14 Posted : Wednesday, March 25, 2026 2:29:20 PM(UTC)
Tim P.

Rank: Member

Groups: Registered
Joined: 3/3/2025(UTC)
Posts: 25
United States

Thanks: 2 times
I will keep that in mind. It works through the Stream Deck but I would prefer it to be more internal with Vmix. But it is not my call in the end.
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-2026, Yet Another Forum.NET
This page was generated in 0.147 seconds.