Delimited File sources - Manual Correlation

Feedback Bugs
, ,
1

What problem are you observing?

If delimiter for Delimited File source is NOT comma, then manual correlation via upload file fails in two ways.

  1. The dowload file is comma separated, so upload of this cant parse the header row
  2. If you replace all the comma’s with whatever your delimiter is, ISC still fails to parse the input file

What is the correct behavior?

  1. ISC should provide the correct Correlation File
  2. ISC should be able to read/parse the Correlation File provided.

What product feature is this related to?

Delimited File sources for ISC

What are the steps to reproduce the issue?

  1. Given a Delimited File source, set the delimiter to something other than comma, eg pipe character.
  2. Aggregate file so there are some uncorrelated accounts
  3. Under Account Management > Uncorrelated Accounts, click ‘Download Correlation File’
  4. View file, you will see it is comma separated
  5. Specify a username you wish to correlate
  6. Attempt to upload file, it will fail as headers are comma separated in the provided file.

error “Column: “[account,displayName,userName,type]” is unknown and/or column: “[account, displayName, userName, type]” is missing."

  1. Replace all commas in file with your delimiter, eg |
  2. Attempt to upload file. This time file is successfully uploaded, but will not be parsed successfully

An unexpected error occurred: java.lang.IndexOutOfBoundsException: Index 1 out of bounds for length 1

Do you have any other information about your environment that may help?

N/A

2

Thank you for submitting this. I have opened a ticket (SET-20240) to investigate.

1 Like
3

Hi guys, I’ve found a way to make this work, adding " on all columns, like:

"account","displayName","userName","type"