1. Quick data import

    Article: AN0001573Updated: 03.10.2018

    This functionality is used for a simple, initial load of data into ObjectGears system.

    If you create a new class and you want to fill it with data, than you have several posssibilitiesí:

    1. Enter all the records manually.
    2. Create import and than read the data. After that you want probably delete the import.
    3. Perform inserting records into the table in the database. However, you have to be sure what you are doing and that you are doing it right.
    4. Use this qiock data import.

    When importing there are following rules and limitatations:

    • Only data insert is performed without taking care of existing records in the class.
    • Rules before record save are started.
    • Restrictions on column are checked - min., max. length/value, mandatory column...
    • All column types can be imported except for:
      • files
      • classes
      • multiple references to classes/users

    This import is available in the administration tool. This means that is available for administrator.

    Course of import

    1. Prepare and Excel file with data. You can use Excel with more sheets or more ranges with data in one sheet.
    2. Start administration tool and display for for the quick data import.
    3. Select the Excel file in the tab Data source and click on button Add.
    4. In the tab Data select by mouse range with data that you want to import.
    5. If there are column names in the first row, check the option First row contains column names.
    6. In the third tab Mapping select model and class, into which you want to import the records.
    7. In the list of columns select the target column for data, that you want to import.
    8. In the toolbar click on button Import.

     

    Enter particular records into Excel rows - each row corresponds to one record in the class.

    Do not use empty rows, these are also imported and an error could occur (e.g.: not filled in columns).

    Particular records are imported separately (not in one transaction). When an error occurs during reading x-th record, than previous records will stay in the class.

    Before the import data types are checked. If there is an error, there will be an error message written at the respective control in the Data tab. After moving mouse to such a control, error description is displayed.

    Extraction of data into a reference class

    There is button Extract reference data in the form for import, that displays a form for a comfortable extraction of data from one text column into a reference class.
    The form calls internally function OG.DataRow.CreateTypeRows.

    Description of form fields: 

    Name Description
    Model Model with class that you want to modify.
    Class Class with data that you want to modify.
    Source text Values of the column that you want to extract into a reference class.
    Source reference Links to reference class records will be stored in this column.
    Target text The target column in the reference class into which values from the source text column will be stored.
×