Manual correlation file upload failure

[jrossicare (Jason Ross)]

Hi,

Is manual correlation via upload file no longer working?

I get the error

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

when uploading a file

Thanks

[rachel_rigdon]

Hi @jrossicare! I checked https://status.sailpoint.com/ and Platform Status Updates - SailPoint Developer Community, and it looks like correlation is working as expected.

I moved your comment over to ISC Discussion and Questions - SailPoint Developer Community to see if the community has any insight on what you’re seeing.

[KevinHarrington]

Try opening your file in a plain text editor like Notepad or Notepad++. It sounds like ISC is reading your column headers as one quoted string and not individual headers.

[KRM7 (Krishna Mummadi)]

On top of Kevin’s response, there is a new feature Identity Management → Accounts → Uncorrelated Accounts you can correlate any account manually to any identity. If it is not too many accounts, you can do directly from console itself.

[TJ21 (Tom Cipriano)]

@jrossicare see screenshot double check for spaces and typos when you do the file import.

[KRM7 (Krishna Mummadi)]

what are the columns you are passing in CSV file.

[TJ21 (Tom Cipriano)]

[jrossicare (Jason Ross)]

I downloaded the correlation file “Download Correlation File”, then I put in the username I wanted to correlate, then tried to upload

All I did was add in the username I wanted to correlate. I didnt manipulate the header row at all or save in different encoding or format type

[jrossicare (Jason Ross)]

Thanks for the suggestion. I tried that, but it made no difference.

I dont know why it is reading the first line of the file as a single string, and not comma separated.

[vkashat (Vincent Kashat)]

Might be a dumb question, but have you checked what the delimiter is set to in the source configuration?

[jrossicare (Jason Ross)]

That’s exactly it!!

If the delimiter is NOT comma, then it fails.

I change the input file to my delimiter, | and it still fails.

I have to change the source delimiter to comma, then upload correlation file, then change it back.

[vkashat (Vincent Kashat)]

I’m glad it worked out!

[leonardo_frodrigues (Leonardo Ferreira Rodrigues)]

Hi guys, another fix I’ve found here is to add " on all columns, like:

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