import csv

import re

# Read Baselight$\_$export.txt file

file$\_$baselight $=$ open$(\text{'}/$Users$/$sayrareyes$/$Python$-$Projects$/$COMP$-467-$Assignment$/$Baselight$\_$export.txt$\text{'},\text{'}$r$\text{'})$

# print$($file$\_$baselight.read$())$

# Read Xytech.txt file

with open$(\text{'}$Xytech$.$txt$\text{'},\text{'}$r$\text{'})$ as f:

# xytech$\_$file $=[]$

xytech$\_$data $=$ f$.$read$().$splitlines$()$

# Baselight$\_$export.txt file

baselight$\_$data $=[]$

for currentReadline in file$\_$baselight:

if not currentReadline.strip$()$:

continue

print$("$Current read:

$"+$ currentReadline$)$

parse$\_$line $=$ currentReadline.split$()$

if not parse$\_$line:

continue

print$("$Baselight file: $",$ parse$\_$line$)$

current$\_$folder $=$ parse$\_$line.pop$(0)$

parse$\_$folder $=$ current$\_$folder.split$("/")$

parse$\_$folder.pop$(1)$

new$\_$folder $="/".$join$($parse$\_$folder$)$

print$("$Parse Folder: $",$ parse$\_$folder$)$

print$("$New Folder: $",$ new$\_$folder$)$

print$(\text{'}----------------------------------------------------------------\text{'})$

for xytech$\_$file in xytech$\_$data:

isVerbose $=$ True

if new$\_$folder in xytech$\_$file:

# print$("$Found: $"+$ new$\_$folder $+""+$ xytech$\_$file$)$

current$\_$folder $=$ xytech$\_$file.strip$()$

# Process frames and ranges

def process$\_$frames$($location$)$:

frames $=[]$

for entry in xytech$\_$data:

if entry.startswith$($location$)$:

frames.extend$($re$.$findall$($r$\text{'}\backslash$b$\backslash$d$+\backslash$b$\text{'},$ entry$))$

frames $=[$int$($frame$)$ for frame in frames$]$

frames.sort$()$

return frames

print$($xytech$\_$data$)$

print$(\text{'}----------------------------------------------------------------\text{'})$

# Export CSV File

with open$("$baselight$\_$and$\_$xytech.csv$",\text{'}$w$\text{'},$ newline$=\text{'}\text{'})$ as csvfile:

writer $=$ csv$.$writer$($csvfile$)$

writer.writerow$([\text{'}$Producer$\text{'},$ 'Operator', 'Job', 'Notes'$])$

writer.writerow$([\text{'}$Olivia Rodrigo', 'Johnny Bananas', $\text{'}$ Dirtfixing', 'Please clean files noted per Colorist Brock $\text{'}$

'Purdy'$])$

writer.writerow$([])$ # Empty row

writer.writerow$([\text{'}$Show Location', 'Frame to fix'$])$

writer.writerow$([\text{'}\text{'}])$

writer.writerow$([])$ # Empty rowImport file created from baselight $($Baselight$\_$export.txt$)$

Import xytech work order $($Xytech$.$txt$)$

Script will parse data

Computation done to match shareholder request, to replace file system from local baselight to facility storage

$($remember color correcter's prefer local storage for bandwidth issues$)$

Remember we are dealing with $3$rd party data, so some errors in the data might occur and you have to deal

Xytech Workorder $1109$

Producer: Olivia Rodrigo

Operator: Johnny Bananas

Job: Dirtfixing

Location:

$/$hpsans$13/$production$/$Dune$2/$reel$1/$partA$/1920$x$1080$

$/$hpsans$12/$production$/$Dune$2/$reel$1/$VFX$/$Hydraulx

$/$hpsans$13/$production$/$Dune$2/$reel$1/$VFX$/$Framestore

$/$hpsans$14/$production$/$Dune$2/$reel$1/$VFX$/$AnimalLogic

$/$hpsans$13/$production$/$Dune$2/$reel$1/$partB$/1920$x$1080$

$/$hpsans$15/$production$/$Dune$2/$pickups$/$shot$\_1$ab$/1920$x$1080$

$/$hpsans$11/$production$/$Dune$2/$pickups$/$shot$\_2$b$/1920$x$1080$

$/$hpsans$17/$production$/$Dune$2/$reel$1/$partC$/1920$x$1080$

Notes:

Please clean files noted per Colorist Brock Purdy

$/$baselightfilesystem$1/$Dune$2/$reel$1/$partA$/1920$x$1080234313233676869$

$70122123155102311111112116012011202120312041205121112121213$

$12141215$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$VFX$/$Hydraulx $1251125212531260$

$127012711272$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$partA$/1920$x$108013021303131015005000$

$50015002$

$/$baselightfilesystem$1/$Dune$2/$pickups$/$shot$\_1$ab$/1920$x$10805010501150125013$

$5014$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$partA$/1920$x$108051115122513351445155$

$5166$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$VFX$/$Framestore $618861896190$

$6191$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$VFX$/$Hydraulx $619761986199$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$partA$/1920$x$108062006201620962126219$

$6233623462676269627162786282628862896290629262936294$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$partB$/1920$x$108064096410641164136450$

$6666666766686670667166806681668266836684$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$VFX$/$AnimalLogic $68326833683469116912$

$69136914$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$partB$/1920$x$10808845$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$VFX$/$Hydraulx $8846$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$VFX$/$Framestore $8847$

$/$baselightfilesystem$1/$Dune$2/$pickups$/$shot$\_2$b$/1920$x$1080100011000210008$

$11113$

$/$baselightfilesystem$1/$Dune$2/$reel$1/$partB$/1920$x$108012011120211203112041$