Ubuntu Script using PostFix, Unzip, Convert .xls file to .csv
$30-100 USD
Cancelled
Posted almost 12 years ago
$30-100 USD
Paid on delivery
**********************************************************
PLEASE DO NOT BID UNLESS YOU KNOW WHAT YOU'RE DOING AND CAN DELIVER BY DUE DATE - NOT NEGOTIABLE
Please read the detailed requirements as well and see the attached .xls file.
==============================================
I need a script written that runs every night.
Here is the situation...
We receive an email week-days (Monday-Friday) at about 9pm (server time) at a particular email address, e.g. myemail@domain.com.
Email:
From-address is 'orders@[login to view URL]'
Subject has a prefix as Company1 and a suffix as YYYYMMDD.
Email contains a .zip file
The zip filename is displayed as YYYYMMDD Company2 Daily Reports .zip file.
If email and/or .zip file not received by 5am next day, then send a warning email to email1@[login to view URL], email2@[login to view URL], email3@domain.com.
The .zip contains a few files. We are only interested in the filename defined as [login to view URL]
Take this file and convert it to .CSV
[login to view URL]
*** In my tests simply changing the extension from .xls to .csv works. Please test this first before implementing any other code.
.xls file attached.
Place [login to view URL] in a predefined folder.
Send email to email1@[login to view URL] if process was successful.
Ensure duplicates are avoided. Only 1 file per date permitted. If duplicate file arrives, send warming email to email1@domain.com.
No imports required for Saturdays and Sundays. So after processing Friday's email (about 9pm Friday), nothing is required until Monday 9pm.
Specify a start date so old emails are not processed (emails received before this script is implemented).
Please note: You are more than welcome to the use of 3rd party scripts(s) that does this, especially the .XLS -> .CSV conversion - but please test it whatever with the rest of the script. No point reinvesting the wheel.
Your primary focus should be 100% automation.
## Deliverables
System Specs:
* Mail Server: Postfix, configured to use dovecot for delivery. (Using virtual hosts and virtual users: not sure if this can be important)
* Format: Maildir
* OS: Ubuntu 10.04.4
If you need help with .xls to .csv conversion, then please consider these resources but you should test with simply changing the extension first.
You might the following resources useful:
[login to view URL]
[login to view URL]