# 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
### 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
#### 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"
Sign in with Wallet
Connect another wallet