Project $1$: import$/$export script$$

Import 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 with it $($i$.$e $)$

Export CSV file $(\text{'}/\text{'}$ indicates columns$)$: $$

Line $1$: Producer $/$ Operator $/$ job $/$notes$$

Line $4$: show location $/$ frames to fix$$

Frames and frame ranges processed in consecutive$/$numerical order shown $($from baselight$\_$export.txt$)$ as either:

ranges $($i$.$e $/$filesystem$/$Dune$2/$PartA$/1920$x$108032-35)$

individually $($i$.$e $/$filesystem$/$Dune$2/$PartA$/1920$x$108041)$

Frames shown need to reflect their proper location and not mix with ranges from another location

import csv

import re

print$("$Current files: $")$

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

# parsing two files, computationally two things frame ranges and folder fix and exporting cvs files

# method import and read baselight file

with open$(\text{'}$Baselight$\_$export.txt$\text{'},\text{'}$r$\text{'})$ as file:

baselight$\_$data $=[]$

Baselight$\_$data $=$ file.read$()$

print$($Baselight$\_$data$)$

# method to import and read xytech file

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

xytech$\_$data $=[]$

Xytech$\_$data $=$ file.read$()$

print$($Xytech$\_$data$)$

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

$\text{'})$

# Function to parse Baselight.txt

def parse$\_$baselight$\_$data$()$:

data $=\{\}$

with open$("$Baselight$\_$export.txt$",\text{'}$r$\text{'})$ as file:

lines $=$ file.readline$()$

current$\_$location $=$ None

for line in lines:

line $=$ line.strip$()$

if line.startswith$("/$baselightfilesystem$1")$:

current$\_$location $=$ line

data$[$current$\_$location$]=[]$

else:

frames $=$ re$.$findall$($r$\text{'}\backslash$d$+\text{'},$ line$)$

data$[$current$\_$location$]=[]$

return data

# Function to parse Xytech.txt

def parse$\_$xytech$\_$data$($data$)$:

parsed$\_$data $=[]$

for line in data:

parsed$\_$line $=$ line.split$(\text{'},\text{'})$

# parsed$\_$line $=$ line.split$[0]$

show$\_$location $=$ parsed$\_$line$[0]$

frames$\_$fix $=$ parsed$\_$line$[1]$

parsed$\_$data.append$(\{\text{'}$Show Location': show$\_$location, 'Frames to Fix': frames$\_$fix$\})$

return parsed$\_$data

# Function to compute frame ranges

def compute$\_$frames$($data$)$:

for line in data:

frames$\_$fix $=$ line.get$(\text{'}$Frames to fix'$)$

if frames$\_$fix:

ranges $=$ re$.$findall$($r$\text{'}/$d$+-\backslash$d$+-\text{'},\text{'}\text{'}.$join$($frames$\_$fix$))$

if ranges:

line$[\text{'}$Frames Ranges'$]=$ ranges

# Combine data and compute frame ranges

combined$\_$data $=$ baselight$\_$data $+$ xytech$\_$data

print$(\text{'}$Combined data: $\text{'},$ combined$\_$data$)$

compute$\_$frames$($combined$\_$data$)$

print$(\text{'}$Computed data: $\text{'},$ combined$\_$data$)$

# Parse Baselight data

parse$\_$baselight$\_$data $=$ parse$\_$baselight$\_$data$()$

print$(\text{'}$Parsed Baselight data: $\text{'},$ parse$\_$baselight$\_$data$)$

# Parse Xytech data

parse$\_$xytech$\_$data $=$ parse$\_$xytech$\_$data$($xytech$\_$data$)$

print$(\text{'}$Parsed Xytech data: $\text{'},$ parse$\_$xytech$\_$data$)$

# Export to csv

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{'}\text{'}])$

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

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

for row in combined$\_$data:

writer.writerow$([$

row.get$(\text{'}$Producer$\text{'},\text{'}\text{'}),$

row.get$(\text{'}$Operator$\text{'},\text{'}\text{'}),$

row.get$(\text{'}$Job$\text{'},\text{'}\text{'}),$

row.get$(\text{'}$Notes$\text{'},\text{'}\text{'}),$

row.get$(\text{'}$Show Location'$),$

row.get$(\text{'}$Frames Fix'$),$

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

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

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

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

row.get$(\text{'}$Frames Ranges', $\text{'}\text{'}),$

$\text{'},\text{'}.$join$($map$($str$,$ row.get$(\text{'}$Frames fix', $[]))),$

$\text{'},\text{'}.$join$($map$($str$,$ row.get$(\text{'}$Frames Ranges', $[])))$

$])$Project: example with random data

Xytech:

$/$ddnsan$2/$avengers$/$reel$1/1920$x$1080$

Baselight$\_$export:

$/$images$1/$avengers$/$reel$1/1920$x$108010111213192324$

$/$ddnsan$2/$avengers$/$reel$1/1920$x$108010-13$

$/$ddnsan$2/$avengers$/$reel$1/1920$x$108019$

$/$ddnsan$2/$avengers$/$reel$1/1920$x$108023-24$

WHAT IS WRONG WITH MY CODE I CANT GET IT TO WORK