I have web archives of a outboard motor parts website that I must use to create the relationships between the diagram image files and the make, year, horsepower, model and list of parts that accompany the diagram. The easiest way I know to do this is to create a unix/linux shell script to read the path information which contains all the data related to the drawings including drawing name and image file.
There will be a very large amount of data in some of the tables due to the need to list many of the part numbers multiple times to associate them with every drawing that they may be included in.
Its a relatively simple task but a very large amount of data. It will likely be near 1 million rows per manufacturer
Once the table is created it must be integrated into a database that already exists with a structure that separates the manufacturer name , years, horsepower, model numbers.
This work will be done on my linux server so that I don't have to upload the archives to work on them.