Importing People Profile in NERM

We are trying to import non-employees as People profile in NERM. Now, we have a profile search attribute which has a value with a comma in it. Importing a csv is not able to escape the comma.

We have tried many things to escape the comma but it does not work.

Any help would be appreciated.

Hi Anshuk,

I have not personally tackled it in NERM but had resolved the issue for direct APIs by changing the csv content. Can you please try below

  1. Wherever, we have comma in the column value → need to wrap that column with double quotes for example Jone,Doe will become like “jone,Doe”

  2. wherever we have double quotes in the column value → we need to replace double quotes with \" , so jone "Doe will become jone \"Doe.

  3. wherever we have double quotes and comma both in the column value → we need to replace double quote (“) with \”" and wrap that value in double quotes e.g.

jone, doe “barry”, David → changed to → “jone, doe \”“barry\”“, david” .

Please check it with one user first and see if that helps.

Thank You.
Regards
Vikas.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.