jcorbeill's Profile
Agile User
21
Points

Questions
0

Answers
4

  • Agile User Asked on October 20, 2017 in Agile PLM (v9).

    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_root00′ || 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
  • Agile User Asked on September 29, 2017 in Others.

    If you are using iis proxy:

    Open IIS
    Select Default Web Site in the Connections pane, open the Request Filtering in the IIS section.
    Click Edit Feature Settings in the Actions pane and adjust the Maximum allowed content length (Bytes) and Maximum query string (Bytes).

    • 2104 views
    • 4 answers
    • 0 votes
  • Agile User Asked on May 1, 2017 in Agile PLM (v9).

    The correct syntax is:
    Net use Y: http://agileXXX.XXX.com:7060/webdav /USER:USERID PASSWORD

    • 1668 views
    • 4 answers
    • 0 votes
  • Agile User Asked on May 1, 2017 in Agile PLM (v9).

    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