Operational data exports: Users

The User export returns all LENA users in the selected organization and any of its sub-organizations.

It does not contain group associations.

This export is available to any LENA account administrator.

1. Select the highest organization of interest in the context menu.

2. From the main menu, expand the Data section, select Data Exports, and then choose the Operational Data tab.

(Note: Your list of tabs may be different, as available options differ by LENA program type.)

3. Filter by date range (optional).

Leave dates blank to export all data.

4. Click the User button at the bottom of the screen.

The exported CSV can be opened as a spreadsheet in Excel.

Click here for a list of exported fields and their descriptions.
Field
Description
OrgID
LENA Online database ID number of the organization in which the user's account is located
OrgName Name of the organization in which the user's account is located
UserID User's LENA database ID number
Title Information from the optional "Title" field on the user record screen
Status Indicates whether this user's account is active or inactive
FirstName User's first name
MiddleName User's middle name
LastName User's last name
Language User's preferred language
Phone User's texting number
ReceiveTexts Indicates whether the user is set to receive system texts
Email User's email address
ReceiveEmail Indicates whether the user is set to receive system emails
Admin Indicates whether the user has LENA Online administrator permissions 
ViewChild Indicates whether the user can see child names in LENA Online
ViewOrg Indicates whether the user can see all data within his/her organization (if false, then must have group associations)
DatabaseInsertDateTime Date and time when the user was added to the system