First the Callisto application has not been working. They may have changed the website, so I have attached the error log. Please fix this as soon as possible.
I need Artemis output to be checked against the input and if any serials are missing in the output for any reason it should re run those serials at the end and add them to the output. Also if for any reason the 1st check didn't catch anything or did and the 2nd catch didn't work the message box that says completed needs to be changes to say something like Artemis failed to capture all the serials, please double check the file and re-run!. I have found that either thru our network or the connecting some records are getting skipped. So i want to add this type of check at the end. This will be testable by having a pause/play button that would stop the code before the next serial is entered. I would then change the output and see if the program catches on. Then again pause/play the program the second time around to see if it triggers the end user notification. We ran 5000 serials and 1 was skipped.
There are two other small popup's i would like added to the begining of the code after the user hits the start button. One is a simply "Your input file has ## duplicates in it...would you like to continue?" "Yes" or "No" no would stop the code, yes would just move on. The user could then de dup the file. It would just check the input for the same values in the 1st and 3rd column in two or more rows and use that count when creating the pop up.
Lastly we have found where the 7 digit serial can be manipulated to return different results. Any serial with the first two digits as numeric "10XXXXX" can be also linked to results with an input of "00XXXXX". So the program would check for this condition of any serial with 2 numeric begining digits and ask the user "Do you want to run with a 00 prefix as well?" Yes would duplicate the affected serials and change the first to digits to 00, and a no would just move on.
On the 7 digit prefix one, if yes, the output should put a double break between those records and the others("***" in two adjacent rows) so we can easily see what the program added to accomplish the task.
Lastly I would like to discuss a duplicate application, same everything, but a different URL. Instead of clicking by CPU it could click by Serial(4 choices down) input the serial and copy all the data from this results page into excel.