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) |
| BLX3140OR8210S3454R1ST |
| IMG: | BLX3140_OR8210S3454R1_ST |
| LDIN: | BLX3140_OR8210S3454R1_ST |
| SLDIN: | BLX3140OR8210S3454R1ST |
| UUID: | 41ACC8A8FFC64666BFC73BCB4F185DA7 |
| Pressmark: | Or.8210/S.3454 |
| Thum_type: | StitchedR |
| Manip_comp: | true
|
|
| JPG: | BLX3140_OR8210S3454R1_ST_M
|
| path: | ./BLX/BLX3140/ |
| size: | 2.1M |
| LDIN: | BLX3140_OR8210S3454R1_ST |
| SLDIN: | BLX3140OR8210S3454R1ST |
| | |
| | TIF: | BLX3140_OR8210S3454R1_ST_L.tif |
| path: | ./BLX/BLX3140/ |
| size: | 108M |
| LDIN: | BLX3140_OR8210S3454R1_ST |
| SLDIN: | BLX3140OR8210S3454R1ST |
| | |
| YYY |
| BLX3140OR8210S3454R1ST1 |
| IMG: | BLX3140_OR8210S3454R1_ST1 |
| LDIN: | BLX3140_OR8210S3454R1_ST1 |
| SLDIN: | BLX3140OR8210S3454R1ST1 |
| UUID: | D72334F769764F8BA935C4A6A9EEB665 |
| Pressmark: | Or.8210/S.3454 |
| Thum_type: | none |
| Manip_comp: | true
|
|
| | TIF: | BLX3140_OR8210S3454R1_ST1_L.tif |
| path: | ./BLX/BLX3140/ |
| size: | 174M |
| LDIN: | BLX3140_OR8210S3454R1_ST1 |
| SLDIN: | BLX3140OR8210S3454R1ST1 |
| | |
| YNY |
| BLX3140OR8210S3454R1ST2 |
| IMG: | BLX3140_OR8210S3454R1_ST2 |
| LDIN: | BLX3140_OR8210S3454R1_ST2 |
| SLDIN: | BLX3140OR8210S3454R1ST2 |
| UUID: | 2094BA69682642A99C17796BB3294177 |
| Pressmark: | Or.8210/S.3454 |
| Thum_type: | none |
| Manip_comp: | true
|
|
| | TIF: | BLX3140_OR8210S3454R1_ST2_L.tif |
| path: | ./BLX/BLX3140/ |
| size: | 174M |
| LDIN: | BLX3140_OR8210S3454R1_ST2 |
| SLDIN: | BLX3140OR8210S3454R1ST2 |
| | |
| YNY |
| BLX3140OR8210S3454V11E |
| IMG: | BLX3140_OR8210S3454V1_1E |
| LDIN: | BLX3140_OR8210S3454V1_1E |
| SLDIN: | BLX3140OR8210S3454V11E |
| UUID: | 8662347AA781430D93308F4C2CD20172 |
| Pressmark: | Or.8210/S.3454 |
| Thum_type: | More |
| Manip_comp: | true
|
|
| JPG: | BLX3140_OR8210S3454V1_1E_L
|
| path: | ./BLX/BLX3140/ |
| size: | 111K |
| LDIN: | BLX3140_OR8210S3454V1_1E |
| SLDIN: | BLX3140OR8210S3454V11E |
| | |
| JPG: | BLX3140_OR8210S3454V1_1E_M
|
| path: | ./BLX/BLX3140/ |
| size: | 32K |
| LDIN: | BLX3140_OR8210S3454V1_1E |
| SLDIN: | BLX3140OR8210S3454V11E |
| | |
| JPG: | BLX3140_OR8210S3454V1_1E_T
|
| path: | ./BLX/BLX3140/ |
| size: | 2.8K |
| LDIN: | BLX3140_OR8210S3454V1_1E |
| SLDIN: | BLX3140OR8210S3454V11E |
| | |
| | TIF: | BLX3140_OR8210S3454V1_1E_L.tif |
| path: | ./BLX/BLX3140/ |
| size: | 15M |
| LDIN: | BLX3140_OR8210S3454V1_1E |
| SLDIN: | BLX3140OR8210S3454V11E |
| | |
| TIF: | BLX3140_OR8210S3454V1_1E_R.tif |
| path: | ./BLX/BLX3140/ |
| size: | 26M |
| LDIN: | BLX3140_OR8210S3454V1_1E |
| SLDIN: | BLX3140OR8210S3454V11E |
| | |
| YYY |
| BLX3140OR8210S3454VB15E1 |
| IMG: | BLX3140_OR8210S3454VB_15E1 |
| LDIN: | BLX3140_OR8210S3454VB_15E1 |
| SLDIN: | BLX3140OR8210S3454VB15E1 |
| UUID: | 68901B42F9F84F0892570E571BBF8BDD |
| Pressmark: | Or.8210/S.3454 |
| Thum_type: | More |
| Manip_comp: | true
|
|
| JPG: | BLX3140_OR8210S3454VB_15E1_L
|
| path: | ./BLX/BLX3140/ |
| size: | 39K |
| LDIN: | BLX3140_OR8210S3454VB_15E1 |
| SLDIN: | BLX3140OR8210S3454VB15E1 |
| | |
| JPG: | BLX3140_OR8210S3454VB_15E1_M
|
| path: | ./BLX/BLX3140/ |
| size: | 13K |
| LDIN: | BLX3140_OR8210S3454VB_15E1 |
| SLDIN: | BLX3140OR8210S3454VB15E1 |
| | |
| JPG: | BLX3140_OR8210S3454VB_15E1_T
|
| path: | ./BLX/BLX3140/ |
| size: | 2.0K |
| LDIN: | BLX3140_OR8210S3454VB_15E1 |
| SLDIN: | BLX3140OR8210S3454VB15E1 |
| | |
| | YYN |
| BLX3140OR8210S3454VB15E2 |
| IMG: | BLX3140_OR8210S3454VB_15E2 |
| LDIN: | BLX3140_OR8210S3454VB_15E2 |
| SLDIN: | BLX3140OR8210S3454VB15E2 |
| UUID: | 093680051E3848E78859567FE2B6689C |
| Pressmark: | Or.8210/S.3454 |
| Thum_type: | More |
| Manip_comp: | true
|
|
| JPG: | BLX3140_OR8210S3454VB_15E2_L
|
| path: | ./BLX/BLX3140/ |
| size: | 133K |
| LDIN: | BLX3140_OR8210S3454VB_15E2 |
| SLDIN: | BLX3140OR8210S3454VB15E2 |
| | |
| JPG: | BLX3140_OR8210S3454VB_15E2_M
|
| path: | ./BLX/BLX3140/ |
| size: | 37K |
| LDIN: | BLX3140_OR8210S3454VB_15E2 |
| SLDIN: | BLX3140OR8210S3454VB15E2 |
| | |
| JPG: | BLX3140_OR8210S3454VB_15E2_T
|
| path: | ./BLX/BLX3140/ |
| size: | 2.8K |
| LDIN: | BLX3140_OR8210S3454VB_15E2 |
| SLDIN: | BLX3140OR8210S3454VB15E2 |
| | |
| | YYN |
| BLX3140OR8210S3454VB17E |
| IMG: | BLX3140_OR8210S3454VB_17E |
| LDIN: | BLX3140_OR8210S3454VB_17E |
| SLDIN: | BLX3140OR8210S3454VB17E |
| UUID: | 034FDA3F180A4D26A827C3C4F97FDBCA |
| Pressmark: | Or.8210/S.3454 |
| Thum_type: | More |
| Manip_comp: | true
|
|
| JPG: | BLX3140_OR8210S3454VB_17E_L
|
| path: | ./BLX/BLX3140/ |
| size: | 138K |
| LDIN: | BLX3140_OR8210S3454VB_17E |
| SLDIN: | BLX3140OR8210S3454VB17E |
| | |
| JPG: | BLX3140_OR8210S3454VB_17E_M
|
| path: | ./BLX/BLX3140/ |
| size: | 38K |
| LDIN: | BLX3140_OR8210S3454VB_17E |
| SLDIN: | BLX3140OR8210S3454VB17E |
| | |
| JPG: | BLX3140_OR8210S3454VB_17E_T
|
| path: | ./BLX/BLX3140/ |
| size: | 2.9K |
| LDIN: | BLX3140_OR8210S3454VB_17E |
| SLDIN: | BLX3140OR8210S3454VB17E |
| | |
| | TIF: | BLX3140_OR8210S3454VB_17E_L.tif |
| path: | ./BLX/BLX3140/ |
| size: | 12M |
| LDIN: | BLX3140_OR8210S3454VB_17E |
| SLDIN: | BLX3140OR8210S3454VB17E |
| | |
| TIF: | BLX3140_OR8210S3454VB_17E_R.tif |
| path: | ./BLX/BLX3140/ |
| size: | 21M |
| LDIN: | BLX3140_OR8210S3454VB_17E |
| SLDIN: | BLX3140OR8210S3454VB17E |
| | |
| YYY |
| BLX3140OR8210S3454VB1E |
| IMG: | BLX3140_OR8210S3454VB_1E |
| LDIN: | BLX3140_OR8210S3454VB_1E |
| SLDIN: | BLX3140OR8210S3454VB1E |
| UUID: | 2C750B8B2B0F4FF9B0C690B53F70A97E |
| Pressmark: | Or.8210/S.3454 |
| Thum_type: | More |
| Manip_comp: | true
|
|
| JPG: | BLX3140_OR8210S3454VB_1E_L
|
| path: | ./BLX/BLX3140/ |
| size: | 32K |
| LDIN: | BLX3140_OR8210S3454VB_1E |
| SLDIN: | BLX3140OR8210S3454VB1E |
| | |
| JPG: | BLX3140_OR8210S3454VB_1E_M
|
| path: | ./BLX/BLX3140/ |
| size: | 11K |
| LDIN: | BLX3140_OR8210S3454VB_1E |
| SLDIN: | BLX3140OR8210S3454VB1E |
| | |
| JPG: | BLX3140_OR8210S3454VB_1E_T
|
| path: | ./BLX/BLX3140/ |
| size: | 2.2K |
| LDIN: | BLX3140_OR8210S3454VB_1E |
| SLDIN: | BLX3140OR8210S3454VB1E |
| | |
| | TIF: | BLX3140_OR8210S3454VB_1E_L.tif |
| path: | ./BLX/BLX3140/ |
| size: | 5.2M |
| LDIN: | BLX3140_OR8210S3454VB_1E |
| SLDIN: | BLX3140OR8210S3454VB1E |
| | |
| TIF: | BLX3140_OR8210S3454VB_1E_R.tif |
| path: | ./BLX/BLX3140/ |
| size: | 9.3M |
| LDIN: | BLX3140_OR8210S3454VB_1E |
| SLDIN: | BLX3140OR8210S3454VB1E |
| | |
| YYY |