1 Reply Latest reply on Nov 7, 2017 6:22 AM by Toby Erkson Branched from an earlier discussion.

    Multiple Sites based off one data source file



      sorry to bring this old topic back to the Top but I have another question to this.


      As Vizalert is now sending mails to me from the site where the ScheduledTriggerViews is uploaded to, I now want to have automated reports from my other sites.


      The Idea I have now is to create one excel file with all fields I need to fill in


      in this excel file you find Email Action, Email from, Email to, Subject and so on


      Now I have 3 Sites


      SiteName 1 Vizalert (There I uploaded the complete configuration and workbooks from vizalerts)

      Sitename 2 Manager

      Sitename 3 Sales


      the Idea now is to upload 1 workbook to site Vizalerts refering to the excel file as Datasource and then send out the reports for the other two sites

        • 1. Re: Multiple Sites based off one data source file
          Toby Erkson

          Jens ,

          I branched this as its own question because it's very different.


          The location of the ScheduledTriggerViews doesn't matter as it's only a configuration file when a VA (VizAlert) is triggered.  I have mine in an admin Site but my other Sites still run VAs.  You only need one ScheduledTriggerViews so don't worry about which Site contains it because that doesn't matter.  Remember, VA pretty much works like the standard subscriptions; the Schedules are shared across all Sites.


          As to your particular request, using an Excel file to divvy out reports to various Sites, I don't think your idea will work.  You'll need that Excel data source in each Site.  One good thing is that you can have the single Excel data source on a network drive and publish it as a data source to each Site, thus one file feeding multiple Sites.  For the reports on each site, I'm guessing you'd create a simple calculated field that you use as a filter to exclude data entries in the Excel file that are not relevant to the Site in which the report is running within.