In the data explorer ‘Allow groups to access this query’ is set to: moderators, admins, staff
In the Automation record ‘Attach the CSV file to the PM’ is ticked. The script is ‘Schedule a PM with Data explorer results’.
The recipients are an admin and a moderator - same result for both.
I’ve tried it with a couple of data explorer queries, ‘Inactive Users with no posts’ for instance. (The csv is available to download on the Data explorer page.)
The Discourse version installed is 3.4.0.beta3-dev (d7503a6153), the Data Explorer plugin is up to date (f2891947).
Automation setting for the ‘Inactive Users with no posts’ PM:
After adding the csv extension and retriggering a PM the csv link in the subsequent PM worked.
A couple of suggestions:
On the automation pages, add some text and a link after the tickbox ‘Attach the CSV file to the PM’. Something like: (Requires authorization of csv extension). Linking ‘authorization of csv extension’ to /admin/site_settings/category/all_results?filter=authorized%20extensions%20for%20staff
To help diagnose what the issue is in future instances, if possible, change the link in the PM when csv isn’t an authorized extension, from:
href=“/404”
to something like:
href=“/unauthorized”
I can’t do all your recommendations but from now when you save an automation using this script and attach_csv is checked, it will generate an error if csv is not in the list of authorized_extensions:
