We need to Scan 100,000s of documents into Sharepoint. Each Document Will be named like PEN2938348 - 02. We have created a list in Sharepoint like 01 - Account Staff, 02 - Affidavit, 03 - Bank statement up to 43 - Consent form.
Also another DB has been connect in Sharepoint Designer. This database has records of clients with unique id like PEN20488454, Firstname, Surname.
The document library metadata is PIN Number, FirstName, Surname and Document Type,
What I require is when we bulk upload documents into the library, the database will pick up the Unique ID in the document name PEN2938348 and use the database to load the FirstName and Surname. Then pick up the last 2 digit in the document name - the Document Code - and use it connect to the DocumentList to load the DocumentType and Description 02 - Withdrawal Form, into the document library field