Collating 3 listings according to matching values of the Remapped Logical Digital image name (RLDIN).
The Logical DIN (LDIN) is first mapped to a standardized logical DIN (SLDIN) according to defined rules: strip out all but letters and numbers, convert to upper case. The SLDIN is mapped to the Remapped logical DIN (RLDIN) according to custom mappings: in most cases the RLDIN matches the SLDIN but custom mapping allows us to overcome collation problems when file names for TIFFs in particular do not follow convention. Finally, it is the RLDIN that is used for collating the three listings.
| Remapped Logical DIN (RLDIN) | [Images] records in database | JPGs on IDP server | TIFs on NAS drive | Exist? (Image/JPG/TIFF) |
| BLB44SF270710R |
| IMG: | BLB44_SF270710_R |
| LDIN: | BLB44_SF270710_R |
| SLDIN: | BLB44SF270710R |
| UUID: | 8B61F08ED8184F39AEF97ACA2B5D8295 |
| Pressmark: | SF170707_de |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_R_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 37M |
| LDIN: | BLB44_SF270710_R |
| SLDIN: | BLB44SF270710R |
| | |
| TIF: | BLB44_SF270710_R_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF270710_R |
| SLDIN: | BLB44SF270710R |
| | |
| YNY |
| BLB44SF270710RST |
| IMG: | BLB44_SF270710_R_ST |
| LDIN: | BLB44_SF270710_R_ST |
| SLDIN: | BLB44SF270710RST |
| UUID: | 0AE31250035F4589B8E92B8FBFDFE1F5 |
| Pressmark: | SF270710 |
| Thum_type: | StitchedR |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_R_ST.tif |
| path: | ./BLB/BLB44/ |
| size: | 68M |
| LDIN: | BLB44_SF270710_R_ST |
| SLDIN: | BLB44SF270710RST |
| | |
| YNY |
| BLB44SF270710R11 |
| IMG: | BLB44_SF270710_R1_1 |
| LDIN: | BLB44_SF270710_R1_1 |
| SLDIN: | BLB44SF270710R11 |
| UUID: | 5273736525724066A84D70214834F52C |
| Pressmark: | SF270710 |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_R1_1.NEF |
| path: | ./BLB/BLB44/ |
| size: | 15M |
| LDIN: | BLB44_SF270710_R1_1 |
| SLDIN: | BLB44SF270710R11 |
| | |
| TIF: | BLB44_SF270710_R1_1_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 36M |
| LDIN: | BLB44_SF270710_R1_1 |
| SLDIN: | BLB44SF270710R11 |
| | |
| TIF: | BLB44_SF270710_R1_1_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF270710_R1_1 |
| SLDIN: | BLB44SF270710R11 |
| | |
| YNY |
| BLB44SF270710R12 |
| IMG: | BLB44_SF270710_R1_2 |
| LDIN: | BLB44_SF270710_R1_2 |
| SLDIN: | BLB44SF270710R12 |
| UUID: | 34EC4E860150416F98EC4E8935819950 |
| Pressmark: | SF270710 |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_R1_2.NEF |
| path: | ./BLB/BLB44/ |
| size: | 15M |
| LDIN: | BLB44_SF270710_R1_2 |
| SLDIN: | BLB44SF270710R12 |
| | |
| TIF: | BLB44_SF270710_R1_2_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 36M |
| LDIN: | BLB44_SF270710_R1_2 |
| SLDIN: | BLB44SF270710R12 |
| | |
| TIF: | BLB44_SF270710_R1_2_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF270710_R1_2 |
| SLDIN: | BLB44SF270710R12 |
| | |
| YNY |
| BLB44SF270710R13 |
| IMG: | BLB44_SF270710_R1_3 |
| LDIN: | BLB44_SF270710_R1_3 |
| SLDIN: | BLB44SF270710R13 |
| UUID: | 3648BB07C5A24ABC82DB8D94F6400D18 |
| Pressmark: | SF270710 |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_R1_3.NEF |
| path: | ./BLB/BLB44/ |
| size: | 15M |
| LDIN: | BLB44_SF270710_R1_3 |
| SLDIN: | BLB44SF270710R13 |
| | |
| TIF: | BLB44_SF270710_R1_3_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 36M |
| LDIN: | BLB44_SF270710_R1_3 |
| SLDIN: | BLB44SF270710R13 |
| | |
| TIF: | BLB44_SF270710_R1_3_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF270710_R1_3 |
| SLDIN: | BLB44SF270710R13 |
| | |
| YNY |
| BLB44SF270710V |
| IMG: | BLB44_SF270710_V |
| LDIN: | BLB44_SF270710_V |
| SLDIN: | BLB44SF270710V |
| UUID: | 848D60844C1F4B7EAACB38EB28F4A9B7 |
| Pressmark: | SF170707_de |
| Thum_type: | Verso |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_V.NEF |
| path: | ./BLB/BLB44/ |
| size: | 16M |
| LDIN: | BLB44_SF270710_V |
| SLDIN: | BLB44SF270710V |
| | |
| TIF: | BLB44_SF270710_V_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 37M |
| LDIN: | BLB44_SF270710_V |
| SLDIN: | BLB44SF270710V |
| | |
| TIF: | BLB44_SF270710_V_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF270710_V |
| SLDIN: | BLB44SF270710V |
| | |
| YNY |
| BLB44SF270710VST |
| IMG: | BLB44_SF270710_V_ST |
| LDIN: | BLB44_SF270710_V_ST |
| SLDIN: | BLB44SF270710VST |
| UUID: | 9398ADB0D1C448E78BE1BDCBDAC79259 |
| Pressmark: | SF270710 |
| Thum_type: | StitchedV |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_V_ST.tif |
| path: | ./BLB/BLB44/ |
| size: | 68M |
| LDIN: | BLB44_SF270710_V_ST |
| SLDIN: | BLB44SF270710VST |
| | |
| YNY |
| BLB44SF270710V11 |
| IMG: | BLB44_SF270710_V1_1 |
| LDIN: | BLB44_SF270710_V1_1 |
| SLDIN: | BLB44SF270710V11 |
| UUID: | 61E108BA0AE34CCFAC8E47C671F6DDC1 |
| Pressmark: | SF270710 |
| Thum_type: | Verso |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_V1_1.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF270710_V1_1 |
| SLDIN: | BLB44SF270710V11 |
| | |
| TIF: | BLB44_SF270710_V1_1_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 36M |
| LDIN: | BLB44_SF270710_V1_1 |
| SLDIN: | BLB44SF270710V11 |
| | |
| TIF: | BLB44_SF270710_V1_1_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF270710_V1_1 |
| SLDIN: | BLB44SF270710V11 |
| | |
| YNY |
| BLB44SF270710VB1 |
| IMG: | BLB44_SF270710_VB_1 |
| LDIN: | BLB44_SF270710_VB_1 |
| SLDIN: | BLB44SF270710VB1 |
| UUID: | 0D861A6AEE6C4F04AD51998E328013B9 |
| Pressmark: | SF270710 |
| Thum_type: | Verso |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_VB_1.NEF |
| path: | ./BLB/BLB44/ |
| size: | 15M |
| LDIN: | BLB44_SF270710_VB_1 |
| SLDIN: | BLB44SF270710VB1 |
| | |
| TIF: | BLB44_SF270710_VB_1_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 36M |
| LDIN: | BLB44_SF270710_VB_1 |
| SLDIN: | BLB44SF270710VB1 |
| | |
| TIF: | BLB44_SF270710_VB_1_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF270710_VB_1 |
| SLDIN: | BLB44SF270710VB1 |
| | |
| YNY |
| BLB44SF270710VB2 |
| IMG: | BLB44_SF270710_VB_2 |
| LDIN: | BLB44_SF270710_VB_2 |
| SLDIN: | BLB44SF270710VB2 |
| UUID: | F1CE8BD4DDEB4C83A76BC2622021185A |
| Pressmark: | SF270710 |
| Thum_type: | Verso |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF270710_VB_2.NEF |
| path: | ./BLB/BLB44/ |
| size: | 15M |
| LDIN: | BLB44_SF270710_VB_2 |
| SLDIN: | BLB44SF270710VB2 |
| | |
| TIF: | BLB44_SF270710_VB_2_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 36M |
| LDIN: | BLB44_SF270710_VB_2 |
| SLDIN: | BLB44SF270710VB2 |
| | |
| TIF: | BLB44_SF270710_VB_2_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF270710_VB_2 |
| SLDIN: | BLB44SF270710VB2 |
| | |
| YNY |
| BLB44SF9164AA |
| IMG: | BLB44_SF9164AA |
| LDIN: | BLB44_SF9164AA |
| SLDIN: | BLB44SF9164AA |
| UUID: | 6FFAC74BCAA4453FB798AC9BC81EFCC0 |
| Pressmark: | SF9164A |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF9164AA.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF9164AA |
| SLDIN: | BLB44SF9164AA |
| | |
| TIF: | BLB44_SF9164AA_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 35M |
| LDIN: | BLB44_SF9164AA |
| SLDIN: | BLB44SF9164AA |
| | |
| TIF: | BLB44_SF9164AA_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF9164AA |
| SLDIN: | BLB44SF9164AA |
| | |
| YNY |
| BLB44SF9164AB |
| IMG: | BLB44_SF9164AB |
| LDIN: | BLB44_SF9164AB |
| SLDIN: | BLB44SF9164AB |
| UUID: | 73DCD01190924770B1A307050E8E1089 |
| Pressmark: | SF9164A |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF9164AB.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF9164AB |
| SLDIN: | BLB44SF9164AB |
| | |
| TIF: | BLB44_SF9164AB_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 35M |
| LDIN: | BLB44_SF9164AB |
| SLDIN: | BLB44SF9164AB |
| | |
| TIF: | BLB44_SF9164AB_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF9164AB |
| SLDIN: | BLB44SF9164AB |
| | |
| YNY |
| BLB44SF9164AC |
| IMG: | BLB44_SF9164AC |
| LDIN: | BLB44_SF9164AC |
| SLDIN: | BLB44SF9164AC |
| UUID: | 0866D88FE13B4A21930AB0DF0A4DB068 |
| Pressmark: | SF9164A |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF9164AC.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF9164AC |
| SLDIN: | BLB44SF9164AC |
| | |
| TIF: | BLB44_SF9164AC_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 35M |
| LDIN: | BLB44_SF9164AC |
| SLDIN: | BLB44SF9164AC |
| | |
| TIF: | BLB44_SF9164AC_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF9164AC |
| SLDIN: | BLB44SF9164AC |
| | |
| YNY |
| BLB44SF9164BA |
| IMG: | BLB44_SF9164BA |
| LDIN: | BLB44_SF9164BA |
| SLDIN: | BLB44SF9164BA |
| UUID: | 90A3D622A27F4D478EA76AAB04393D41 |
| Pressmark: | SF9164B |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF9164BA.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF9164BA |
| SLDIN: | BLB44SF9164BA |
| | |
| TIF: | BLB44_SF9164BA_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 35M |
| LDIN: | BLB44_SF9164BA |
| SLDIN: | BLB44SF9164BA |
| | |
| TIF: | BLB44_SF9164BA_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF9164BA |
| SLDIN: | BLB44SF9164BA |
| | |
| YNY |
| BLB44SF9164BB |
| IMG: | BLB44_SF9164BB |
| LDIN: | BLB44_SF9164BB |
| SLDIN: | BLB44SF9164BB |
| UUID: | FF8DDCC998A044A3BD2DFE15873D3199 |
| Pressmark: | SF9164B |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF9164BB.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF9164BB |
| SLDIN: | BLB44SF9164BB |
| | |
| TIF: | BLB44_SF9164BB_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 35M |
| LDIN: | BLB44_SF9164BB |
| SLDIN: | BLB44SF9164BB |
| | |
| TIF: | BLB44_SF9164BB_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF9164BB |
| SLDIN: | BLB44SF9164BB |
| | |
| YNY |
| BLB44SF9164BC |
| IMG: | BLB44_SF9164BC |
| LDIN: | BLB44_SF9164BC |
| SLDIN: | BLB44SF9164BC |
| UUID: | 4A3BFF09F65F4315B77228C146F773B9 |
| Pressmark: | SF9164B |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF9164BC.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF9164BC |
| SLDIN: | BLB44SF9164BC |
| | |
| TIF: | BLB44_SF9164BC_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 35M |
| LDIN: | BLB44_SF9164BC |
| SLDIN: | BLB44SF9164BC |
| | |
| TIF: | BLB44_SF9164BC_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF9164BC |
| SLDIN: | BLB44SF9164BC |
| | |
| YNY |
| BLB44SF9164CA |
| IMG: | BLB44_SF9164CA |
| LDIN: | BLB44_SF9164CA |
| SLDIN: | BLB44SF9164CA |
| UUID: | 85C5BD462FF84396A451ED1E9737D760 |
| Pressmark: | SF9164C |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF9164CA.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF9164CA |
| SLDIN: | BLB44SF9164CA |
| | |
| TIF: | BLB44_SF9164CA_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 35M |
| LDIN: | BLB44_SF9164CA |
| SLDIN: | BLB44SF9164CA |
| | |
| TIF: | BLB44_SF9164CA_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF9164CA |
| SLDIN: | BLB44SF9164CA |
| | |
| YNY |
| BLB44SF9164CB |
| IMG: | BLB44_SF9164CB |
| LDIN: | BLB44_SF9164CB |
| SLDIN: | BLB44SF9164CB |
| UUID: | B839CA5DE755444F9494056ED370B6EB |
| Pressmark: | SF9164C |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF9164CB.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF9164CB |
| SLDIN: | BLB44SF9164CB |
| | |
| TIF: | BLB44_SF9164CB_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 35M |
| LDIN: | BLB44_SF9164CB |
| SLDIN: | BLB44SF9164CB |
| | |
| TIF: | BLB44_SF9164CB_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF9164CB |
| SLDIN: | BLB44SF9164CB |
| | |
| YNY |
| BLB44SF9164CC |
| IMG: | BLB44_SF9164CC |
| LDIN: | BLB44_SF9164CC |
| SLDIN: | BLB44SF9164CC |
| UUID: | B6547234CC6144168CFC59738FC5D929 |
| Pressmark: | SF9164C |
| Thum_type: | Recto |
| Manip_comp: | true
|
|
| | TIF: | BLB44_SF9164CC.NEF |
| path: | ./BLB/BLB44/ |
| size: | 14M |
| LDIN: | BLB44_SF9164CC |
| SLDIN: | BLB44SF9164CC |
| | |
| TIF: | BLB44_SF9164CC_L.tif |
| path: | ./BLB/BLB44/ |
| size: | 35M |
| LDIN: | BLB44_SF9164CC |
| SLDIN: | BLB44SF9164CC |
| | |
| TIF: | BLB44_SF9164CC_R.tif |
| path: | ./BLB/BLB44/ |
| size: | 70M |
| LDIN: | BLB44_SF9164CC |
| SLDIN: | BLB44SF9164CC |
| | |
| YNY |
| BLB44SF270710 |
|
| | TIF: | BLB44_SF270710_R.NEF |
| path: | ./BLB/BLB44/ |
| size: | 15M |
| LDIN: | BLB44_SF270710 |
| SLDIN: | BLB44SF270710 |
| | |
| NNY |