I have a MS Access database that was used with a scanning application. We now want to export all the images from the application while maintaining our Delivery number (This is not possible within the app)
So we need someone to code a system to rename all the images to their specific number from the database.
There is no Delivery number in the database and no image name in the Database ((Anywhere))
The only sequence is in how the images are dispalyed e.g. Sort by name
Here is what will work perfect if possible.
Export all images to single folder
Sort by name
1. Take Delivery number from database and apply to image
2. If last 3 digits of image filename is 002 apply same Delivery number
3. If last 3 digits of image filename is 003,4,5,6,7,8,9,010,011 etc... apply same Delivery number
(There is sometimes more that one image per delivery number.)
4. If last 3 digits of image filename is 001 reset and go back to step 1 using next record from database.
I have attached an example of the database and images.
If you have any questions please PM.
Payment will be on project completion.