Conforming Database Records


Conformalizer can automate the process of conforming and rebalancing FX, foley and ADR lists by applying the change EDL to a 'tab-separated' or 'comma-separated' text file. Rather than applying the conform to your entire database, you first export a text file containing the records you wish to modify. Once Conformalizer has conformed the values in your list, you will re-import the modified records to your database.

1. Export as text
In your database application (e.g. Filemaker), export the records you wish to conform as a tab or comma separated text file. If you are not using a database application, you should ensure that the timecode or feet+frames values are separated by a 'tab'.

Each line of the list should include at least one timecode or feet+frames value and at least one other field to identify the record (like the record ID). You can use as many or as few timecode and feet+frames fields as you wish, as long as the are separated by a 'tab'.
e.g.

01:00:03:21     01:00:05:11     FX-1234     car hits fruit stall

ADRSc123005     Arnie     01:00:03:21     01:00:05:11     "aaargh"   sync NG

Sc123FX005     233+11     car hits ice sculpture

You will usually want to include this extra information as a means of identifying each record when the conformed list is re-imported.

2. Check Settings
Make sure you have the correct change EDL loaded in the change panel and that the 'session/file settings' preferences are set as you wish (see the setup page for an explanation of these settings). In particular, ensure that 'conform type' is set to the 'file - ' option which corresponds with the type of file you created in step 1.

3. Conform
Click the 'Conform' button and check the details in the window that appears. Click 'OK' and select the file from step 1.
Conformalizer will conform the timecode and feet+frames values from the list and create a new text file with the suffix '_conf'. This file will be located next to the original file.

Any timecodes which are not modified by the process will be enclosed in [square brackets] to show that they need to be respotted. e.g. [01:03:05:08].

4. Re-Import
Import the conformed list into your database program (if any). You may wish to overwrite the old records by matching the record ID you included in step 1 or retain the old records and import the conformed records as new items, belonging to the new cut. An additional field is added to the records which will contain either CONFORMED, RESPOT or NOCODE. If imported this will help you sort the successfully conformed records from those which could not be. In most database setups you would also want to update the 'reel name' for all of the conformed records.

5. Re-Spot
For any timecodes which could not be conformed (footage dropped from the cut) you will find the timecode in [square brackets] and the word RESPOT in the last field. These timecodes represent footages in the old cut which are not present in the new. Using the RESPOT field you can quickly find and fix (or delete) these records.