Hello all ,
There is a use case where we need to upload users via flat file upload but the headers we have received is this :
Staff_ID,Forename1:People,Surname:People,Full Name,Position,Department,Cost Code,User Email,Start Date,Leaving Date:People,Reporting Manager Name,Site
Now while upload we can do the respective mapping like Forename=Firstname and Surname=Lastname etc. But are there any preprocessor script through which we will only do the upload and the preprocessor JSON will do the mapping and we will just click on import now . Like no manual mapping .
Unable to do so , tried couple of preprocessor scripts but seems they are only responsible for making computed attributes . Need suggestions around.
I have tried using .sav upload but unable to make it work . suppose i have ForeName:People in my file , i want to make this value to save in FIRSTNAME , where to specify in .sav file this thing .
note : I tried putting below logic under preprocessor queries in .sav file but not working . Can you pls provide one sample for the above requirement:
"UPDATE NEWUSERDATA SET firstname=NEWUSERDATA.ForeName",
Thanks for the insight .Then to implement this requirement then as you suggested uploading from UI is not correct approach , then can you pls let me know to perform this what will be the best suited .sav file .
e.g. suppose i have ForeName:People in my file , i want to make this value to save in FIRSTNAME , where to specify in .sav file this thing .
@Diptansu1 you can use .sav file which refer attached sample .sav file (change file extension from .tx to .sav before using it). Based on your requirement use the correct saviynt attribute name in .sav file (for example FIRSTNAME) corresponding to the column in data file and you should be able to update the data in Firstname attribute.
The schema based import supports inline processing as well. Refer following document for details on how to use schema based imports
I have gone through this link and prepared sav file as below :
still its not working . Task is success but no user is inserted in Saviynt . Please let me know for this requirement if the attached sav file is fine.