Updating user IDs
The updates feature of the Sametime Database utility changes specified first names, last names, display names, or group names.
Before you begin
About this task
The following is the format for the update task in the CVS file. Each ID to be
updated is listed on a separate line. The syntax for the update task in the CVS
files is:
ID
"existing_ID", "new_ID"[,"new_display_name"]
CSV
files are case-sensitive and sensitive to spaces.The ID task works by comparing existing user IDs with the names provided in the CSV
list, and replacing the IDs when a match is found. By default, comparisons are case
sensitive. To allow case-insensitive comparisons of user IDs by adding the following
statement to the sametime.ini
file.
NC_ID_TASK_CASE_INSENSITIVE=1
For more
information, refer to Configuring the sametime.ini file.Procedure
-
Create a CSV file. The file must be saved in UTF-8 format.
In the CVS file, specify the ID descriptor followed by the UIDs to be deleted. Specify each UID on a separate line. Note that
For example,ID "existing_ID", "new_ID"[,"new_display_name"]
ID "Maria Smith," "Maria Smith-Brown"[,"Maria Brown"]
Note: The brackets [ ] indicate that the new display name is optional. If you use it, you must precede it with a comma. The new display name must immediately follow the comma. Do not leave a blank space between the comma and the new display name. - Copy the CSV file into an accessible read or writable location.
-
Create or edit a file that contains the environment variables.
The following is an example env_file_name file.
MONGO_CONNECTION_URL=mongodb://sametimeUser:xxxxxxxx@192.168.1.1:27017/admin?authSource=admin&authMechanism=SCRAM-SHA-256&readPreference=primary&directConnection=true&ssl=false DELETE_CSV=/temp/test_delete.csv DEEP_DELETE=1
-
Run the Database utility using the following command. The CSV file is mounted
in the container in the /temp directory in the following
example for the application to access and process. The tag
attribute is the image tag to use.
docker run -v /temp:/temp:rw --env-file env_file_name.env hclcr.io/st/sametime-db-utility:tag
- Copy the CSV file into an accessible read or writable location.
- To verify your changes, view the report created in the data directory.