search

muk-it / muk_dms

MuK Document Management System
GNU Lesser General Public License v3.0
91 stars 143 forks source link

MUK MSOffice Preview Error #87

Closed asolano88 closed 5 years ago

asolano88 commented 5 years ago

When previewing MS Office (Word, PPT or Excel)

It will give an error on the Preview:

" An error occured We're sorry, but for some reason we can't open this for you."

keshrath commented 5 years ago

Is muk_web_utils up to date? https://github.com/muk-it/muk_web/commit/6ab318c0d216f37bd6579e2ca0657c3edac9a48e

asolano88 commented 5 years ago

Hi Mathias,

Yes, muk_web_utils is version 12.0.2.9.4

From: Mathias Marklmailto:notifications@github.com Sent: Tuesday, May 21, 2019 2:04 PM To: muk-it/muk_dmsmailto:muk_dms@noreply.github.com Cc: asolano88mailto:asolano88@hotmail.com; Authormailto:author@noreply.github.com Subject: Re: [muk-it/muk_dms] MUK MSOffice Preview Error (#87)

Is muk_web_utils up to date? muk-it/muk_web@6ab318chttps://github.com/muk-it/muk_web/commit/6ab318c0d216f37bd6579e2ca0657c3edac9a48e

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/muk-it/muk_dms/issues/87?email_source=notifications&email_token=ALOYR5ILPMXHDDPLA52EFR3PWOGILA5CNFSM4HOHN2SKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODV23BFA#issuecomment-494252180, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ALOYR5LDS6I26GJSNVSZCLDPWOGILANCNFSM4HOHN2SA.

keshrath commented 5 years ago

Since you open the ticket in the dms repo i guess you are trying to preview a dms file. To preview a office file the system creates a temporary attachment. Can you check if the mimetype of this attachment is correctly set.

asolano88 commented 5 years ago

Hi Mathias,

Here is the file info for your reference.

Name: product.template (9).xls Mimetype: application/vnd.ms-excel Size: 760.83 KB Last Updated on: 2019-04-23 03:36:53 Last Updated by: Administrator

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Mathias Markl notifications@github.com Sent: Tuesday, May 21, 2019 2:12:56 PM To: muk-it/muk_dms Cc: asolano88; Author Subject: Re: [muk-it/muk_dms] MUK MSOffice Preview Error (#87)

Since you open the ticket in the dms repo i guess you are trying to preview a dms file. To preview a office file the system creates a temporary attachment. Can you check if the mimetype of this attachment is correctly set.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/muk-it/muk_dms/issues/87?email_source=notifications&email_token=ALOYR5LZCFXNRM3G3I5N6K3PWOHGRA5CNFSM4HOHN2SKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODV23OXY#issuecomment-494253919, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ALOYR5KVI53E24GL4JVVNTDPWOHGRANCNFSM4HOHN2SA.

keshrath commented 5 years ago

This is the dms file or the attachment?

asolano88 commented 5 years ago

DMS File.

It automatically creates the same Name as the attachment.

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Mathias Markl notifications@github.com Sent: Tuesday, May 21, 2019 2:41:29 PM To: muk-it/muk_dms Cc: asolano88; Author Subject: Re: [muk-it/muk_dms] MUK MSOffice Preview Error (#87)

This is the dms file or the attachment?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/muk-it/muk_dms/issues/87?email_source=notifications&email_token=ALOYR5OIRIUJGJD6B6CCWELPWOKRTA5CNFSM4HOHN2SKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODV25DAI#issuecomment-494260609, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ALOYR5N3ODRPJN2SGFT62D3PWOKRTANCNFSM4HOHN2SA.

keshrath commented 5 years ago

And this attachment has the right mimetype?

keshrath commented 5 years ago

Just to make sure: You are trying to do that on a server right? not local with localhost? localhost wont work since the MS Office Viewer needs to be able to download the file, so it has to be available on the web.

asolano88 commented 5 years ago

Yes

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Mathias Markl notifications@github.com Sent: Tuesday, May 21, 2019 3:34:21 PM To: muk-it/muk_dms Cc: asolano88; Author Subject: Re: [muk-it/muk_dms] MUK MSOffice Preview Error (#87)

And this attachment has the right mimetype?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/muk-it/muk_dms/issues/87?email_source=notifications&email_token=ALOYR5JZ437IGHIHZSVJDOTPWOQX3A5CNFSM4HOHN2SKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODV3AURY#issuecomment-494275143, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ALOYR5OG6H2FNVYJZ2QOZDTPWOQX3ANCNFSM4HOHN2SA.

keshrath commented 5 years ago

I was able to reproduce it. Its a problem for non admin users. Admin seem to work fine.

I will close this ticket since its not a dms bug and reopen this one: https://github.com/muk-it/muk_web/issues/85

asolano88 commented 5 years ago

Hi Mathias,

The environment is that we have a local Server (on premise and with Odoo Community Edition v12). So is this the issue?

From: Mathias Markl notifications@github.com Sent: Tuesday, May 21, 2019 3:35:53 PM To: muk-it/muk_dms Cc: asolano88; Author Subject: Re: [muk-it/muk_dms] MUK MSOffice Preview Error (#87)

Just to make sure: You are trying to do that on a server right? not local with localhost? localhost wont work since the MS Office Viewer needs to be able to download the file, so it has to be available on the web.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/muk-it/muk_dms/issues/87?email_source=notifications&email_token=ALOYR5JWVQTFWURVVNWFJVDPWOQ5TA5CNFSM4HOHN2SKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODV3AYCY#issuecomment-494275595, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ALOYR5OMP36UY6OM4Q54JATPWOQ5TANCNFSM4HOHN2SA.

keshrath commented 5 years ago

On premise doesn't necessarily mean it's a problem. But the attachments have to be reachable via http/s. So if the server is completely in the VPN without access to the Internet, then it will not work.

asolano88 commented 5 years ago

Hi Mathias,

I understand.

At this time, our setup is without access to internet.

From: Mathias Markl notifications@github.com Sent: Tuesday, May 21, 2019 3:51:02 PM To: muk-it/muk_dms Cc: asolano88; Author Subject: Re: [muk-it/muk_dms] MUK MSOffice Preview Error (#87)

On premise doesn't necessarily mean it's a problem. But the attachments have to be reachable via http/s. So if the server is completely in the VPN without access to the Internet, then it will not work.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/muk-it/muk_dms/issues/87?email_source=notifications&email_token=ALOYR5ND4MSEX5SXI5HPQH3PWOSWNA5CNFSM4HOHN2SKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODV3B7UI#issuecomment-494280657, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ALOYR5PNXIHWFQ66VPMMRPDPWOSWNANCNFSM4HOHN2SA.

asolano88 commented 5 years ago

Hi Mathias,

May I check with you if you did have a chance to look at this issue?

Thanks and best regards, Allen

DMS ver 12- using Filter for the Field Tags #89 Open asolano88https://github.com/asolano88 opened this issue 16 days ago · 0 comments Open DMS ver 12- using Filter for the Field Tagshttps://github.com/muk-it/muk_dms/issues/89 #89 asolano88https://github.com/asolano88 opened this issue 16 days ago · 0 comments Comments Assignees No one assigned Labels 12.0https://github.com/muk-it/muk_dms/labels/12.0 Projects None yet Milestone No milestone Notifications Unsubscribe

You’re receiving notifications because you authored the thread. 2 participants [@asolano88]https://github.com/asolano88[@keshrath]https://github.com/keshrath [@asolano88]https://github.com/asolano88

asolano88https://github.com/asolano88 commented 16 days agohttps://github.com/muk-it/muk_dms/issues/89#issue-450287763

At the Files Menu: Select Filters Add Custom Filter Select Field Tags condition (contains, not equal to , etc) = "value"

Error: Odoo Server Error

Traceback (most recent call last): File "/opt/odoo12/odoo/odoo/http.py", line 654, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/opt/odoo12/odoo/odoo/http.py", line 312, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/opt/odoo12/odoo/odoo/tools/pycompat.py", line 87, in reraise raise value File "/opt/odoo12/odoo/odoo/http.py", line 696, in dispatch result = self._call_function(self.params) File "/opt/odoo12/odoo/odoo/http.py", line 344, in _call_function return checked_call(self.db, *args, *kwargs) File "/opt/odoo12/odoo/odoo/service/model.py", line 97, in wrapper return f(dbname, args, kwargs) File "/opt/odoo12/odoo/odoo/http.py", line 337, in checked_call result = self.endpoint(*a, kw) File "/opt/odoo12/odoo/odoo/http.py", line 939, in call return self.method(*args, *kw) File "/opt/odoo12/odoo/odoo/http.py", line 517, in response_wrap response = f(args, kw) File "/opt/odoo12/odoo/addons/web/controllers/main.py", line 962, in call_kw return self._call_kw(model, method, args, kwargs) File "/opt/odoo12/odoo/addons/web/controllers/main.py", line 954, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/odoo12/odoo/odoo/api.py", line 745, in call_kw return _call_kw_model(method, model, args, kwargs) File "/opt/odoo12/odoo/odoo/api.py", line 718, in _call_kw_model result = method(recs, *args, kwargs) File "/opt/odoo12/odoo-custom-addons/muk_dms/models/file.py", line 301, in search_panel_select_multi_range return super(File, self).search_panel_select_multi_range(field_name, kwargs) File "/opt/odoo12/odoo-custom-addons/muk_web_searchpanel/models/base.py", line 132, in search_panel_select_multi_range groups = self.read_group(model_domain, [field_name], [field_name]) File "/opt/odoo12/odoo/odoo/models.py", line 2070, in read_group result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy) File "/opt/odoo12/odoo/odoo/models.py", line 2093, in _read_group_raw query = self._where_calc(domain) File "/opt/odoo12/odoo/odoo/models.py", line 3879, in _where_calc e = expression.expression(domain, self) File "/opt/odoo12/odoo/odoo/osv/expression.py", line 672, in init self.parse() File "/opt/odoo12/odoo/odoo/osv/expression.py", line 1023, in parse ids2 = [x[0] for x in comodel.name_search(right, domain or [], op2, limit=None)] File "/opt/odoo12/odoo/odoo/models.py", line 1643, in name_search return self._name_search(name, args, operator, limit=limit) File "/opt/odoo12/odoo/odoo/models.py", line 1656, in _name_search ids = self._search(args, limit=limit, access_rights_uid=access_rights_uid) File "/opt/odoo12/odoo/odoo/models.py", line 4083, in _search if expression.is_false(self, args): File "/opt/odoo12/odoo/odoo/osv/expression.py", line 225, in is_false elif token[1] == 'in' and not token[2]: IndexError: string index out of range

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10