Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Filtering input of XML with XSLT using preceding-sibling

nycpost

By nycpost
in Importing & Exporting

 Share

This topic is 4649 days old. Please don't post here. Open a new topic instead.

Recommended Posts

nycpost Enthusiast

nycpost

Posted
Posted

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>

comment Grand Master

comment

Posted
Posted

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="">

...

nycpost Enthusiast

nycpost

Posted
  • Author
Posted

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

comment Grand Master

comment

Posted
Posted

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.

This topic is 4649 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

Important Information

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

  I accept