IEC.DataManagement.ImportExport.Screens.BackDoorEntries

Data Management : Import/Export Feature Specifications Late Entries

Contents


Purpose

As we are developing these specifications, there are some nice ideas flying across our able minds that we wish to register on this wiki page.
This page will contain screen shots of some latest concepts that we wish to incorporate into the specifications either now or for the future as indicated.

For Present Implementation

P1. Select Fields to Import into a New or Existing Database Table

  • This feature enables the user to select data fields that actually need to be imported.
  • On this panel, user can also select if the imported data needs to go into a new table or if it has to be mapped into an existing database table.
  • This panel would allow to perform mentioned operations on each of the data sources selected one - by - one.
  • This panel is applicable for importing either from a file or database source.


Following screen show three different states of this panel that it can present to provide the designed functionality. File:IEC.DataManagement.Uploads/Import Import-into-existing-table.PNG
Screen Description

  1. This panel displays the preview of fields that will be imported from the selected data source for the import.
  2. "Source Table" drop down will show the list of import sources selected. User can toggle between the preview shown in the field table on the panel by selecting the appropriate selection on the "Source Table" drop down list.
  3. "Target Table" displays the name with with the table would be imported. This is the name entered by the user on screen 4 of this section. This is non-editable here.
  4. User can de-select the fields that need not be imported for this "Source Table" by un-checking them in the first column of the field preview table shown.
  5. This view is the default view of thie screen.


File:IEC.DataManagement.Uploads/Import Import-into-existing-table-checked.PNG
Screen Description

  1. On the default view, user can check the option "Import into existing table" for mapping the import for a specific "Source Table" into an existing database table.
  2. On checking the option, "Target table" field gets converted into a selectable drop down list of table names to which import for "Source table" could be mapped.
  3. User can select one "Source table" at a time to import the "Target table" fields.
  4. Additional options that get enabled with this check option are two radio buttons that would allow the user to either append into the "Target table" or repopulate it by truncating the existing values and inserting the mapped fields.
  5. On selection of a target table from the drop down, view preview table shown in the panel changes to mapper panel which is discussed further.


File:IEC.DataManagement.Uploads/Import Import-into-existing-table-checked-selected.PNG

Screen Description

  1. As it could be seen here, on selecting a "Target Table", view of preview panel shows three columns, "Target Fields", "Source Fields" and a "Primary Key".
  2. "Target Fields" are columns from the selected "Target Table". The values in the table shown are non-editable/non-selectable.
  3. "Source Fields" are columns from the selected "Source Tables". On clicking any of the fields under "Source Fields" column, user is presented with the "Drop down" list of "Source Table" columns.
  4. User can map each source table columns with the columns in target table as shown in the view.
  5. Source Fields that are exact match to the Target Fields get Auto Mapped as seen in the case of "FIRSTNAME" and "LASTNAME" fields shown on the captured screen.
  6. Primary key columns is the information column marking which Target Table field is the PK among the fields displayed.



P2. Select Fields to Export on a File

File:IEC.DataManagement.Uploads/Export export-columns-names-selector-file.PNG

Screen Description

  1. On selecting the file type to export, this panel would allow the user to ascertain which columns need to be exported on the file selected.
  2. User can exclude the columns from export by unchecking them in the "Available Fields" list.
  3. "Export path" and "Export with Name" allow user to edit path of exported file and name of exported file respectively.
  4. Note that the wizard adds the file suffix to the file name automatically as the file type to export is already determined by this step.
  5. User can do the mentioned tasks on all the tables selected for export by selecting them from "Table to Export" drop down list.
  6. "Available Fields" shown would change based on "Table to Export" selected.



P3. Select Data Export Properties for Export on File

File:IEC.DataManagement.Uploads/Export-Additional-Export-Properties.png

Screen Description

  1. This wizard panel is a logical replacement for the 4th Panel in this section.
  2. The panel is devided into 4 different sections, "General properties", "Export Write Properties", "File Properties" and "Data,Time and Number Properties".
  3. "File properties" will be enables only when the selection is "CSV" or "Fixed Width". Rest all the properties are applicable to all file type export options being supported.
  4. Properties set here are applicable to all files being exported.
  5. Here is some more explanation for each of these :
  • General properties
  • Export Column Names would also export database columns names along with data on the file selected. First line of the file would contain the column names on this file. By Default, this option is checked.
  • Ignore errors during export would ignore some of the errors which export is in progress. The row where the error would occur will be excluded from the exported data.
  • Export Write Properties
  • Append to target would append the exported data to target file if the file already exists on the path.
  • Truncate and Write would clear the file data and write a fresh file if the file already exists on the path.
  • File Properties
  • Field and Record delimiters" are all the supported delimiters respectively as already explained under this section.
  • Data,Time and Number Properties
  • Date Format would allow user to select from one of the available data formats or create a user defined one. Once the user selects User Defines option from the drop down, the combo box will be come editable where user can create his own data format.
  • Date delimiter is the delimiter user can define to separate out DD, MM and YYYY in the date format selected.
  • Time delimiter allows user to define delimiter for time field.
  • Decimal Symbol allows user to define decimal symbol which might be different from different locales or countries.


P4. Select Fields to Export into a New or Existing Database table

  • The concept explained here is similar to field mapping and target table selection in the import section. See this for details
  • The screen as applicable for export to a database table only.
  • This screen is a logical replacement for this screen
  • All three screens shown below are different states of the same panel.


File:IEC.DataManagement.Uploads/Export-Select col to export in new existing tbls-Step1.png

  1. User selects the database to export using "Export to DB" drop down list of database connections.
  2. Connections listed are all the database connections added from NetBeans DB explorer.
  3. User can test the connection with the admin passwd as shown on the panel. Appropriate test message will be displayed.
  4. User can select the appropriate "Source Table" from the list in drop down to select fields that need to be exported. Available fields section shows fields from the selected "Source Tables".
  5. User can check/uncheck fields that need to be exported from the available fields.
  6. Available fields list changes on changing the "Source Table" selected.
  7. User can change the name of exported table in the target database by editing the name in "Target table" text field. Default name is same as that of "Source Table"


File:IEC.DataManagement.Uploads/Export-Select col to export in new existing tbls-step2.PNG

  1. On selection of "Export to existing table" option, "Target table" would get converted into a drop down list of target tables available in the selected target database.
  2. User can select an available target table and map fields from the selected source to export into this.
  3. Additional options that get enabled with this check option are two radio buttons that would allow the user to either append into the "Target table" or repopulate it by truncating the existing values and inserting the mapped fields.


File:IEC.DataManagement.Uploads/Export-Select col to export in new existing tbls-step3.PNG

Screen Description

  1. As it could be seen here, on selecting a "Target Table", view of preview panel shows "Target Fields" and "Source Fields".
  2. "Target Fields" are columns from the selected "Target Table". The values in the table shown are non-editable/non-selectable.
  3. "Source Fields" are columns from the selected "Source Tables". On clicking any of the fields under "Source Fields" column, user is presented with the "Drop down" list of "Source Table" columns.
  4. User can map each source table fields with the fields in target table as shown in the view.
  5. Fields that need to be excluded from export should be left unmapped with the "Target Fields".
  6. Source Fields that are exact match to the Target Fields get Auto Mapped.
  7. Primary key columns is the information column marking which Target Table field is the PK among the fields displayed.








Future / Some food for thought

F1 Filtering Import Sets

F2 Canceling the ongoing import and displaying the status of ongoing import on a progress bar.

  • This is critical in cases where import is taking too long.

F3 Export from a view or a query result.

F4 Add support to export into following file types :

  • HTML
  • RSS
  • Work and Star Office Doc
  • SQL Script file (very useful)
  • Adobe PDF
  • LDAP file

F5 Add support to import using user defined date formats, time delimiter and decimal symbol.

F6 Provide a complete database backup and restore facility (Both user initiated and scheduled)

Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo