Hi I have a master detail database in Firebird 2.0, one main table with 4 detail tables with approx. 8 lookup tables. Approx. 80 attributes in total. The export/import function must be able to handle one or more exports/imports at any one time i.e. single or batch. The application must be written in Delphi 2007 for Win 32 and use the latest FIBPlus database access tools for Firebird. The database is attached. The application must export the RISK_ASSESSMENT table with its related detail tables RA_HAZARD, RA_PAR, RA_PERMIT, RA_PPE into an XML file to have a default value of HSMRA + RA_NBR + datetime which can be renamed by the user in a Save As dialog. The import function must import the XML file into the applicable tables and create the RISK_ASSESSMENT and related detail tables as above. For the RISK_ASSESSMENT table if the lookup table i.e. Department, location and Person entries do not exist the application must prompt the user for the value to use, either the value supplied in the XML file or 'Unknown' or a value to be input by the user, these values must then be created in the lookup table to ensure referential integrity. For a batch load an option to 'Use this value for all records' must be provided to the user. For the RA_* detail tables the values in the XML file must be created in the lookup tables e.g. RA_HAZ and HAZARD, RA_PAR and PEOPLE_AT_RISK, RA_PERMIT and PERMIT, RA_PPE and PPE to ensure referential integrity. A copy of the database is supplied. User is SYSDBA password 'masterkey'. The application MUST use FIBPlus 6.7. Many thanks
## Deliverables
1) Complete and fully-functional working program as a test harness in executable form as well as complete source code of all work done that can be easily integrated into the main applications source code
2) Deliverables must be in ready-to-run condition.
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
Windows Vista Business and XP, Delphi 2007 for Win32 with the latest version of FIBPlus (currently 6.7).