Rank: Advanced Member
Groups: Registered
Joined: 4/4/2016(UTC) Posts: 235  Location: Not Los Angeles CA Thanks: 86 times
Was thanked: 28 time(s) in 23 post(s)
|
Can you specify a date range on data sources?
I have some google sheets with lots of data and I may only want this week or today as an example of how I would use this.
Thanks.
Rich Shumaker
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 4/4/2016(UTC) Posts: 235 Location: Not Los Angeles CA Thanks: 86 times
Was thanked: 28 time(s) in 23 post(s)
|
To expand on this your data source would need dates, seems obvious but your data doesn't have to have dates.
Maybe what would be more helpful instead of locking into 'dates' is 'ranges'.
So I define a column and then say use 'Row X' to 'Row Y' - This could be dates or anything else.
I could see 'ranges' being used for things like team lineups where the first 11 were on the field and the next 5 were substitutes.
One Title could pull from on the field and one from the substitutes.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 3/20/2014(UTC) Posts: 2,721   Location: Bordeaux, France Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
|
Hi Rich
this is why I'd rather use a real database system than a spreadsheet.
When you work against a DB like SQL or MySQL, you can execute very sophisticated queries to filter results.
You might know James Bowman, he's developped his own CMS for vMix with SQL server. I did quite the same for MySQL.
The most important point is that it is possible to export in realtime these recordsets to XML or JSON through ASP or PHP scripts on a web server so that vMix can use them.
Guillaume
|
 1 user thanked DWAM for this useful post.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 4/4/2016(UTC) Posts: 235 Location: Not Los Angeles CA Thanks: 86 times
Was thanked: 28 time(s) in 23 post(s)
|
DWAM wrote:Hi Rich
this is why I'd rather use a real database system than a spreadsheet.
When you work against a DB like SQL or MySQL, you can execute very sophisticated queries to filter results.
You might know James Bowman, he's developped his own CMS for vMix with SQL server. I did quite the same for MySQL.
The most important point is that it is possible to export in realtime these recordsets to XML or JSON through ASP or PHP scripts on a web server so that vMix can use them.
Guillaume First Awesome Second That makes sense since a database is designed to work with data and doing a realtime conversion to another format for vMix makes perfect sense. Third I was bringing this up as I am using IFTTT to Google Sheets so I will need to pull that data into probably MySQL to do what you are discussing. I will need to see if IFTTT can send directly to a database except I know that they are a pretty closed environment. May need to switch to a different more open product. Rich Shumaker
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 3/20/2014(UTC) Posts: 2,721 Location: Bordeaux, France Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
|
I have not used IFTTT for quite a long time but I'm pretty sure it is possible to inject data to databases.
At worst, I have already used a script to convert and inject spreadsheet data into a database. This is pretty basic stuff. There are tons of solutions to do this.
|
|
|
|
|
|
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
