Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Filtering input of XML with XSLT using preceding-sibling

nycpost
in Importing & Exporting

Featured Replies

Hi All,

I have an XML doc that I need to import into FMP. The document lists multiple "Event" elements. Sometimes these Event elements are followed by a "Comment" element. I want to filter the XML on import so only those Events who are followed by a Comment are imported.

I'm trying to use the "for-each" expression in conjunction with the "preceding-sibling" axis to select the correct nodes, but it fails to pull any values from the XML. Below is an example of the XML I'm using and the XSLT. Can anyone shed any light on the proper syntax for this?

Much appreciated,

Mike

XML:


<?xml version="1.0" encoding="UTF-8"?>

<FilmScribeFile Version="1.0" Date="Oct. 25, 2008">

<AssembleList>

<ListHead>

<Title>TEST</Title>

<Tracks>V1</Tracks>

<EventCount>23</EventCount>

<OpticalCount>0</OpticalCount>

<DupeCount>0</DupeCount>

<MasterDuration><FrameCount>4347</FrameCount>

<Edgecode Type="Master" Film="Total Frames">0271+11</Edgecode>

<Timecode Type="TC1">00:03:01:02</Timecode>

</MasterDuration>

<SrcDur></SrcDur>

<MediaFile></MediaFile>

<VideoConform>KN Start</VideoConform>

<AudioConform>Aux Ink</AudioConform>

<LFOA><Edgecode Type="Master" Film="Total Frames">0271+11</Edgecode>

</LFOA>

<EditRate>24</EditRate>

<Resolution>24</Resolution>

</ListHead>

<Events>

<Event Num="1"  Type="Cut" Length="192" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:00:00</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0000+00</Edgecode>

<Frame>0</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:07:23</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0011+15</Edgecode>

<Frame>191</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:08:00</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>Academy.mov</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d22be90-eafa-0151-060e2b347f7f2a80}</MobID>

<Start>

<Frame>604800</Frame>

<Timecode Type="Start TC">07:00:00:00</Timecode>

</Start>

<End>

<Frame>604991</Frame>

<Timecode Type="Start TC">07:00:07:23</Timecode>

</End>

<EndOut>

<Timecode Type="Start TC">07:00:08:00</Timecode>

</EndOut>

<UNC>PI CRUZER:Academy.mov</UNC>

<Custom Name="UNC Path">PI CRUZER:Academy.mov</Custom>

<TapeName>Academy.mov</TapeName>

</Source>

</Event>

<Event Num="2"  Type="Cut" Length="116" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:08:00</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0012+00</Edgecode>

<Frame>192</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:12:19</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0019+03</Edgecode>

<Frame>307</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:12:20</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88(X)F-5</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4dc2ae5b-43b7-0023-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1212870</Frame>

<Timecode Type="Start TC">14:02:16:06</Timecode>

<Timecode Type="Aux TC1">14:02:16:06</Timecode>

<Timecode Type="Aux TC2">14:02:16:06</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD06207-5804+06</Edgecode>

<Edgecode Type="DPX">X88F_5-0001186</Edgecode>

</Start>

<End>

<Frame>1212985</Frame>

<Timecode Type="Start TC">14:02:21:01</Timecode>

<Timecode Type="Aux TC1">14:02:21:01</Timecode>

<Timecode Type="Aux TC2">14:02:21:01</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD06207-5811+09</Edgecode>

<Edgecode Type="DPX">X88F_5-0001301</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">14:02:21:02</Timecode>

<Timecode Type="Aux TC1">14:02:21:02</Timecode>

<Timecode Type="Aux TC2">14:02:21:02</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.2764 1.2762 1.2764)(-0.1295 -0.1295 -0.1296)(0.9882 0.9881 0.9881)</ASC_SOP>

<ASC_SAT>1.3120</ASC_SAT>

<Custom Name="Tech Notes All">MOS</Custom>

<Custom Name="Description">Cu Pi&apos;s hands tie knots</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>MOS</LabRoll>

<CamRoll>XD62</CamRoll>

<SoundRoll>MOS</SoundRoll>

<TapeName>XD62</TapeName>

<SceneTake>X88F/5</SceneTake>

</Source>

</Event>

<Event Num="3"  Type="Cut" Length="519" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:12:20</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0019+04</Edgecode>

<Frame>308</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:34:10</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0051+10</Edgecode>

<Frame>826</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:34:11</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88-8</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d7f59a5-0363-0509-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1008423</Frame>

<Timecode Type="Start TC">11:40:17:15</Timecode>

<Timecode Type="Aux TC1">11:40:17:15</Timecode>

<Timecode Type="Aux TC2">11:40:17:15</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06206-3026+07</Edgecode>

<Edgecode Type="DPX">88_8-0000416</Edgecode>

</Start>

<End>

<Frame>1008941</Frame>

<Timecode Type="Start TC">11:40:39:05</Timecode>

<Timecode Type="Aux TC1">11:40:39:05</Timecode>

<Timecode Type="Aux TC2">11:40:39:05</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06206-3058+13</Edgecode>

<Edgecode Type="DPX">88_8-0000934</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">11:40:39:06</Timecode>

<Timecode Type="Aux TC1">11:40:39:06</Timecode>

<Timecode Type="Aux TC2">11:40:39:06</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.2231 1.1970 1.2063)(-0.0647 -0.0652 -0.0471)(0.9892 1.0048 0.9929)</ASC_SOP>

<ASC_SAT>1.1915</ASC_SAT>

<Custom Name="Description">WS Pi, Hyena attacks OJ-MCU Pi</Custom>

<Custom Name="VFX #">hao0192/0210</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0308</LabRoll>

<CamRoll>C062</CamRoll>

<SoundRoll>072</SoundRoll>

<TapeName>C062</TapeName>

<SceneTake>88/08</SceneTake>

</Source>

</Event>

<Event Num="4"  Type="Cut" Length="86" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:34:11</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0051+11</Edgecode>

<Frame>827</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:38:00</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0057+00</Edgecode>

<Frame>912</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:38:01</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88(X)-2</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4da3d9ca-0712-0076-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1337134</Frame>

<Timecode Type="Start TC">15:28:33:22</Timecode>

<Timecode Type="Aux TC1">15:28:33:22</Timecode>

<Timecode Type="Aux TC2">15:28:33:22</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD02708-3570+14</Edgecode>

<Edgecode Type="DPX">X88_2-0000635</Edgecode>

</Start>

<End>

<Frame>1337219</Frame>

<Timecode Type="Start TC">15:28:37:11</Timecode>

<Timecode Type="Aux TC1">15:28:37:11</Timecode>

<Timecode Type="Aux TC2">15:28:37:11</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD02708-3576+03</Edgecode>

<Edgecode Type="DPX">X88_2-0000720</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">15:28:37:12</Timecode>

<Timecode Type="Aux TC1">15:28:37:12</Timecode>

<Timecode Type="Aux TC2">15:28:37:12</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.3038 1.3040 1.3039)(-0.1134 -0.1136 -0.1135)(0.8933 0.8933 0.8932)</ASC_SOP>

<ASC_SAT>1.3005</ASC_SAT>

<Custom Name="Tech Notes All">MOS</Custom>

<Custom Name="Description">VFX Clean Plate</Custom>

<Custom Name="VFX #">hao0150</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>MOS</LabRoll>

<CamRoll>XD27</CamRoll>

<SoundRoll>REF</SoundRoll>

<TapeName>XD27</TapeName>

<SceneTake>X88/02</SceneTake>

</Source>

</Event>

<Event Num="5"  Type="Cut" Length="53" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:38:01</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0057+01</Edgecode>

<Frame>913</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:40:05</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0060+05</Edgecode>

<Frame>965</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:40:06</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88(X)E-4</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4dbe4e1a-c3a8-10cd-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1387403</Frame>

<Timecode Type="Start TC">16:03:28:11</Timecode>

<Timecode Type="Aux TC1">16:03:28:11</Timecode>

<Timecode Type="Aux TC2">16:03:28:11</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD05908-6712+11</Edgecode>

<Edgecode Type="DPX">X88E_4-0007156</Edgecode>

</Start>

<End>

<Frame>1387455</Frame>

<Timecode Type="Start TC">16:03:30:15</Timecode>

<Timecode Type="Aux TC1">16:03:30:15</Timecode>

<Timecode Type="Aux TC2">16:03:30:15</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD05908-6715+15</Edgecode>

<Edgecode Type="DPX">X88E_4-0007208</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">16:03:30:16</Timecode>

<Timecode Type="Aux TC1">16:03:30:16</Timecode>

<Timecode Type="Aux TC2">16:03:30:16</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.2950 1.2950 1.2950)(-0.1330 -0.1330 -0.1330)(0.9579 0.9579 0.9579)</ASC_SOP>

<ASC_SAT>1.2370</ASC_SAT>

<Custom Name="Tech Notes All">MOS</Custom>

<Custom Name="Description">VFX Clean Plate, OJ hits Hyena HA00150</Custom>

<Custom Name="cut">c</Custom>

<Custom Name="Element">VFX Clean Plate, OJ hits Hyena HA00150</Custom>

<LabRoll>MOS</LabRoll>

<CamRoll>XD59</CamRoll>

<SoundRoll>MOS</SoundRoll>

<TapeName>XD59</TapeName>

<SceneTake>X88E/4</SceneTake>

</Source>

</Event>

<Event Num="6"  Type="Cut" Length="74" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:40:06</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0060+06</Edgecode>

<Frame>966</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:43:07</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0064+15</Edgecode>

<Frame>1039</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:43:08</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88-7</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d7f59a9-11b3-0509-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1000145</Frame>

<Timecode Type="Start TC">11:34:32:17</Timecode>

<Timecode Type="Aux TC1">11:34:32:17</Timecode>

<Timecode Type="Aux TC2">11:34:32:17</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06206-2509+01</Edgecode>

<Edgecode Type="DPX">88_7-0001038</Edgecode>

</Start>

<End>

<Frame>1000218</Frame>

<Timecode Type="Start TC">11:34:35:18</Timecode>

<Timecode Type="Aux TC1">11:34:35:18</Timecode>

<Timecode Type="Aux TC2">11:34:35:18</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06206-2513+10</Edgecode>

<Edgecode Type="DPX">88_7-0001111</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">11:34:35:19</Timecode>

<Timecode Type="Aux TC1">11:34:35:19</Timecode>

<Timecode Type="Aux TC2">11:34:35:19</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.1116 1.0880 1.0850)(-0.0165 -0.0190 0.0025)(0.9618 0.9807 0.9670)</ASC_SOP>

<ASC_SAT>1.1920</ASC_SAT>

<Custom Name="Description">WS Pi, Hyena attacks OJ-MCU Pi</Custom>

<Custom Name="VFX #">hao0192/0210</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0308</LabRoll>

<CamRoll>C062</CamRoll>

<SoundRoll>072</SoundRoll>

<TapeName>C062</TapeName>

<SceneTake>88/07</SceneTake>

</Source>

</Event>

<Event Num="7"  Type="Cut" Length="120" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:43:08</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0065+00</Edgecode>

<Frame>1040</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:48:07</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0072+07</Edgecode>

<Frame>1159</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:48:08</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88(X)B-2</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4da3f7cf-47fd-00eb-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1496958</Frame>

<Timecode Type="Start TC">17:19:33:06</Timecode>

<Timecode Type="Aux TC1">17:19:33:06</Timecode>

<Timecode Type="Aux TC2">17:19:33:06</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD02809-3559+14</Edgecode>

<Edgecode Type="DPX">X88B_2-0000153</Edgecode>

</Start>

<End>

<Frame>1497077</Frame>

<Timecode Type="Start TC">17:19:38:05</Timecode>

<Timecode Type="Aux TC1">17:19:38:05</Timecode>

<Timecode Type="Aux TC2">17:19:38:05</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD02809-3567+05</Edgecode>

<Edgecode Type="DPX">X88B_2-0000272</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">17:19:38:06</Timecode>

<Timecode Type="Aux TC1">17:19:38:06</Timecode>

<Timecode Type="Aux TC2">17:19:38:06</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.3038 1.3040 1.3039)(-0.1134 -0.1136 -0.1135)(0.8933 0.8933 0.8932)</ASC_SOP>

<ASC_SAT>1.3005</ASC_SAT>

<Custom Name="Soundroll">MOS</Custom>

<Custom Name="Tech Notes All">MOS</Custom>

<Custom Name="Description">VFX Plate, PI Pov of OJ</Custom>

<Custom Name="VFX #">hao 0182</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>MOS</LabRoll>

<CamRoll>XD28</CamRoll>

<SoundRoll>MOS</SoundRoll>

<TapeName>XD28</TapeName>

<SceneTake>X88B/2</SceneTake>

</Source>

</Event>

<Event Num="8"  Type="Cut" Length="48" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:48:08</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0072+08</Edgecode>

<Frame>1160</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:50:07</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0075+07</Edgecode>

<Frame>1207</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:50:08</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88D-3</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d83a6af-b08a-0098-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1778732</Frame>

<Timecode Type="Start TC">20:35:13:20</Timecode>

<Timecode Type="Aux TC1">20:35:13:20</Timecode>

<Timecode Type="Aux TC2">20:35:13:20</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00A07411-1170+12</Edgecode>

<Edgecode Type="DPX">88D_3-0000861</Edgecode>

</Start>

<End>

<Frame>1778779</Frame>

<Timecode Type="Start TC">20:35:15:19</Timecode>

<Timecode Type="Aux TC1">20:35:15:19</Timecode>

<Timecode Type="Aux TC2">20:35:15:19</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00A07411-1173+11</Edgecode>

<Edgecode Type="DPX">88D_3-0000908</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">20:35:15:20</Timecode>

<Timecode Type="Aux TC1">20:35:15:20</Timecode>

<Timecode Type="Aux TC2">20:35:15:20</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.1213 1.1161 1.1172)(-0.0689 -0.0692 -0.0659)(0.9883 0.9904 0.9901)</ASC_SOP>

<ASC_SAT>1.1740</ASC_SAT>

<Custom Name="Description">CU Pi for yes,no</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0316</LabRoll>

<CamRoll>A074</CamRoll>

<SoundRoll>080</SoundRoll>

<TapeName>A074</TapeName>

<SceneTake>88D/03</SceneTake>

</Source>

</Event>

<Comment Type="Locator"><Color></Color>

<Master><Timecode Type="TC1">04:00:49:00</Timecode>

<Frame>1176</Frame>

</Master>

<Source><ClipName>88D-3</ClipName>

<Timecode Type="Start TC">20:35:14:12</Timecode>

<Timecode Type="Aux TC1">20:35:14:12</Timecode>

<Timecode Type="Aux TC2">20:35:14:12</Timecode>

</Source>

<Text>OA060 - R&amp;H - recon +4</Text></Comment>

<Event Num="9"  Type="Cut" Length="55" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:50:08</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0075+08</Edgecode>

<Frame>1208</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:52:14</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0078+14</Edgecode>

<Frame>1262</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:52:15</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88(X)A-1</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4da3e0c5-4a00-0091-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1470598</Frame>

<Timecode Type="Start TC">17:01:14:22</Timecode>

<Timecode Type="Aux TC1">17:01:14:22</Timecode>

<Timecode Type="Aux TC2">17:01:14:22</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD02809-1912+06</Edgecode>

<Edgecode Type="DPX">X88A_1-0001038</Edgecode>

</Start>

<End>

<Frame>1470652</Frame>

<Timecode Type="Start TC">17:01:17:04</Timecode>

<Timecode Type="Aux TC1">17:01:17:04</Timecode>

<Timecode Type="Aux TC2">17:01:17:04</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD02809-1915+12</Edgecode>

<Edgecode Type="DPX">X88A_1-0001092</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">17:01:17:05</Timecode>

<Timecode Type="Aux TC1">17:01:17:05</Timecode>

<Timecode Type="Aux TC2">17:01:17:05</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.3038 1.3040 1.3039)(-0.1134 -0.1136 -0.1135)(0.8933 0.8933 0.8932)</ASC_SOP>

<ASC_SAT>1.3005</ASC_SAT>

<Custom Name="Description">VFX Plate for HA00190</Custom>

<Custom Name="Tech Notes All">MOS</Custom>

<Custom Name="VFX #">hao0190</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>MOS</LabRoll>

<CamRoll>XD28</CamRoll>

<SoundRoll>MOS</SoundRoll>

<TapeName>XD28</TapeName>

<SceneTake>X88A/01</SceneTake>

</Source>

</Event>

<Event Num="10"  Type="Cut" Length="42" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:52:15</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0078+15</Edgecode>

<Frame>1263</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:54:08</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0081+08</Edgecode>

<Frame>1304</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:54:09</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88D-4</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d83a6ab-a041-0098-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1786414</Frame>

<Timecode Type="Start TC">20:40:33:22</Timecode>

<Timecode Type="Aux TC1">20:40:33:22</Timecode>

<Timecode Type="Aux TC2">20:40:33:22</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00A07411-1650+14</Edgecode>

<Edgecode Type="DPX">88D_4-0004422</Edgecode>

</Start>

<End>

<Frame>1786455</Frame>

<Timecode Type="Start TC">20:40:35:15</Timecode>

<Timecode Type="Aux TC1">20:40:35:15</Timecode>

<Timecode Type="Aux TC2">20:40:35:15</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00A07411-1653+07</Edgecode>

<Edgecode Type="DPX">88D_4-0004463</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">20:40:35:16</Timecode>

<Timecode Type="Aux TC1">20:40:35:16</Timecode>

<Timecode Type="Aux TC2">20:40:35:16</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.1213 1.1161 1.1172)(-0.0689 -0.0692 -0.0659)(0.9883 0.9904 0.9901)</ASC_SOP>

<ASC_SAT>1.1740</ASC_SAT>

<Custom Name="Description">CU Pi for yes,no</Custom>

<Custom Name="Tech Notes All">Restarts</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0316</LabRoll>

<CamRoll>A074</CamRoll>

<SoundRoll>080</SoundRoll>

<TapeName>A074</TapeName>

<SceneTake>88D/04</SceneTake>

</Source>

</Event>

<Event Num="11"  Type="Cut" Length="70" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:54:09</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0081+09</Edgecode>

<Frame>1305</Frame>

</Start>

<End>

<Timecode Type="TC1">04:00:57:06</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0085+14</Edgecode>

<Frame>1374</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:00:57:07</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88(X)A-1</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4da3e0c5-4a00-0091-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1470707</Frame>

<Timecode Type="Start TC">17:01:19:11</Timecode>

<Timecode Type="Aux TC1">17:01:19:11</Timecode>

<Timecode Type="Aux TC2">17:01:19:11</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD02809-1919+03</Edgecode>

<Edgecode Type="DPX">X88A_1-0001147</Edgecode>

</Start>

<End>

<Frame>1470776</Frame>

<Timecode Type="Start TC">17:01:22:08</Timecode>

<Timecode Type="Aux TC1">17:01:22:08</Timecode>

<Timecode Type="Aux TC2">17:01:22:08</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD02809-1923+08</Edgecode>

<Edgecode Type="DPX">X88A_1-0001216</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">17:01:22:09</Timecode>

<Timecode Type="Aux TC1">17:01:22:09</Timecode>

<Timecode Type="Aux TC2">17:01:22:09</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.3038 1.3040 1.3039)(-0.1134 -0.1136 -0.1135)(0.8933 0.8933 0.8932)</ASC_SOP>

<ASC_SAT>1.3005</ASC_SAT>

<Custom Name="Description">VFX Plate for HA00190</Custom>

<Custom Name="Tech Notes All">MOS</Custom>

<Custom Name="VFX #">hao0190</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>MOS</LabRoll>

<CamRoll>XD28</CamRoll>

<SoundRoll>MOS</SoundRoll>

<TapeName>XD28</TapeName>

<SceneTake>X88A/01</SceneTake>

</Source>

</Event>

<Event Num="12"  Type="Cut" Length="109" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:00:57:07</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0085+15</Edgecode>

<Frame>1375</Frame>

</Start>

<End>

<Timecode Type="TC1">04:01:01:19</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0092+11</Edgecode>

<Frame>1483</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:01:01:20</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88-7</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d7f59a9-11b3-0509-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1000416</Frame>

<Timecode Type="Start TC">11:34:44:00</Timecode>

<Timecode Type="Aux TC1">11:34:44:00</Timecode>

<Timecode Type="Aux TC2">11:34:44:00</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06206-2526+00</Edgecode>

<Edgecode Type="DPX">88_7-0001309</Edgecode>

</Start>

<End>

<Frame>1000524</Frame>

<Timecode Type="Start TC">11:34:48:12</Timecode>

<Timecode Type="Aux TC1">11:34:48:12</Timecode>

<Timecode Type="Aux TC2">11:34:48:12</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06206-2532+12</Edgecode>

<Edgecode Type="DPX">88_7-0001417</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">11:34:48:13</Timecode>

<Timecode Type="Aux TC1">11:34:48:13</Timecode>

<Timecode Type="Aux TC2">11:34:48:13</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.1116 1.0880 1.0850)(-0.0165 -0.0190 0.0025)(0.9618 0.9807 0.9670)</ASC_SOP>

<ASC_SAT>1.1920</ASC_SAT>

<Custom Name="Description">WS Pi, Hyena attacks OJ-MCU Pi</Custom>

<Custom Name="VFX #">hao0192/0210</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0308</LabRoll>

<CamRoll>C062</CamRoll>

<SoundRoll>072</SoundRoll>

<TapeName>C062</TapeName>

<SceneTake>88/07</SceneTake>

</Source>

</Event>

<Event Num="13"  Type="Cut" Length="228" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:01:01:20</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0092+12</Edgecode>

<Frame>1484</Frame>

</Start>

<End>

<Timecode Type="TC1">04:01:11:07</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0106+15</Edgecode>

<Frame>1711</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:01:11:08</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88(X)C-8</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4da5241a-1c16-040f-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1376055</Frame>

<Timecode Type="Start TC">15:55:35:15</Timecode>

<Timecode Type="Aux TC1">15:55:35:15</Timecode>

<Timecode Type="Aux TC2">15:55:35:15</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD03008-6003+07</Edgecode>

<Edgecode Type="DPX">X88C_8-0000823</Edgecode>

</Start>

<End>

<Frame>1376282</Frame>

<Timecode Type="Start TC">15:55:45:02</Timecode>

<Timecode Type="Aux TC1">15:55:45:02</Timecode>

<Timecode Type="Aux TC2">15:55:45:02</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD03008-6017+10</Edgecode>

<Edgecode Type="DPX">X88C_8-0001050</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">15:55:45:03</Timecode>

<Timecode Type="Aux TC1">15:55:45:03</Timecode>

<Timecode Type="Aux TC2">15:55:45:03</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.3411 1.3413 1.3412)(-0.1134 -0.1136 -0.1135)(0.8862 0.8862 0.8861)</ASC_SOP>

<ASC_SAT>1.3005</ASC_SAT>

<Custom Name="Soundroll">MOS</Custom>

<Custom Name="Tech Notes All">Something on mirror in Right eye</Custom>

<Custom Name="Description">VFX plate zebra Stuffy only</Custom>

<Custom Name="cut">c</Custom>

<Custom Name="Element">VFX plate zebra Stuffy only</Custom>

<LabRoll>MOS</LabRoll>

<CamRoll>XD30</CamRoll>

<SoundRoll>MOS</SoundRoll>

<TapeName>XD30</TapeName>

<SceneTake>X88C/08</SceneTake>

</Source>

</Event>

<Comment Type="Locator"><Color></Color>

<Master><Timecode Type="TC1">04:01:07:07</Timecode>

<Frame>1615</Frame>

</Master>

<Source><ClipName>88(X)C-8</ClipName>

<Timecode Type="Start TC">15:55:41:02</Timecode>

<Timecode Type="Aux TC1">15:55:41:02</Timecode>

<Timecode Type="Aux TC2">15:55:41:02</Timecode>

</Source>

<Text>OA110 - R&amp;H - recon -4 , please increase IO</Text></Comment>

<Event Num="14"  Type="Cut" Length="112" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:01:11:08</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0107+00</Edgecode>

<Frame>1712</Frame>

</Start>

<End>

<Timecode Type="TC1">04:01:15:23</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0113+15</Edgecode>

<Frame>1823</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:01:16:00</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88B-2</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d7a8798-324a-0169-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1101610</Frame>

<Timecode Type="Start TC">12:45:00:10</Timecode>

<Timecode Type="Aux TC1">12:45:00:10</Timecode>

<Timecode Type="Aux TC2">12:45:00:10</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00A06906-8850+10</Edgecode>

<Edgecode Type="DPX">88B_2-0003057</Edgecode>

</Start>

<End>

<Frame>1101721</Frame>

<Timecode Type="Start TC">12:45:05:01</Timecode>

<Timecode Type="Aux TC1">12:45:05:01</Timecode>

<Timecode Type="Aux TC2">12:45:05:01</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00A06906-8857+09</Edgecode>

<Edgecode Type="DPX">88B_2-0003168</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">12:45:05:02</Timecode>

<Timecode Type="Aux TC1">12:45:05:02</Timecode>

<Timecode Type="Aux TC2">12:45:05:02</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.2548 1.2461 1.2470)(-0.0847 -0.0839 -0.0834)(0.9587 0.9760 0.9716)</ASC_SOP>

<ASC_SAT>1.1915</ASC_SAT>

<Custom Name="Description">MCU Pi with knife</Custom>

<Custom Name="Tech Notes All">Restarts</Custom>

<Custom Name="VFX #">hao0235</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0309</LabRoll>

<CamRoll>A069</CamRoll>

<SoundRoll>073</SoundRoll>

<TapeName>A069</TapeName>

<SceneTake>88B/02</SceneTake>

</Source>

</Event>

<Comment Type="Locator"><Color></Color>

<Master><Timecode Type="TC1">04:01:14:06</Timecode>

<Frame>1782</Frame>

</Master>

<Source><ClipName>88B-2</ClipName>

<Timecode Type="Start TC">12:45:03:08</Timecode>

<Timecode Type="Aux TC1">12:45:03:08</Timecode>

<Timecode Type="Aux TC2">12:45:03:08</Timecode>

</Source>

<Text>OA120 - R&amp;H - recon -4</Text></Comment>

<Event Num="15"  Type="Cut" Length="60" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:01:16:00</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0114+00</Edgecode>

<Frame>1824</Frame>

</Start>

<End>

<Timecode Type="TC1">04:01:18:11</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0117+11</Edgecode>

<Frame>1883</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:01:18:12</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88(X)C-7</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4da5241e-2ba6-040f-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1366900</Frame>

<Timecode Type="Start TC">15:49:14:04</Timecode>

<Timecode Type="Aux TC1">15:49:14:04</Timecode>

<Timecode Type="Aux TC2">15:49:14:04</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD03008-5431+04</Edgecode>

<Edgecode Type="DPX">X88C_7-0002246</Edgecode>

</Start>

<End>

<Frame>1366959</Frame>

<Timecode Type="Start TC">15:49:16:15</Timecode>

<Timecode Type="Aux TC1">15:49:16:15</Timecode>

<Timecode Type="Aux TC2">15:49:16:15</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">0XD03008-5434+15</Edgecode>

<Edgecode Type="DPX">X88C_7-0002305</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">15:49:16:16</Timecode>

<Timecode Type="Aux TC1">15:49:16:16</Timecode>

<Timecode Type="Aux TC2">15:49:16:16</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.3411 1.3413 1.3412)(-0.1134 -0.1136 -0.1135)(0.8862 0.8862 0.8861)</ASC_SOP>

<ASC_SAT>1.3005</ASC_SAT>

<Custom Name="Soundroll">MOS</Custom>

<Custom Name="Tech Notes All">Something on mirror in Right eye</Custom>

<Custom Name="Description">VFX plate, OJ Stuffies</Custom>

<Custom Name="cut">c</Custom>

<Custom Name="Element">VFX plate, OJ Stuffies</Custom>

<LabRoll>MOS</LabRoll>

<CamRoll>XD30</CamRoll>

<SoundRoll>MOS</SoundRoll>

<TapeName>XD30</TapeName>

<SceneTake>X88C/07</SceneTake>

</Source>

</Event>

<Comment Type="Locator"><Color></Color>

<Master><Timecode Type="TC1">04:01:17:07</Timecode>

<Frame>1855</Frame>

</Master>

<Source><ClipName>88(X)C-7</ClipName>

<Timecode Type="Start TC">15:49:15:11</Timecode>

<Timecode Type="Aux TC1">15:49:15:11</Timecode>

<Timecode Type="Aux TC2">15:49:15:11</Timecode>

</Source>

<Text>OA125 - R&amp;H - recon -2</Text></Comment>

<Event Num="16"  Type="Cut" Length="143" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:01:18:12</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0117+12</Edgecode>

<Frame>1884</Frame>

</Start>

<End>

<Timecode Type="TC1">04:01:24:10</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0126+10</Edgecode>

<Frame>2026</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:01:24:11</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88C-4</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d7a87b3-9bda-0169-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1196593</Frame>

<Timecode Type="Start TC">13:50:58:01</Timecode>

<Timecode Type="Aux TC1">13:50:58:01</Timecode>

<Timecode Type="Aux TC2">13:50:58:01</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06307-4787+01</Edgecode>

<Edgecode Type="DPX">88C_4-0001389</Edgecode>

</Start>

<End>

<Frame>1196735</Frame>

<Timecode Type="Start TC">13:51:03:23</Timecode>

<Timecode Type="Aux TC1">13:51:03:23</Timecode>

<Timecode Type="Aux TC2">13:51:03:23</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06307-4795+15</Edgecode>

<Edgecode Type="DPX">88C_4-0001531</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">13:51:04:00</Timecode>

<Timecode Type="Aux TC1">13:51:04:00</Timecode>

<Timecode Type="Aux TC2">13:51:04:00</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.1849 1.1944 1.1905)(-0.0694 -0.0771 -0.0725)(0.9672 0.9743 0.9721)</ASC_SOP>

<ASC_SAT>1.1660</ASC_SAT>

<Custom Name="Description">WS Pi with knife, RP emerges</Custom>

<Custom Name="Tech Notes All">Restart</Custom>

<Custom Name="VFX #">hao1020</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0309</LabRoll>

<CamRoll>C063</CamRoll>

<SoundRoll>073</SoundRoll>

<TapeName>C063</TapeName>

<SceneTake>88C/04</SceneTake>

</Source>

</Event>

<Comment Type="Locator"><Color></Color>

<Master><Timecode Type="TC1">04:01:23:18</Timecode>

<Frame>2010</Frame>

</Master>

<Source><ClipName>88C-4</ClipName>

<Timecode Type="Start TC">13:51:03:07</Timecode>

<Timecode Type="Aux TC1">13:51:03:07</Timecode>

<Timecode Type="Aux TC2">13:51:03:07</Timecode>

</Source>

<Text>OA130 - R&amp;H - recon +4</Text></Comment>

<Event Num="17"  Type="Cut" Length="631" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:01:24:11</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0126+11</Edgecode>

<Frame>2027</Frame>

</Start>

<End>

<Timecode Type="TC1">04:01:50:17</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0166+01</Edgecode>

<Frame>2657</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:01:50:18</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88A-6</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d7f5993-bd53-0508-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1538281</Frame>

<Timecode Type="Start TC">17:48:15:01</Timecode>

<Timecode Type="Aux TC1">17:48:15:01</Timecode>

<Timecode Type="Aux TC2">17:48:15:01</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06209-6142+09</Edgecode>

<Edgecode Type="DPX">88A_6-0000352</Edgecode>

</Start>

<End>

<Frame>1538911</Frame>

<Timecode Type="Start TC">17:48:41:07</Timecode>

<Timecode Type="Aux TC1">17:48:41:07</Timecode>

<Timecode Type="Aux TC2">17:48:41:07</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06209-6181+15</Edgecode>

<Edgecode Type="DPX">88A_6-0000982</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">17:48:41:08</Timecode>

<Timecode Type="Aux TC1">17:48:41:08</Timecode>

<Timecode Type="Aux TC2">17:48:41:08</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.2037 1.2593 1.2417)(-0.0316 -0.0485 -0.0279)(1.0187 1.0287 1.0393)</ASC_SOP>

<ASC_SAT>1.1915</ASC_SAT>

<Custom Name="Description">WS Pi,RP kills Hyena, Pi jumps on raft</Custom>

<Custom Name="VFX #">hao1030</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0308</LabRoll>

<CamRoll>C062</CamRoll>

<SoundRoll>072</SoundRoll>

<TapeName>C062</TapeName>

<SceneTake>88A/06</SceneTake>

</Source>

</Event>

<Comment Type="Locator"><Color></Color>

<Master><Timecode Type="TC1">04:01:38:02</Timecode>

<Frame>2354</Frame>

</Master>

<Source><ClipName>88A-6</ClipName>

<Timecode Type="Start TC">17:48:28:16</Timecode>

<Timecode Type="Aux TC1">17:48:28:16</Timecode>

<Timecode Type="Aux TC2">17:48:28:16</Timecode>

</Source>

<Text>OA140  pt1 - R&amp;H - keyframe recon, start at 0, recon to -6</Text></Comment>

<Event Num="18"  Type="Cut" Length="77" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:01:50:18</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0166+02</Edgecode>

<Frame>2658</Frame>

</Start>

<End>

<Timecode Type="TC1">04:01:53:22</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0170+14</Edgecode>

<Frame>2734</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:01:53:23</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88E-3</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d83a6a4-8522-0098-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1837669</Frame>

<Timecode Type="Start TC">21:16:09:13</Timecode>

<Timecode Type="Aux TC1">21:16:09:13</Timecode>

<Timecode Type="Aux TC2">21:16:09:13</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06811-4854+05</Edgecode>

<Edgecode Type="DPX">88E_3-0006925</Edgecode>

</Start>

<End>

<Frame>1837745</Frame>

<Timecode Type="Start TC">21:16:12:17</Timecode>

<Timecode Type="Aux TC1">21:16:12:17</Timecode>

<Timecode Type="Aux TC2">21:16:12:17</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06811-4859+01</Edgecode>

<Edgecode Type="DPX">88E_3-0007001</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">21:16:12:18</Timecode>

<Timecode Type="Aux TC1">21:16:12:18</Timecode>

<Timecode Type="Aux TC2">21:16:12:18</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.0919 1.0869 1.0879)(-0.0399 -0.0402 -0.0369)(0.9796 0.9817 0.9814)</ASC_SOP>

<ASC_SAT>1.1740</ASC_SAT>

<Custom Name="Description">CU Pi as RP hovers</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0316</LabRoll>

<CamRoll>C068</CamRoll>

<SoundRoll>080</SoundRoll>

<TapeName>C068</TapeName>

<SceneTake>88E/03</SceneTake>

</Source>

</Event>

<Event Num="19"  Type="Cut" Length="558" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:01:53:23</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0170+15</Edgecode>

<Frame>2735</Frame>

</Start>

<End>

<Timecode Type="TC1">04:02:17:04</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0205+12</Edgecode>

<Frame>3292</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:02:17:05</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>88A-6</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d7f5993-bd53-0508-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1538989</Frame>

<Timecode Type="Start TC">17:48:44:13</Timecode>

<Timecode Type="Aux TC1">17:48:44:13</Timecode>

<Timecode Type="Aux TC2">17:48:44:13</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06209-6186+13</Edgecode>

<Edgecode Type="DPX">88A_6-0001060</Edgecode>

</Start>

<End>

<Frame>1539546</Frame>

<Timecode Type="Start TC">17:49:07:18</Timecode>

<Timecode Type="Aux TC1">17:49:07:18</Timecode>

<Timecode Type="Aux TC2">17:49:07:18</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00C06209-6221+10</Edgecode>

<Edgecode Type="DPX">88A_6-0001617</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">17:49:07:19</Timecode>

<Timecode Type="Aux TC1">17:49:07:19</Timecode>

<Timecode Type="Aux TC2">17:49:07:19</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.2037 1.2593 1.2417)(-0.0316 -0.0485 -0.0279)(1.0187 1.0287 1.0393)</ASC_SOP>

<ASC_SAT>1.1915</ASC_SAT>

<Custom Name="Description">WS Pi,RP kills Hyena, Pi jumps on raft</Custom>

<Custom Name="VFX #">hao1030</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>0308</LabRoll>

<CamRoll>C062</CamRoll>

<SoundRoll>072</SoundRoll>

<TapeName>C062</TapeName>

<SceneTake>88A/06</SceneTake>

</Source>

</Event>

<Comment Type="Locator"><Color></Color>

<Master><Timecode Type="TC1">04:02:01:06</Timecode>

<Frame>2910</Frame>

</Master>

<Source><ClipName>88A-6</ClipName>

<Timecode Type="Start TC">17:48:51:20</Timecode>

<Timecode Type="Aux TC1">17:48:51:20</Timecode>

<Timecode Type="Aux TC2">17:48:51:20</Timecode>

</Source>

<Text>OA140  pt2 - R&amp;H - keyframe recon to +4 at jump in water, end at +8</Text></Comment>

<Event Num="20"  Type="Cut" Length="478" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:02:17:05</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0205+13</Edgecode>

<Frame>3293</Frame>

</Start>

<End>

<Timecode Type="TC1">04:02:37:02</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0235+10</Edgecode>

<Frame>3770</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:02:37:03</Timecode>

</EndOut>

</Master>

<Source>

<MobID>060a2b340101010101010f00-13-00-00-00-{00000000-0000-0000-060e2b347f7f2a80}</MobID>

<Start>

<Frame>0</Frame>

<Timecode Type="Start TC">00:00:00:00</Timecode>

<Timecode Type="VITC">00:00:00:00</Timecode>

<Timecode Type="Sound TC">00:00:00:00</Timecode>

<Timecode Type="Film TC">00:00:00:00</Timecode>

<Timecode Type="Aux TC1">00:00:00:00</Timecode>

<Timecode Type="Aux TC2">00:00:00:00</Timecode>

<Timecode Type="Aux TC3">00:00:00:00</Timecode>

<Timecode Type="Aux TC4">00:00:00:00</Timecode>

<Timecode Type="Aux TC5">00:00:00:00</Timecode>

<Timecode Type="TC24">00:00:00:00</Timecode>

<Timecode Type="TC25PD">00:00:00:00</Timecode>

<Timecode Type="TC25">00:00:00:00</Timecode>

<Timecode Type="TC30">00:00:00:00</Timecode>

<Timecode Type="AUX TC24">00:00:00:00</Timecode>

<Timecode Type="TC30N">00:00:00:00</Timecode>

<Edgecode Type="DPX">-LEADER-0000+00</Edgecode>

<Edgecode Type="Transfer">-LEADER-0000+00</Edgecode>

<Edgecode Type="VFX">-LEADER-0000+00</Edgecode>

</Start>

<End>

<Frame>477</Frame>

<Timecode Type="Start TC">00:00:15:27</Timecode>

<Timecode Type="VITC">00:00:15:27</Timecode>

<Timecode Type="Sound TC">00:00:15:27</Timecode>

<Timecode Type="Film TC">00:00:15:27</Timecode>

<Timecode Type="Aux TC1">00:00:15:27</Timecode>

<Timecode Type="Aux TC2">00:00:15:27</Timecode>

<Timecode Type="Aux TC3">00:00:15:27</Timecode>

<Timecode Type="Aux TC4">00:00:15:27</Timecode>

<Timecode Type="Aux TC5">00:00:15:27</Timecode>

<Timecode Type="TC24">00:00:15:27</Timecode>

<Timecode Type="TC25PD">00:00:15:27</Timecode>

<Timecode Type="TC25">00:00:15:27</Timecode>

<Timecode Type="TC30">00:00:15:27</Timecode>

<Timecode Type="AUX TC24">00:00:15:27</Timecode>

<Timecode Type="TC30N">00:00:15:27</Timecode>

<Edgecode Type="DPX">-LEADER-0029+13</Edgecode>

<Edgecode Type="Transfer">-LEADER-0029+13</Edgecode>

<Edgecode Type="VFX">-LEADER-0029+13</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">00:00:15:28</Timecode>

<Timecode Type="VITC">00:00:15:28</Timecode>

<Timecode Type="Sound TC">00:00:15:28</Timecode>

<Timecode Type="Film TC">00:00:15:28</Timecode>

<Timecode Type="Aux TC1">00:00:15:28</Timecode>

<Timecode Type="Aux TC2">00:00:15:28</Timecode>

<Timecode Type="Aux TC3">00:00:15:28</Timecode>

<Timecode Type="Aux TC4">00:00:15:28</Timecode>

<Timecode Type="Aux TC5">00:00:15:28</Timecode>

<Timecode Type="TC24">00:00:15:28</Timecode>

<Timecode Type="TC25PD">00:00:15:28</Timecode>

<Timecode Type="TC25">00:00:15:28</Timecode>

<Timecode Type="TC30">00:00:15:28</Timecode>

<Timecode Type="AUX TC24">00:00:15:28</Timecode>

<Timecode Type="TC30N">00:00:15:28</Timecode>

</EndOut>

</Source>

</Event>

<Event Num="21"  Type="Cut" Length="528" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:02:37:03</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0235+11</Edgecode>

<Frame>3771</Frame>

</Start>

<End>

<Timecode Type="TC1">04:02:59:02</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0268+10</Edgecode>

<Frame>4298</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:02:59:03</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>89-6</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d80367b-532c-008b-060e2b347f7f2a80}</MobID>

<Start>

<Frame>1342155</Frame>

<Timecode Type="Start TC">15:32:03:03</Timecode>

<Timecode Type="Aux TC1">15:32:03:03</Timecode>

<Timecode Type="Aux TC2">15:32:03:03</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00A07208-3884+11</Edgecode>

<Edgecode Type="DPX">89_6-0000232</Edgecode>

</Start>

<End>

<Frame>1342682</Frame>

<Timecode Type="Start TC">15:32:25:02</Timecode>

<Timecode Type="Aux TC1">15:32:25:02</Timecode>

<Timecode Type="Aux TC2">15:32:25:02</Timecode>

<Edgecode Type="AuxInk" Film="35mm4p">00A07208-3917+10</Edgecode>

<Edgecode Type="DPX">89_6-0000759</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">15:32:25:03</Timecode>

<Timecode Type="Aux TC1">15:32:25:03</Timecode>

<Timecode Type="Aux TC2">15:32:25:03</Timecode>

</EndOut>

<LUT>Bruno LUT</LUT>

<ASC_SOP>(1.2557 1.2592 1.2557)(-0.1374 -0.1406 -0.1374)(0.9957 0.9989 0.9937)</ASC_SOP>

<ASC_SAT>1.0235</ASC_SAT>

<Custom Name="Circled take">x</Custom>

<Custom Name="Dailies take">x</Custom>

<Custom Name="Tech Notes All">MOS</Custom>

<Custom Name="Description">WS Pi ties life vest to oar</Custom>

<Custom Name="VFX #">teh1010</Custom>

<Custom Name="cut">c</Custom>

<LabRoll>MOS</LabRoll>

<CamRoll>A072</CamRoll>

<SoundRoll>MOS</SoundRoll>

<TapeName>A072</TapeName>

<SceneTake>89/06</SceneTake>

</Source>

</Event>

<Event Num="22"  Type="Cut" Length="47" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:02:59:03</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0268+11</Edgecode>

<Frame>4299</Frame>

</Start>

<End>

<Timecode Type="TC1">04:03:01:01</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0271+09</Edgecode>

<Frame>4345</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:03:01:02</Timecode>

</EndOut>

</Master>

<Source>

<MobID>060a2b340101010101010f00-13-00-00-00-{00000000-0000-0000-060e2b347f7f2a80}</MobID>

<Start>

<Frame>0</Frame>

<Timecode Type="Start TC">00:00:00:00</Timecode>

<Timecode Type="VITC">00:00:00:00</Timecode>

<Timecode Type="Sound TC">00:00:00:00</Timecode>

<Timecode Type="Film TC">00:00:00:00</Timecode>

<Timecode Type="Aux TC1">00:00:00:00</Timecode>

<Timecode Type="Aux TC2">00:00:00:00</Timecode>

<Timecode Type="Aux TC3">00:00:00:00</Timecode>

<Timecode Type="Aux TC4">00:00:00:00</Timecode>

<Timecode Type="Aux TC5">00:00:00:00</Timecode>

<Timecode Type="TC24">00:00:00:00</Timecode>

<Timecode Type="TC25PD">00:00:00:00</Timecode>

<Timecode Type="TC25">00:00:00:00</Timecode>

<Timecode Type="TC30">00:00:00:00</Timecode>

<Timecode Type="AUX TC24">00:00:00:00</Timecode>

<Timecode Type="TC30N">00:00:00:00</Timecode>

<Edgecode Type="DPX">-LEADER-0000+00</Edgecode>

<Edgecode Type="Transfer">-LEADER-0000+00</Edgecode>

<Edgecode Type="VFX">-LEADER-0000+00</Edgecode>

</Start>

<End>

<Frame>46</Frame>

<Timecode Type="Start TC">00:00:01:16</Timecode>

<Timecode Type="VITC">00:00:01:16</Timecode>

<Timecode Type="Sound TC">00:00:01:16</Timecode>

<Timecode Type="Film TC">00:00:01:16</Timecode>

<Timecode Type="Aux TC1">00:00:01:16</Timecode>

<Timecode Type="Aux TC2">00:00:01:16</Timecode>

<Timecode Type="Aux TC3">00:00:01:16</Timecode>

<Timecode Type="Aux TC4">00:00:01:16</Timecode>

<Timecode Type="Aux TC5">00:00:01:16</Timecode>

<Timecode Type="TC24">00:00:01:16</Timecode>

<Timecode Type="TC25PD">00:00:01:16</Timecode>

<Timecode Type="TC25">00:00:01:16</Timecode>

<Timecode Type="TC30">00:00:01:16</Timecode>

<Timecode Type="AUX TC24">00:00:01:16</Timecode>

<Timecode Type="TC30N">00:00:01:16</Timecode>

<Edgecode Type="DPX">-LEADER-0002+14</Edgecode>

<Edgecode Type="Transfer">-LEADER-0002+14</Edgecode>

<Edgecode Type="VFX">-LEADER-0002+14</Edgecode>

</End>

<EndOut>

<Timecode Type="Start TC">00:00:01:17</Timecode>

<Timecode Type="VITC">00:00:01:17</Timecode>

<Timecode Type="Sound TC">00:00:01:17</Timecode>

<Timecode Type="Film TC">00:00:01:17</Timecode>

<Timecode Type="Aux TC1">00:00:01:17</Timecode>

<Timecode Type="Aux TC2">00:00:01:17</Timecode>

<Timecode Type="Aux TC3">00:00:01:17</Timecode>

<Timecode Type="Aux TC4">00:00:01:17</Timecode>

<Timecode Type="Aux TC5">00:00:01:17</Timecode>

<Timecode Type="TC24">00:00:01:17</Timecode>

<Timecode Type="TC25PD">00:00:01:17</Timecode>

<Timecode Type="TC25">00:00:01:17</Timecode>

<Timecode Type="TC30">00:00:01:17</Timecode>

<Timecode Type="AUX TC24">00:00:01:17</Timecode>

<Timecode Type="TC30N">00:00:01:17</Timecode>

</EndOut>

</Source>

</Event>

<Event Num="23"  Type="Cut" Length="1" SourceCount="1" >

<Master><Reel></Reel>

<Start>

<Timecode Type="TC1">04:03:01:02</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0271+10</Edgecode>

<Frame>4346</Frame>

</Start>

<End>

<Timecode Type="TC1">04:03:01:02</Timecode>

<Pullin></Pullin>

<Edgecode Type="Master" Film="Total Frames">0271+10</Edgecode>

<Frame>4346</Frame>

</End>

<EndOut>

<Timecode Type="TC1">04:03:01:03</Timecode>

</EndOut>

</Master>

<Source>

<ClipName>Academy.mov</ClipName>

<MobID>060a2b340101010101010f00-13-00-00-00-{4d22be90-eafa-0151-060e2b347f7f2a80}</MobID>

<Start>

<Frame>604944</Frame>

<Timecode Type="Start TC">07:00:06:00</Timecode>

</Start>

<End>

<Frame>604944</Frame>

<Timecode Type="Start TC">07:00:06:00</Timecode>

</End>

<EndOut>

<Timecode Type="Start TC">07:00:06:01</Timecode>

</EndOut>

<UNC>PI CRUZER:Academy.mov</UNC>

<Custom Name="UNC Path">PI CRUZER:Academy.mov</Custom>

<TapeName>Academy.mov</TapeName>

</Source>

</Event>

</Events>

</AssembleList>

</FilmScribeFile>






XSLT:






<?xml version='1.0' encoding='UTF-8' ?>

<xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'>

<xsl:output version='1.0' encoding='UTF-8' indent='no' method='xml' />

	<!--*****CUSTOMIZATION***********************************-->

	<xsl:variable name="Episode" select="'Episode'"/>

	<!--*****END OF CUSTOMIZATION****************************-->

<xsl:template match='/'>

<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

  <ERRORCODE>0</ERRORCODE>

  <PRODUCT BUILD="" NAME="" VERSION=""/>

  <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT="h:mm:ss a"/>

  <METADATA>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="RecordTCStart" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="RecordTCEnd" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="RecordFramesStart" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="RecordFramesEnd" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="RecordFramesDuration" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Clip_Name" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Tape" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SourceTCStart" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SourceTCEnd" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SourceFramesStart" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SourceFramesEnd" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Locator_Text" TYPE="TEXT"/>

   <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="NLESequenceName" TYPE="TEXT"/>

  </METADATA>

  <RESULTSET FOUND="">

   <xsl:for-each select="FilmScribeFile/AssembleList/Events/Comment[preceding-sibling::Event]">

	<ROW MODID="0" RECORDID="0">

	 <COL><DATA><xsl:value-of select="Master/Start/Timecode" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="Master/End/Timecode" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="Master/Start/Frame" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="Master/End/Frame" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="@Length" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="Source/ClipName" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="Source/TapeName" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="Source/Start/Timecode" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="Source/End/Timecode" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="Source/Start/Frame" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="Source/End/Frame" /></DATA></COL>

	 <COL><DATA><xsl:value-of select="following-sibling::*[1][name()='Comment']/Text"/></DATA></COL>

	 <COL><DATA><xsl:value-of select="/FilmScribeFile/AssembleList/ListHead/Title"/></DATA></COL>

	</ROW>

   </xsl:for-each>

  </RESULTSET>

</FMPXMLRESULT>

</xsl:template>

</xsl:stylesheet>

I want to filter the XML on import so only those Events who are followed by a Comment are imported.

I read this as:


...

<xsl:for-each select="FilmScribeFile/AssembleList/Events/Event[following-sibling::*[1][name()='Comment']]">

<ROW MODID="" RECORDID="">

...

  • Author

Thanks, Comment. That works beautifully. I didn't realize the same expression I was using later in the XSLT to pull those values would also work for the for-each, but it does! Thanks again!

Mike

I didn't realize the same expression I was using later in the XSLT to pull those values would also work

It wouldn't work the way you had it, because you were trying to select the Comment element. Going that route, you would have to fetch the actual data from the preceding sibling.

Create an account or sign in to comment

https://fmforums.com/topic/82755-filtering-input-of-xml-with-xslt-using-preceding-sibling/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.