Two Python processes - Python experience required. MySQL experience required. Python running in Win10 environment.
Process 1 - Fetch Email Instruction - Run every 60 seconds: - Login to EMAIL - Load next unread email in with SUBJECT = "XXXXXX" - Read new unread Email with XML body into memory with ORDERID/# + customised fields - Update order status progress in existing remote MySQL eg: PROCESSING STEP 1 of X - Lookup fields from body and query existing remote MySQL - Create Concatenate job list with from mail body using parameters in email XML body - Create Job Script files using PROVIDED template adding parameters read from email XML - Validate job script files - Update order status progress in MySQL eg: PROCESSING STEP 2 of X - Move Job files to 'jobready' folder (If error - Send email to Error Handling email address with any created files attached) - Update order status progress in MySQL eg: PROCESSING STEP 2e of X
Process 2 - Run every 90 seconds: - If Job Script and Job file list exists (set filename format) {- Move Job files into into execution folder - Update order status progress in MySQL eg: PROCESSING STEP 3 of X - Execute Job - review output - If successful {- Upload/Move file to archive location - Update order status progress in MySQL eg: PROCESSING STEP 4 of X - Move Job files into completed folder named ( Produced-MMM-YY) - Ftp/Upload/Move job output file (video) to designated host or googledrive - Update order status progress in MySQL eg: PROCESSING STEP 5 of X - Generate short link } - If error {-send email to Error Handling email address with any created files attached - Update order status progress in MySQL eg: PROCESSING STEP 5e of X }
So in summary I am looking to set up two periodic processes. 1) poll to read the next unread email, process the fields as input and create a command line script (like a batch file) then place the created script in a specific folder depending on the email fields and update an existing remote MySQL database (credentials provided). and 2) poll a folder, execute a custom script created in step 1) , check the output is created, move the script files to a done folder, ftp the mp4 output to a website, create a tinurl, update the MySQL, Code must be documented Must work on Python 3 with Windows 10 Payment on installation, configuration and testing of Python scripts on Win10 machine.
