I am an Ex Service Veteran and need assistance with a Small Program to use with my Rats of Tobruk Project, for the purpose of evaluating Archives Information, which I normally do by Manual Means, but my List has grown to 11,663 records that need Verification.
I have put this together as a Guide to what needs to happen. I hope someone with experience can assist me with a Program.
Automate Finding Service Records & Evaluation
I produce an Excel List from my National Rats of Tobruk Database, consisting of two (2) Columns – Service Number and NAA.
a) Service Number will contain the List of Service Numbers to be found and evaluated, in sequence.
b) NAA will initially be Blank, but will be changed to (Y) if a Condition is found “True” for the Loaded Service Number.
Open Browser (Firefox or Chrome)
b) Set Button to “List Report”
c) Click Tab = “Basic Search”
From Excel Service Number List, Enter the first “Service Number” in the Pad = “Keywords” and Press “Enter” or Click “Search”
a) If the Column “Digitised Item” is Blank – Loop Back – load the next Service Number from the Excel Service Number List and evaluate.
b) If the Column “Digitised Item” shows a "Document Icon" or Other Content, the Condition = True – Go To Excel Service Number List, and show “Y” in the NAA Column, for that Loaded Service Number.
On the Web Page, Click “New Search” and Load the next Service Number from the Excel Service Number List and Repeat the Evaluation Process for each Service Number, till the end of the Excel Service Number List is exhausted.
When the Service Number List is completed, Save the Excel File to Desktop/ROTWEB/Service Number NAA Test. (ROTWEB is a Folder on my Desktop)
I hope you are able to follow my thoughts - if not please contact me, either with a Reply Post or by my Email ( firstname.lastname@example.org ) Best Regards Owen Carlton ( www.ratsoftobruktribute.com )