# Exporting timeline segment descriptions and names **URL:** \ **Category:** Flame Questions\ **Tags:** timeline\ **Created:** [November 7, 2023, 6:56pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443 "2023-11-07T18:56:54Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 7, 2023, 6:56pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/1 "2023-11-07T18:56:54Z")
Hello. I can’t find the post from several weeks ago about this, but I had inquired about exporting timeline segment data to a .csv or .exl, etc. in order to create a shot list from a timeline — segment names and descriptions. Any tips? Thanks. ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 7, 2023, 7:38pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/2 "2023-11-07T19:38:58Z")
\*Segment number, name and description. ---
**Author:** ![PlaceYourBetts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/placeyourbetts/32/6852_2.png) [@PlaceYourBetts](https://forum.logik.tv/u/PlaceYourBetts)\ **Post date:** [November 7, 2023, 8:30pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/3 "2023-11-07T20:30:13Z")
Can you get anything from the conform tab 🤔 ---
**Author:** ![PlaceYourBetts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/placeyourbetts/32/6852_2.png) [@PlaceYourBetts](https://forum.logik.tv/u/PlaceYourBetts)\ **Post date:** [November 7, 2023, 8:31pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/4 "2023-11-07T20:31:21Z")
Or this 🤔 > **[Shot Sheet Maker — Flame Python Scripts](https://www.pyflame.com/python-scripts/shot-sheet-maker)** > > Create excel shot sheet from selected sequence clip ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 7, 2023, 9:13pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/5 "2023-11-07T21:13:56Z")
Hey thanks Richard – this looks like exactly what the doctor ordered. However I’m unable to get it to run without an error “Script path is incorrect. Please reinstall script. Script path should be: /opt/Autodesk/shared/python/script\_template” That path is where I dropped the extracted .zip of Shot Sheet Maker from Dropbox. I’ve tried running it both with and without extracting the .tgz of the Excel script. Any thoughts? ---
**Author:** ![PlaceYourBetts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/placeyourbetts/32/6852_2.png) [@PlaceYourBetts](https://forum.logik.tv/u/PlaceYourBetts)\ **Post date:** [November 7, 2023, 9:16pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/6 "2023-11-07T21:16:17Z")
@MikeV might know the exact meaning of the error ~~but I think it uses an Excel template and injects your data into it. Is the script\_template excel doc in that location 🤔~~ I had this script a good while back but we use NiM to generate shot sheets so I wouldn’t know its quirks. Sorry @GPM EDIT: I have no idea what this means. I see that the dropbox page has a script\_template but this might be a catch all error message. ([Dropbox - \_SCRIPT\_TEMPLATE - Simplify your life](https://www.dropbox.com/sh/xirh0yo3d27upy8/AAAfQN3BF5ciRffw5xME2QSYa/_SCRIPT_TEMPLATE?dl=0&subfolder_nav_tracking=1)) ---
**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\ **Post date:** [November 7, 2023, 9:21pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/7 "2023-11-07T21:21:09Z")
Looks like a typo on my part. The path in that error should be: /opt/Autodesk/shared/python/shot\_sheet\_maker I just updated it on the Portal and Dropbox so this error will now show the correct path. @GPM After you unzip the file from Dropbox to /opt/Autodesk/shared/python your folders should look like this. Do not untar the xlsxwriter-3.0.3.tgz file. The script will handle that the first time you run it. ![image](https://us1.discourse-cdn.com/flex020/uploads/thedepartmentofexternalservices/original/2X/a/a93634bc1e567a23f181bb1542173c446be4a7a6.png) ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 7, 2023, 9:29pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/8 "2023-11-07T21:29:27Z")
Thanks Mike. I’m having no luck. Is the xlsxwriter.tgz supposed to be extracted before launching Flame? I put shot sheet maker folder in the shared/python/ folder. I’m still getting the same error. ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 7, 2023, 9:56pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/9 "2023-11-07T21:56:40Z")
![IMG_9644](https://us1.discourse-cdn.com/flex020/uploads/thedepartmentofexternalservices/original/2X/0/0c8151c4e8df8099eb3c3f90f51d0297dabfc11d.jpeg) ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 7, 2023, 10:03pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/10 "2023-11-07T22:03:43Z")
I must be doing something wrong somewhere… ---
**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\ **Post date:** [November 7, 2023, 10:05pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/11 "2023-11-07T22:05:07Z")
looks like the shot sheet maker folder is missing underscores. It should be shot\_sheet\_maker. With a little further investigation I found out the script I’ve been using to automatically copy scripts over to dropbox after they’ve been added to the Portal has been taking out the underscores in the folder names. I’ve gone through and fixed all the folder names so this error should happen anymore. Gotta fix the script now so that doesn’t happen in the future… ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 8, 2023, 12:00am UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/12 "2023-11-08T00:00:57Z")
Thanks a bunch, Mike – I got it working. This script is already so helpful. I wonder if it’s possible to translate certain TL segment metadata into its own column in xls. For instance, we like having a left column of “Shot #”, then a column of “Start frame” (the start frame of the segment in the TL) and “Shot length”. Is it conceivable that this data could create its own columns in the xls? ---
**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\ **Post date:** [November 8, 2023, 5:43pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/13 "2023-11-08T17:43:44Z")
Yea, if you click on Edit Column Names and change the name to any of the following names it will put that info into the columns: Shot Name Source Name Source Path Source TC Source TC In Source TC Out Record TC Record TC In Record TC Out Shot Length Source Length Comment Right now it doesn’t get the start frame within a timeline, but I’ll see if that’s something I can easily add. ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 8, 2023, 5:51pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/14 "2023-11-08T17:51:51Z")
Wonderful! Thanks so much. ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 8, 2023, 5:54pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/15 "2023-11-08T17:54:19Z")
Does the “comment” field come from marker descriptions? ---
**Author:** ![KuleshovEffect](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/kuleshoveffect/32/4928_2.png) [@KuleshovEffect](https://forum.logik.tv/u/KuleshovEffect)\ **Post date:** [November 9, 2023, 5:48pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/16 "2023-11-09T17:48:22Z")
That was a feature I requested! If you right click on a segment in the timeline, there’s a “Comment” option. That’s what the Comment field pulls from. I think I used it to store the original camera file name. -Ted ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 9, 2023, 6:06pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/17 "2023-11-09T18:06:02Z")
Thanks Ted! ---
**Author:** ![Slabrie](https://avatars.discourse-cdn.com/v4/letter/s/7cd45c/32.png) [@Slabrie](https://forum.logik.tv/u/Slabrie)\ **Post date:** [November 10, 2023, 11:32am UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/18 "2023-11-10T11:32:55Z")
Since we are between friends, let me share a secret with you! -Open the sequence -Go to Conform -Select the columns you would like to be part of an exported file -right click on the columns header -select Export (the option is located at the bottom of the drop down) -an XML file is waiting for you! -Enjoy ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 10, 2023, 3:20pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/19 "2023-11-10T15:20:25Z")
Thanks Stephane! We will try this. ---
**Author:** ![GPM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/gpm/32/4224_2.png) [@GPM](https://forum.logik.tv/u/GPM)\ **Post date:** [November 10, 2023, 3:21pm UTC](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443/20 "2023-11-10T15:21:24Z")
What about converting the XML to a csv or xls that can be imported into Google Sheets? [Next page](https://forum.logik.tv/t/exporting-timeline-segment-descriptions-and-names/9443.md?page=2)