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 13 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: 861
Belgium
Location: Belgium

Thanks: 55 times
Was thanked: 148 time(s) in 132 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 7 time(s).
012.png (30kb) downloaded 16 time(s).
526.png (87kb) downloaded 12 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: 861
Belgium
Location: Belgium

Thanks: 55 times
Was thanked: 148 time(s) in 132 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: 1,930
Man
France
Location: Bordeaux, France

Thanks: 140 times
Was thanked: 515 time(s) in 414 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: 1,930
Man
France
Location: Bordeaux, France

Thanks: 140 times
Was thanked: 515 time(s) in 414 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: 73
Man
Location: USA

Thanks: 27 times
Was thanked: 7 time(s) in 7 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
Data Sources and Umlauts (General Discussion)
by Slaver 8/15/2018 5:23:55 AM(UTC)
Data Sources Feature Requests (Feature Requests)
by 540144407 7/2/2018 5:22:24 AM(UTC)
Multiple data sources issue (General Discussion)
by elicip 6/16/2018 8:48:32 AM(UTC)
Animated title not "synched" with the Data Sources AutoNext (General Discussion)
by matteoarrigone 6/15/2018 1:15:35 PM(UTC)
Data Sources issue (General Discussion)
by monamiga 3/10/2018 11:16:56 PM(UTC)
Data sources short cut set up (Feature Requests)
by 321actionvideo 2/21/2018 12:31:34 PM(UTC)
Filter function for data sources (Feature Requests)
by Rinsky 2/14/2018 8:07:55 AM(UTC)
Combining Data Sources on titles? (General Discussion)
by Argo82 2/12/2018 12:40:47 PM(UTC)
Data Sources Short Cut to Row (General Discussion)
by calamityjane 1/31/2018 12:30:42 PM(UTC)
XML Data Sources Help (Newbie) (General Discussion)
by Argo82 1/21/2018 4:38:49 PM(UTC)
Conditional Statements with Data sources (General Discussion)
by kruvek 10/25/2017 3:28:42 PM(UTC)
Tab Delimited Data Sources... (Feature Requests)
by clafarge 9/12/2017 4:02:22 PM(UTC)
Data Sources problem (rows to columns) *solved* (General Discussion)
by ESNTV 9/8/2017 7:00:07 AM(UTC)
Pause Data sources update (Feature Requests)
by corporatejames 8/24/2017 6:27:54 AM(UTC)
Images in Data Sources (sheets) (General Discussion)
by kjones9999 8/23/2017 11:02:29 PM(UTC)
Triggers from Data Sources (General Discussion)
by PTZOptics 7/31/2017 10:37:29 AM(UTC)
Data sources for Web controller shortcuts titles (Feature Requests)
by corporatejames 6/14/2017 8:28:17 PM(UTC)
Data Sources - More Rows Feature (Feature Requests)
by PTZOptics 5/14/2017 11:07:29 AM(UTC)
Excel cells (not rows) as data sources (General Discussion)
by ClaudiuCiprian 4/8/2017 3:36:12 AM(UTC)
Data sources: using numeric format strings (General Discussion)
by dasmedienatelier 2/6/2017 12:56:56 PM(UTC)
Effects with Data Sources (General Discussion)
by kgoodyer 1/31/2017 6:28:00 PM(UTC)
Bug with data sources - can cause VMIX to crash (General Discussion)
by kgoodyer 1/31/2017 6:10:24 PM(UTC)
Possible bugs with Data Sources? (General Discussion)
by DWAM 1/29/2017 7:51:37 AM(UTC)
Control Data Sources from a web broswer (General Discussion)
by ghbroadcast 1/3/2017 8:35:08 AM(UTC)
Data Sources, search&replace team name before each game (General Discussion)
by Ario 12/27/2016 10:32:13 AM(UTC)
Data Sources - Use bulk data on screen (Feature Requests)
by infinity21 12/24/2016 9:13:48 AM(UTC)
Data sources: Countdown settings (General Discussion)
by EricvdB 12/15/2016 7:14:54 AM(UTC)
Vmix 18 - Data Sources (General Discussion)
by alanppp 12/9/2016 6:00:19 PM(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.