How to use the Compare CSV feature

Added in version v3.83 beta 3
Screenshot of the Compare CSV tool.

Screenshot of the Compare CSV tool.

Example file 1

cn=U1,ou=Users,o=ACME;[email protected];TRUE;TRUE
cn=U2,ou=Users,o=ACME;[email protected];TRUE;TRUE
cn=U3,ou=Users,o=ACME;[email protected];TRUE;TRUE
cn=U4,ou=Users,o=ACME;[email protected];TRUE;TRUE
cn=U5,ou=Users,o=ACME;[email protected];TRUE;TRUE

Example file 2

[email protected],TRUE,TRUE
[email protected],FALSE,TRUE
[email protected],TRUE,FALSE
[email protected],TRUE,TRUE
[email protected],TRUE,TRUE
[email protected],FALSE,FALSE

Using the example files above we want to find out which e-mail addresses are missing from each file.

Usually you might have an export from an IDM system and a connected system and you want to compare them.

It might be thousands of lines or more that must be compared, this can be done in many different ways with other tools.

  1. Select the files by browsing to the by clicking on the icon next to File 1 and File 2.
  2. Select the charset encoding for the files, the tool always default to UTF-8.
    1. Optionally preview the files using the selected charset by clicking on the icon next to Charset.
  3. Enter the separator character for each file, in the example above it would be ; for file 1 and , for file 2.
  4. Enter the column index to select the column in each file you want to compare.
    1. In this exampl, select 1 for file 1 to get the e-mail addresses from file 1.
    2. For file 2, select 0 to get the e-mail addresses from file 2.
  5. Click Perform operation to do the comparison.
  6. Results will be written to the same directory where the source files are located.
    1. Make sure that C2 has permissions to write to that directory.

Output 1

Values in C:\Users\a\Desktop\file1.txt that are missing from C:\Users\a\Desktop\file2.txt
[email protected]

Output 2

Values in C:\Users\a\Desktop\file2.txt that are missing from C:\Users\a\Desktop\file1.txt
[email protected]
[email protected]