Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
07/04/2024 09:54 AM
Hello,
We have a problem when we import users from a file based import.
Users with a first or last name with an accent are incorrectly displayed on Saviynt.
Example: José / Chloé
At first we had special characters instead of accents like this
So we converted our file to UTF-8 and reimported it into Saviynt, but now a black diamond with a question mark appears instead of the accent.
Could you please help us correct this problem?
Solved! Go to Solution.
07/04/2024 04:33 PM
07/05/2024 12:39 AM
Hi,
Could you detail how to do it please ?
Use database functions from the Saviynt application ? What type of request to do ?
Because I have 1800 users and I can't check manually what users are badly encoded
Thanks
07/05/2024 03:09 AM
@HichamElk Refer below doc
07/05/2024 06:11 AM
Ok,
So we tried using this :
{
"ADDITIONALTABLES":
{
"USERS": "SELECT username, firstname, lastname, displayName FROM USERS"
},
"COMPUTEDCOLUMNS":
[
"username",
"firstname",
"lastname",
"displayName"
],
"PREPROCESSQUERIES":
[
"UPDATE NEWUSERDATA SET firstname = FN_EIC_REPLACE(NEWUSERDATA.firstname, null)",
"UPDATE NEWUSERDATA SET lastname = FN_EIC_REPLACE(NEWUSERDATA.lastname, null)",
"UPDATE NEWUSERDATA SET displayName = FN_EIC_REPLACE(NEWUSERDATA.displayName, null)"
]
}
We entered this json in the part User Pre-Processor Config JSON in the page User File Based Import. Also our CSV file that contains those columns :
username,firstname,lastname,DisplayName
Selected First Row as Heading YES and then clicked on Upload and Preview
The preview still shows the special caracters.
Are we doing it good or is there any mistake ?
Thanks
07/05/2024 06:18 AM
Did you added preprocessor JSON during import?
07/05/2024 06:23 AM
We did it this way,
We completed every field then clicked on upload and preview. Does it answer the question ?
We haven't Imported as we don't see changes in the preview
07/05/2024 06:29 AM
Share logs
07/05/2024 06:43 AM
Could you help us finding the logs of the preview import
We dont' find anything related to it
Do you have any keyword to search or anything ?
Thanks
07/05/2024 06:48 AM
Once you upload files share logs for last 3 minutes
07/05/2024 06:52 AM - edited 07/05/2024 07:27 AM
07/05/2024 01:57 PM
Try with below JSON
{"ADDITIONALTABLES":{"USERS":"SELECT username, firstname, lastname, displayName FROM USERS"},"COMPUTEDCOLUMNS":["username","firstname","lastname","displayName"],"PREPROCESSQUERIES":["UPDATE NEWUSERDATA SET firstname = FN_EIC_REPLACE(NEWUSERDATA.firstname, null)","UPDATE NEWUSERDATA SET lastname = FN_EIC_REPLACE(NEWUSERDATA.lastname, null)","UPDATE NEWUSERDATA SET displayName = FN_EIC_REPLACE(NEWUSERDATA.displayName, null)"]}
07/08/2024 12:15 AM
Hi,
This JSON doesn't work too, Saviynt seems to find no difference between old import and new one. Check the screenshot below
Thanks
07/08/2024 07:27 AM
Is it possible trying on your side the function and if it works, to show us what you have done to make it
Thanks
07/08/2024 11:44 AM
Are you changing data like firstname/lastname during import ? Please share logs
07/09/2024 07:50 AM
07/09/2024 07:58 AM
07/09/2024 09:06 AM
Yes you are right,
I just imported a new file in UTF8 with the special characters corrected and it worked fine, no function needed.
Thanks for the help
07/09/2024 09:40 PM
✅👍Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.
07/10/2024 05:55 AM
Please confirm if provided preprocessor worked ? If not provide working solution to help others
07/10/2024 06:02 AM
Hi,
Preprocessor solution was not needed.
What we have done is :