Export to CSV - You are not authorised to view this resource

[futuron]

Hi,
Hope you can help. This took me me quite some time to figure out this far.

Fresh install J!373 and F37 (from this site no github since it's just released)

Created a list with just an ID and Date-time and added 4 records.

List settings 'Publishing':
LIST > Publishing > CSV > Frontend export = Special
List settings 'Access':
View list / View records / Edit = SPECIAL
Add records = PUBLIC
Delete records =SPECIAL
Empty records =SPECIAL

When I go to the listview and do 'Export CSV' the little popup in fabrik shows 'CSV export complete - Download here' . But when I click that I get a white screen saying: You are not authorised to view this resource (this is the url, not administrator in it... not sure if that means anything, http://localhost:8888/Joomla_3.7.3-...w=list&format=csv&listid=1&start=100&Itemid=0)

If I change the List Access Settings View list to PUBLIC (instead of SPECIAL) I am able to download the CSV. But of course I don't want the list to be publicly viewable. Besides that, in my live site there are a few hundred records with more elements. It's not giving the CSV but again a white screen with this message:
{"total":"532","count":200,"file":"{fab_conference_registrations-export.csv","limitStart":100,"limitLength":100}

So I also have no idea what's happening here. I'm pretty sure this was working in the previous J! & F versions.

 

[troester]

"not administrator in it."
Are you working in the backend?
Is it the same if logged in frontend?

Edit:
yes, confirmed
If you are exporting in the backend (with your list access settings) you'll get this message.

It's ok if you are working in the frontend or
if any user with list access is logged in in the frontend

 

[futuron]

Yes it's all in the backend where i need this to work. I didn't check how it works in the frontend myself.

 

[cheesegrits]

OK, I just committed a fix. Added a backend controller for list csv download, and the JS now picks the right one to use.

https://github.com/Fabrik/fabrik/commit/601f3eb831c46cb6e1bfdf4adbd51ac83cc63862

-- hugh

 

[futuron]

Yep worked perfectly!
Thnx a lot guys!