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

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 [url removed, login to view] 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: PHP, Software Architecture, User Interface / IA, Visual Basic for Apps, XML

See more: xml firebird, create a test plan, job mapping, Tale, Firebird, fdb, fd, create and edit, conversion of vb to php, operational plan, write code upload, open input file php, php open input file, open input file, database php interface, php write file xml, retail conversion, php write xml file, php lookup, database identification, read write xml, create store name, create training, php xml table example, customer interface

About the Employer:
( 0 reviews ) Truckee, United States

Project ID: #4472361

5 freelancers are bidding on average $819 for this job


I understand the needs

$825 USD in 14 days
(28 Reviews)

Hello, I am interested in your Project. please provide sample Db and xML file. i will prepare solution in Vb.Net thanks Kalpesh

$750 USD in 15 days
(56 Reviews)

I'm interested by your project. If you could send me your files in my PMB, it would be great :) Thanks, G.

$770 USD in 20 days
(56 Reviews)

Kia ora! [url removed, login to view] are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$1030 USD in 20 days
(5 Reviews)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$721 USD in 25 days
(1 Review)