Exif Video Resolved

evrExpanse







Mac version

 


    Instruction Manual v1.0  - updated June 9st 2021


    How to Install

    How to uninstall

    How to use

    Media files and Camera specifications

    How to import CSV file in DaVinci Resolve

    How to import ALE file in Assimilate Scratch

    How to import ALE file in Avid Media Composer

    How to import CSV file in Silverstack

    Metadata mapping



































How to Install

 


1. Install evrExpanse. Open the DMG file and drag & drop evrExpanse.app to the Applications

folder.







How to uninstall

 

1.     Delete (Move to Trash) the /Applications/evrExpanse.app.


How to use

 

On Run select a folder with media files to be processed.

Single or multiple selection (hold CMD) can be made.



If Avid Media Composer (ALE) is selected, you need to set the project Format, FPS and Bin name.

By default, Bin name is filled with the name of the selected folder but it can be changed.


When the process is finished, the selected export files will be available inside the selected folder.



Also a log file for each process will be generated with the process details.




Media files and Camera specifications


File type: MOV, MP4, MXF

Camera supported: Panasonic Lumix, Sony Alpha, Canon EOS, Nikon, Fujifilm, Sony XDCAM*, Atomos, Kinefinity**, Z Cam


Note

* to be able to extract all the metadata possible, the XML sidecar file should be present in the same folder of the media file.

** Kinefinity support is conditioned by the presence of the slate.txt sidecar file which must be present in the same folder as the MOV file and there must be no other MOV files inside the folder. This is a special condition and it is highly recommended to process the folder structure in the original format as written by the camera.





How to import CSV file in Davinci Resolve


1.     Open a project containing clips you want to populate with imported metadata,

     just click the media pool (make sure a red line will be visible if not point n.3 will be not

     possible)




 

2.     Optionally, select which clips in the Media Pool you want to import metadata to.

3.     Choose File > Import Metadata To > Media Pool to import metadata to potentially every

     clip in the Media Pool, or choose File > Import Metadata To > Selected Clips to only import

     metadata to clips you selected in step 2.





4.     When the Import Metadata dialog appears, choose a metadata CSV file to import, and click

     Open.

 

5.     When the Metadata Import dialog appears, by default, DaVinci Resolve tries to use “Match

     using filename” and “Match using clip start and end Timecode” to match each line of

     metadata in the CSV file with a clip in  the Media Pool, but because "clip start and end

     Timecode" are not present in imported metadata you have to uncheck “Match using clip

     start and end Timecode” and (optionally) check “Match using source file paths".





6.     Next, choose which Merge Option you want to use in the Metadata Import dialog.

     There are three options:

-    Only update metadata items with entries in the source file (recommended):

   The default setting. Only updates a clip’s metadata if there’s a valid entry in the imported CSV

         file. Other clip metadata fields are left as they were before the import.


-    Update all metadata fields available in the source file: For each clip that corresponds to a line of

         metadata in the imported CSV file, every single metadata field referenced by the CSV file is

         overwritten, regardless of whether or not there’s a valid entry for that field.

-    Update all metadata fields available in the source file and clear others: For each clip that

         corresponds to a line of metadata in the imported CSV file, every single metadata field

         referenced by the CSV file is overwritten, regardless of whether or not there’s a valid entry for

         that field.

         Furthermore, metadata fields that aren’t referenced by the imported CSV file are cleared of

  whatever metadata was there before.

 

7.     When you’re finished choosing options, click OK and all available metadata from

     the source CSV file will be imported.



If the media files have been tagged using the macOS Finder Tag, the information will be reported in Keyword window and

in the Flags section in DaVinci Resolve.



How to import ALE file in Assimilate Scratch


To import .ale files exported by evrExpanse that contain metadata information in Scratch you have

to follow 4 consecutive steps:


    1. Import the clips into Scratch that you want to apply the metadata information to.

    2. Import the .ale file from evrExpanse.

    3. Check settings for matching and import.

    4. Go to the clip view and enable the imported metadata.



Importing the Clips

Click the “Import Clips” button from the lower left side of the interface:




Choose the clips you exported the ALE for to add them to the Scratch project:

 





Importing the ALE File


Go to the “Conform”, c
lick the “Import” button to open the ALE:




Navigate to the exported ALE and click “Open”.





Check Settings for Matching and Import


You will see the matching user interface where now the ALE data will be matched to the clips:




At the top of the the columns from the .ale you can select the action that should be performed for

each column. Make sure you have all the columns set to “Import”. Matching on TC or File Name will

be easiest so make sure to that at least one of those columns, or any other you want to match based

on, is set to “Match on…”. You can make that selection from the drop down on top of every column.

"Match on Name" is already selected by default and "Match on TimeCode Start" it's a good choise.




Click “Start Matching” to match the metadata to the clips according to your settings.

While then selecting the different rows in the ALE  you will see the clips the data will be matched to

in the right bar of the wizard.




Click “Execute” when you are happy with the match and want the metadata to be taken over to the clips.


Clip view and enable the imported metadata

Go to the Media Browser, "Metadata" section and after selecting one file in the table, select all the

imported metadata.



And they will be shown as the below figure.





How to import ALE file in Avid Media Composer


After having created the .ale file in evrExpanse, go to the Avid Media Composer and import the

clips if not done so far. They should thereon be available as master clips.




Select the bin in the Avid Media Composer which contains the relevant clips.

Select those clips and choose “Input > Import Media…” from the context menu in the bin.


   
Open the “Options”, then click on “Options…” navigate to the Shot Log tab and select

“Merge events with known master clips”.

Navigate to the ALE file you created before and click “Open”.



Avid Media Composer now matches master clips and metadata information from the .ale file

according to their TimeCode, Bin Name and Name of clip.


The information from the .ale file is attached within additional columns in the bin table.

Some of the columns are already known by the Avid Media Composer, all unknown information

will be added as custom columns.




If you cannot see any custom columns, perform the following steps:

    1. Close and re-open the bin

    2. Right-click in the free space of the bin window and click on “Choose columns…”

        in the context menu.

    3. Then select and unselect columns, the custom columns from the imported .ale file you

        will find at the end of the list.




How to import CSV file in Silverstack



After having created the .csv file in evrExpanse, go to the Silverstack Composer and import the

clips if not done so far.





To be able to import metadata evrExpanse will use the Drylab CSV import feature in Silverstack.

Select the folder or bin in the library of Silverstack that you want to import metadata for.

Then, in the “Import” menu button in the toolbar select the option Drylab CSV:




When the Finder dialog points you to select a file, choose the CSV file exported from

evrExpanse and select “Open”.


There are two options to match the events in the CSV to the clips in the library:

  • by Clip Name

  • by Creation Date




Select Clip Name and Creation Date (Date only) and click “Continue”.


Import Section: In this step you can select or unselect the metadata that should be imported from the CSV to the Silverstack library.

evrExpanse metadata are under the sections:


  • Camera Settings

  • Lens and Filter

  • Comment and Caption

  • Append Tags

  • Day Number + Day Date (as Custom 1)



Insert/Update Behavior: Choose if you only want to insert new metadata if a fields is empty or you want to force an overwrite.




Select the option in bold and click "Finish"





If the media files have been tagged using the macOS Finder Tag, the information will be reported in Tags column in Silverstack.


This is the list of metadata (in bold those exportable by evrExpanse) whose fields are mapped in the Silverstack library (sorted by Silvertack metadata section):



DryLab/evrExpanse CSV
Silverstack
Field Section Field
tStop Camera Settings T-Stop
iso Camera Settings ISO
colorTemperature Camera Settings White Balance
latitude Camera Settings GPS Position
longitude Camera Settings GPS Position
cameraName Camera Settings Model
lens Lens and Filter Model
shotNotes Comment and Caption Comment
cameraTakeNotes Comment and Caption Comment
tags Append Tags Tags






Metadata mapping


In the following table there are the metadata tag exported.



Metadata

Tags


DaVinci

Resolve

Assimilate

Scratch

Avid Media

Composer

Pomfort

Silverstack

EVRapp

evrExpanse

File Name

Recorded date & time


Time Code Start


Time Code End


Clip Directory


Camera FPS


Avg Bitrate


Video Codec


Video Bit Depth


Video Gamma Curve


Video Color Spaces


Camera Maker

Camera Serial Number


Camera Model


Camera Firmware


Camera ISO

Aperture Fnumber

Shutter Speed


Aperture Type


White Balance


White Point Kelvin

Lens Type

Focal length 35efl


Lens Serial Number


Lens Firmware


Camera Notes

Sensor Area


Lut.Used


GPS Position


Finder TAG



Finder Color Flags