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
barryondeck  
#1 Posted : Friday, October 25, 2024 1:13:55 AM(UTC)
barryondeck

Rank: Member

Groups: Registered
Joined: 2/8/2023(UTC)
Posts: 12
United States
Location: Houston

I use data sources a lot in my live streamed show. I use them to populate fantasy score results, pick ‘em contest results, previous days scores from various leagues (NBA, NFL, MLB, NHL), stats, news, and more.

A lot of this data is gathered through scripting using Google AppScript and Google Sheets and the Espn API, so I’m constantly coding and tweaking along the way so sometimes I’ll break a script or code or spreadsheet. The spreadsheet is the big one because in doing so this seems to break the data source connection to the title, which resets the mappings, which means I have to go back and remap everything, which is an absolute PITA.

For example, last night I had to re-map all my fantasy league titles.

That means:

10 team names
10 team records
10 team owners
10 team scores

X 4 leagues

That means I had to re-map 160 fields, and have to do so every time it “magically” resets ( I still haven’t figured out why it does this sometimes).

Is there a config file where the mappings are stored? (doggy got me thinking after my formatting rant 🤣)

If not can these mappings be scripted?

Anything has to be easier than doing this by hand every time.

doggy  
#2 Posted : Friday, October 25, 2024 4:05:53 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 291 times
Was thanked: 954 time(s) in 789 post(s)
Originally Posted by: barryondeck Go to Quoted Post


Is there a config file where the mappings are stored? (doggy got me thinking after my formatting rant 🤣)



Believe they are in the preset file

Edit: YUP
barryondeck  
#3 Posted : Friday, October 25, 2024 4:30:12 AM(UTC)
barryondeck

Rank: Member

Groups: Registered
Joined: 2/8/2023(UTC)
Posts: 12
United States
Location: Houston

Originally Posted by: doggy Go to Quoted Post
Originally Posted by: barryondeck Go to Quoted Post


Is there a config file where the mappings are stored? (doggy got me thinking after my formatting rant 🤣)



Believe they are in the preset file

Edit: YUP


oh niiiiice. This changes things a bit for me. Phew! Thanks Doggy! You have saved me AGAIN!
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.