create an interface: firebird DB -> cXML file w lookup tables; upload to Web

IN PROGRESS
Bids
5
Avg Bid (USD)
$819
Project Budget (USD)
$250 - $750

Project Description:
I would like you to write an interface that imports data from a firebird db and exports it as a cXML file to a web url. OS is windows 7.
The Firebird data is from a retail store running "Postalmate" software. The data will need to be read, cross referenced and create a destination cXML file for export to a web-based database (Britannia). The data field names and locations will be different and all need to be mapped from the FB field name to a cXML filed name. Total number of fields to be mapped is less than 50; however, approximately 6 of the fields will require cross referencing and look-up tables. Data exceptions, for example blank or "null" values, will need to have standard inserted values in the cXML field to indicate a flag/exception on the destination software. The finished conversion routine will need to be open for alterations (depending on modifications to both the original FB database and destination (Britannia) database. User interface must satisfy the following: Select FB database file with a default name/location; user to be able to run the routine manually or automate the run-time (to a default 1 times per day @ 6:00PM), user may input a code # that references the store/user identification to be tagged in a field on the cXML file; user will need to be able to open and edit the look-up table data for each of the filed mappings requiring a look-up; for eample, if a custoer ID in the FD database is #234, then a look-up tale will be used to determine that the new customer ID # in the cXML file will be #567.

See attached files for basic data mapping plan, sample test PCS.fdb firebird database, and resulting cXML database format.

The interface may be written in PHP (or VB). We require all rights to the code. Deliverables: Source code, assistance and training on establishing the software in-house to edit, compile and run, a test cXML file generated that satisfies the requirements, a completed and operational executable file that can be tested in-house against the real FB database file.
This job is considered done, when the data is actually imported in the new software.

Of course the data we will provide is strictly confidential and may not be used in any other way.

Skills required:
PHP, Software Architecture, User Interface / IA, Visual Basic for Apps, XML
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 770
in 20 days
$ 750
in 15 days
$ 825
in 14 days
$ 721
in 25 days
$ 1030
in 20 days