21
Points
Questions
0
Answers
4
-
Hi Helen,
I do it a little bit more old school.
I run a scheduled job (shortly after I know the scheduled report had executed) on a windows server to call a BAT file (BAT file 1)
The BAT file will execute an SQL query. The query will get the filename and location in the vault of the last saved scheduled report for a specified scheduled report and spool the formatted copy statement to another BAT file (BAT file 2).
BAT file 1 then executes BAT file 2 to copy the file to a new name in a different location.Here is the core of the query:
select ‘copy \vault_root 00′ || substr(file_id,1,3) || ” || substr(file_id,4,3) || ‘agile’ || file_id || ‘.xls NEW DESTINATION AND NAME.xls’ from attachment_map am, report r where r.name = ‘AGILE SCHEDULED REPORT NAME HERE’ and r.id = am.parent_id and am.created = (select max(am2.created) from attachment_map am2 where am2.parent_id = am.parent_id);
Contact me if interested in more details or to exchange solutions.
Regards,
Jonathan- 1962 views
- 4 answers
- 0 votes
-
- 2104 views
- 4 answers
- 0 votes
-
- 1668 views
- 4 answers
- 0 votes
-
Brad,
You do use the port number for the file manager. Agile documentation includes the “Agile Drive User Guide”, you will find answers there. I think that error is caused by not setting the Web Client parameters in the registry or the Host Name cannot be resolved.
From the “Agile Drive User Guide” for 9.3.4:
On Windows 7/ Windows 8 System
To map Agile Drive on Windows 7/Windows 8 systems (both 32-bit and 64-bit
systems):
1. Click the Start button in Windows 7/Windows 8.
2. Run regedit.
3. Navigate to key “HKEY_LOCAL_
MACHINESYSTEMCurrentControlSetservicesWebClientParameters” in
regedit and modify the parameter “BasicAuthLevel” with value of 2, which enables
basic authentication for Windows 7/ Windows 8.
Figure 2–4 Edit DWORD Value
4. Close regedit to save the changes.
5. Restart the service of “Web Client” in Windows 7/ Windows 8 Services.
6. Launch the command in Windows 7 /Windows 8.
7. Enter the following in the command line: net use * http://<Host Name or IP
Address>:<port>/webdav/PASSWORD /USER:USERID where User= Username, and
password.
8. Press ENTER.Agile Drive has been helpful under certain special circumstances and when attachments on several affected items need to get revised.
Jonathan.
- 1668 views
- 4 answers
- 0 votes