logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Map Datasource to Title using Script - Map a datasource's cells to a title using a script
Options
Go to last post Go to first unread
Previous Topic Next Topic
FelixS  
#1 Posted : Tuesday, February 4, 2025 7:13:24 PM(UTC)
FelixS

Rank: Newbie

Groups: Registered
Joined: 2/4/2025(UTC)
Posts: 5
Germany

Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
Hey everyone,

I have some big titles in my production with a lot of fields to be populated. The datasource to be used is a google sheet. I used to manually assign the title's fields to the corresponding cells of the sheet. That works perfectly, however it takes a lot of time to assign the fields by hand and it is very error prone.
I would like to assign the cells of the datasource via a VB.NET script. I thought this would be a very easy task to do with a script but didn't find a way to do it. Basically I want to set row and column inside of the sheet for every field in my title.
I don't want to read out the sheets data and set the title's text, I only want to assign the corresponding rows and columns.

Any help would be appreciated, thanks in advance :)

Best regards
Felix
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
doggy  
#2 Posted : Tuesday, February 4, 2025 8:01:00 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 297 times
Was thanked: 975 time(s) in 808 post(s)
Originally Posted by: FelixS Go to Quoted Post
Hey everyone,

I have some big titles in my production with a lot of fields to be populated. The datasource to be used is a google sheet. I used to manually assign the title's fields to the corresponding cells of the sheet. That works perfectly, however it takes a lot of time to assign the fields by hand and it is very error prone.
I would like to assign the cells of the datasource via a VB.NET script. I thought this would be a very easy task to do with a script but didn't find a way to do it. Basically I want to set row and column inside of the sheet for every field in my title.
I don't want to read out the sheets data and set the title's text, I only want to assign the corresponding rows and columns.

Any help would be appreciated, thanks in advance :)

Best regards
Felix


The very old "trick" is to name the column headers the same as the title text fields (according the vMix User Gude ;-) ) and use the "Auto" option
Back to top
thanks 1 user thanked doggy for this useful post.
FelixS on 2/4/2025(UTC)
FelixS  
#3 Posted : Tuesday, February 4, 2025 8:08:33 PM(UTC)
FelixS

Rank: Newbie

Groups: Registered
Joined: 2/4/2025(UTC)
Posts: 5
Germany

Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
Thanks for the reply, I will try that.
But what about the rows? Do I still have to assign them manually or is there also some "auto" way of doing this?
My problem is the data is scattered around the sheet but I try to bring it to standard table form.
Back to top
doggy  
#4 Posted : Wednesday, February 5, 2025 3:50:29 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 297 times
Was thanked: 975 time(s) in 808 post(s)
Originally Posted by: FelixS Go to Quoted Post
Thanks for the reply, I will try that.
But what about the rows? Do I still have to assign them manually or is there also some "auto" way of doing this?

Whenever you select a row *within the datasource or using shortcut functions) all its data that is linked to a title (column) will show their content from that row
have you watched the mutliplt vMix tutorial videos regarding titles and datources ?

Quote:
My problem is the data is scattered around the sheet but I try to bring it to standard table form.

seems a reorganisatoion of the datatable is in order.
If there is some logic to the scatter a script could convert it into a more suitable table
Back to top
thanks 1 user thanked doggy for this useful post.
FelixS on 2/5/2025(UTC)
FelixS  
#5 Posted : Wednesday, February 5, 2025 7:33:31 PM(UTC)
FelixS

Rank: Newbie

Groups: Registered
Joined: 2/4/2025(UTC)
Posts: 5
Germany

Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
Quote:
seems a reorganisatoion of the datatable is in order.

I added a bunch of new pages to my google sheet with only one row and a lot of labeled columns. Looks stupid but works like a charm!
However, some columns with static values are also being auto-assigned despite of the fact that I don't want them to change while having a completely different name than the field inside of the title. Seems totally arbitrary to me but it took only a few minutes to manually correct these instances.

Made me go down from over an hour of concentrated work to less than 10min.

Thank you!
Back to top
thanks 1 user thanked FelixS for this useful post.
doggy on 2/5/2025(UTC)
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.149 seconds.