Built a Python-based import/export pipeline to process Baselight export data and Xytech work orders, transforming local filesystem paths into standardized facility storage locations. Implemented parsing logic to clean and normalize inconsistent path structures, accurately map file locations between systems, and generate a structured CSV output for downstream production use. Designed frame-processing functionality to consolidate consecutive frame numbers into clear ranges while preserving separation by source location. This improved readability and ensured accurate tracking of frames requiring fixes. The solution reduced manual reconciliation effort, streamlined handoffs between color and production teams, and established a repeatable workflow for converting raw text-based data into actionable outputs.