Relative path for schema import

[HarishG]

Hi,

We are using SFTP connector to get the userimport file to Saviynt DataFiles location - we are using the relative paths for different user files.

But while running the SchemaImport, what should be the filename in SAV file?

I have tried the below as FILENAME, but didn't work!

FILENAME:

• #FILENAME=/saviynt_shared/saviynt/Import/DataFiles/SFTPImports/TestFolder1/sftpuserimport.csv
• #FILENAME=/SFTPImports/TestFolder1/sftpuserimport.csv
• #FILENAME=SFTPImports/TestFolder1/sftpuserimport.csv
• #FILENAME=/SFTPImports/TestFolder1/sftpuserimport

Any suggestions on how to handle the files from relative path?

Thanks

Harish

[PremMahadikar]

Hi @HarishG ,

Can you try renaming the file to Users_sftpimport.csv and use like below

#FILENAME=Users_sftpimport

[rushikeshvartak]

FILENAME

Specify the string that you want to add as a prefix to the name of the corresponding CSV file. In case multiple CSV files with the same prefix are uploaded, all the files are processed. For example, if you specify Users for this property, then the CSV file name can be: Users1.csv, Users_Import.csv, Users_Import_2.csv, or any file name that starts with Users and has a .csv extension.

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

try 

FILENAME=Users_sftpimport

[HarishG]

Hi @PremMahadikar , @rushikeshvartak ,

Thanks for the reply.

I tried the below FILENAME=Users_sftpuserimport, but didn’t work.

FILENAME=Users_sftptuserimport - this will check if the file is present directly in DATAFILES.

But the file which we are trying to process is in the relative path

file location: DATAFILES > SFTPImport > TestFolder1 > sftpuserimport.csv

Any suggestions, on how to process files from relative paths?

Thanks,

Harish

[PremMahadikar]

@HarishG ,

I don't think there is any configuration to add the path on .SAV file. 

Try this, update the path to the relative path in externalconfig.properties (Once you update the file, please restart)

But I would suggest you to use the destination has 'DataFiles' ("eic_dest_dir":"DataFiles") in the SFTPFileconnector.

[HarishG]

Hi @PremMahadikar ,

Thank you for the reply.

But this would work for only 1 file location. we are looking for some solution to pick up files from relative path - by giving the file locations in respective SAV files.

Any idea how to use relative path as FILENAME in SAV file?

Thanks,

Harish

[rushikeshvartak]

You can't use relative path, It will be static path for all Saviynt files. Please place all files in same location and keep different file name as per application name