---
# System prepended metadata

title: AMC DF Studio migration

---

# AMC DF Studio migration
[https://link.orangelogic.com/Tasks/4ZO7V](https://link.orangelogic.com/Tasks/4ZO7V)

Status: InProgress


| When | Who | What |
| -------- | -------- | -------- |
| 2024-01-22     | Lanh Nguyen     | Initial Creation     |

## Why
…The reason we are doing this development

## Target
...What to be done within this development

## Related documents
#### Overral DF Sync structure

https://link.orangelogic.com/CMS4/Internal-Resource-Center/Homepage/Dept--Specific-Information/Internal-Documentation/Modules/DFStudio-API-Sync/

### Previous Hulu migration notes
https://docs.google.com/document/d/1BFia8wCYi1ryob7LvH16gluMenWdeM8hWMRFttALuFA/edit

https://docs.google.com/document/d/1LM9SqFF5mWYuG5LfFZT8HObOizkUrDyATXC1ErtQqvo/edit

https://docs.google.com/document/d/1drXkS_Y7h2uiK_NndeTMZqqq0xMenVA94IuiwMPme5A/edit


## Architecture
Give a concise overview of how the feature works
If the module evolves, keep this chapter up to date


## Classes involved
IWhateverService
...

## Import Assets
### Create 3 Agent jobs follow 
https://link.orangelogic.com/CMS4/Internal-Resource-Center/Homepage/Dept--Specific-Information/Internal-Documentation/Modules/DFStudio-API-Sync/2

![image](https://hackmd.io/_uploads/SyRphUsKa.png)


### Copy parameters from COR.HLU to COR.AMC session “24LE1Z_DF_Migration”
DF_ContainerMetadataExport_Approvals_BO 
DF_ContainerMetadataExport_BO
DF_ContainerMetadataExport_EditsOnly_BO 
DF_ContainerMetadataGatheringTool_BO 
DF_ContainerMetadataGatheringTool_FullSyncMode_BO 
DF_DOCUMENTSFORFETCH_DbBO
DF_MetadataExport_BO DF_MetadataExport_Metadata1_BO
DF_MetadataExport_Metadata10_BO
DF_MetadataExport_Metadata2_BO 
DF_MetadataExport_Metadata3_BO 
DF_MetadataExport_Metadata4_BO
DF_MetadataExport_Metadata5_BO
DF_MetadataExport_Metadata6_BO 
DF_MetadataExport_Metadata7_BO 
DF_MetadataExport_Metadata8_BO 
DF_MetadataExport_Metadata9_BO 
DF_MetadataExport_MetadataBase_BO 
DF_MetadataExport_Originals_BO 
DF_MetadataExport_Others_BO 
DF_MetadataExport_RecordsOnly_2_BO 
DF_MetadataExport_RecordsOnly_3_BO 
DF_MetadataExport_RecordsOnly_4_BO 
DF_MetadataExport_RecordsOnly_BO 
DF_TalentApprovalMetadataGatheringTool_BO 
DF_ThirdPartyMetadataGatheringTool_BO 
DF_ThirdPartyMetadataGatheringTool_FullSyncMode_BO

### Step 1: Get metadata from DF

#### DF cridentials

DF_ThirdPartyMetadataGatheringTool_BO.Data.Configuration.LoginUsername
DF_ThirdPartyMetadataGatheringTool_BO.Data.Configuration.LoginAccount
DF_ThirdPartyMetadataGatheringTool_BO.Data.Configuration.LoginPassword

For OL dev: Cridentials are shared in 1password shared vault: https://start.1password.com/open/i?a=F7DX32NXYREXBIZTAYH3L55LYU&h=orangelogic.1password.com&i=ombegbjyklw34ojfmabw7qtfzq&v=vbogdzprfp56nemevr35igcype

#### Configure API to get assets from DF

Ask AMC team to create 2 custom fields for tracking which assets should be sync 
- custom.ReadyForCortex: use to filter which asset should be syn
- custom.DateInCortex: Cortex will call API to update this field after sync asset done

Update API to get asset (this parameters can contains multiples)

*DF_ThirdPartyMetadataGatheringTool_BO.Data.APICalls.GetAssetsToSyncUrl*
``` api/v1/session/[SID]/assets.js?custom.ReadyForCortex=true&limit=[LIMIT] ```

Update fields to update in DF after sync done
*DF_ThirdPartyMetadataGatheringTool_BO.Data.Fields.FieldInPostData*
```
custom.ReadyForCortex = false
custom.DateInCortex = [DATE_NOW] 
```

#### Configure fields mapping from DF to Cortex temp DB

Mapping: https://docs.google.com/spreadsheets/d/1_aM_L9F9FoJOO720HzY4HrMI7WQLDquT5AQ14h4-8t4/edit#gid=2083151766


Parameter: *DF_ThirdPartyMetadataGatheringTool_BO.Data.Fields.MapFieldToMetaData*

Data will be imported to a temp table (DF_ThirdPartyMetadataGatheringTool_BO.Data.Configuration.TableName) default is SYNC_DF_ASSETS
<details>
    <summary>Example JSON response for metadata (click to see)</summary>
    
{{URL}}api/v1/session/d4z6gj0ad0w437ows6k2/assets.js?name=61ST_S2Portrait_Franklin_3769_RT
```jsonld=
    
{
            "addedDate": "2022-11-01T20:37:03+0000",
            "addedToStudio": "2022-11-01T20:37:03+0000",
            "approvalState": "N",
            "createdDate": "2022-11-01T20:37:03+0000",
            "dfsId": "dfsa-cdda01if-7463535",
            "dfsid": "dfsa-cdda01if-7463535",
            "folder": "/AMC/61st Street/61St Street Gallery S1 & S2",
            "id": "7463535",
            "isStoredActive": false,
            "isStoredCold": true,
            "location": "/AMC/61st Street/61St Street Gallery S1 & S2/61ST S1 Gallery RT",
            "name": "61ST_S2Portrait_Franklin_3769_RT",
            "path": "/AMC/61st Street/61St Street Gallery S1 & S2/61ST S1 Gallery RT",
            "project": "61ST S1 Gallery RT",
            "projectDfsid": "dfsp-cdda01if-16683",
            "rest.resourceName": "asset",
            "rest.resources": {
                "approvals": "https://amcnetworks.dfstudio.com:443/api/v1/session/d4z6gj0ad0w437ows6k2/asset/dfsa-cdda01if-7463535/approvals.js",
                "asset": "https://amcnetworks.dfstudio.com:443/api/v1/session/d4z6gj0ad0w437ows6k2/asset/dfsa-cdda01if-7463535.js",
                "edits": "https://amcnetworks.dfstudio.com:443/api/v1/session/d4z6gj0ad0w437ows6k2/asset/dfsa-cdda01if-7463535/edits.js",
                "file": "https://amcnetworks.dfstudio.com:443/api/v1/session/d4z6gj0ad0w437ows6k2/asset/dfsa-cdda01if-7463535/file.js",
                "metadata": "https://amcnetworks.dfstudio.com:443/api/v1/session/d4z6gj0ad0w437ows6k2/asset/dfsa-cdda01if-7463535/metadata.js",
                "rest.self": "https://amcnetworks.dfstudio.com:443/api/v1/session/d4z6gj0ad0w437ows6k2/asset/dfsa-cdda01if-7463535.js"
            },
            "setup": "Franklin RT"
        }
```

{{URL}}api/v1/session/2260cv0lslxij3hi7zhp/asset/7463535/metadata/all.js

```jsonld=
{
    "app14:APP14Flags0": "[14]",
    "app14:APP14Flags1": "(none)",
    "app14:ColorTransform": "YCbCr",
    "app14:DCTEncodeVersion": "100",
    "composite:Aperture": "11",
    "composite:CFAPattern": "[Red,Green][Green,Blue]",
    "composite:CircleOfConfusion": "0.026 mm",
    "composite:Copyright": "© 2022 AMC Film Holdings LLC.  All rights reserved.",
    "composite:CreateDate": "2021:10:17 11:53:22",
    "composite:Creator": "JD Barnes/AMC",
    "composite:DOF": "inf (0.00 m - inf)",
    "composite:DateTimeCreated": "2021:10:17 11:53:22+00:00",
    "composite:DateTimeOriginal": "2021:10:17 11:53:22",
    "composite:Description": "Courtney B. Vance as Franklin Roberts - 61st Street _ Season 1, Gallery - Photo Credit: JD Barnes/AMC",
    "composite:DigitalCreationDateTime": "2021:10:17 11:53:22+00:00",
    "composite:FOV": "24.7 deg",
    "composite:FocalLength35efl": "70.0 mm (35 mm equivalent: 82.3 mm)",
    "composite:HyperfocalDistance": "17.42 m",
    "composite:ImageSize": "4641x6958",
    "composite:LensID": "Canon RF 24-70mm F2.8L IS USM",
    "composite:LightValue": "11.9",
    "composite:Megapixels": "32.3",
    "composite:ModifyDate": "2022:03:10 15:58:26.14",
    "composite:Orientation": "Horizontal (normal)",
    "composite:Rating": "0",
    "composite:ScaleFactor35efl": "1.2",
    "composite:ShutterSpeed": "1/160",
    "composite:SubSecCreateDate": "2021:10:17 11:53:22.14",
    "composite:SubSecDateTimeOriginal": "2021:10:17 11:53:22.14",
    "composite:SubSecModifyDate": "2022:03:10 15:58:26.14",
    "custom.starrating": "0",
    "custom.talentapproval": "",
    "dfstudio.caption": "Courtney B. Vance as Franklin Roberts - 61st Street _ Season 1, Gallery - Photo Credit: JD Barnes/AMC",
    "dfstudio.copyright": "© 2022 AMC Film Holdings LLC.  All rights reserved.\n",
    "dfstudio.credit": "",
    "dfstudio.headline": "",
    "dfstudio.instructions": "",
    "dfstudio.keywords": "",
    "dfstudio.location": "",
    "dfstudio.photographer": "JD Barnes/AMC",
    "dfstudio.writer": "",
    "exif:ActiveArea": "0 0 5464 8192",
    "exif:ApertureValue": "11",
    "exif:Artist": "JD Barnes/AMC",
    "exif:AsShotNeutral": "0.5013921856 1 0.5782732367",
    "exif:BaselineExposure": "0.09761086809",
    "exif:BayerGreenSplit": "500",
    "exif:BitsPerSample": "16",
    "exif:CFALayout": "Rectangular",
    "exif:CFAPattern2": "0 1 1 2",
    "exif:CFARepeatPatternDim": "2 2",
    "exif:CalibrationIlluminant1": "Unknown",
    "exif:ColorMatrix1": "1 0 0 0 1 0 0 0 1",
    "exif:ColorSpace": "Uncalibrated",
    "exif:ComponentsConfiguration": "Y, Cb, Cr, -",
    "exif:Compression": "JPEG (old-style)",
    "exif:Copyright": "© 2022 AMC Film Holdings LLC.  All rights reserved.\n",
    "exif:CreateDate": "2021:10:17 11:53:22",
    "exif:CustomRendered": "Normal",
    "exif:DNGBackwardVersion": "1.1.0.0",
    "exif:DNGVersion": "1.1.0.0",
    "exif:DateTimeOriginal": "2021:10:17 11:53:22",
    "exif:DefaultCropOrigin": "0 0",
    "exif:DefaultCropSize": "8192 5464",
    "exif:ExifImageHeight": "6958",
    "exif:ExifImageWidth": "4641",
    "exif:ExifVersion": "0230",
    "exif:ExposureCompensation": "0",
    "exif:ExposureMode": "Manual",
    "exif:ExposureProgram": "Manual",
    "exif:ExposureTime": "1/160",
    "exif:FNumber": "11",
    "exif:FileSource": "Digital Camera",
    "exif:Flash": "On, Fired",
    "exif:FlashpixVersion": "0100",
    "exif:FocalLength": "70.0 mm",
    "exif:FocalPlaneResolutionUnit": "inches",
    "exif:FocalPlaneXResolution": "5773.07959",
    "exif:FocalPlaneYResolution": "5769.799316",
    "exif:GPSVersionID": "2.3.0.0",
    "exif:ISO": "500",
    "exif:ImageDescription": "Courtney B. Vance as Franklin Roberts - 61st Street _ Season 1, Gallery - Photo Credit: JD Barnes/AMC",
    "exif:ImageHeight": "5464",
    "exif:ImageWidth": "8192",
    "exif:LensInfo": "24-70mm f/?",
    "exif:LensModel": "Canon RF 24-70mm F2.8L IS USM",
    "exif:LensSerialNumber": "8413000097",
    "exif:Make": "Canon",
    "exif:MeteringMode": "Multi-segment",
    "exif:Model": "Canon EOS R5",
    "exif:ModifyDate": "2022:03:10 15:58:26",
    "exif:Orientation": "Horizontal (normal)",
    "exif:OriginalRawFileName": "/Users/amcmillan/Desktop/61st SXSW/61ST_S2Portrait_Franklin/61ST_S2Portrait_Franklin_3769.eip",
    "exif:PhotometricInterpretation": "Color Filter Array",
    "exif:PlanarConfiguration": "Chunky",
    "exif:RecommendedExposureIndex": "500",
    "exif:ResolutionUnit": "inches",
    "exif:RowsPerStrip": "1",
    "exif:SamplesPerPixel": "1",
    "exif:SceneCaptureType": "Standard",
    "exif:SceneType": "Directly photographed",
    "exif:SensitivityType": "Recommended Exposure Index",
    "exif:SerialNumber": "062021003048",
    "exif:ShutterSpeedValue": "1/160",
    "exif:Software": "Adobe Photoshop 22.3 (Macintosh)",
    "exif:StripByteCounts": "(Binary data 32783 bytes, use -b option to extract)",
    "exif:StripOffsets": "(Binary data 48507 bytes, use -b option to extract)",
    "exif:SubSecTime": "14",
    "exif:SubSecTimeDigitized": "2021:10:17 11:53:22",
    "exif:SubSecTimeOriginal": "14",
    "exif:SubfileType": "Full-resolution image",
    "exif:SubjectDistance": "0 m",
    "exif:ThumbnailImage": "(Binary data 4478 bytes, use -b option to extract)",
    "exif:ThumbnailLength": "4478",
    "exif:ThumbnailOffset": "1126",
    "exif:ThumbnailTIFF": "(Binary data 51576 bytes, use -b option to extract)",
    "exif:UniqueCameraModel": "Canon EOS R5",
    "exif:WhiteBalance": "Manual",
    "exif:XResolution": "300",
    "exif:YCbCrPositioning": "Centered",
    "exif:YResolution": "300",
    "icc_profile:BlueMatrixColumn": "0.14919 0.06322 0.74457",
    "icc_profile:BlueTRC": "(Binary data 14 bytes, use -b option to extract)",
    "icc_profile:CMMFlags": "Not Embedded, Independent",
    "icc_profile:ColorSpaceData": "RGB ",
    "icc_profile:ConnectionSpaceIlluminant": "0.9642 1 0.82491",
    "icc_profile:DeviceAttributes": "Reflective, Glossy, Positive, Color",
    "icc_profile:DeviceManufacturer": "none",
    "icc_profile:DeviceMfgDesc": "IEC http://www.iec.ch",
    "icc_profile:DeviceModel": "",
    "icc_profile:DeviceModelDesc": "IEC 61966-2.1 Default RGB colour space - sRGB",
    "icc_profile:GreenMatrixColumn": "0.20528 0.62567 0.06087",
    "icc_profile:GreenTRC": "(Binary data 14 bytes, use -b option to extract)",
    "icc_profile:Luminance": "76.03647 80 87.12462",
    "icc_profile:MeasurementBacking": "0 0 0",
    "icc_profile:MeasurementFlare": "0.999%",
    "icc_profile:MeasurementGeometry": "Unknown",
    "icc_profile:MeasurementIlluminant": "D65",
    "icc_profile:MeasurementObserver": "CIE 1931",
    "icc_profile:MediaBlackPoint": "0 0 0",
    "icc_profile:MediaWhitePoint": "0.95045 1 1.08905",
    "icc_profile:PrimaryPlatform": "Apple Computer Inc.",
    "icc_profile:ProfileCMMType": "Adobe Systems Inc.",
    "icc_profile:ProfileClass": "Display Device Profile",
    "icc_profile:ProfileConnectionSpace": "XYZ ",
    "icc_profile:ProfileCopyright": "Copyright 1999 Adobe Systems Incorporated",
    "icc_profile:ProfileCreator": "Adobe Systems Inc.",
    "icc_profile:ProfileDateTime": "1999:06:03 00:00:00",
    "icc_profile:ProfileDescription": "Adobe RGB (1998)",
    "icc_profile:ProfileFileSignature": "acsp",
    "icc_profile:ProfileID": "0",
    "icc_profile:ProfileVersion": "2.1.0",
    "icc_profile:RedMatrixColumn": "0.60974 0.31111 0.01947",
    "icc_profile:RedTRC": "(Binary data 14 bytes, use -b option to extract)",
    "icc_profile:RenderingIntent": "Perceptual",
    "icc_profile:Technology": "Cathode Ray Tube Display",
    "icc_profile:ViewingCondDesc": "Reference Viewing Condition in IEC61966-2.1",
    "icc_profile:ViewingCondIlluminant": "19.6445 20.3718 16.8089",
    "icc_profile:ViewingCondIlluminantType": "D50",
    "icc_profile:ViewingCondSurround": "3.92889 4.07439 3.36179",
    "iptc:ApplicationRecordVersion": "0",
    "iptc:By-line": "JD Barnes/AMC",
    "iptc:Caption-Abstract": "Courtney B. Vance as Franklin Roberts - 61st Street _ Season 1, Gallery - Photo Credit: JD Barnes/AMC",
    "iptc:CodedCharacterSet": "UTF8",
    "iptc:CopyrightNotice": "© 2022 AMC Film Holdings LLC.  All rights reserved.\n",
    "iptc:Credit": "",
    "iptc:DateCreated": "2021:10:17",
    "iptc:DigitalCreationDate": "2021:10:17 11:53:22",
    "iptc:DigitalCreationTime": "2021:10:17 11:53:22",
    "iptc:Headline": "",
    "iptc:Keywords": "",
    "iptc:SpecialInstructions": "",
    "iptc:Sub-location": "",
    "iptc:TimeCreated": "11:53:22+00:00",
    "iptc:Writer-Editor": "",
    "photoshop:AlphaChannelsNames": "Transparency, Blue copy",
    "photoshop:BitDepth": "8",
    "photoshop:ColorMode": "RGB",
    "photoshop:Compression": "RLE",
    "photoshop:DisplayedUnitsX": "inches",
    "photoshop:DisplayedUnitsY": "inches",
    "photoshop:GlobalAltitude": "30",
    "photoshop:GlobalAngle": "90",
    "photoshop:HasRealMergedData": "Yes",
    "photoshop:IPTCDigest": "97b1b3c7a1232b59f62eb43cdfed1627",
    "photoshop:ImageHeight": "8192",
    "photoshop:ImageWidth": "5464",
    "photoshop:LayerBlendModes": "Normal,Normal,Normal,Normal,Normal,Normal,Normal,Normal,Normal,Normal,Normal,Normal,Normal,Normal,Overlay,Normal,Normal,Darken,Overlay",
    "photoshop:LayerCount": "19",
    "photoshop:LayerModifyDates": "2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00,2022:03:10 20:57:05+00:00",
    "photoshop:LayerNames": "Layer 11,Layer 10,61ST_S2Portrait_Franklin_3769_R,</Layer group>,Layer 7,Layer 7 copy,Brightness/Contrast 1,Hue/Saturation 1,Layer 8,Eyes,</Layer group>,Layer 2,Layer 3,Layer 1,Layer 4,Skin,Layer 9,Layer 12,Layer 13",
    "photoshop:LayerOpacities": "100%,100%,100%,100%,100%,100%,100%,100%,45%,100%,100%,100%,61%,100%,74%,100%,100%,47%,100%",
    "photoshop:LayerRectangles": "0 0 8192 5464,0 0 8192 5464,0 0 8192 5464,0 0 0 0,2807 2179 2929 3238,2807 2179 2929 3238,0 0 0 0,0 0 0 0,2797 2195 2944 3236,0 0 0 0,0 0 0 0,1967 1861 4462 3367,1426 1538 4843 3825,1221 1407 4891 4194,0 0 8192 5464,0 0 0 0,0 0 8192 5464,1469 1689 2787 3724,0 0 8192 5464",
    "photoshop:LayerUnicodeNames": "Layer 11,Layer 10,61ST_S2Portrait_Franklin_3769_RT,</Layer group>,Layer 7,Layer 7 copy,Brightness/Contrast 1,Hue/Saturation 1,Layer 8,Eyes,</Layer group>,Layer 2,Layer 3,Layer 1,Layer 4,Skin,Layer 9,Layer 12,Layer 13",
    "photoshop:NumChannels": "5",
    "photoshop:NumSlices": "1",
    "photoshop:PhotoshopFormat": "Standard",
    "photoshop:PhotoshopQuality": "12",
    "photoshop:PhotoshopThumbnail": "(Binary data 4478 bytes, use -b option to extract)",
    "photoshop:PixelAspectRatio": "1",
    "photoshop:PrintPosition": "0 0",
    "photoshop:PrintScale": "1",
    "photoshop:PrintStyle": "Centered",
    "photoshop:ProgressiveScans": "3 Scans",
    "photoshop:ReaderName": "Adobe Photoshop 2021",
    "photoshop:SlicesGroupName": "61ST_S2Portrait_Franklin_3769_RT",
    "photoshop:URL_List": "",
    "photoshop:WriterName": "Adobe Photoshop",
    "photoshop:XResolution": "300",
    "photoshop:YResolution": "300",
    "png:BitDepth": "8",
    "png:ColorType": "RGB with Alpha",
    "png:Compression": "Deflate/Inflate",
    "png:Copyright": "© 2022 AMC Film Holdings LLC.  All rights reserved. ",
    "png:CreateDate": "2021:10:17 11:53:22",
    "png:Description": "Courtney B. Vance as Franklin Roberts - 61st Street _ Season 1, Gallery - Photo Credit: JD Barnes/AMC",
    "png:Filter": "Adaptive",
    "png:ImageHeight": "6958",
    "png:ImageWidth": "4641",
    "png:Interlace": "Noninterlaced",
    "png:ProfileName": "Photoshop ICC profile",
    "xmp:AlreadyApplied": "true",
    "xmp:ApproximateFocusDistance": "0",
    "xmp:AutoLateralCA": "1",
    "xmp:Blacks2012": "-30",
    "xmp:BlueHue": "0",
    "xmp:BlueSaturation": "0",
    "xmp:CameraProfile": "Adobe Standard",
    "xmp:CameraProfileDigest": "23A8FA817AB0E63610A09E90F3703131",
    "xmp:CaptionWriter": "",
    "xmp:Clarity2012": "+20",
    "xmp:ColorGradeBlending": "50",
    "xmp:ColorGradeGlobalHue": "0",
    "xmp:ColorGradeGlobalLum": "0",
    "xmp:ColorGradeGlobalSat": "0",
    "xmp:ColorGradeHighlightLum": "0",
    "xmp:ColorGradeMidtoneHue": "0",
    "xmp:ColorGradeMidtoneLum": "0",
    "xmp:ColorGradeMidtoneSat": "0",
    "xmp:ColorGradeShadowLum": "0",
    "xmp:ColorMode": "RGB",
    "xmp:ColorNoiseReduction": "25",
    "xmp:ColorNoiseReductionDetail": "50",
    "xmp:ColorNoiseReductionSmoothness": "50",
    "xmp:ColorTemperature": "5800",
    "xmp:Contrast2012": "0",
    "xmp:CreateDate": "2021:10:17 11:53:22",
    "xmp:Creator": "JD Barnes/AMC",
    "xmp:CreatorTool": "Capture One 21 Macintosh",
    "xmp:Credit": "",
    "xmp:DateCreated": "2021:10:17 11:53:22",
    "xmp:DefringeGreenAmount": "0",
    "xmp:DefringeGreenHueHi": "60",
    "xmp:DefringeGreenHueLo": "40",
    "xmp:DefringePurpleAmount": "0",
    "xmp:DefringePurpleHueHi": "70",
    "xmp:DefringePurpleHueLo": "30",
    "xmp:Dehaze": "0",
    "xmp:DerivedFromDocumentID": "xmp.did:f0995c8a-e21e-4be3-af4b-f272cd3b87dc",
    "xmp:DerivedFromInstanceID": "xmp.iid:aa33b28b-3f6c-4a9a-a24a-bd46dd537e60",
    "xmp:DerivedFromOriginalDocumentID": "3311688B00C03A118702200724476968",
    "xmp:Description": "Courtney B. Vance as Franklin Roberts - 61st Street _ Season 1, Gallery - Photo Credit: JD Barnes/AMC",
    "xmp:DocumentAncestors": "xmp.did:0f1a866c-73ac-42d6-b167-0eea3b615c38,xmp.did:f0995c8a-e21e-4be3-af4b-f272cd3b87dc",
    "xmp:DocumentID": "adobe:docid:photoshop:4830f858-32b8-7c4c-8591-24be0a1028fc",
    "xmp:Exposure2012": "0",
    "xmp:Firmware": "Firmware Version 1.4.0",
    "xmp:FlashCompensation": "0",
    "xmp:Format": "image/jpeg",
    "xmp:GrainAmount": "0",
    "xmp:GreenHue": "0",
    "xmp:GreenSaturation": "0",
    "xmp:HasCrop": "false",
    "xmp:HasSettings": "true",
    "xmp:Headline": "",
    "xmp:Highlights2012": "+14",
    "xmp:HistoryAction": "saved,saved,derived,saved,derived,saved,saved,converted,derived,saved",
    "xmp:HistoryChanged": "/metadata,/metadata,/,/,/,/",
    "xmp:HistoryInstanceID": "xmp.iid:2f6e2402-cf77-4057-b8c5-33f16c6a55a3,xmp.iid:b6473f99-24e9-4e32-a0a7-47faf801ac41,xmp.iid:f0995c8a-e21e-4be3-af4b-f272cd3b87dc,xmp.iid:0f1a866c-73ac-42d6-b167-0eea3b615c38,xmp.iid:aa33b28b-3f6c-4a9a-a24a-bd46dd537e60,xmp.iid:21fdb446-40a4-477a-9c85-9e764232b3bc",
    "xmp:HistoryParameters": "converted from image/dng to image/tiff,converted from image/tiff to application/vnd.adobe.photoshop,from application/vnd.adobe.photoshop to image/jpeg,converted from application/vnd.adobe.photoshop to image/jpeg",
    "xmp:HistorySoftwareAgent": "Adobe Photoshop Camera Raw 13.2,Adobe Photoshop Camera Raw 13.2 (Macintosh),Adobe Photoshop Camera Raw 13.2 (Macintosh),Adobe Photoshop 22.3 (Macintosh),Adobe Photoshop 22.3 (Macintosh),Adobe Photoshop 22.3 (Macintosh)",
    "xmp:HistoryWhen": "2022:03:10 13:45:30-05:00,2022:03:10 13:55:09-05:00,2022:03:10 13:55:22-05:00,2022:03:10 15:44:10-05:00,2022:03:10 15:58:26-05:00,2022:03:10 15:58:26-05:00",
    "xmp:HueAdjustmentAqua": "0",
    "xmp:HueAdjustmentBlue": "0",
    "xmp:HueAdjustmentGreen": "0",
    "xmp:HueAdjustmentMagenta": "0",
    "xmp:HueAdjustmentOrange": "0",
    "xmp:HueAdjustmentPurple": "0",
    "xmp:HueAdjustmentRed": "0",
    "xmp:HueAdjustmentYellow": "0",
    "xmp:ICCProfileName": "Adobe RGB (1998)",
    "xmp:InstanceID": "xmp.iid:21fdb446-40a4-477a-9c85-9e764232b3bc",
    "xmp:Instructions": "",
    "xmp:LateralChromaticAberrationCorrectionAlreadyApplied": "true",
    "xmp:Lens": "Canon RF 24-70mm F2.8L IS USM",
    "xmp:LensInfo": "24-70mm f/?",
    "xmp:LensManualDistortionAmount": "0",
    "xmp:LensProfileEnable": "1",
    "xmp:LensProfileSetup": "LensDefaults",
    "xmp:LensSerialNumber": "8413000097",
    "xmp:Location": "",
    "xmp:LookAmount": "1",
    "xmp:LookCopyright": "© 2018 Adobe Systems, Inc.",
    "xmp:LookGroup": "Profiles",
    "xmp:LookName": "Adobe Color",
    "xmp:LookParametersCameraProfile": "Adobe Standard",
    "xmp:LookParametersConvertToGrayscale": "false",
    "xmp:LookParametersLookTable": "E1095149FDB39D7A057BAB208837E2E1",
    "xmp:LookParametersProcessVersion": "11",
    "xmp:LookParametersToneCurvePV2012": "0, 0,22, 16,40, 35,127, 127,224, 230,240, 246,255, 255",
    "xmp:LookParametersToneCurvePV2012Blue": "0, 0,255, 255",
    "xmp:LookParametersToneCurvePV2012Green": "0, 0,255, 255",
    "xmp:LookParametersToneCurvePV2012Red": "0, 0,255, 255",
    "xmp:LookParametersVersion": "13.2",
    "xmp:LookSupportsAmount": "false",
    "xmp:LookSupportsMonochrome": "false",
    "xmp:LookSupportsOutputReferred": "false",
    "xmp:LookUUID": "B952C231111CD8E0ECCF14B86BAA7077",
    "xmp:LuminanceAdjustmentAqua": "0",
    "xmp:LuminanceAdjustmentBlue": "0",
    "xmp:LuminanceAdjustmentGreen": "0",
    "xmp:LuminanceAdjustmentMagenta": "0",
    "xmp:LuminanceAdjustmentOrange": "0",
    "xmp:LuminanceAdjustmentPurple": "0",
    "xmp:LuminanceAdjustmentRed": "0",
    "xmp:LuminanceAdjustmentYellow": "0",
    "xmp:LuminanceSmoothing": "0",
    "xmp:MetadataDate": "2022:03:10 15:58:26-05:00",
    "xmp:ModifyDate": "2022:03:10 15:58:26-05:00",
    "xmp:OriginalDocumentID": "3311688B00C03A118702200724476968",
    "xmp:OverrideLookVignette": "false",
    "xmp:ParametricDarks": "0",
    "xmp:ParametricHighlightSplit": "75",
    "xmp:ParametricHighlights": "0",
    "xmp:ParametricLights": "0",
    "xmp:ParametricMidtoneSplit": "50",
    "xmp:ParametricShadowSplit": "25",
    "xmp:ParametricShadows": "0",
    "xmp:PerspectiveAspect": "0",
    "xmp:PerspectiveHorizontal": "0",
    "xmp:PerspectiveRotate": "0",
    "xmp:PerspectiveScale": "100",
    "xmp:PerspectiveUpright": "0",
    "xmp:PerspectiveVertical": "0",
    "xmp:PerspectiveX": "0",
    "xmp:PerspectiveY": "0",
    "xmp:PostCropVignetteAmount": "0",
    "xmp:ProcessVersion": "11",
    "xmp:Rating": "0",
    "xmp:RedHue": "0",
    "xmp:RedSaturation": "0",
    "xmp:Rights": "© 2022 AMC Film Holdings LLC.  All rights reserved.\n",
    "xmp:Saturation": "0",
    "xmp:SaturationAdjustmentAqua": "0",
    "xmp:SaturationAdjustmentBlue": "-86",
    "xmp:SaturationAdjustmentGreen": "0",
    "xmp:SaturationAdjustmentMagenta": "0",
    "xmp:SaturationAdjustmentOrange": "0",
    "xmp:SaturationAdjustmentPurple": "0",
    "xmp:SaturationAdjustmentRed": "0",
    "xmp:SaturationAdjustmentYellow": "0",
    "xmp:SerialNumber": "062021003048",
    "xmp:ShadowTint": "0",
    "xmp:Shadows2012": "+50",
    "xmp:SharpenDetail": "25",
    "xmp:SharpenEdgeMasking": "0",
    "xmp:SharpenRadius": "+1.0",
    "xmp:Sharpness": "40",
    "xmp:SplitToningBalance": "0",
    "xmp:SplitToningHighlightHue": "0",
    "xmp:SplitToningHighlightSaturation": "0",
    "xmp:SplitToningShadowHue": "0",
    "xmp:SplitToningShadowSaturation": "0",
    "xmp:Subject": "",
    "xmp:Texture": "0",
    "xmp:Tint": "+6",
    "xmp:ToneCurveName2012": "Linear",
    "xmp:ToneCurvePV2012": "0, 0,255, 255",
    "xmp:ToneCurvePV2012Blue": "0, 0,255, 255",
    "xmp:ToneCurvePV2012Green": "0, 0,255, 255",
    "xmp:ToneCurvePV2012Red": "0, 0,255, 255",
    "xmp:Version": "13.2",
    "xmp:Vibrance": "0",
    "xmp:VignetteAmount": "0",
    "xmp:WhiteBalance": "As Shot",
    "xmp:Whites2012": "0",
    "xmp:XMPToolkit": "Image::ExifTool 12.37"
}

```

</details>

### Step 2: Import metadata to Cortex

#### Configure Location (Hierachy) when import to Cortex

*DF_MetadataExport_BO.Data.Entity.Location.SQL*
*DF_MetadataExport_BO.Data.Entity.Location.Template*

#### Configure Fields from temp table to xml imported to Cortex
- Configure sql to map from SYNC_DF_ASSETS to a temp table with sepecific mapping for values
*DF_MetadataExport_BO.Data.Entity.DFAsset.SQL*

- Configure xml to import

Root folder: *DF_MetadataExport_BO.Data.Configuration.DestinationFolderIdentifier*

Template: 
*DF_MetadataExport_BO.Data.Entity.DFAsset.Template*

Notes: All fields used in *DF_MetadataExport_BO.Data.Entity.DFAsset.Template* must be available in Datable v2.2 ListFields. Example, if target is standard image: https://local.orangelogic.com/API/DataTable/V2.2/Documents.Image.Default:ListFields

### Step 3: Download files
All configuration in COR works as expected for now


## Import Containers
### Edit
API call: {{URL}}api/v1/session/xkrypt4s4cn7ddq7jwi4/asset/7891861/edits.js
<details>
<summary>Example response</summary>

```json
[
    {
        "container": "/OL Test (please ignore)/2024-01-18",
        "editorEmail": "dev.vietnam@orangelogic.com",
        "editorName": "ol dev",
        "name": "OL First Edit",
        "selectLevel": "FIRST_SELECT",
        "submitDate": "2024-01-22T04:26:14+0000",
        "type": "USER"
    },
    {
        "container": "/OL Test (please ignore)/2024-01-18",
        "editorEmail": "dev.vietnam@orangelogic.com",
        "editorName": "ol dev",
        "name": "Main",
        "selectLevel": "SECOND_SELECT",
        "submitDate": "2024-01-22T03:02:05+0000",
        "type": "USER"
    }
]

```

</details>


Paramter changes compare to HULU
DF_ContainerMetadataExport_EditsOnly_BO.Data.SQL.UpdateAssetParentFolderID 


API call to list fields failed: Datatable/v2.1/Document.WorkflowStep.Link:ListFields?UseSystemNames=1
https://link.orangelogic.com/Tasks/21128T

#### Setup Agent Job for Edit Only - Sync
![image](https://hackmd.io/_uploads/Hy3-4TiYT.png)

#### Parameter to edit: 
DF_ContainerMetadataExport_EditsOnly_BO
*DF_ContainerMetadataExport_EditsOnly_BO.Data.SQL.BuildFolderTempTable*
*DF_ContainerMetadataExport_EditsOnly_BO.Data.SQL.ListRecords*
*DF_ContainerMetadataExport_EditsOnly_BO.Data.SQL.UpdateAssetParentFolderID*

**In COR, the temp table are mismatched, need to correct them, all DFSync_ => DFSyncContainers_**


### Approvals + Messages
API
{{URL}}api/v1/session/z9v7zyvvy99dw1w4g48k/asset/7891861/approvals.js
Sample Response
```json
[
    {
        "approvalState": "Pending",
        "messengerId": "14854",
        "messengerName": "2024-01-18",
        "messengerSentDate": "2024-01-22T05:05:07+0000",
        "recipientEmail": "lanh.nguyen@orangelogic.com",
        "recipientName": "",
        "senderEmail": "dev.vietnam@orangelogic.com",
        "senderName": "ol dev"
    }
]
```

Must change type "MESSAGE" To "MESSAGE_AS_SENT"









