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) |
| BLX2137OR8210S6355R1ST3 |
| IMG: | BLX2137_OR8210S6355R1_ST3 |
| LDIN: | BLX2137_OR8210S6355R1_ST3 |
| SLDIN: | BLX2137OR8210S6355R1ST3 |
| UUID: | 4975E6D1652C48D3807CC18CBBE84252 |
| Pressmark: | Or.8210/S.6355 |
| Thum_type: | none |
| Manip_comp: | true
|
|
| | TIF: | BLX2137_OR8210S6355R1_ST3_L.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 142M |
| LDIN: | BLX2137_OR8210S6355R1_ST3 |
| SLDIN: | BLX2137OR8210S6355R1ST3 |
| | |
| YNY |
| BLX2137OR8210S6355R1ST4 |
| IMG: | BLX2137_OR8210S6355R1_ST4 |
| LDIN: | BLX2137_OR8210S6355R1_ST4 |
| SLDIN: | BLX2137OR8210S6355R1ST4 |
| UUID: | 0D9F5C1E4A74454396490F428811AB42 |
| Pressmark: | Or.8210/S.6355 |
| Thum_type: | none |
| Manip_comp: | true
|
|
| | TIF: | BLX2137_OR8210S6355R1_ST4_L.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 149M |
| LDIN: | BLX2137_OR8210S6355R1_ST4 |
| SLDIN: | BLX2137OR8210S6355R1ST4 |
| | |
| YNY |
| BLX2137OR8210S6355V1ST |
| IMG: | BLX2137_OR8210S6355V1_ST |
| LDIN: | BLX2137_OR8210S6355V1_ST |
| SLDIN: | BLX2137OR8210S6355V1ST |
| UUID: | A541F08F1C4F4BC7B865CABD094FBF8D |
| Pressmark: | Or.8210/S.6355 |
| Thum_type: | StitchedV |
| Manip_comp: | true
|
|
| JPG: | BLX2137_OR8210S6355V1_ST_M
|
| path: | ./BLX/BLX2137/ |
| size: | 460K |
| LDIN: | BLX2137_OR8210S6355V1_ST |
| SLDIN: | BLX2137OR8210S6355V1ST |
| | |
| | TIF: | BLX2137_OR8210S6355V1_ST_L.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 56M |
| LDIN: | BLX2137_OR8210S6355V1_ST |
| SLDIN: | BLX2137OR8210S6355V1ST |
| | |
| YYY |
| BLX2137OR8210S6355V1ST1 |
| IMG: | BLX2137_OR8210S6355V1_ST1 |
| LDIN: | BLX2137_OR8210S6355V1_ST1 |
| SLDIN: | BLX2137OR8210S6355V1ST1 |
| UUID: | 30D155E33A4745DA90B4E617686223ED |
| Pressmark: | Or.8210/S.6355 |
| Thum_type: | none |
| Manip_comp: | true
|
|
| | TIF: | BLX2137_OR8210S6355V1_ST1_L.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 154M |
| LDIN: | BLX2137_OR8210S6355V1_ST1 |
| SLDIN: | BLX2137OR8210S6355V1ST1 |
| | |
| YNY |
| BLX2137OR8210S6355VB10 |
| IMG: | BLX2137_OR8210S6355VB_10 |
| LDIN: | BLX2137_OR8210S6355VB_10 |
| SLDIN: | BLX2137OR8210S6355VB10 |
| UUID: | B3F5199823BF48F5B073CB75785BAB81 |
| Pressmark: | Or.8210/S.6355 |
| Thum_type: | Verso |
| Manip_comp: | true
|
|
| JPG: | BLX2137_OR8210S6355VB_10_L
|
| path: | ./BLX/BLX2137/ |
| size: | 221K |
| LDIN: | BLX2137_OR8210S6355VB_10 |
| SLDIN: | BLX2137OR8210S6355VB10 |
| | |
| JPG: | BLX2137_OR8210S6355VB_10_M
|
| path: | ./BLX/BLX2137/ |
| size: | 34K |
| LDIN: | BLX2137_OR8210S6355VB_10 |
| SLDIN: | BLX2137OR8210S6355VB10 |
| | |
| JPG: | BLX2137_OR8210S6355VB_10_T
|
| path: | ./BLX/BLX2137/ |
| size: | 2.3K |
| LDIN: | BLX2137_OR8210S6355VB_10 |
| SLDIN: | BLX2137OR8210S6355VB10 |
| | |
| | TIF: | BLX2137_OR8210S6355VB_10_L.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 15M |
| LDIN: | BLX2137_OR8210S6355VB_10 |
| SLDIN: | BLX2137OR8210S6355VB10 |
| | |
| TIF: | BLX2137_OR8210S6355VB_10_R.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 12M |
| LDIN: | BLX2137_OR8210S6355VB_10 |
| SLDIN: | BLX2137OR8210S6355VB10 |
| | |
| YYY |
| BLX2137OR8210S6355VB11 |
| IMG: | BLX2137_OR8210S6355VB_11 |
| LDIN: | BLX2137_OR8210S6355VB_11 |
| SLDIN: | BLX2137OR8210S6355VB11 |
| UUID: | 809AE184799B4CE3913EE654C3F1D619 |
| Pressmark: | Or.8210/S.6355 |
| Thum_type: | Verso |
| Manip_comp: | true
|
|
| JPG: | BLX2137_OR8210S6355VB_11_L
|
| path: | ./BLX/BLX2137/ |
| size: | 227K |
| LDIN: | BLX2137_OR8210S6355VB_11 |
| SLDIN: | BLX2137OR8210S6355VB11 |
| | |
| JPG: | BLX2137_OR8210S6355VB_11_M
|
| path: | ./BLX/BLX2137/ |
| size: | 35K |
| LDIN: | BLX2137_OR8210S6355VB_11 |
| SLDIN: | BLX2137OR8210S6355VB11 |
| | |
| JPG: | BLX2137_OR8210S6355VB_11_T
|
| path: | ./BLX/BLX2137/ |
| size: | 2.3K |
| LDIN: | BLX2137_OR8210S6355VB_11 |
| SLDIN: | BLX2137OR8210S6355VB11 |
| | |
| | TIF: | BLX2137_OR8210S6355VB_11_L.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 15M |
| LDIN: | BLX2137_OR8210S6355VB_11 |
| SLDIN: | BLX2137OR8210S6355VB11 |
| | |
| TIF: | BLX2137_OR8210S6355VB_11_R.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 12M |
| LDIN: | BLX2137_OR8210S6355VB_11 |
| SLDIN: | BLX2137OR8210S6355VB11 |
| | |
| YYY |
| BLX2137OR8210S6355VB12 |
| IMG: | BLX2137_OR8210S6355VB_12 |
| LDIN: | BLX2137_OR8210S6355VB_12 |
| SLDIN: | BLX2137OR8210S6355VB12 |
| UUID: | 845FD92F9CBD42B7B91E2F211280F9E7 |
| Pressmark: | Or.8210/S.6355 |
| Thum_type: | Verso |
| Manip_comp: | true
|
|
| JPG: | BLX2137_OR8210S6355VB_12_L
|
| path: | ./BLX/BLX2137/ |
| size: | 211K |
| LDIN: | BLX2137_OR8210S6355VB_12 |
| SLDIN: | BLX2137OR8210S6355VB12 |
| | |
| JPG: | BLX2137_OR8210S6355VB_12_M
|
| path: | ./BLX/BLX2137/ |
| size: | 32K |
| LDIN: | BLX2137_OR8210S6355VB_12 |
| SLDIN: | BLX2137OR8210S6355VB12 |
| | |
| JPG: | BLX2137_OR8210S6355VB_12_T
|
| path: | ./BLX/BLX2137/ |
| size: | 2.2K |
| LDIN: | BLX2137_OR8210S6355VB_12 |
| SLDIN: | BLX2137OR8210S6355VB12 |
| | |
| | TIF: | BLX2137_OR8210S6355VB_12_L.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 15M |
| LDIN: | BLX2137_OR8210S6355VB_12 |
| SLDIN: | BLX2137OR8210S6355VB12 |
| | |
| TIF: | BLX2137_OR8210S6355VB_12_R.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 12M |
| LDIN: | BLX2137_OR8210S6355VB_12 |
| SLDIN: | BLX2137OR8210S6355VB12 |
| | |
| YYY |
| BLX2137OR8210S6355VB13 |
| IMG: | BLX2137_OR8210S6355VB_13 |
| LDIN: | BLX2137_OR8210S6355VB_13 |
| SLDIN: | BLX2137OR8210S6355VB13 |
| UUID: | C03120B31D454716B1C80D63DE2EC0FB |
| Pressmark: | Or.8210/S.6355 |
| Thum_type: | Verso |
| Manip_comp: | true
|
|
| JPG: | BLX2137_OR8210S6355VB_13_L
|
| path: | ./BLX/BLX2137/ |
| size: | 221K |
| LDIN: | BLX2137_OR8210S6355VB_13 |
| SLDIN: | BLX2137OR8210S6355VB13 |
| | |
| JPG: | BLX2137_OR8210S6355VB_13_M
|
| path: | ./BLX/BLX2137/ |
| size: | 33K |
| LDIN: | BLX2137_OR8210S6355VB_13 |
| SLDIN: | BLX2137OR8210S6355VB13 |
| | |
| JPG: | BLX2137_OR8210S6355VB_13_T
|
| path: | ./BLX/BLX2137/ |
| size: | 2.2K |
| LDIN: | BLX2137_OR8210S6355VB_13 |
| SLDIN: | BLX2137OR8210S6355VB13 |
| | |
| | TIF: | BLX2137_OR8210S6355VB_13_L.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 15M |
| LDIN: | BLX2137_OR8210S6355VB_13 |
| SLDIN: | BLX2137OR8210S6355VB13 |
| | |
| TIF: | BLX2137_OR8210S6355VB_13_R.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 12M |
| LDIN: | BLX2137_OR8210S6355VB_13 |
| SLDIN: | BLX2137OR8210S6355VB13 |
| | |
| YYY |
| BLX2137OR8210S6355VB14 |
| IMG: | BLX2137_OR8210S6355VB_14 |
| LDIN: | BLX2137_OR8210S6355VB_14 |
| SLDIN: | BLX2137OR8210S6355VB14 |
| UUID: | 9B7659E6463746E1A0172D0FC10432AC |
| Pressmark: | Or.8210/S.6355 |
| Thum_type: | Verso |
| Manip_comp: | true
|
|
| JPG: | BLX2137_OR8210S6355VB_14_L
|
| path: | ./BLX/BLX2137/ |
| size: | 218K |
| LDIN: | BLX2137_OR8210S6355VB_14 |
| SLDIN: | BLX2137OR8210S6355VB14 |
| | |
| JPG: | BLX2137_OR8210S6355VB_14_M
|
| path: | ./BLX/BLX2137/ |
| size: | 34K |
| LDIN: | BLX2137_OR8210S6355VB_14 |
| SLDIN: | BLX2137OR8210S6355VB14 |
| | |
| JPG: | BLX2137_OR8210S6355VB_14_T
|
| path: | ./BLX/BLX2137/ |
| size: | 2.2K |
| LDIN: | BLX2137_OR8210S6355VB_14 |
| SLDIN: | BLX2137OR8210S6355VB14 |
| | |
| | TIF: | BLX2137_OR8210S6355VB_14_L.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 15M |
| LDIN: | BLX2137_OR8210S6355VB_14 |
| SLDIN: | BLX2137OR8210S6355VB14 |
| | |
| TIF: | BLX2137_OR8210S6355VB_14_R.tif |
| path: | ./BLX/BLX2137/BLX2137/ |
| size: | 12M |
| LDIN: | BLX2137_OR8210S6355VB_14 |
| SLDIN: | BLX2137OR8210S6355VB14 |
| | |
| YYY |