Data Import/Export ============== a firebird database stores data of multiple companies (called 'shops'). Table TB_SHP stores data of each company in the database. Each company/shop has multiple departments. Departments are stored in table TB_DPT. Almost every table in the database has a ID_DPT field that stored the GUID of the department to which the record belongs. 4 components are attached: TSaveDpt stores data belonging to the given department to an external file. TLoadDpt loads data of a given department from an external file into the database. TSaveShp stores data belonging to the given shop to an external file. TLoadShp loads data of a given department from an external file into the database. The coder will go thru 2 steps: step 1 ===== test the attached components. TLoadDpt and TSaveDpt were working ok, but when I created TLoadShp and TSaveShp I introduced some bugs that will have to be fixed. step 2 ===== Add the following property to TLoadShp: Dictionary:TStringlist; The dictionary will includes strings of the form Name=Value. Every time a table (say TABLE1) is processed in the destination table, the code should check if the name of the source table is different. pseudocode is SourceTable:=[login to view URL][DestinationTable]; if SourceTable='' then SourceTable:=DestinationTable; Every time a field (say FIELD1) is processed in the destination table, the code should check if the name of the source field is different. pseudocode is SourceField:=[login to view URL][DestinationField]; if SourceField='' then SourceField:=DestinationField; The code uses component TEasyTable which is available in trial version at [login to view URL] Only the selected coder gets the database and the rest of the code
## Deliverables
the coder will provide a minimal test EXE