Thread Details
  • State Not Answered
  • Replies 4 replies
  • Subscribers 321 subscribers
  • Views 10665 views
  • Users 0 members are here
Forum Actions
Related

Best way to get all documents uploaded in Sugarcrm instance and import into onedrive

shreya dalvi

Hi All,

Can anyone suggest best way to get all documents uploaded in Sugarcrm instance and import into onedrive.

Background is that we are moving from sugarcrm to Microsoft CRM dynamics 365, so need a way to get all documents stored in sugarcrm and transfer into dynamics 365.

And we are thinking to store all documents in One drive.

Kindest Regards,

Shreya

Parents
  • 0

    For the existing documents, you can download them with the SugarCRM REST API one by one and then upload each document with the One-Drive-API. 

    This can be done offline in any development environment (php, c#, java, ...). It takes some time to run, depending on the number and size of the documents you have.

    For the new incoming documents you can write a logic hook in the documents or notes or emails module which transfers all new documents to One-Drive by the One-Drive-API.

Reply
  • 0

    For the existing documents, you can download them with the SugarCRM REST API one by one and then upload each document with the One-Drive-API. 

    This can be done offline in any development environment (php, c#, java, ...). It takes some time to run, depending on the number and size of the documents you have.

    For the new incoming documents you can write a logic hook in the documents or notes or emails module which transfers all new documents to One-Drive by the One-Drive-API.

Children
  • 0 in reply to Harald Kuske

    Hi Harald,

    Thanks for responding!!

    Please see my queries below:

    1. Can you please let me know how to download all documents stored in sugarcrm using API?
    2. After downloading how we can map downloaded file to document record?
    3. As I can see documents are stored in /upload directory but that files are without extension, but I want downloaded file with extension, how to achieve it?

    Note: Apology for typo mistake but we want to store documents in sharepoint and then move it to Microsoft CRM dynamics, do you have any idea from migrating documents?

    Kindest Regards,

    Shreya