I want to upload a users CSV automatically after i get the CSV file through SFTP connection.

[Som9800]

Hi ,

I want to upload users CSV automatically after i get the CSV file through SFTP connection.

Kindly provide me the documentation if it is available in the document portal.

[SumathiSomala]

@Som9800 Refer below documentation

Configuring the Integration for File Transfer (saviyntcloud.com)

Use FILES_TO_GET  parameter in the connection to transfer the file from client location to Saviynt file directory

Refer below doc for schema upload

Saviynt Documentation (saviyntcloud.com)

[Som9800]

Hi Sumathi,

After i receive the file in Saviynt file directory how can i upload that users CSV automatically through CSV upload.

Thanks

Saumya

[rushikeshvartak]

You need to use Schema import Job . Please schedule Job to import user automatically,

Refer https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter03-User-Management/Uploading... 

[PremMahadikar]

Hi @Som9800 ,

Check these documentation link under Uploading the User Details - Uploading Users Using Schema Upload (saviyntcloud.com)

Quick answer:

1. Create a sav file and upload it under- Admin > Settings > FileDirectory > sav files (Refer Contents of the Upload Files to prepare the sav file)
2. Create a new job from Admin > Job Control Panel > Add New Job

   • Select Job Type as SCHEMA > File based User Import (SchemaUserJob) and click + Add New Job to create a new instance of the job.

   • Specify the Job Name and click Save.
     Specify the Job Name to create a job trigger, specify the schedule details as per your requirement.

   • In the SAV File(s) drop-down, select a SAV file you want to import.

   • To start the job, click Action, then click START.

3. Schedule this job to make it automatic

After the job is executed, the corresponding user data is uploaded.

If this helps, please consider selecting Accept As Solution and hit Kudos

[Som9800]

Hello Rushikesh and Prem,

Thanks for your suggestions. I have followed the same but when i am uploading the csv i am getting below error.

Error : Error Data File Not found for any Schema File for SchemaUserJob

I have also attached both sav(USERS.txt) and csv(Users.csv) files FYI.

I have attached USERS.txt file as  sav file because the forum is not allowing me to upload sav file.

Thanks in advance.

[rushikeshvartak]

• Ensure that the CSV file name must start with the string that you specified for the FILENAME property.

• Ensure that the SAV file name ends with users.sav.

  Note

  The file name is not case sensitive. For example, Sample_Users.sav.

  #USER_NOT_IN_FILE_ACTION=NOACTION
  #FILENAME=Users
  #DELIMITER=,
  #SKIP_NUMBER_OF_LINES=1
  #ZERODAYPROVISIONING=TRUE
  #userReconcillationField=employeeid
  #GENERATESYSTEMUSERNAME=FALSE
  #GENERATEEMAIL=FALSE
  #CHECKRULES=TRUE
  CUSTOMPROPERTY2,CUSTOMPROPERTY6,DEPARTMENTNAME,COMPANYNAME,LASTNAME,FIRSTNAME,MANAGER,PHONENUMBER,STREET,REGIONCODE,CITY,COUNTRY,CUSTOMPROPERTY21,TITLE,CUSTOMPROPERTY29,STARTDATE,ENDDATE,CUSTOMPROPERTY31,CUSTOMPROPERTY26,STATUSKEY,CUSTOMPROPERTY30,USERNAME

[Som9800]

Hi Rushikesh,

Facing the same error.

Error : Error Data File Not found for any Schema File for SchemaUserJob

#userReconcillationField=employeeid

But employeeid is not present in the mapping.

Is it causing the issue ?

[rushikeshvartak]

Remove # from sav file. # means commenting line

[Som9800]

Hi Rushikesh,

Facing the same error.

Error : Error Data File Not found for any Schema File for SchemaUserJob

[rushikeshvartak]

Share Below details

• Screenshot that file uploaded in file directory 
  • Csv & SAV file
• Job configuration
• logs in text file ( highlight or mention line number where job starts)

[Som9800]

Hello,

I have attached all the required docs.

Job name :Users_Import_Palantir

Thanks in Advance

[This message has been edited by moderator to mask sensitive information]

[Som9800]

@rushikeshvartak 

I have attached all the required docs in the reply above.

Kindly help me on this.

Thanks,

Saumya

[rushikeshvartak]

Use below Sav file content

#USER_NOT_IN_FILE_ACTION=NOACTION
FILENAME=Users
#DELIMITER=,
#SKIP_NUMBER_OF_LINES=1
#ZERODAYPROVISIONING=TRUE
#userReconcillationField=employeeid
#GENERATESYSTEMUSERNAME=FALSE
#GENERATEEMAIL=FALSE
#CHECKRULES=TRUE
CUSTOMPROPERTY2,CUSTOMPROPERTY6,DEPARTMENTNAME,COMPANYNAME,LASTNAME,FIRSTNAME,MANAGER,PHONENUMBER,STREET,REGIONCODE,CITY,COUNTRY,CUSTOMPROPERTY21,TITLE,CUSTOMPROPERTY29,STARTDATE,ENDDATE,CUSTOMPROPERTY31,CUSTOMPROPERTY26,STATUSKEY,CUSTOMPROPERTY30,USERNAME

• Keep csv file name as Users1.csv
•  

[Som9800]

@rushikeshvartak 

I have tried the solution you have provided above but still i am getting the same error.

Error : Error Data File Not found for any Schema File for SchemaUserJob

Actually in my filedirectory-savfiles-one users 1.csv file present and i am unable to delete it.

attached the screenshot FYI.

kindly have a look.

Thanks for your suggestions

Saumya

[rushikeshvartak]

You need to upload csv file in data files

[Som9800]

@rushikeshvartak 

I am placing the csv file in data files only.

Still facing the same error.

Thanks,

Saumya

[rushikeshvartak]

Screenshot.

[Som9800]

@rushikeshvartak 

I have attached the screenshot. Kindly check

[rushikeshvartak]

#USER_NOT_IN_FILE_ACTION=NOACTION
#FILENAME=Users
#DELIMITER=,
#SKIP_NUMBER_OF_LINES=1
#ZERODAYPROVISIONING=TRUE
#userReconcillationField=employeeid
#GENERATESYSTEMUSERNAME=FALSE
#GENERATEEMAIL=FALSE
#CHECKRULES=TRUE
CUSTOMPROPERTY2,CUSTOMPROPERTY6,DEPARTMENTNAME,COMPANYNAME,LASTNAME,FIRSTNAME,MANAGER,PHONENUMBER,STREET,REGIONCODE,CITY,COUNTRY,CUSTOMPROPERTY21,TITLE,CUSTOMPROPERTY29,STARTDATE,ENDDATE,CUSTOMPROPERTY31,CUSTOMPROPERTY26,STATUSKEY,CUSTOMPROPERTY30,USERNAME

[Som9800]

@rushikeshvartak 

Still facing the same error.

[rushikeshvartak]

Share logs in text file