Migrate your CLEAR Media ERP data

Dailies represent daily footage from a Production unit. Each Dailies record links to a Production, a shoot date, and a set of Asset versions. We extract Dailies as master records and flatten the version chain into a sequential asset list, mapping status and approval flags to destination equivalents.

Assets cover cuts, playlists, masters, and proxy files. CLEAR stores rich metadata per asset including format, resolution, and transcoding status. We map the asset type taxonomy to destination equivalents and preserve the asset-to-Work Order linkage as a custom property.

Work Orders are the operational spine of CLEAR, linking human tasks to machine-enabled tasks. They contain assignees, due dates, and asset references. We map Work Orders as Projects or Tasks in the destination and carry forward any custom Work Order fields as custom properties.

Productions are top-level containers in CLEAR, roughly equivalent to Projects in most PM systems. They carry a name, type (feature, series, commercial), and a date range. We migrate Productions 1:1 as Projects with the Production type preserved as a tag.

Users in CLEAR represent internal staff and external collaborators. Email, display name, and role transfer cleanly, but permissions and access scopes are destination-specific and we map them to the closest equivalent role in the target platform.

CLEAR maintains entity records for production clients and third-party service vendors. These map to Customers in most ERPs. We strip any billing-specific fields not present in the source record and flag missing addresses or tax IDs during the mapping phase.

Items represent deliverables, equipment, or services tracked for billing within a Production. We map Items to Items or Products in the destination, preserving unit cost and description fields. Custom item categories require explicit field mapping.

Documents in CLEAR include contracts, briefs, and approval sign-off sheets attached to Productions or Work Orders. We extract document metadata (name, type, date, owner) and map them to the destination's document or file attachment model. The raw files themselves are referenced via URL unless a file-transfer scope is agreed.

CLEAR does not expose a general-purpose Chart of Accounts as a standalone data object. Financial ledgers are managed within the Work Order billing sub-system and are not independently exportable. We do not migrate this object.

CLEAR does not expose a treasury or bank account object. Open AP/AR balances are not stored as independent records and cannot be migrated as such.

Approval records exist as status flags on Dailies and Assets. We extract the approval chain (approver, timestamp, decision) as a structured metadata field rather than a standalone object, and map it to the destination's review or approval mechanism.