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
Simsyuk  
#1 Posted : Monday, November 16, 2020 6:24:00 PM(UTC)
Simsyuk

Rank: Advanced Member

Groups: Registered
Joined: 8/16/2019(UTC)
Posts: 337
United Kingdom

Thanks: 70 times
Was thanked: 21 time(s) in 17 post(s)
Hi all I hope you're well. I have tired everything I can think of to get my Excel sheet to automatically move to the next cell using triggers (without using auto next from the start); I wish to delay for 2 minutes and then automatically turn On Auto Next.

I thought the DataSourceAuto NextOn would do the trick but no matter what combination I place in the Data source box nothing works. I've followed the so called 'example' but this doesn't work either!

Could someone here please explain in simple English how to set up the correct Excel sheet , thanks in advance.
DWAM  
#2 Posted : Monday, November 16, 2020 6:34:06 PM(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)
for the delay you can either do it manually (having a shortcut to turn the auto next feature on) when desired or with a script with a sleep command
DataSourceAutoNextOn

then the correct command is DataSourceNextRow

with excel make sure to use this syntax 'Excel/CSV,Sheet1' with no spaces and it is case sensitive
doggy  
#3 Posted : Monday, November 16, 2020 6:59:54 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 283 times
Was thanked: 920 time(s) in 759 post(s)
Originally Posted by: Simsyuk Go to Quoted Post
I wish to delay for 2 minutes and then automatically turn On Auto Next.


Code:
Sleep (20000)
API.Function("DataSourceAutoNextOn",Value:="Excel/CSV,Sheet1")  


Replace Excel/CSV with the name you gave in the datasource setup
Replace Sheet1 with the name of the sheet in your Excel File

Quote:
Could someone here please explain in simple English how to set up the correct Excel sheet , thanks in advance.


????? ; Standard like when you create a new excel
Simsyuk  
#4 Posted : Monday, November 16, 2020 7:36:22 PM(UTC)
Simsyuk

Rank: Advanced Member

Groups: Registered
Joined: 8/16/2019(UTC)
Posts: 337
United Kingdom

Thanks: 70 times
Was thanked: 21 time(s) in 17 post(s)
Thank you gentleman, I noticed my error (hangs in shame), I put 9,000 instead of 2,000 no idea how I missed that, but the script idea is better so will implement that.

Still so much to learn in vMix.
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.