Reports copied to a network share
An oddly missing feature from enVision is to send reports to a network share instead of e-mailing them to a mailbox. I've had a number of requests for this and attempted to kludge a solution with a timed task BAT file copying the reports but the structure of a folder for year + month + report makes it too burdensome. Should be something out of the box. Dropping reports to a web server for example would enable auditors to stop bugging me .
Sure, So first what I have happening is a bunch of reports being saved to a local directory on the enVision server. I then have a scheduled job setup that runs this batch file at a time when I know all the reports will be completed. As I said before, I then have all the .csv (could do html or pdf just as easily) files moved to the FTP folder where our sharepoint team then has a handler setup to log in and grab the reports. I cannot speak to the functionality there. Here is the batch file. Ignore the line numbers and I will use those to describe what each line does below:
1. cd /d "C:\Configuration_Management"
2. for /r %%a in (*.csv) do copy "%%a" "E:\nic\4100\Cprenvsp01-ES\ftp_files\Configuration_Management"
3. del C:\Configuration_Management\*.* /Q
4. RD /S "C:\Configuration_Management" /Q
Line 1 changes the working directory to parent folder where all my reports are, this is the directory where the default or admin reports tree gets created by enVision
Line 2 searches this root folder and all subfolders for the files in question. In this case it is .csv files. It then copies them to the ftp directory.
Line 3 preforms cleanup, it deletes out all the other files not needed that envision created
Line 4 deletes out all the folders created by enVision leaving the parent directory completely empty.
Wow... 5 years and no feature for this yet. I'm STILL wishing I could drop reports to a network shared folder. Not SharePoint... not LiveLink. Just a plain old fashioned network share. I'll send a note to tech support and update here.
One key word with enVision "Don't wait for a solution form the support"
Before these steps, be sure that your network folder is accessible to envision and their nic_xxx users.
To store reports in a shared nas, directory or something else,
Go to the application server,
Go to the nic folder, domain name, version
Go to database folder
Go to cmd folder
This will start the sybase sql editor.
Then make a select on the correct dabasae, I don't remember the name but the table contains the word report
Select * from generatedreport
You should see the path used to store the reports.
Change it by your UNC path, Now your report should be created on that folder.