Access conversion to MYSQL/PHP

Fertiggestellt Veröffentlicht Jan 29, 2007 Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

I currently have an Access database constructed for reconciling documentation sent form several locations.

To improve the effectiveness of this I would like the database structure and functionality transferred to mysql with a website/php interface.

I require the scripts to create the tables, query, reports and form functionality migrated and a back office CMS.

Some improvements to the functionality is required.

Currently the data is loaded into Access from excel. I would like to be able to either link the sql DB to a specific file location or to have an upload form for back office use.

The search criteria/options needs to be improved

The functionality is clearly defined as front and back office.

I have outlined the process below and will provide the access database for any further analysis that is required.

**Reconciliation Flow**

*Back office*

Data is loaded into Access once per week

*Front office*

User selects their location from a drop down and requests “Outstanding Documentation??

A list of any documentation with a specific status is displayed.

User changes the status of any documentation to dispatch ??" this creates a Batch Number and the user is asked to print a Batch Header which displays several key fields from the data, location, date, count of records and a section for signature.

If documentation is not present, this is updated accordingly but not included in the batch

These are sent to a central location.

*Back office*

Each Batch Header is checked manually.

A form is displayed which allows the user to update all records on that batch as received and OK.

If there are any that are not accepted, a status is amended before submission.

The ability to search by Batch Number or other key criteria is available.

There is a Back Office and Front office reporting function

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Intranet; Linux; IE

Ingenieurwesen Microsoft Access MySQL PHP Softwarearchitektur Testen von Software Benutzerschnittstelle / IA

Projekt-ID: #2818702

Über das Projekt

3 Vorschläge Remote Projekt Aktiv Jan 30, 2007

Vergeben an:

gamasoftware5

See private message.

$42.5 USD in 14 Tagen
(142 Bewertungen)
5.7

3 Freelancer bieten im Durchschnitt $65 für diesen Job

webtechnodu

See private message.

$85 USD in 14 Tagen
(3 Bewertungen)
2.9
ratheeshkumarps

See private message.

$68 USD in 14 Tagen
(2 Bewertungen)
0.2