logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Linking excel data to images - Can you dispay an image on a graphic based on data?
Options
Go to last post Go to first unread
Previous Topic Next Topic
andrewgfd  
#1 Posted : Monday, May 11, 2020 1:10:08 AM(UTC)
andrewgfd

Rank: Newbie

Groups: Registered
Joined: 5/6/2020(UTC)
Posts: 5
United Kingdom
Location: Surrey

Thanks: 2 times
Hi there,

I am building a scorecard in GT, which is all good. I have text in the graphic which in vMix I will link the appopriate text cell in an Excel spreadsheet. The spreadsheet calculates scores and rankings and puts in the right order.

Within the GT scorecard, I have also added small image placeholders against each position, for which I want to dynamically change the picture in that window based on a the data I have in a cell in the Excel sheet (could be text or number). The images are located in a single folder and apropriatly sized. Does anyone know if it is possible to change an image in vMix based on the image field in the GT graphic? Would putting the file name/path in the Excel help?

Hope that makes sense. Any thoughts greatly apreciated.

Thanks,

Andrew.
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
IceStream  
#2 Posted : Monday, May 11, 2020 1:27:16 AM(UTC)
IceStream

Rank: Advanced Member

Groups: Registered
Joined: 3/7/2012(UTC)
Posts: 2,602
Man
Location: Canada

Thanks: 33 times
Was thanked: 501 time(s) in 470 post(s)
@ andrewgfd

Yes, if the correct file path is in the cell, and Data Sources point to that cell for an Image field in your Title, it will change dynamically as the cell change is saved.


Ice
Back to top
WWW
andrewgfd  
#3 Posted : Monday, May 11, 2020 1:33:53 AM(UTC)
andrewgfd

Rank: Newbie

Groups: Registered
Joined: 5/6/2020(UTC)
Posts: 5
United Kingdom
Location: Surrey

Thanks: 2 times
Fantastic! Thanks IceStream, that works a treat.

Andrew.
Back to top
doggy  
#4 Posted : Monday, May 11, 2020 1:41:05 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 284 times
Was thanked: 920 time(s) in 759 post(s)
@ andrewgfd

Same as Ice said but
a bit easier is as you have the images in a local folder anyway is to just use the data (nr or text) that matches the image name (don't even need the file extension ) and put the file location in the title editor format field where {0} replaces the data .

example : d:/myfolder/{0}.jpg

Makes it also easier if the file folder location should change as you would only have to change one thing in the title instead of all in the excel file
Back to top
thanks 1 user thanked doggy for this useful post.
andrewgfd on 5/11/2020(UTC)
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.110 seconds.