logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Datasource Excel multiple sheet bug?
Options
Go to last post Go to first unread
Previous Topic Next Topic
fgolman  
#1 Posted : Thursday, April 10, 2025 9:45:58 AM(UTC)
fgolman

Rank: Advanced Member

Groups: Registered
Joined: 3/30/2023(UTC)
Posts: 86
United States
Location: Chicago

Thanks: 8 times
Was thanked: 3 time(s) in 2 post(s)
Please clarify that the API documentation regarding sheet names isn't functional, even though it appears that one should be able to script to pick up data from multiple sheets from a single file.

The data source manager does expose it. Just not through application of scripting via the API.

Driving me crazy.

Yes, I can create a much larger single spreadsheet with groupings of information, but the sheet name mechanism yields much cleaner code.

Thanks,

Fritz Golman
RadioDNA
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
admin  
#2 Posted : Thursday, April 10, 2025 11:48:21 AM(UTC)
admin

Rank: Administration

Groups: Administrators
Joined: 1/13/2010(UTC)
Posts: 5,196
Man
Location: Gold Coast, Australia

Was thanked: 4446 time(s) in 1556 post(s)
That is not accurate, the API and the shortcuts for data sources work as described, so you are going to need to provide some examples.
Back to top
WWW BLOG
fgolman  
#3 Posted : Thursday, April 10, 2025 12:34:04 PM(UTC)
fgolman

Rank: Advanced Member

Groups: Registered
Joined: 3/30/2023(UTC)
Posts: 86
United States
Location: Chicago

Thanks: 8 times
Was thanked: 3 time(s) in 2 post(s)
OK here are the details, as a demonstration.

Simple Excel spreadsheet with these tabs:

Sheet1:

cam1-a desc1-a
cam2-a desc2-a
cam3-a desc3-a

Sheet2:

cam1-b desc1-b
cam2-b desc2-b
cam3-b desc3-b

No matter what I do this API call won't get data from Sheet2.

api.function("DataSourceSelectRow",,"Excel/CSV,Sheet2,0") which should pull up cam1-b, desc1-b or
api.function("DataSourceSelectRow",,"Excel/CSV,Sheet2,1") which should pull up cam2-b, desc2-b or
api.function("DataSourceSelectRow",,"Excel/CSV,Sheet2,2") which should pull up cam3-b, desc3-b.

However, it will pull up from Sheet1 as appropriate, using this API calls like this: api.function("DataSourceSelectRow",,"Excel/CSV,Sheet1,1")

Is it something in how this is mapped in the Data Source Manager? It does see Sheet1 and Sheet2 in the dropdown, so it's definitely pulling up the spreadsheet correctly.

Now, if I'm doing something wrong, let me know.

Also, a clarification, this feeds into a lower third with name (which is example for cam1, 2, 3) and additional text description (which is example with desc1, 2, 3). I can see it changing when using Sheet1 but not Sheet2.

Thank you,

Fritz Golman
RadioDNA
Back to top
admin  
#4 Posted : Thursday, April 10, 2025 7:07:59 PM(UTC)
admin

Rank: Administration

Groups: Administrators
Joined: 1/13/2010(UTC)
Posts: 5,196
Man
Location: Gold Coast, Australia

Was thanked: 4446 time(s) in 1556 post(s)
I just did a quick test with a 2 sheet spreadsheet and the scripting functions work as expected.
Double check the spelling to ensure the sheet names entered exactly match what they are called in the spreadsheet.

Failing that you can contact vMix Support (https://www.vmix.com/contact-us.aspx)
(Use the Email address at the bottom of the page so you can add attachments)

Attach the spreadsheets and presets used and we should be able to see where the issue is.
Back to top
WWW BLOG
fgolman  
#5 Posted : Thursday, April 10, 2025 8:55:47 PM(UTC)
fgolman

Rank: Advanced Member

Groups: Registered
Joined: 3/30/2023(UTC)
Posts: 86
United States
Location: Chicago

Thanks: 8 times
Was thanked: 3 time(s) in 2 post(s)
It's literally copy and paste from example above.

I'll drop support a note.

Thanks
Back to top
admin  
#6 Posted : Thursday, April 10, 2025 11:55:05 PM(UTC)
admin

Rank: Administration

Groups: Administrators
Joined: 1/13/2010(UTC)
Posts: 5,196
Man
Location: Gold Coast, Australia

Was thanked: 4446 time(s) in 1556 post(s)
So I have just re-read your example, and is it possible that maybe you have misunderstood what DataSourceSelectRow is for?

Its purpose is to change the selected row within a particular table/sheet. It won't change the table/sheet assigned to a title field to something else...

For example, say you have two titles, one assigned to Sheet1 and one assigned to Sheet2.
These shortcuts can independently switch which row each of the titles is assigned to. (assuming the data mapping row in a title is set to "Selected")

Hope this clears things up.
Back to top
WWW BLOG
thanks 1 user thanked admin for this useful post.
eduardocfs on 4/15/2025(UTC)
fgolman  
#7 Posted : Friday, April 11, 2025 12:42:13 AM(UTC)
fgolman

Rank: Advanced Member

Groups: Registered
Joined: 3/30/2023(UTC)
Posts: 86
United States
Location: Chicago

Thanks: 8 times
Was thanked: 3 time(s) in 2 post(s)
OK I think this gets to the bottom of the issue.

Certainly wasn't clear that it only operates within one sub-sheet/tab of the entire spreadsheet.

Thanks for the clarification.

Now I'll just have to build the spreadsheet with blocks of titles stacked in fixed groupings. Not as clean both in code and in the spreadsheet itself but that's ok.

Thanks again.

Fritz Golman
RadioDNA

Back to top
Users browsing this topic
Guest
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-2025, Yet Another Forum.NET
This page was generated in 0.201 seconds.