We are in search of a developer/designer to assist in the design and development of an extranet website which will be used for the management of data input by users from different sources.
Once a user logs in he will be shown a homepage which shows a small rotating banner with images. These images must be able to be uploaded by an administrator and changed where necessary. On this page as well will be a welcome note, last logged in date and access to different tabs with the use of button links.
The extranet will allow users to login, upload multiple or individual CSV/xls/xlsx/XML files by dragging into the upload box or alternatively uploading by clicking a browse to upload button.
There are multiple tabs on the web site and each tab will have either a pre-populated or blank downloadable template which the user may download as an example. The pre-populated file will be populated with the data that they have uploaded before, allowing them to just change other data in the file.
After a user has uploaded his file or multiple files he will be shown a success message on the screen. The view will switch to another tab (known as the error log tab) showing the user errors in his file(s) if any.
Once the file has been uploaded the data in the file should be read and inserted/imported into a sql database
User will have access to a History tab allowing them to download previous files that they have uploaded.
When uploading any template the data belonging to a specific users company should be displayed showing all information for that specific tab which he has uploaded before. All tabs requiring data and uploads will have filter fields allowing the user to filter out the data he has already uploaded...
There will be a section which allows a user to edit his account details, this is called the My Account Details section. The user will be restricted to only editing fields which we decide can be altered. Only once approved by an administrator will the data be replaced in the system.
The system should have an approval tab allowing any administrator to view awaiting approvals. When an administrator is created there should be an option for him to be sent mail when users change any account details that might need approval.
One of the Tabs will be a POD Management tab allowing users to upload a document or multiple documents in the form either PDF, TIFF,any picture image or word document format. These files should be stored in a secure location and allow for administrators to access the files later on.
There will also be an administration section allowing us to accept users who have registered on the site and are awaiting approval. This section will also allow an administrator to restrict access to the different tabs available as well as create new users and reset passwords when needed.
We have had issues with uploading excel files in the past where users who entered numeric data first and alpha-numeric data a few lines after in the same sheet have they're data disappear because of formatting. A user should be able to upload any amount of data in any format without any data disappearing and should read the different formats no matter how they were entered.
Users will not have access to the administration section.
The files uploaded show how we would like the web site to look and a more detailed look will be provided later. In terms of graphics and animations we will leave it up to the designer/developer to add some fancy animations and transitions where needed.
The database must be a SQL database
This system can be developed in SharePoint if possible
This system can also be developed using [url removed, login to view], PHP or any other formidable CMS ([url removed, login to view] is preferred but not limited to)
The system must be based somewhat on a Content Management System for ease of use and to update content (Logos,pictures,text etc.) where needed.