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.