Help: how to send a report via mail attachment?

Get Help
1

Hello everyone,

I just use Metabase v0.43.3 and want send some reports via mail attachment. but when I seted up an alert I just get an email with a link.

so if I can get the report via mail attachment?

thanks a lot

2

Hi @ljqPro
The Alert will automatically include an attachment if there's more results than what can be displayed.
You can use Subscriptions to do a more customized setup:
https://www.metabase.com/docs/latest/users-guide/dashboard-subscriptions.html

3

thanks a lot !
and I subscription I see 8:00 AM CT ,what it's means? and my report timezone is Asia/Shanghai

my database is SQL Server

4

@ljqPro If your report time is Shanghai, then you should get the emails there, otherwise Metabase uses the instance timezone.

5

@flamber thanks a lot! when I updated JRE i get everything ok except the attachment format.

i select xlsx then i get the csv still.

6

@ljqPro Post "Diagnostic Info" from Admin > Troubleshooting.
I cannot reproduce. Check the cards property from the URL /api/pulse?dashboard_id=123, where 123 is your dashboard ID. Each card should have include_xls: true

7

{"archived":false,"collection_position":null,"creator":{"email":"admin@xxxl.com","first_name":"BI","last_login":"2022-06-22T01:09:29.355","is_qbnewb":false,"is_superuser":true,"id":1,"last_name":"xxx","date_joined":"2022-06-17T08:22:48.803","common_name":"xxx"},"can_write":true,"channels":[{"schedule_type":"daily","schedule_hour":8,"channel_type":"email","schedule_frame":null,"recipients":[{"email":"hi@xxx.com"},{"id":1,"email":"admin@xxxl.com","first_name":"BI","last_name":"xxx","common_name":"BI xxx"},{"id":2,"email":"ldmin@xxxl.com","first_name":"xx","last_name":"xx","common_name":"xxx"}],"updated_at":"2022-06-22T10:28:30.162","pulse_id":9,"id":9,"schedule_day":null,"enabled":true,"created_at":"2022-06-22T09:11:15.053"}],"collection_id":33,"name":"每日生产订单工时分析仪表盘","creator_id":1,"updated_at":"2022-06-22T10:28:30.162","id":9,"cards":[{"description":null,"include_xls":false,"dashboard_card_id":1,"collection_id":33,"name":"每日生产订单工时分析","id":2,"parameter_mappings":null,"include_csv":false,"display":"table","dashboard_id":3}],"skip_if_empty":false,"parameters":[],"dashboard_id":3,"created_at":"2022-06-22T09:11:15.053"},{"archived":false,"collection_position":null,"creator":{"email":"adminxxx.com","first_name":"BI","last_login":"2022-06-22T01:09:29.355","is_qbnewb":false,"is_superuser":true,"id":1,"last_name":"xxx","date_joined":"2022-06-17T08:22:48.803","common_name":"BI xxx"},"can_write":true,"channels":[{"schedule_type":"hourly","schedule_hour":null,"channel_type":"email","schedule_frame":null,"recipients":[{"email":"hi@xxx.com"}],"updated_at":"2022-06-22T21:02:22.985","pulse_id":10,"id":10,"schedule_day":null,"enabled":true,"created_at":"2022-06-22T21:02:22.985"}],"collection_id":33,"name":"每日生产订单工时分析仪表盘","creator_id":1,"updated_at":"2022-06-22T21:02:22.985","id":10,"cards":[{"description":null,"include_xls":false,"dashboard_card_id":1,"collection_id":33,"name":"每日生产订单工时分析","id":2,"parameter_mappings":null,"include_csv":false,"display":"table","dashboard_id":3}],"skip_if_empty":false,"parameters":[],"dashboard_id":3,"created_at":"2022-06-22T21:02:22.985"}]

8

@ljqPro It clearly shows that you have not enabled XLSX (or CSV) attachments for that subscription.
Make sure you click the "Attach results" and select XLSX:
https://www.metabase.com/docs/latest/users-guide/dashboard-subscriptions.html

9

@flamber thank you very much