Export Accounts in Batches
This function allows you to export the account information to a file and save the file locally or to the INC server.
Operation Procedure
- Select the User tab, and then click Access User > Batch Operations in the navigation tree to enter the batch operations page.
- Select the radio button of Export Accounts in Batches, and then click Next to enter the access account query page.
- Type the query conditions and click Preview. The matched access accounts will be displayed in the access user list. To restore the default query conditions and query accounts information by the default query conditions, click the Reset button.
- Click Export Accounts, enter the format setting page of exporting file. When finished the setting, you can click the OK button.
- The system will export the accounts to a file, save the file to the INC server, and then enter the operation result page.
- On the operation result page, you can click the Download button to download and save the account file to the local PC.
Precautions
- In operation step 4, the formats include TXT and CSV. If TXT is selected, you can select the file column separators: space, Tab, comma (,), colon(:), number sign (#), and dollar sign ($). The comma-separated values (CSV) format is a text format that uses commas (,) to separate values. In Windows, a file in CSV format is opened by using Excel by default. Excel can automatically select the display format according to the contents. As a result, the contents displayed in Excel may be different from the actual contents. For example, Excel will display 123456789123456789 as 1.23457E+17 according to the scientific notation. In this case, you can configure Excel to display the contents as text, or use text editors (for example, Notepad) to open a file in CSV format.
- In operation step 4, you can customize the account information to export. If you do not have the administrator permission, the Password option does not appear.
- In operation step 5, the path for saving the exported file is: <conductor INC server installation directory>/tmp.
- In operation step 5, the name of the exported file is suffixed with the time at which you exported the file. This is for you to find the file easily.
- The Export Plain Password parameter is hidden by default. To export plain passwords, execute the following SQL statement in the database to enable displaying this parameter: "UPDATE EAD.EAD.TBL_PARAMETER SET VALUE = 1 WHERE PARAMETER_ID = 2018;".
Related Topics