FR: Open Files with...

[FlyingMike1979]

Could a general option be set so that files like documents, images, and PDFs are always opened by default with Office or a PDF editor instead of being downloaded?

Currently, each user has to manually select "Open with" and check the box for the default application for every type of file (docx, xlsx, pdf, jpg, etc.).

It would be great if this could be set globally as the default instead of downloading.

[michalcharvat]

You can prepare the PR for this :-) At the moment the fastest workaround is just insert/update values to the fs_filehandlers table

[FlyingMike1979]

Thanks for the quick reply. To make it apply to all users, do I simply enter 0 for User ID?

[michalcharvat]

nope you have to generate regular records for all users. Something like this. Of corse you have to use handlers hased on the wopi configuration - in this case its

  INSERT INTO `fs_filehandlers` (`user_id`, `extension`, `cls`)
  SELECT u.`id`, h.`extension`, h.`cls`
  FROM `core_user` u
  CROSS JOIN (
      SELECT 'csv'  AS `extension`, 'go\\modules\\business\\wopi\\filehandler\\Collabora' AS `cls`
      UNION ALL SELECT 'doc',  'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'docx', 'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'dot',  'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'ods',  'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'odt',  'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'ppt',  'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'pptx', 'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'rtf',  'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'xls',  'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'xlsm', 'go\\modules\\business\\wopi\\filehandler\\Collabora'
      UNION ALL SELECT 'xlsx', 'go\\modules\\business\\wopi\\filehandler\\Collabora'
  ) h
  WHERE u.`enabled` = 1
  ON DUPLICATE KEY UPDATE `cls` = VALUES(`cls`);```

[FlyingMike1979]

I was too hasty and ran a test.

I created an entry for each file extension (xlsx, docx, pdf, etc.) and entered "0" for the user ID. For CLS, I entered "go\modules\community\wopi\filehandler\Collabora".

It now works for all users. I'll monitor and test it for a while.

[FlyingMike1979]

I've now run a test with a newly created user. It works perfectly, and even if a different default is selected for a user, it's still saved in the fs_filehandler table. Attached is a screenshot of the entries I manually created for the file extensions. Perhaps this could be integrated into the settings somewhere.

[michalcharvat]

I would say you didnt find a workaround but you probably catch nice edge case where the first handler is taken if there is no record for the user. By default file handler loading record by primary key - user_id + extension. If its not there it just choose the first available file handler. I would be surprised if it will work with the 0 in the database.

[FlyingMike1979]

Yes, that's exactly what I wanted, and thank you very much because your keyword "fs_filehandler" table helped me at least to that extent. If the user hasn't yet selected what should happen to the file when they open it, it should be opened in Office by default, not downloaded.

I've already experimented with several users and defined how files are opened and/or downloaded, setting it individually with different extensions as the default for each user. This was also correctly entered in the table for the user with the correct ID. It works with 0 as the user ID... theoretically, as an administrator, I could also set it as the default with user ID 1, but I know that this wouldn't apply to everyone else if they haven't set a default. Apparently, it works with user ID 0, though. I can't explain why.

Whether this was a coincidence with the test or not... it works very well for me so far.

It would still be interesting to know if it would be possible to implement an administrative setting so that certain file types are opened with modules like Office, PDF Editor, etc., instead of as downloads, by default if a user hasn't already set a default. This would be possible, and each user would still have the option to choose which file types are opened and how, and set this as the default, which would then be recorded in the table.

If this is desired or of interest in the future, please feel free to open a pull request. Sorry, my English isn't very good. I hope you understand.

[michalcharvat]

Actually I have similar problem and you solution isnt real solution because you have to modify the intalled handlers to obtain what you want. @mschering there should be at least $fh = FileHandler::model()->findByPk(['extension'=>$ex, 'user_id'=>0]); as a workaround if the users handler wouldnt be defined. I dont like that solution but it is at least workaround how to solve this issue.

[FlyingMike1979]

I know it's not a solution for everyone. It's a short-term solution for me, but it would still be interesting to integrate it into the administration.