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
btc9183  
#1 Posted : Friday, May 7, 2021 12:32:36 PM(UTC)
btc9183

Rank: Newbie

Groups: Registered
Joined: 11/21/2020(UTC)
Posts: 4
Man
United States

I am having issues getting the shortcut I set up for DataSourceNextRow and/or DataSourcePreviousRow to work at all. I have seen how some people have done this programmatically but I am no programmer. I just need the shortcut to advance to the next row in my Excel spreadsheet. The file name I am using is test_lyrics.xlsx and vMix imports it and I can see the data. If I advance manually in the Data Source Manager, it shows up on my output but If I close the data manager and try to advance the row usng the shortcut it is not working. I hope I am being clear enough. I really need this to work as our Pastor is not happy with using an inset of the PowerPoint slides we use during the service for the congregation.

Bill
doggy  
#2 Posted : Friday, May 7, 2021 5:23:06 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 3,141
Belgium
Location: Belgium

Thanks: 178 times
Was thanked: 569 time(s) in 468 post(s)
Have you referenced the shortcut to the NAME of the data source table like Excle/CSV or one you created ?
btc9183  
#3 Posted : Saturday, May 8, 2021 10:26:52 AM(UTC)
btc9183

Rank: Newbie

Groups: Registered
Joined: 11/21/2020(UTC)
Posts: 4
Man
United States

Originally Posted by: doggy Go to Quoted Post
Have you referenced the shortcut to the NAME of the data source table like Excle/CSV or one you created ?


I put C:\Users\lcpc\Desktop\test_lyrics.xlsx,Sheet1 in the Value: field. Is this correct?
doggy  
#4 Posted : Saturday, May 8, 2021 11:10:32 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 3,141
Belgium
Location: Belgium

Thanks: 178 times
Was thanked: 569 time(s) in 468 post(s)
Originally Posted by: btc9183 Go to Quoted Post
Originally Posted by: doggy Go to Quoted Post
Have you referenced the shortcut to the NAME of the data source table like Excle/CSV or one you created ?


I put C:\Users\lcpc\Desktop\test_lyrics.xlsx,Sheet1 in the Value: field. Is this correct?


No, need to use the name specified with the Edit Data Source

dts.JPG (28kb) downloaded 1 time(s).
btc9183  
#5 Posted : Sunday, May 9, 2021 3:52:40 AM(UTC)
btc9183

Rank: Newbie

Groups: Registered
Joined: 11/21/2020(UTC)
Posts: 4
Man
United States

Originally Posted by: doggy Go to Quoted Post
Originally Posted by: btc9183 Go to Quoted Post
Originally Posted by: doggy Go to Quoted Post
Have you referenced the shortcut to the NAME of the data source table like Excle/CSV or one you created ?


I put C:\Users\lcpc\Desktop\test_lyrics.xlsx,Sheet1 in the Value: field. Is this correct?


No, need to use the name specified with the Edit Data Source

dts.JPG (28kb) downloaded 1 time(s).


So this is what I have set up:

The Data source:
Data source

Shortcut setup:
Shortcut

I think that is the right way to set it up but it does not work. What am I doing wrong?
LNavarro  
#6 Posted: : Sunday, May 9, 2021 9:17:16 PM(UTC)
LNavarro

Rank: Newbie

Groups: Registered
Joined: 1/2/2021(UTC)
Posts: 1
United States
Location: San Antonio

Hi,

As doggy mentioned, you need to use the name of your data source. So, your value should be:

Excel/CSV,Sheet1

Regards,

Lou
doggy  
#7 Posted : Sunday, May 9, 2021 9:20:07 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 3,141
Belgium
Location: Belgium

Thanks: 178 times
Was thanked: 569 time(s) in 468 post(s)
Originally Posted by: btc9183 Go to Quoted Post

I think that is the right way to set it up but it does not work. What am I doing wrong?


Easy answer: You are thinking wrong and are NOT listening !

Users browsing this topic
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.