0

Download Pyramid Discovers on a schedule to an OS folder

Hello,

Just wanted to check if there is a way we can have the discovers run automatically and land an excel file into an OS folder (Windows or a Samba file share)

Thanks

Mad

8 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 1 mth ago
    • Reported - view

    Hi  ,

    You can subscribe to a discover and create a schedule whereby the output in Excel format is automatically sent to you, but only via the Pyramid Bulletin board, email or a web channel (Slack or Teams), not to an OS folder.

    You can however, use a Discover as a data source for a Model Data Flow and have the scheduled flow output an Excel file written to an OS Folder or other file target (like FTP for example).

    Hope that helps.

    Ian

    • Mad_Amruthur
    • 1 mth ago
    • Reported - view

    Thanks Ian, that is very helpful

    I did know about the subscription options to email and webhooks, but this is an option I will give a try

    I am also exploring an option to email it to our MoveIT downloads which then automatically lands it in a folder and I can then have a MoveIT job move it to another folder

    Are there any options to do this via API or invoking Pyramid via a shell script ?

    Thanks

    Mad

    • Mad_Amruthur
    • 1 mth ago
    • Reported - view

    I setup a model as above, but for some reason the file does not show up in the destination

    The progress window shows that it succeeded

    I do have rights to the folder

    Is there anything else I need to setup on the Pyramid side 

    Thanks

    Mad

    • Senior Director of Product
    • Ian_Macdonald
    • 1 mth ago
    • Reported - view

    Hi 

    It is the Pyramid Server that needs rights to the folder, as well as you, the user.

    Hope that helps.

    Ian

    • Mad_Amruthur
    • 1 mth ago
    • Reported - view

    Thanks Ian

    I have access to that folder

    When you say Pyramid server, would that be the padmin user ?

    Thanks

    Mad

    • Senior Director of Product
    • Ian_Macdonald
    • 1 mth ago
    • Reported - view

    Hi 

    No, the identity that the Pyramid Server is running under. If you're running it on a Windows server, it will likely be the machine name on the network. From our Help:

    "The machine hosting Pyramid must have access to the shared file location. If the Pyramid services are running on different machines, the Runtime and Task Servers must be given access to the shared file location."

    Hope that helps.

    Ian

      • Mad_Amruthur
      • 1 mth ago
      • Reported - view

      Thanks  

      We are running Pyramid on a Linux server

      Let me check the help documentation as well

      Thanks

      Mad

    • Mad_Amruthur
    • 1 mth ago
    • Reported - view

    Hello,

    Just FYI

    We basically took the windows share and mounted it as a Samba file share on the Pyramid Linux server and it worked well

    Thanks

    Mad

Login to reply

Content aside

  • Status Answered
  • 1 mth agoLast active
  • 8Replies
  • 77Views
  • 2 Following