Rank: Advanced Member
Groups: Registered
Joined: 8/24/2016(UTC) Posts: 41
Thanks: 4 times Was thanked: 2 time(s) in 2 post(s)
|
Hi Guys Reasonably familiar with title editor etc
But odes anyone have any idea about the best way to go about setting a final match type score board with top 10 athletes in a list pulled from a excel spread sheet So that all 10 show on a page with times etc also on the page
Rather than scrolling through the list if that makes sense.
Ideally then you could update the top 10 on the list and put the whole list up at once.
thanks for any feedback
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 3/20/2014(UTC) Posts: 2,721 Location: Bordeaux, France Thanks: 243 times Was thanked: 794 time(s) in 589 post(s)
|
Hi
I'm not sure this can be done with vMix only. But I would use vMix UTC to design such a layout.
Simply design a xaml title with your table layout for 10 first rows. You will also need to convert your excel file to XML. Check Export XML data in google to learn how to do it. (at least for vMixUTC, vMix can use excel as a datasource)
Then you can use data source to your XML to fill in the text areas for "page 1". Then create a function button using the API commands for datasource to learn how to go to "page 2" from your data source (next 10 rows) and so on.
Maybe there is a vMix only method to do it. I will try...
|
|
|
|
Rank: Member
Groups: Registered
Joined: 2/10/2017(UTC) Posts: 11 Location: DFW
Was thanked: 4 time(s) in 4 post(s)
|
You can do it with only vMix, but you need to think of each row in the spreadsheet as a "page" as if you were paging 10 at a time through say 50 names. So to do that you would have columns named Athlete1, Athlete2, Athlete3 and so on. So the whole first row will have all 10 athletes as columns. Then if you wanted a top 20 list, you'd have a second row with 10 more athletes, still under the labels Athlete1, Athlete2, etc. If you need other fields you can have Place1, Athlete1, Place2, Athlete2, etc. as your column names.
If you will always display the top 10 and you don't need anything other than a single field, then you could put them in a column and check the "Convert columns to rows" box in the datasource manager and it will do exactly as I've described above.
|
|
|
|
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