prrvchr / oauth2ooo Goto Github PK

Hi prrvchr,

While testing and trying to save to google drive a dialog requests 6 digit pin number. Two step authentication is disabled in Google.

Regards

hi,

I tried to install google drive connection like below but i can not do authorization request, while i enter my google email, it freeze and not authorize. I use mac pro.

In menu Tools - Options - LibreOffice - Advanced - Open Expert Configuration

Search for: UseSystemFileDialog (Found under: org.openoffice.Office.Common > Misc)

Edit or change “true” to “false” (set it to “false”)
Open your Google Drive:

In File - Open - File name enter: vnd.google-apps://your_account/ or vnd.google-apps:///

If you don’t give your_account, you will be asked for…

After authorizing the OAuthOOo application to access your Drive, your Google Drive should open!!! normally ;-)

screenshot

I am trying to perform a email mail merge in libreoffice 7.3.
I have performed the Oauth2 wizard in the extension manager, and that was successful.
I am using gmail.
In the mail merge menu, I am able to set up the merge, it prepares to send the emails, but never actually sends them. I'm not sure how to debug this.

Not sure what other information you would like but it is libre office 7.3. Installed jave jre, this, and the gContactOOo.

Error 400: invalid_request
The loopback flow has been blocked in order to keep users secure. Follow the Loopback IP Address flow migration guide linked in the developer docs below to migrate your app to an alternative method.
Related developer documentation

This is a minor inconvenience, but I thought I'd report it:

If pasting a URL into the "URL" field in the OAuth2 settings, the "Add" button is greyed out.
One has to first fill in the "Provider" and "Scopes" fields, before being able to click "Add". And once you click "Add", it empties the "Provider" and "Scopes" fields, so you have to fill them in once again before being able to click "Next".

This is on:

• Windows 10
• LibreOffice 7.2.1.1

If there is a better place for this, please say so. I'm a professional programmer but just starting in on LibreOffice. I'm trying to figure out how to use OAuth2OOo but can't find much in the way of examples.

	dim oauth2 as object
	oauth2 = CreateUnoService("io.github.prrvchr.OAuth2OOo.OAuth2Service")

gives

BASIC runtime error.
An exception occurred 
Type: com.sun.star.uno.RuntimeException
Message: <class 'RuntimeError'>: Requests dependency 'urllib3' must be version >= 1.21.1, < 1.22!, traceback follows
  File "C:\Users\bugma\scoop\apps\libreoffice\current\LibreOffice\program\pythonloader.py", line 134, in activate
    mod = self.getModuleFromUrl( locationUrl )
  File "C:\Users\bugma\scoop\apps\libreoffice\current\LibreOffice\program\pythonloader.py", line 102, in getModuleFromUrl
    exec(codeobject, mod.__dict__)
  File "C:\Users\bugma\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu115447545e4.tmp_\OAuth2OOo.oxt\service\OAuth2Service.py", line 57, in <module>
    from oauth2 import KeyMap
  File "C:\Users\bugma\scoop\apps\libreoffice\current\LibreOffice\program\uno.py", line 346, in _uno_import
    return _builtin_import(name, *optargs, **kwargs)
  File "C:\Users\bugma\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu115447545e4.tmp_\OAuth2OOo.oxt\service\pythonpath\oauth2\__init__.py", line 30, in <module>
    from .options import OptionsManager
  File "C:\Users\bugma\scoop\apps\libreoffice\current\LibreOffice\program\uno.py", line 346, in _uno_import
    return _builtin_import(name, *optargs, **kwargs)
  File "C:\Users\bugma\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu115447545e4.tmp_\OAuth2OOo.oxt\service\pythonpath\oauth2\options\__init__.py", line 30, in <module>
    from .optionsmanager import OptionsManager
  File "C:\Users\bugma\scoop\apps\libreoffice\current\LibreOffice\program\uno.py", line 346, in _uno_import
    return _builtin_import(name, *optargs, **kwargs)
  File "C:\Users\bugma\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu115447545e4.tmp_\OAuth2OOo.oxt\service\pythonpath\oauth2\options\optionsmanager.py", line 39, in <module>
    from ..oauth2model import OAuth2Model
  File "C:\Users\bugma\scoop\apps\libreoffice\current\LibreOffice\program\uno.py", line 346, in _uno_import
    return _builtin_import(name, *optargs, **kwargs)
  File "C:\Users\bugma\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu115447545e4.tmp_\OAuth2OOo.oxt\service\pythonpath\oauth2\oauth2model.py", line 53, in <module>
    from .wizard import WatchDog
  File "C:\Users\bugma\scoop\apps\libreoffice\current\LibreOffice\program\uno.py", line 346, in _uno_import
    return _builtin_import(name, *optargs, **kwargs)
  File "C:\Users\bugma\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu115447545e4.tmp_\OAuth2OOo.oxt\service\pythonpath\oauth2\wizard\__init__.py", line 32, in <module>
    from .httpserver import Server
  File "C:\Users\bugma\scoop\apps\libreoffice\current\LibreOffice\program\uno.py", line 346, in _uno_import
    return _builtin_import(name, *optargs, **kwargs)
  File "C:\Users\bugma\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu115447545e4.tmp_\OAuth2OOo.oxt\service\pythonpath\oauth2\wizard\httpserver.py", line 40, in <module>
    from requests.compat import unquote_plus
  File "C:\Users\bugma\scoop\apps\libreoffice\current\LibreOffice\program\uno.py", line 346, in _uno_import
    return _builtin_import(name, *optargs, **kwargs)
  File "C:\Users\bugma\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu115447545ec.tmp_\gMailOOo.oxt\pythonpath\requests\__init__.py", line 57, in <module>
    raise RuntimeError('Requests dependency \'urllib3\' must be version >= 1.21.1, < 1.22!')

.

If occurs to me that urllib is an issue, viz

Package    Version
---------- -------
pip        23.2.1
setuptools 68.1.2
urllib3    2.0.4
wheel      0.41.2

Everything is working fine untill we have to auth, it redirect propperly to the default browser and then this happens (att.)

Hi,

I followed your instructions and got the following message after the last step.

Sign in with Google temporarily disabled for this app

This app has not been verified yet by Google in order to use Google Sign In.

Any ideas what to do?

Hi there!

I am not sure if it is my lack of understanding or a lack of documentation, but: once the OAuth2 has been successfully established, how does one make Mail Merge in LibreOffice use that authentication to send emails with that email account?

I am using the following at the moment:

Version: 7.2.1.1 (x64) / LibreOffice Community
Build ID: 3cfc32d9754d2d239bd8ce2941029c12873010c1
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded

with OAuth2OOo version 0.0.5

Hello!
When i try to get access from libreoffice 6.3 to gdrive i get following errors:

1. When sending request to google for OAuth2OOo app allowance, the browser returns error [Missing required parameter 'scope']. If i add the scope string manually in the module's settings it replaces nonalphabetic symbols to hex codes.
2. The module does not add the 'scope' part authomatically despite correct appropriate setting.
3. Finally i've replaced needed symbols manually in the URL and managed to register OAuth module in my google account, but no success opening the gdrive, the gdriveOOo plugin reports with 'nonexistent object' and 'nonexistant file' messageboxes

Hi. I tryied to install the extension on the Libreoffice V. 6.0.7.3, but it doesn't work. Durign installation I receive an error message, even if the extension seems to be installed. Then I try to activate the extension and i get a lot of error. Every error attached. Could you please help me? Thanks kind rgds

1. How make this POST HTTP request with OAuth2OOo (LibreOffice BASIC):
   POST / HTTP/1.1
   Host : http://foo.com/
   Content-Type : application/x-www-form-urlencoded
   Content-Length : 13

say=Hi&to=Mom

2. Please give an example of filling a Object Parameters - how fill Data(integer(0 to -1)) ?

3. Where we can see the description of methods and properties of Object OAuth2OOo ?

Hi,

I have an issue with installing the OAuth2OOo for LibreOffice(24.2.0.3 (X86_64, Flatpak)).
The issue is the following error when trying to install the extension:

I have run the: pip install -r requirements.txt
Python version: 3.10.12

Platform info:
Distributor ID: Pop
Description: Pop!_OS 22.04 LTS
Release: 22.04
Codename: jammy

I have tried to install the lxml packaged for Python, but it yielded nothing - the same error.

Let me know if any further details are required.

Hello,
lorsque j'essaie d'installer l'extension sous LibreOffice 7.4.6.2 windows 11 j'ai ce message d'erreur
(com.sun.star.uno.RuntimeException) { { Message = "<class 'ImportError'>: No module named 'ply' (or 'ply.lex.LexToken' is unknown), traceback follows\X000a File "C:\Program Files\LibreOffice\program\pythonloader.py", line 147, in writeRegistryInfo\X000a mod = self.getModuleFromUrl( locationUrl )\X000a File "C:\Program Files\LibreOffice\program\pythonloader.py", line 102, in getModuleFromUrl\X000a exec(codeobject, mod.dict)\X000a File "C:\Users\lcm\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu18712fwp3i.tmp\OAuth2OOo.oxt\service\OAuth2Service.py", line 57, in \X000a from oauth2 import getAccessToken\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\lcm\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu18712fwp3i.tmp\OAuth2OOo.oxt\service\pythonpath\oauth2\init.py", line 65, in \X000a from .plugin import extract2Json\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\lcm\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu18712fwp3i.tmp\OAuth2OOo.oxt\service\pythonpath\oauth2\plugin.py", line 31, in \X000a import js2xml\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\lcm\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu18712fwp3i.tmp\OAuth2OOo.oxt\service\pythonpath\js2xml\init.py", line 1, in \X000a from calmjs.parse.parsers.es5 import Parser\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\lcm\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu18712fwp3i.tmp\OAuth2OOo.oxt\service\pythonpath\calmjs\parse\init.py", line 6, in \X000a from calmjs.parse.factory import ParserUnparserFactory\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\lcm\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu18712fwp3i.tmp\OAuth2OOo.oxt\service\pythonpath\calmjs\parse\factory.py", line 9, in \X000a from calmjs.parse import asttypes\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a File "C:\Users\lcm\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu18712fwp3i.tmp\OAuth2OOo.oxt\service\pythonpath\calmjs\parse\asttypes.py", line 30, in \X000a from ply.lex import LexToken\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 425, in _uno_import\X000a raise uno_import_exc\X000a File "C:\Program Files\LibreOffice\program\uno.py", line 346, in _uno_import\X000a return builtin_import(name, *optargs, **kwargs)\X000a\X000a", Context = (com.sun.star.uno.XInterface) @0 } }

Ami calmant, J.P