[Frappe App] Google Calendar Integration

Frappe Framework App Development
8

Hello Team,

Please consider link for Google Calendar App.

Note
Currently application not supporting for recurring event syncing.

4 Likes
9

Good work.

Thanks.

1 Like
10

@rmehta Can you add this functionality in the core product? I was wondering there may be many developers who have no problem sharing their code and getting credited for it.

Also, I think these products should be tested by erpnext team before they are deployed for use by erpnext users.

Google Calendar integration is a very good thing if it’s safe!

3 Likes
11

+1 to this

It would be a great addon to the core product and allow us paying users access to some much needed features.

Brent Glover
RespInnovation

1 Like
12

+1 from me as well :+1:
Definitely would appreciate calendar integration, either Google Calendar or CalDAV!

13

+1 from me as well regarding the Google Calendar integration!

14

I would also love seeing this to be tested by Frappe and implemented as an easy to install App @rushabh_mehta

15

@saurabh6790 already working on this.

2 Likes
16

I am getting error while install GCAL app. Could you please help?
Raised issue here

Need it urgently :cry: Please help.

17

try bench migrate

18

Same error. Already tried. Is it possible to get the logs why it might be failing?
I can see the app GCAL Sync in the Frappe Desk but it only half installed. There is no option for setting gmail id and api key.

19

Hi Saurabh,

Thanks for help. At last I was able to make things work.

  1. Upgraded to latest version 6.
  2. Started redis cache server.
  3. Dropped the site using bench drop-site mysite and again created it.
  4. Added the apps from Frappe Desk.

Things are running smooth now. ERPNext and Frappe Bench are really great tools. Thanks again.

20

Hi Saurabh,

I tried your GCAL integration,

What i did was

  1. upgraded to latest version
  2. update the dependency
  3. bench get-app gcal GitHub - indictranstech/GCAL
  4. then install the module through the UI in erpnext.

however when i wanted to setup individual profile and save it using my email address, this error come out

Traceback (innermost last):
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py”, line 69, in application
response = frappe.handler.handle()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py”, line 20, in handle
execute_cmd(cmd)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py”, line 37, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 801, in call
return fn(*args, **newargs)
File “/home/ubuntu/frappe-bench/apps/gcal/gcal/gcal_sync/doctype/sync_configuration/sync_configuration.py”, line 92, in sync_calender
credentials = store.get()
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/oauth2client/client.py”, line 396, in get
return self.locked_get()
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/oauth2client/keyring_storage.py”, line 88, in locked_get
content = keyring.get_password(self._service_name, self._user_name)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/keyring/core.py”, line 42, in get_password
return _keyring_backend.get_password(service_name, username)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/keyring/backends/fail.py”, line 18, in get_password
raise RuntimeError("No recommended backend was available. Install the "
RuntimeError: No recommended backend was available. Install the keyrings.alt package if you want to use the non-recommended backends. See README.rst for details.

it seemed the keyring failed in get password and state no recomended backend was available.

Can you help me with what i am still lacking?

Thanks and apreciated

Anton

21

@tara_antonius

Seems issue with keyring package.

from frappe-bench ./env/bin/pip install keyring

22

i did install the keyring by using ./env/bin/pip install keyring
however the problem persists, it shown that my system dont have compatible keyring backend.

for Information i am installing this to ubuntu 14.04 server and installed all the necessary package that you mentioned.
anything that i miss?

24

Is ERPNext planning on adopting this as an official app? Also, I uninstalled it, and can’t reinstall because it seems like there are entries in my database that halt the re-install process when it’s trying to create new info, I guess?

25

+1 for this integration. Many thanks for the effort.

1 Like
26

It will be much better to modify this app to support exporting to any calendar rather than gmail calendar only.
I don’t know if that is possible or not.

Regards,
Ahmed

1 Like
27

I tried to install and already install dependence like Keyring. However, there is still error: No module named keyring_storage

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 55, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 36, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 879, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/page/applications/applications.py”, line 79, in install_app
frappe.installer.install_app(name)
File “/home/frappe/frappe-bench/apps/frappe/frappe/installer.py”, line 131, in install_app
sync_for(name, force=True, sync_everything=True, verbose=verbose)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/sync.py”, line 43, in sync_for
import_file_by_path(doc_path, force=force)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 54, in import_file_by_path
import_doc(doc, force=force, data_import=data_import, pre_process=pre_process)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 122, in import_doc
doc.insert()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 231, in insert
self.run_post_save_methods()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 728, in run_post_save_methods
self.run_method(“on_update”)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 661, in run_method
return Document.hook(fn)(self, *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 839, in composer
return composed(self, method, *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 822, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 655, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”, line 148, in on_update
self.run_module_method(“on_doctype_update”)
File “/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”, line 157, in run_module_method
module = load_doctype_module(self.name, self.module)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/init.py”, line 64, in load_doctype_module
doctype_python_modules[key] = frappe.get_module(get_module_name(doctype, module, prefix, suffix))
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 643, in get_module
return importlib.import_module(modulename)
File “/usr/lib/python2.7/importlib/init.py”, line 37, in import_module
import(name)
File “/home/frappe/frappe-bench/apps/gcal/gcal/gcal_sync/doctype/sync_configuration/sync_configuration.py”, line 19, in
from oauth2client.keyring_storage import Storage
ImportError: No module named keyring_storage

28

from frappe-bench run ./env/bin/pip install keyring hopefully this will work

@makarand_b can you check this?