Configurable Java Application for Exporting and Uploading Data

General: - Java Applications to export data from a database or file-system and submit via https with credentials. - Platform independent - Highly configurable, object oriented, and commenting as needed - Two separate applications with executable jar files: - Configuration - Scheduled Export/Upload - Documentation for support and end-user - Third-party software libraries must be accepted prior to use Configuration Application - Java Application with UI - User configuration friendly - Ability to pick from list of supported configurations or specify new configuration - Configurations can be file, jdbc, or custom (see below for fields) - Ability to schedule daily/weekly/bi-weekly/semi-monthly/monthly exports at a specific time of day - Should create directories if missing - Config App is a http client to the background application for status, recent transfers, and reload - Suggested configuration format is xml - Client will read and write the configurations Background Application - Java Daemon - Use quartz for scheduling - Limited set of rolling logs for log messages, default level warn/error - Transfer log that is available for viewing within the configuration app - Exports will be either csv or excel. (always csv for jdbc) - Exported dates should be formatted as yyyy/mm/dd - Exported times should be formatted as yyyy/mm/dd HH:mm - Zips the file to be uploaded if not already zipped - Optional encryption of the zip using aes-256 - Use url multipart/form-data post to submit export file - Embedded http server for shutdown, current status, recent transfers and config reload - Configuration files can be reworked/reorganized as needed - Server will read the current configuration - Should cleanup working files after uploaded Configuration: - Should be able to easily add new configurations - Set of example configurations - Base configuration file - Generated current configuration Example general configuration fields: - working directory - post url - http daemon status port - http daemon status host (optional, default localhost) - transfer log file - export zip password (optional) - export configuration(s) - polling time(s) - polling start date (optional) - polling end date (optional) - configuration specifics Example configuration fields for jdbc: - configuration name - configuration description - csv header - username - password - jdbc driver - jdbc prepare query (optional) - jdbc export query - jdbc post query (optional) - jdbc url Example configuration field for directory polling: - configuration name - configuration description - csv header (optional) - prepare system command (optional) - post system command (optional) - file directory - file prefix - file suffix Example configuration fields for custom: - configuration name - configuration description - csv header (optional) - username - password - prepare system command (optional) - post system command (optional) - qualified class name