Here is the new validation requirements that we need
Please review and let me know if you have any questions.
1. Remove the code for UPPER CASE - this is no longer needed.
2. Error logs will now need to be stored in a Sub-folder from where spreadsheets are. For example if spreadsheets are located in C:Sample
Then the error logs will need to be stored in C:SampleErrors
3 Error logs will need to be created in seperate sub folders each time the application is ran. For Example: C:SampleError11-11-2007 if it was ran on the 11th of November.
4. Based on Validation number 3 from the first project the relationship in the relationship spreadsheets will need to need to be deleted as well. For example if Project doesn't have an Idea (this was validation number 3 in the old project) then the row in [url removed, login to view] will need to be deleted as well and stored in a [url removed, login to view] spreadsheet. Basically what we are doing is if an object (Idea, Project, Product, Product Option) has a related child object then that relationship is removed from the data load.
5. Create a column in the errors logs that will display the error for each row that is in the error logs. For example ? in the ProjectError log there would be a column that would state why each row is in there (no Idea found for it, or no unique type). This would be based on the last validations instructions I sent over.