Specific columns appear empty when exporting user data to a CSV file. This occurs even when the User Profile contains data for those fields. This issue specifically affects fields stored as arrays, such as the multifactor attribute.

• User Management
• User Import / Export Extension

The CSV export format does not support the direct rendering of array data types into a single cell. When a field stored as an array is requested without specifying an index, the export generates a blank value for that column.

Use one of the following methods to retrieve data stored in array fields. The multifactor field is used in these examples to illustrate the process.

Method 1: Export using JSON Format (Recommended)

This method retrieves the complete list of values for an array field.

1. Navigate to User Management > Users.
2. Click the Import / Export button.
3. Select Export Users.
4. Select JSON in the Format dropdown.
5. Add multifactor in the Fields section.
6. Click Export.

Method 2: Export using CSV Format

This method retrieves a specific value from the array by targeting its index.

1. Navigate to User Management > Users.
2. Click the Import / Export button.
3. Select Export Users.
4. Select CSV in the Format dropdown.
5. Enter multifactor[0] in the Fields section.
   • NOTE: Using brackets allows the retrieval of the specific item at that index in the array.
6. Click Export.

Related References

• Include user metadata in exported CSV