SharePoint Integration

mel_erp · August 13, 2019, 6:01pm

Hi all,
I’m starting a new project to integrate SharePoint into ERPNext. I’ve seen a couple of post on this forum about this, but no one seems to have continued the project…
Is anyone has started to do something about it? Do you have any clues on what I should do to make it work?
Honestly, I’m a little bit lost in all the documentation on SharePoint and I’m not sure where to begin

The first step would be to be able to attach the file into SharePoint instead of ERPNext.
The UI would stay the same, but when we click on ‘attach’, it will save into a specific path* instead of ERP.
*path : if it’s an attachment in a project, I want the path in SharePoint to match. ie: I attach something inside project PR-0999 with Client: SomeClient. Then I want to save the attachment in SharePoint at : /root/SomeClient/PR-0999/file1

Any help/guidance will be appreciated!

rmeyer · August 13, 2019, 10:41pm

Check out this app that uploads attachments to S3:

github.com

bailabs/Frappe-attachments-s3/blob/73a4161e8f14152a6864a44bfdb21a3c3867d297/frappe_s3_attachment/hooks.py#L90-L94


      
          doc_events = {
              "File": {
                  "after_insert": "frappe_s3_attachment.controller.file_upload_to_s3",
              },
          }

github.com

bailabs/Frappe-attachments-s3/blob/73a4161e8f14152a6864a44bfdb21a3c3867d297/frappe_s3_attachment/controller.py#L82-L103


      
          def file_upload_to_s3(doc, method):
              """
              check and upload files to s3. the path check and
              """
              s3_upload = s3Upload()
              path = doc.file_url
              site_path = frappe.utils.get_site_path()
              if not doc.is_private:
                  file_path = site_path + '/public' + path
              else:
                  file_path = site_path + path
              key, status = s3_upload.upload_files_to_s3_with_key(
                  file_path, doc.file_name)
              if status:
                  file_url = "/api/method/frappe_s3_attachment.controller.generate_file?key=%s" % key
                  os.remove(file_path)
                  doc = frappe.db.sql("""UPDATE `tabFile` SET file_url=%s, folder=%s,
                      old_parent=%s, content_hash=%s WHERE name=%s""", (
                      file_url, 'Home/Attachments', 'Home/Attachments', None, doc.name))
                  frappe.db.commit()

This file has been truncated. show original

JayRam · August 14, 2019, 5:19am

I think a client of mine may be interested in this integration. Let me find out if he’s willing to put money on the table to achieve this integration. If he does, I’m happy to build it so that it works for you too. Else, we can collaborate, bootstrap and still build it.

Will get back next week about whether we can get this funded.

Thanks

Jay