Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Need to send analytic report from saviynt to SFTP server in txt format

VenkatAligineni
New Contributor
New Contributor

Hi,

As we understood Saviynt has OOTB feature to transfer files from Saviynt to SFTP location and SFTP location to Saviynt. In this process we got a good experience in downloading the file from SFTP location to Saviynt Datafiles location. However we are facing a challenge while uploading the file from Saviynt location (/saviynt_shared/saviynt/Reports/) to SFTP location. 

Expectation : Reports which we generate need to be sent to SFTP location in txt format.

Observations : 

1. Analytic reports are storing in /Reports/ location in zip format and as per the upload functionality zip format is not supported.

2. Tried uploading .csv file from /datafiles/ location  to SFTP server and successfully transferred.   

@rushikeshvartak any help will be highly appreciated.

Thanks in advance

Regards,

Venkat Aligineni

5 REPLIES 5

Darshanjain
Saviynt Employee
Saviynt Employee

Hi @venkat 

(/saviynt_shared/saviynt/Reports/) will be stored in xlsx format always. This format is supported to upload SFTP. 

Also currently format changes are not supported, so the same format needs to be uploaded to SFTP location

VenkatAligineni
New Contributor
New Contributor

Hi @Darshanjain 

I had created a analytic report (TestReverseFeed) and provided the save to file location as /saviynt_shared/saviynt/Reports/

When I tried to transfer the above file to SFTP location it was not succeeding.

Connection Details : 

"ACTION":"upload",
"SFTP_DIRECTORY":"/home/*********/Dev_Test/",
"SAVIYNT_DIRECTORY":"/saviynt_shared/saviynt/Reports/",
"FILE_NAME_REGEX":"^.*TestReverse?[-_.A-Za-z0-9]*",
"SFTP_LOGFILE_DIRECTORY":"/saviynt_shared/saviynt/Import/Success/",
"DELETE_SOURCE_FILE_AFTER_DOWNLOAD":"no ",
"SFTP_CERT_DEFAULT_PATH":"/saviynt_shared/saviynt/Import/Datafiles/",
"FILE_EXTENSION":".xlsx",
"LOG_FILE_AGE":"5"

I would like to know what was the file name will be in the reports folder?

Is there a way to check what file available in the reports folder?

Thanks & Regards,

Venkat Aligineni

9177247342

Hi @VenkatAligineni 

I would suggest you to check with saviynt support team to get the exact path if you have used this directly from documentation.

Also do you see anything in the logs to check why its not succeeding.

 

Thanks
Darshan

 

Thanks

Darshan

VenkatAligineni
New Contributor
New Contributor

Hi @Darshanjain 

Please find the log

"ecm-worker","2023-03-16T12:34:24.842+00:00","{"log":"2023-03-16 12:34:24,400 [quartzScheduler_Worker-2] DEBUG println.PrintlnToLogger - Println :: \u001b[1;31m| Error \u001b[22;39m\u0009at com.saviynt.provisoning.JarConnectorService.invokeExternalClass(JarConnectorService.groovy:1160)\u001b[m\n","stream":"stdout","time":"2023-03-16T12:34:24.400048432Z"}"
"ecm-worker","2023-03-16T12:34:24.842+00:00","{"log":"2023-03-16 12:34:24,400 [quartzScheduler_Worker-2] DEBUG println.PrintlnToLogger - Println :: \u001b[1;31m| Error \u001b[22;39m\u0009at com.saviynt.provisoning.JarConnectorService.this$2$invokeExternalClass(JarConnectorService.groovy)\u001b[m\n","stream":"stdout","time":"2023-03-16T12:34:24.400060334Z"}"
"ecm-worker","2023-03-16T12:34:24.842+00:00","{"log":"2023-03-16 12:34:24,400 [quartzScheduler_Worker-2] DEBUG println.PrintlnToLogger - Println :: \u001b[1;31m| Error \u001b[22;39m\u0009at com.saviynt.provisoning.JarConnectorService$this$2$invokeExternalClass$2.callCurrent(Unknown Source)\u001b[m\n","stream":"stdout","time":"2023-03-16T12:34:24.400109062Z"}"
"ecm-worker","2023-03-16T12:34:24.842+00:00","{"log":"2023-03-16 12:34:24,400 [quartzScheduler_Worker-2] DEBUG println.PrintlnToLogger - Println :: \u001b[1;31m| Error \u001b[22;39m\u0009at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:49)\u001b[m\n","stream":"stdout","time":"2023-03-16T12:34:24.400115847Z"}"

rushikeshvartak
All-Star
All-Star

Use jar connector to read report data using rest api and prepare txt and send to sftp location


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.