Hello,
We are looking for a custom piece of software to do the following tasks :
- Download from an FTP "A" to a local PC in a folder “ZIP” all .zip files written the last X days (for example the last 10 days) situated in a folder named "XXX" on the FTP “A” of a remote PC.
- on local PC : extract all zip files to a folder “XML_UTF16” (each ZIP file contains one .XML File)
- on local PC : convert all .XML files from UTF-16 to UTF-8, and place the UTF-8 versions in a “UTF8” folder
- on local PC : replace text "utf-16" by "utf-8" inside the body text of each .XML file of the “UTF8” folder, save the new versions of the files
- Upload from the local PC to a FTP "B"in another remote PC all "utf-8 versions" .xml files of the “UTF8” folder
- Delete in FTP "B" all the files older than X days
- IF upload is successful, remove in folders “ZIP” “XML_UTF16” and “UTF8” all files.
We need :
To be able to edit the X days (10, 15..etc)
Automatic schedule to do this every day at X time/hour
Y retries per day if not successful every Z minutes (Y & Z parametrable, default to 5 retries / 60 minutes)
Manual button to launch the SCRIPT when no automatic schedule
Progress bar
Show status during the execution of the script
Logs to be written every day (1 file per day) on the local PC for us to check what, where and when the operations of download, extract, convert, upload, delete happened.
Alert email to be sent to one email with our smtp if the operation is not successful (if failure to connect, no file, other problem)
Clean GUI
Software shall work on win XP/2000/2003 server.
One example of unzipped XML file attached.