D2L Staff Load

 Problem Description : 

How to do a staff load in D2L

 Resolution : 

N:\csd\TRACY\SQL\CSD SQLs\D2L\D2L 

Run create staff accounts sql: 

SELECT  'CREATE',

        GOBTPAC.GOBTPAC_EXTERNAL_USER,

        CONCAT ('760.', Gobsrid_sourced_id),

        vp.FIRST_NAME,

        vp.last_name,

        '' PIN,

        'Student',

        '1',

        VP.EMAIL_ADDRESS

  FROM  v_person vp,

        gobtpac,

        spraddr,

        gobsrid

 WHERE      gobtpac_pidm = vp.pidm

        AND spraddr_pidm = vp.pidm

        AND gobsrid_pidm = vp.pidm

        AND SPRADDR.SPRADDR_ATYP_CODE = 'ST'

        AND SPRADDR_STATUS_IND  IS NULL -- added to prevent disabled ST address

        AND SPRADDR_to_date IS NULL

        AND VP.EMAIL_ADDRESS IS NOT NULL -- added to prevent users without email address from loading - required

        /*and not exists (select 'X'

            from v_faculty vf

                where vf.pidm = vp.pidm

                And vf.FCST_CODE = 'AC'

                And vf.CNTR_CODE in ('FT', 'AD'))*/

export as a CSV

Log on to D2L as D2L admin username: goc.admin

Settings

Users

Bulk User Management

Browse

Select user csv

Next

Next

Next

Uncheck creation email notification

View Summary

Done

 Revision Date : 2/10/2020

 Keywords : account, username, uploading files