We need to prepare data and insert it into MySQL database.
Currently we have documentation in PDF format that contain images. We need to use these images in our application. For that, it is needed to "CUT" these images from PDF into a directory. Next a relative path to this images should be inserted into corresponding fields of several tables. So the project includes the following steps.
1. Generate .jpg image files from provided pdf documents
2. Create a directory system for those images and place images there
3. Insert "relative" path into tables of MySQL database
Our initial estimate indicate approximately 700 images for 4000 entries in the Database.
To avoid "mistyping", it is most resonable to create/find a simple tool that would allow to "browse" for images and insert path into MySQL. But you are free to use anything you think is best for you.
1) database generating SQL (for example MySQL dump file) that contain all required data