Forum Discussion

Clarke_Hair's avatar
Clarke_Hair
Contributor
2 years ago

Data Mgt job that runs a Dashboard or Book and saves output to Application File storage

We have created a book that when run outputs an Excel file that is 67 tabs.  It can take 20+ minutes to run on our desktop Clients and many times will time out if we are at home vs. in the office.  A...
Data Management
  • ckattookaran's avatar
    ckattookaran
    2 years ago

    I've done it using Dashboard, extender rules, parcel service, and task scheduler. Yes, it is possible.

  • db_pdx's avatar
    db_pdx
    2 years ago

    Do the reports use parameters?  If so, you'll likely need to specify them in the last lines of the Export File definition.  

Clarke_Hair's avatar
Clarke_Hair
Contributor

Thanks for pointing me to the Doc's  What it said do, is what I had been doing but nothing was getting created and was running way too fast.  Can you look at the below and let me know if you see anything that looks wrong.

When I run it, it takes about 10 seconds to finish and i can't find any file so assume something is wrong on the setup.

 

db_pdx's avatar
db_pdx
Valued Contributor
2 years ago

Check under: File Share > Applications > YourApplicationName > DataManagement > Export > YourUserName

That is where I found mine.

  • Clarke_Hair's avatar
    Clarke_Hair
    Contributor
    2 years ago

    Thanks, found the files, now just have to get them to have data :).  Will get there at some point.  Going to try ckattookaran's process as well.

    • db_pdx's avatar
      db_pdx
      Valued Contributor
      2 years ago

      Do the reports use parameters?  If so, you'll likely need to specify them in the last lines of the Export File definition.  

    • DavidW's avatar
      DavidW
      New Contributor II
      2 years ago

      Clarke, from the last screenshot, it looks like the source file type and path could be the problem.