PARTNERS - Please join us for our upcoming webinar:
Leveraging Intelligent Recommendations for Operational Transformation.
AMS Partners click HERE | EMEA/APJ Partners click HERE

Pushing CSV file using SFTP Jar connector

Mahak_Acharya
Regular Contributor
Regular Contributor

Hi Team,

 

Is it possible to push the CSV file using the SFTP Jar connector as currently only XLSX files are being pushed to the SFTP location.

We have tried this in 5.5 and now will be moving onto 24.3 version. Is it possible in either of these instances.

Thanks,

Mahak

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

It’s supported

 https://docs.saviyntcloud.com/bundle/SFTP-Certified-v24x/page/Content/Permissible-Values-for-File-Tr...

Default File Location Permissible File Extensions

In the FILES_TO_PUTparameter, when you specify Reports in the eic_src_dirattribute, files are uploaded from the /saviynt_shared/reports/admindirectory.

From Release v23.8 onwards,, when you specify Reports, in the eic_src_dirattribute, files are uploaded from the /saviynt_shared/reportsdirectory.

Files with the following extensions can be uploaded:

  • .zip

  • .csv

  • .xlsx

  • .xls


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Mahak_Acharya
Regular Contributor
Regular Contributor

Thanks for your response Rushikesh.

We are actually running a report/analytics in Saviynt, storing the same in reports location and then uploading it in the target location. As i understand the file must already be in CSV format for us to upload, but exported reports are stored in xlsx format. How can we change this format to CSV?

Regards,

Mahak

  • Using java code you need to convert xlsx file into csv and sent to target

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Mahak_Acharya
Regular Contributor
Regular Contributor

Could you maybe share some example of the same for Jar Connector