dataLoader

     csvLoader = require('dataLoader'),
     conn = session.connection;
     csvLoader.loadSimpleCSVData(conn, __dirname + '/ubm_enum-CDN.csv',
        'ubm_enum', 'eGroup;code;name;sortOrder'.split(';'), [0, 1, 2, 3]
     );

      var ukraineID = conn.lookup('cdn_country', 'ID', {expression: 'code', condition: 'equal', values: {code: 'UKR'}});
         if (!ukraineID) {
                throw new Error('Country with code UKR not found');
            }

         // CSV columns: code,regionType,name,fullName
         // we map:
         //  - parentAdminUnitID to id of Ukraine (constant)
         //  - regionTypeID fo function what lookup region ID using region code from CSV file
         csvLoader.loadSimpleCSVData(conn, __dirname + '/cdn_region_ukraine.csv', 'cdn_region',
            ['parentAdminUnitID', 'code', 'regionTypeID', 'name', 'caption', 'fullName'],
            [
                function(){return ukraineID;},
                0,
                function(row){
                    var regionType;
                    regionType = conn.lookup('cdn_regiontype', 'ID', {expression: 'code', condition: 'equal', values: {code: row[1]}});
                    if (!regionType){
                        throw new Error('Unknown region type ' + row[1]);
                    }
                    return regionType;
                },
                2, 2, 3
            ],
            1, ','
         );

Methods

loadSimpleCSVData(conn, fileName, entityName, ettAttributes, mapping, startRowopt, delimiteropt, transLen) inner

Arguments:

1. conn (UBConnection)  Connection to UnityBase server
2. fileName (String)  Full path to file
3. entityName (String)  Entity code to load data into
4. ettAttributes (Array:.<string:>)  Array of attribute codes
5. mapping (Array:.<(Number:|Object:|function())>)  

   Mapping of CSV file columns to attributes. Can be:

   • either numeric (zero based) index of column is CSV file
   • or lookup configuration
   • or function what take a array representing current row in CSW file on input and return a attribute value to bi inserted
6. [startRow=0] (Number)  Start from this CSV file row
7. [delimiter=';'] (String)  CSV file delimiter
8. transLen=1000} (Number)  Maximum rows count to be inserted on the single database transaction

loadArrayData(conn, dataArray, entityName, ettAttributes, mapping, mapping, transLen) inner

Arguments:

1. conn (UBConnection)  Connection to UnityBase server
2. dataArray (Array)  array to load
3. entityName (String)  Entity code to load data into
4. ettAttributes (Array:.<string:>)  Array of attribute codes
5. mapping (Array:.<(Number:|Object:|function())>)  Mapping of CSV file columns to attributes. Can be:
6. mapping (Array:.<(Number:|Object:|function())>)  

   Mapping of CSV file columns to attributes. Can be:

   • either numeric (zero based) index of column is CSV file
   • or lookup configuration
   • or function (currentRowAsArray, newRecordID) what take a array representing current row in CSV file & new RecordID on input and return a attribute value to be inserted
7. transLen=1000} (Number)  Maximum rows count to be inserted on the single database transaction

localizeEntity(session, config, locale) inner

   var
     loader = require('dataLoader'),
     localizationConfig = {
            entity: 'ubm_enum',
            keyAttribute: 'eGroup;code',
            localization: [
                 {keyValue: 'UBS_MESSAGE_TYPE;user',  execParams: {name: 'Користувачів'}},
                {keyValue: 'UBS_MESSAGE_TYPE;system',  execParams: {name: 'Система'}},
                {keyValue: 'UBS_MESSAGE_TYPE;warning',  execParams: {name: 'Попереждення'}},
                {keyValue: 'UBS_MESSAGE_TYPE;information',  execParams: {name: 'Інформація'}}
            ]
        };
     loader.localizeEntity(session, localizationConfig, __filename);

Arguments:

1. session (cmd.argv.serverSession)
2. config (Object)

   Properties

   1. entity (String)  Entity to localize
   2. keyAttribute (String)  Unique key attribute (language independent) we search row for localize. If the key is a component that values should be separated by a ";"
   3. localization (Array:.<Object:>)  Array of object {keyValue: valueOfKeyAttribute}, execParams: {attrToLocalize1: 'localized value', ...}} If config.keyAttribute is complex, key value must be a ; separated string
3. locale (String)  Locale to localize to. Either locale file name (contain file start with locale^ (uk^my_data.js)) or locale ("uk")