I need you to work with the script already created and do some modifications:
- As discussed we need to have a html website uplaod the CVS Spreadsheet to the master server
- There will need to be a the option to email (Due to the high number of users Best to allow the users to input their Email Address)
- Once uploaded to the server the script will need to determine which host this file is to actually be promoted to. The script will look at the worksheet tabs in order to determine the hostname.
- There will also be a multiple of tabs for other teams that will need to be ignored in this spreadsheet as well.
- I also need the script to be able to have an easily managed allowable list
- This file will be named the hostname. The contents inside this file will contain the list of allowable directories the script is allowed to promote the files to. (The "To" column in the spreadsheet) It will need to reject anything outside of this list. This is to increase security of where the users are able to promote to.
- We will need to setup a cron job to have the Master server looking for the scripts every 5-10Min. The Queued files will also need to move into the correct directory once the first spreadsheet is uploaded.
- when the user uploads the xlsx file from the html they will need a confirmation email that it was recieved. When the script processes the xlsx spreadsheet it is to email that user and 3 other teams with the result of success or failure(just like how we have it setup right now)
Sometimes the excel spreadsheet will only have 2 hostnames sometimes they will have 5. This is a changable variable but they will always have other tabs in there as well.
I am currently in the process of re-designing the spreadsheet and determining if they want this in xls or xlsx. So leave this part for last.
I will need a list of requirements of software you will need to install on the server: example: apache, phaseExcel etc.
Also to keep in mind this has to go though a verification process by 3 teams before I can release the payment. This will be a delay but I will push for you to have the payment asap.
New things to add to the script:
Extend the colums so that they read 400 lines in the colum opposed to the current 50-58 lines. This is for both the File/Script column and the "To" column.
I will need a line in the script for this:
If the hostname is: hostname1 hostname2 hostname3, etc then run this command: <command> (I will provide you the command) if it is not that hostname then skip. (This is for audit purposes when we move these systems.)