vMix Forums
»
General
»
General Discussion
»
data source shortcut for excel
Rank: Newbie
Groups: Registered
Joined: 11/21/2020(UTC) Posts: 4  
|
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
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,225  Location: Belgium Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
|
Have you referenced the shortcut to the NAME of the data source table like Excle/CSV or one you created ?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/21/2020(UTC) Posts: 4
|
Originally Posted by: doggy  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?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,225 Location: Belgium Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
|
Originally Posted by: btc9183 Originally Posted by: doggy 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 2 time(s).
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/21/2020(UTC) Posts: 4
|
Originally Posted by: doggy Originally Posted by: btc9183 Originally Posted by: doggy 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 2 time(s). So this is what I have set up: The Data source:  Shortcut setup:  I think that is the right way to set it up but it does not work. What am I doing wrong?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 1/2/2021(UTC) Posts: 2 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
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,225 Location: Belgium Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
|
Originally Posted by: btc9183
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 !
|
|
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
data source shortcut for excel
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
