Graphics

I'm looking for an automated way to export the data from TakeIDs into a .csv file. I have found that I can manually right click and export a csv file which takes the entire sequencer list. Is there a way to export just a range of TakeIDs so I don't have to take our hundreds of takeIDs? 

I would also like to find a way to datalinq but instead of pulling in data I will want to export that data so another program can read what is in it. I know Dashboard can do this as it has an Xpression interface panel. I would like to populate a Google Sheet with our TakeID data of around 20 on average names of people. 

We first type the names in Inception and send them into Xpression. I would like to keep it a one way link so that the data being sent to google sheet can only be read and cannot be modified by accident on the sheet and fed back into Xpression incorrectly. 

At minimum, I am trying for as minimal clicks as possible by the operator to export the takeID data into a .csv and a google app script can handle the rest if the .csv is created.

------------------------------
John Kimball
Video Production
Legislative
------------------------------

The asRun logs include the data as they are taken off air, would that be useful? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------

Thank you Simon for the thought. In this case, I would need to capture the sequencer list before I take an item on or off air. It would be in a pre-production planning situation. 

------------------------------
John Kimball
Video Production
Legislative
------------------------------

Original Message:
Sent: 03-06-2025 07:03
From: Simon Redmile
Subject: Xpression Sequencer List Data Export

The asRun logs include the data as they are taken off air, would that be useful? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------

Hey John,

I went to e-mail back and saw your inbox was full. I'm just going to post my message and scripts here to make sure you get them. 

For the first script (where we call the group by name):

Yes, you can absolutely copy and paste the script, and alter the group name. Just change the string between the quotes here:

engine.Sequencer.GetGroupByName("myTakeItemGroup", desiredGroup)

In general:

You can trigger the script via a button press using the Keyboard/GPI mapping. I used CTRL+Numpad 9, for example. 
 
You can drag in as many script actions as you'd like to the map, and name them based on the group you're saving. 

Understanding your use case better (20+ groups that need exporting), I made a version of my initial script to just get every group in the sequencer and export them. You'll still need to change the filepath and xml to csv. I've also fixed the initial script, because I noticed that it wasn't grabbing the group itself when exporting. 

Best,

Flint
 

------------------------------
Flint Gleeson
Technical Support Product Prime - Xpression
Ross Video
------------------------------

Original Message:
Sent: 03-10-2025 16:23
From: John Kimball
Subject: Xpression Sequencer List Data Export

Thank you Simon for the thought. In this case, I would need to capture the sequencer list before I take an item on or off air. It would be in a pre-production planning situation. 

------------------------------
John Kimball
Video Production
Legislative
------------------------------


Original Message:
Sent: 03-06-2025 07:03
From: Simon Redmile
Subject: Xpression Sequencer List Data Export

The asRun logs include the data as they are taken off air, would that be useful? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom