logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Data source, omit first row?
Options
Go to last post Go to first unread
Previous Topic Next Topic
spencerm24  
#1 Posted : Sunday, July 22, 2018 2:18:50 AM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
Is it possible to omit the first row of data? Right now my data source generator generates the first row as the label of the column, I tried clicking "first row as column names" and it didn't work because the same column name appears more than once (or so I assume "ERROR: A Column named 'position' already belongs to this DataTable")

That being said, I want to scroll through the data sources, but don't want it to show the first row. Is this possible?
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
DWAM  
#2 Posted : Sunday, July 22, 2018 11:33:16 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)
Maybe correcting the datasource generator is a better idea than trying to modify vMix for incorrect situations, vMix is not supposed to focus on handling errors created by third-party tools

My 2 cts
Guillaume
Back to top
WWW
spencerm24  
#3 Posted : Sunday, July 22, 2018 2:18:38 PM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
It's not an incorrect data source generator, it generates an output for a race, and theres 3 position headers for the top 3, the next row is 4-6th, etc. and not being a programmer of the software used to generate the output, I was hoping vMix would somehow be able to work with this CSV file.

Alternatively I can convert all rows to columns, but then I'd have to make 10 separate inputs for all the positions, so they can scroll, right now there are 3 lines on screen for the top 3, and they scroll, and I was hoping to make it one input, and have the data source scroll through and loop. If there is another way to accomplish this, I'm all ears, but short of omitting the first row, or making 10 inputs, I don't see how else to accomplish this.
Back to top
doggy  
#4 Posted : Sunday, July 22, 2018 2:43:34 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
Based on your initial post DWAM is correct

Quote:
it didn't work because the same column name appears more than once (or so I assume "ERROR: A Column named 'position' already belongs to this DataTable")


Seems a weird way of structuring if each row depicts 3 positions

if you mean by inputs being title fields , yes each one always needs a seperate input !
As an ultimate solution one could program its own data retrieval function in the back of the title if your source is really specific

Maybe show an example of the CSV file ?
Back to top
spencerm24  
#5 Posted : Sunday, July 22, 2018 3:02:44 PM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
They give us two options in the software, 1 position per line, or 3 per line. Since my graphic has 3 on a line, I figured going with the 3 per line CSV and just changing the row would be the least inputs (only one input, data source changes, rather than 10 of the same graphic with different data mapping)

If I went with the one position per line, (as I understand data sources) I'd have to map position 1 to a spot, position 2, and position 3 as well. on another graphic, map positions 4-6, on a third graphic map positions 7-9 etc. There is only one row to the data source if I do it this way.

Here is the link to the generator with the sample files.

https://www.race-monitor.com/ProductionTools

Paged version has 3 on a line, non paged is 1 per line.


I guess an alternative question would be, is there a way to scroll through a field of 30 drivers without having 10 inputs of the same graphic using cpu resources? I just deleted 20 inputs after Martin advised me that I had too many inputs causing renderer dropped frames, so I'm hesitant to go back and put 10 in.
Back to top
doggy  
#6 Posted : Sunday, July 22, 2018 3:27:58 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
just my opinion ; i would go with the basic csv output , as the multi item per line collum names mess things up

still not fully visualizing how you intend to show (sorry) but for say a 1 item per line ranking one can convert rows to collumns
If your title inputs have the same name as the collumn names its much easyer to specify also (auto)

As mentioned before, for an out of the box kind of display i personally wouldn't even use the build in datasources but a specific reading script and filtering within the title code or even an external wpf script creating a NDI source of the graphics (sdk) , a bit of prepping but in the end well worth it
Back to top
spencerm24  
#7 Posted : Sunday, July 22, 2018 3:32:20 PM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
I intend to show a horizontal strip at the top of the screen

1. DRIVER 1 2. DRIVER 2 3. DRIVER 3


In doing this, I'd need 10 titles (30 drivers). I'd convert rows to columns, so

Title 1-Position 1-3
Title 2-Position 4-6
Title 3-Position 7-9


Mapping each field manually so that say the left driver on title 2 always shows position 4's spot on the CSV



As far as your last bit goes about scripting a reader for the title...I have absolutely no idea how or what that means, I'm not a coder or programmer, hence why I'm trying to use the tools the scoring system has. I'd rather not have to make 10 titles, as that is very taxing on the system.
Back to top
doggy  
#8 Posted : Sunday, July 22, 2018 3:54:22 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
a pitty the 3 in 1 source has issue with the collumn names and can't use first row as names

I understand you are not a coder or programmer but a little scripting and use the "DataSourceSelectRow" to loop through the list but omitting the first row could circumvent the issue would be in order for your desired effect.
if your license doesn't allow for scripting an external script could do the same using httprequests , mayb a little autohostscript looping shortcuts could be possible .
Back to top
doggy  
#9 Posted : Sunday, July 22, 2018 4:03:04 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
little brainstorm:

would you be willing to sacrifice 10 shortcuts to need only one title ?
Back to top
spencerm24  
#10 Posted : Sunday, July 22, 2018 4:30:58 PM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
Interesting....I think I know what you're getting at. I'd like it automated the scroll though, so if I can still achieve that, I'd sacrifice the shortcuts.
Back to top
spencerm24  
#11 Posted : Sunday, July 22, 2018 4:32:22 PM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
Too bad we can't build in delays in shortcuts. Otherwise the selectRow shortcut with a 5 second gap before selecting the next row would do it.
Back to top
doggy  
#12 Posted : Sunday, July 22, 2018 4:38:10 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
could use autohotkey to loop through the shortcuts with delays in between ;-)
Back to top
spencerm24  
#13 Posted : Sunday, July 22, 2018 4:44:57 PM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
Interesting, hadn't thought of autohotkey


I'm also wondering if vMix will take this key-value data source.

https://www.race-monitor...ionTools/timing_data.txt

I tried it as a text file, and XML and it didn't work in data source manager
Back to top
doggy  
#14 Posted : Sunday, July 22, 2018 5:00:19 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
quick and dirty ahk

Code:


Loop
{
     WinActivate, vMix Basic HD           ; Replace  with whatever Window Spy said your Window's title is. making sure vmix is in focus
     send {k}                             ; shortcut with key k as DataSourceSelectRow for row one
     Sleep,5000                           ; 5 second pauze

     WinActivate, vMix Basic HD
     send {l}                             ; row 2                         
     Sleep, 5000

     WinActivate, vMix Basic HD
     send {m}                              ; row 3                         
     Sleep, 5000

                                           ; and so on 

}


Back to top
thanks 1 user thanked doggy for this useful post.
spencerm24 on 7/22/2018(UTC)
spencerm24  
#15 Posted : Sunday, July 22, 2018 6:38:10 PM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
Awesome! Thanks!
Back to top
Users browsing this topic
Guest (3)
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.123 seconds.