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
540144407  
#1 Posted : Sunday, August 19, 2018 11:59:23 PM(UTC)
540144407

Rank: Member

Groups: Registered
Joined: 3/7/2017(UTC)
Posts: 14

Thanks: 1 times
UserPostedImage

Convenient data management, more efficient integration of form functions!

Do you agree?

540144407 attached the following image(s):
0819112810.png (38kb) downloaded 35 time(s).

You cannot view/download attachments. Try to login or register.
doggy  
#2 Posted : Monday, August 20, 2018 1:58:34 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 283 times
Was thanked: 916 time(s) in 755 post(s)
could you please elaborate ! as in why and how.
540144407  
#3 Posted : Monday, August 20, 2018 3:22:18 AM(UTC)
540144407

Rank: Member

Groups: Registered
Joined: 3/7/2017(UTC)
Posts: 14

Thanks: 1 times
Row lookup function.Can accurately match the form data and Data Sources.Complete the complex scoreboard data operation and ranking.
540144407 attached the following image(s):
0123.png (7kb) downloaded 34 time(s).
012.png (30kb) downloaded 52 time(s).
526.png (87kb) downloaded 51 time(s).

You cannot view/download attachments. Try to login or register.
doggy  
#4 Posted : Monday, August 20, 2018 4:25:26 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 283 times
Was thanked: 916 time(s) in 755 post(s)
i Don't know but in less time than it took to make these virtual vMix views (or duplicate the same request you already made a while ago and claimed it was to much work) i edited the textblock names in the title code (ranking graphics) according to the "convert rows to collumns" option and the subsequent headernames as per the help for auto: "a) Will first look for the first column with the same name as the Title field"

so say its a file with no specific header names as per your excel example the names in the textblock names in the title would be :
for first row : Column11, Column21, Column31,...
second row : Column12, Column22, Column32,...
and so on

but that's just how i did it ;-)
DWAM  
#5 Posted : Monday, August 20, 2018 5:04:18 AM(UTC)
DWAM

Rank: Advanced Member

Groups: Registered
Joined: 3/20/2014(UTC)
Posts: 2,721
Man
France
Location: Bordeaux, France

Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
Un-managed data is no data.

If you want to talk about data "management", start by managing it instead of asking for vMix to do it for you...

Guillaume
thanks 1 user thanked DWAM for this useful post.
doggy on 8/20/2018(UTC)
Church_livestream  
#6 Posted : Thursday, October 11, 2018 10:36:34 PM(UTC)
Church_livestream

Rank: Newbie

Groups: Registered
Joined: 4/4/2017(UTC)
Posts: 9
Location: United States

Thanks: 3 times
Some else along these same lines that I cannot find any other place. would be the ability to link cells in a group, for example for a lower third a name of joe doe, ceo of abc company and title of his speech would all be tied together so as you change speakers you only change the name and the other information will come along from the spreadsheet.
DWAM  
#7 Posted : Thursday, October 11, 2018 10:46:32 PM(UTC)
DWAM

Rank: Advanced Member

Groups: Registered
Joined: 3/20/2014(UTC)
Posts: 2,721
Man
France
Location: Bordeaux, France

Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
Quote:
for example for a lower third a name of joe doe, ceo of abc company and title of his speech would all be tied together so as you change speakers you only change the name and the other information will come along from the spreadsheet.


That's default behaviour of vMix titles and/or datasources. I don't understand what you're asking for.

Just check the manual and watch vMix tutorials on YouTube. It's all explained.

https://www.vmix.com/help21/Title.html
https://www.vmix.com/help21/DataSources.html
https://www.vmix.com/help21/vMixTitleDesigner.html

https://www.youtube.com/user/vmixcomau/videos

Guillaume
Video Dave  
#8 Posted : Friday, October 12, 2018 1:16:26 PM(UTC)
Video Dave

Rank: Advanced Member

Groups: Registered
Joined: 6/4/2014(UTC)
Posts: 81
Man
Location: USA

Thanks: 40 times
Was thanked: 9 time(s) in 9 post(s)
We created a spreadsheet that when you type in the page number of any hymn, excel finds the title and vMix displays it in a lower third.
Once you learn how to use spreadsheets and data sources it becomes a very powerful tool.
Users browsing this topic
Similar Topics
Vmix Voice and data sources (Feature Requests)
by jgmott@gmail.com 2/8/2024 3:04:21 PM(UTC)
VMIX data sources not updating (XML/JSON) (General Discussion)
by themoog 8/20/2023 6:33:30 PM(UTC)
Tickers | Data Sources Manager | Multiple Titles (General Discussion)
by cuyahogacuse 7/26/2023 5:07:55 AM(UTC)
Working with Data Sources / XML / Titles - question... (General Discussion)
by Nuno 7/18/2023 2:11:24 AM(UTC)
Exporting Title with Data Sources setup (GT)
by matt_112358 4/12/2023 9:14:54 PM(UTC)
Rearrange order of Data Sources in Data Sources Manager (Feature Requests)
by jameslex 1/26/2023 12:30:55 AM(UTC)
Conditional formatting with data sources? (General Discussion)
by Jmslnch 1/24/2023 9:52:43 AM(UTC)
pages/layers and data sources with GT titles (GT)
by MitchDevlin 11/29/2022 8:51:34 PM(UTC)
YAML support for Data Sources (Feature Requests)
by engelschall 6/28/2022 4:06:04 AM(UTC)
Data Sources Shortcut Issue (General Discussion)
by DavidJChalmers 4/8/2022 9:00:17 PM(UTC)
DATA SOURCES Photographs (General Discussion)
by Metroplex Mobile Studio 2/21/2022 3:44:06 AM(UTC)
Data Sources Manager access via API/Web (even if just read only) (Feature Requests)
by vmixLove33 10/20/2021 1:57:55 AM(UTC)
Data Sources Open on Startup? (General Discussion)
by toddstowe2@gmail.com 8/2/2021 1:45:51 PM(UTC)
Data Sources For Tickers (General Discussion)
by PinMason 2/6/2021 3:25:17 AM(UTC)
API Data sources (Feature Requests)
by Janne Adolfsson 1/31/2021 11:11:03 PM(UTC)
Binding title shape colors to data sources (General Discussion)
by evaneaston 1/31/2021 11:20:11 AM(UTC)
DATA SOURCES IN EXCEL (General Discussion)
by kalpesh175 1/5/2021 9:04:07 PM(UTC)
Shared Control of Data Sources? (General Discussion)
by AgentPete 11/23/2020 5:35:23 AM(UTC)
Data Sources - Leading/Trailing Zeros (Feature Requests)
by cookdoeyl 10/2/2020 1:49:43 PM(UTC)
Rectangle color from Data Sources (GT)
by bain1320 9/19/2020 4:26:22 PM(UTC)
DATA SOURCES IN EXCEL FILE AND GT DESIGNER (3rd Party Software and Development)
by kalpesh175 9/10/2020 3:49:49 PM(UTC)
Number Format in Data Sources (Feature Requests)
by jedibrooker 9/8/2020 1:45:34 PM(UTC)
Countdown Timers and Data Sources (General Discussion)
by zd20 7/5/2020 7:53:54 AM(UTC)
Add the ability to change text color using data sources (Feature Requests)
by rnhturner 6/18/2020 1:17:19 AM(UTC)
GT Designer Advanced - Change effects based on Data Sources (Feature Requests)
by SF89 5/22/2020 10:01:53 AM(UTC)
Can you save different data sources to Title Presets? (General Discussion)
by whichswitch 5/1/2020 3:09:55 AM(UTC)
XML on data sources (General Discussion)
by davidcallahan 3/6/2020 11:50:29 PM(UTC)
Data sources with separate titles (GT)
by mcjones2000 1/13/2020 12:49:02 AM(UTC)
Moving GTZIP files and Data Sources between vMix versions (GT)
by PopisDad 1/4/2020 5:40:13 AM(UTC)
Data sources stop refreshing until I restart the software (General Discussion)
by xemles 1/2/2020 11:16:54 AM(UTC)
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.