We have the google drive app loaded on our Xpression Studio PC, and put our excel file in there.
The Drive app lets google drive show up as a mounted drive, in our case G:\
Then we were able to share that excel .xlsx file with others to populate like a normal excel shared file Our datalinq was pointed to the version on our studio PC G:\, and whenever drive would update the shared file- usually once every minute or so, it would be in datalinq. For stats you might have to refresh or find a way to make it update quicker. And we were able to use the AODB excel thing. It worked out pretty well.
-Jay Cofield, Ph.D.
Professor of Mass Communication
The University of Montevallo
205-665-6624
cofieldj@montevallo.edu
Original Message:
Sent: 12/10/2024 2:48:00 PM
From: JOSHUA KEAGY
Subject: RE: Stats Workflow
As soon as I saw that I checked the version, its 10.5 so yeah its like you guys are saying, specific to version. I built the sheet and went to add it to datalinq, it only gives XML or JSON, no text option.
I can drive the suggestion of getting the google drive app downloaded and using excel with it?
Thanks for the input!
------------------------------
JOSHUA KEAGY
Xpression operator
Blue Ridge 11
------------------------------
Original Message:
Sent: 12-04-2024 10:33
From: Garner Millward
Subject: Stats Workflow
XPression version 11.5 supports Google Sheets natively and you can see a tutorial video here: XPression U Google Sheets
If you are running an older version of XPression let us know.
Original Message:
Sent: 12-03-2024 12:48
From: JOSHUA KEAGY
Subject: Stats Workflow
We were able to crew an extra person on site to keep a statbook for our local basketball productions.
How could I best utilize this info?
Google sheet w/API Key, "shared" excel sheet, or a stats website via xml datalinq? I only know how to config the google sheet, I have a lot to learn.
Open for any suggestions, thanks for the input!
------------------------------
JOSHUA KEAGY
Xpression operator
Blue Ridge 11
------------------------------