CSV file or URL

Note

This feature required Enterprise Edition

You can add users to the Policy Server by importing end user information from a comma-separated value (CSV) file.

Go to Preferences in the top panel.
Navigate to User Authentication> Authentication Synchronization in the left panel.
Click Tasks> Create.
Find the General menu.
For ID, Enter name here
For Update Interval, Select the specified time or periodic interval for synchronization.
For Policy Apply, After synchronization, select Enabled to reflect the changes. If you have multiple sync settings, you can set it to Disabled and enable only the last sync.
For Environment, Input is not required for basic synchronization tasks. However, it is used when defining variable values to be commonly referenced within a separate custom shell script executed for integration with external systems.

Warning

Configuration Caution: Incorrect environment variable declarations can lead to malfunctions in the integration script or system errors. Before configuration, please ensure that the variables are correctly processed within the script.

Usage Scenario: Log Level Control Used when you want to control simple operation options such as Log Level or Retry Count during external script execution.
```
export LOG_LEVEL='ERROR'
```
For Query, Enter the SQL query to be executed immediately after information synchronization is complete. This is used when secondary processing is required based on specific conditions using the synchronized information.

Warning

Risk of Data Loss: This feature directly affects the database. In particular, the use of UPDATE or DELETE statements may result in irreversible data loss.

Usage Scenario: Account Lock Processing based on Employment Status Used when you want to automatically disable the NAC account of resigned (or on-leave) employees according to the 'Employment Status' code after information synchronization.

Prerequisites 1. Create a field to manage employment status (e.g., USER_CUSTOM08) in [Settings] > [Property Management] > [Custom Fields] > [User Custom Fields]. 2. Assign the user custom field created in step 1 to [Additional Info] under [User Information] in [Information Synchronization].

Writing Example If the value of USER_CUSTOM08 is '001' (Resigned/On-leave, etc.), update USER_STATUS to '0' (Disabled).
```
UPDATE USER
SET USER_STATUS = 0
WHERE USER_CUSTOM08 = '001';
```
Find Advanced> DB Type and select CSV.
In the Data Synchronization list, click the checkbox in the desired synchronization list.
Click Tasks> Synchronize now.