File grab from Email attachment and placed on SFTP location
Budget: $30 – $250 USD
Our clients will email all incoming order files to an email address.
At a defined frequency, the script would grab any files from the email, taking note of the file name.
ClientoneXXXXXXXXX.csv
ClienttwoXXXXXXX.csv
NOTE: These names could vary so a data table should exist that the user can edit to account for the variations, EX: clientone, Clientone, Client One, Client1, ect....
The script will then do a count of order numbers (Shipment ID field in the order file), and send an email to a defined email address with the client's name and “XXX qty of orders” listed in the subject field.
Based on the order file name the script should place the file in the appropriate folder on the SFTP site.
File name contains Clientone = SFTP folder C1-Neworders.
File name contains Clienttwo = SFTP folder C2-Neworders.
The original email can remain in the inbox, or moved/deleted if needed for the script to function properly.
Additional requirements:
Ability to add/change the SFTP folder locations for puts.
Ability to add/change the email address for reading the order file.
Ability to add/change the file name for identification of where to place the file.
Ability to define frequency (every hour, every 2 hours, once a day ect…) for the script to run
At a defined frequency, the script would grab any files from the email, taking note of the file name.
ClientoneXXXXXXXXX.csv
ClienttwoXXXXXXX.csv
NOTE: These names could vary so a data table should exist that the user can edit to account for the variations, EX: clientone, Clientone, Client One, Client1, ect....
The script will then do a count of order numbers (Shipment ID field in the order file), and send an email to a defined email address with the client's name and “XXX qty of orders” listed in the subject field.
Based on the order file name the script should place the file in the appropriate folder on the SFTP site.
File name contains Clientone = SFTP folder C1-Neworders.
File name contains Clienttwo = SFTP folder C2-Neworders.
The original email can remain in the inbox, or moved/deleted if needed for the script to function properly.
Additional requirements:
Ability to add/change the SFTP folder locations for puts.
Ability to add/change the email address for reading the order file.
Ability to add/change the file name for identification of where to place the file.
Ability to define frequency (every hour, every 2 hours, once a day ect…) for the script to run