At the moment, reporting dashboards with pivottables does not always go the right way. Pivot tables are cut off and therefore not useable. This script exports that specific widget to PDF (pivot tables are then exported in full) and sends this PDF over email to a specific user(s). *These do not have to be Sisense users*
Config Customers
- Edit the settings.yml
- For the use of data security each customer needs its own 'export-user'. Fill in email and pass
- For each report add a line consisting of dashboard id, widget id, orientation, PDF name and email (only 1)
Config get_pdfs_email_them.py
- Change SISENSE_BASE_URL to your own url without trailing '/'
- Change email subject and email body
- Replace sender_email and pass of sender_email
- Replace SMTP and save
Run that .py file and it will export all widgets to pdf and sends them to your recipients.
