Examples of files used by UIMPORT

The following examples are based on records taken from a database sample that uses these fields:

• Last name:

• First name:

• Middle initial:

• Local address

  • Street:

  • City:

  • State or province:

  • Zip code:

• Student number:

• Year:

• Major:

• Cumulative grade point average:

• Department:

Data file created from exported database fields

When you export your database records to a comma-separated ASCII file, the records appear in the data file as shown here:

   ``Jones'',``Adam'',``J'',``111 South 8th East'',``Salt Lake
   City'',``Utah'',``84007'',``2345'',``Sophomore'',``Environmental
   Engineering'',``2.8'',``Engineering Sciences''
   

   ``Smith'',``John'',``D'',``222 North Cerillos'',``Los
   Angeles'',``California'',``96000'',``2875'',``Senior'',``Accounting'',
   ``3.0'',``Business Administration''

Corresponding import control file

Using the data file as a guide, you could set up the import control file to import the data file fields as shown here. This example assumes that you are creating new users in the NDS database:

   Import control
      Name context=.administration.student_accts
      User template=y
      Create home directory=y
      Home directory path=``Students/Home''
      Home directory volume=``.SYSVOL.Student Records''
   Fields
      Last name
      Given name
      Middle initial
      Mailing label information
      Mailing label information
      Mailing label information
      Mailing label information
      Name
      Skip
      Skip
      Skip
      Department

An alternative to managing numbers is to create a field of unique login names in your data file.

Data file edited to update user objects

Suppose that later you wanted to update User object information and add properties that were not imported when the users were created.

For example, if you wanted to delete values from the ``Middle initial'' field, import new values from the ``Year'',``Major'',and ``Grade point average'' fields, and change the separator used for all user information after Adam Jones, you would edit the data file as shown here:

   ``Jones'',``Adam'',``#DEL'',``111 South 8th East'',``Salt Lake
   City'',``Utah'',``84007'',``2345'',``Sophomore'',``Environmental
   Engineering'',``2.8'',``Engineering Sciences''
   

   !Separator=/
   

   ``Smith''/``John''/``#DEL''/``222 North Cerillos''/``Los Angeles''/``California''/
   ``96000''/``2875''/``Senior''/``Accounting''/``3.0''/``Business Administration''

For example, to place the users in the Engineering.Acme context, and to change the separator to a semicolon ``;'', you would add the following lines to the data file:

   !Name context=.ENGINEERING.ACME.
   !Separator=;

Corresponding changes to the import control file

After editing the data file, you must change the import control file to reflect the changes you made.

In the following example, the ``delete property'' and ``replace value'' control parameters have been added to delete the marked properties and specify that you want properties in both single- and multiple-value fields to be replaced by new properties. Fields marked ``Skip'' are replaced by ``See also'', so the properties are imported to the ``See also'' field for the users.

   Import control
   Name context=.administration.student_accts
      User template=y
      Create home directory=y
      Home directory path=students/home
      Home directory volume=.SYSVOL.Student Records
      Delete property=#DEL
      Replace value=y
   Fields
      Last name
      Given name
      Middle initial
      Postal address
      Postal address
      Postal address
      Postal address
      Name
      See also
      See also
      See also
      Department