Replicon Web Timesheet is an application that specializes in time tracking. ? It comes with an import utility that allows timesheet imformation to be uploaded to it's database from a csv file.
This project involves creating a program that will work with Replicon's import utility to allow for users to import hours. ? The custom import utility will allow import from other formats (by converting them to Replicon's formats and then running Replicon's utility).
This program will address 2 main deficiencies of Replicon's out-of-the-box utility
1) It can only be run from the server hosting the replicon database - the new program will be a client-server application
2) It's error checking is limited and messages can be cryptic? - the program will implement a number of checks and provide user friendly messages.
The program will consist of 2 components:
1) A client that allows a user to select an import file, specify the import format (there are 3 different import formats), the server (ie prod or test) and run the import. ? The client will provide feedback to the user regarding if the import was successful, the number of hours imported and other imports that were executed. ? The program will initiate other imports (users and projects) as necessary.
2) A server application that has access to the replicon database and replicon's import utility. ? The server side will accept the import file from the client as well as other user input, validate the users import file, convert the users import file to Replicon's import format, create other necessary imports (users and projects), execute the imports and respond to the client with the status of the imports: users created/editted, projects created/editted and hours uploaded.
We are using replicon version 8.10 (their latest version as of November 2009)?
This program must be supported by .NET 3.5
I have a working version of this import utility that does only runs on the server hosting the replicon database and import utility, it also has some other deficiencies and has some missing features, you can work off of this version or start from scratch.