and more in a single search tool across platforms. Read the announcement here. |
02/22/2023 12:52 AM
Hi,
I'm trying to import users with the schemauserjob that is well working for basic user import.
But, I need to make pre process on these with some json code. From the sample of the freshdesk I see that it's possible:
But when I have this line as last line at the end of my .sav file per exemple it is allways triggering me an error :
Error in Users Import - Username column is mandatory and not present in data |
But I have the username column, so I tried to put the modifyuserdatajson one line above, and then it's not triggering error at all but completely ignoring the process..
Could you please give me an sample of a .sav file with a working configuration with modifyuserdatajson making easy modification (just a simple one but that's working so then I can modify it for my use case)?
Best regards,
Quentin NEUMAYER
Solved! Go to Solution.
02/22/2023 03:14 AM
Can you please share the sav file you are using, Also if you are using any custom java function it has to be available and it will use username as key field to identify the users
02/22/2023 05:46 AM
02/22/2023 04:16 PM
I see you have used ACTIVEIDENTITIES which is not actual SSM table you just aliased users table. I don't think it is supported like that.
What is the logic you want to implement in preprocessor?
02/23/2023 01:11 AM
Hi,
My goal here is only to have a working sample, so then I can edit in function of my use case. I have many use case that I will have to perform thanks to this. Per example, if the location of my user is switzerland, set the status of the account to active.
Actually the error message that I receive through savyint is that I don't have username column. So I would like to try a working example.
Regards,
Regards
02/23/2023 05:13 AM
PFA sav file which you can use. ( Sample one - update new queries if needed )
I see there was a query error where u didn't mention alias u for users table.
Also make sure modify user data json should be in one single line- if its having multiple lines it will error out.
Let me know if you still face any issue.
@sk I see u had a doubt whether ACTIVEIDENTITIES table can be used or not, it is supported these are temporary tables which are created so you can choose any naming conventions.
02/23/2023 06:10 AM
@Darshanjain : Thanks for confirming
03/07/2023 02:31 AM - edited 03/07/2023 02:32 AM
03/07/2023 02:41 AM
Hi @QNeumayer
You can check the logs, you will get a fare idea where you are doing the mistake. Please check and see which query is having issues while updating and try to fix it.
If you still face a issue, let me know the error what you are getting and will check
Thanks
Darshan