1. Avi Nackash
  2. PowerBuilder
  3. Thursday, 14 March 2024 16:00 PM UTC

Hi,

I want to implement the import/export functionality from Powerbuilder to OneDrive.

 

Has anyone any implemented it in PB?

 

Thank you

Avi Nackash Accepted Answer Pending Moderation
  1. Thursday, 14 March 2024 18:00 PM UTC
  2. PowerBuilder
  3. # 1

Hi Armeen/Mark,

Thank you for the comments. What I meant about export/import is - from PB users can export the results on the datawindow into a file like xls or txt and can save it on any drive. The issue that we are having is - the Onedrive is available when you run the application from the local/network drive but it is not available from Citrix, we are not sure if it is a Citrix issue or if it is related to any additional of PB dlls. 

Thank you

Comment
  1. Mark Goldsmith
  2. Thursday, 14 March 2024 18:40 PM UTC
You're welcome Avi and I see now what you're trying to do. This sounds to me like a Citrix related issue. You may still be able to get around it by mapping a local drive, to which you should have access via Citrix if you can currently access "local" drives. That said, you may wish to have a look at these links for further info re OneDrive and Citrix:

https://learn.microsoft.com/en-us/sharepoint/onedrive-in-citrix-virtual-apps-deployment-guide

https://support.citrix.com/article/CTX276664/limitations-of-microsoft-onedrive-when-using-with-profile-manager-and-virtual-desktops

https://www.citrix.com/blogs/2023/03/02/enable-easy-access-citrix-profile-management/
  1. Helpful 1
There are no comments made yet.
Mark Goldsmith Accepted Answer Pending Moderation
  1. Thursday, 14 March 2024 17:48 PM UTC
  2. PowerBuilder
  3. # 2

Hi Avi,

Similar to Armeen's questions, I guess it depends what import/ export means and the functionality you are trying to accomplish. Assuming the location is not already a synchronized location and you just wish to open, copy, create etc. files on your OneDrive but with PB's FILE???????() functions then you have a couple of approaches:

  1. Map a network drive to your OneDrive and then use that mapped drive letter as you would the C: drive...if this is needed for many users in an organization then the drive mapping should be accomplished as part of Group Policy configurations
  2. Hardcode the UNC naming format (minus the user and machine names which would be obtained at run time and concatenated together) of the OneDrive in your PB code such that it would look something like this: "\\" + ls_MACHINENAME + "\Users\" + ls_USERNAME + "\OneDrive"

If you're looking to do more complex things, like getting notifications when files on OneDrive are changed, then the API approach is the way to go.

HTH...regards,

Mark

Comment
There are no comments made yet.
Avi Nackash Accepted Answer Pending Moderation
  1. Thursday, 14 March 2024 16:47 PM UTC
  2. PowerBuilder
  3. # 3

Hi Francisco,

Thanks for the link, and I already familiar with it, I was looking for a built-in solution in PB Appeon to be able to access Onedrive the same as accessing the C drive without writing any code for it.

Comment
  1. Armeen Mazda @Appeon
  2. Thursday, 14 March 2024 17:06 PM UTC
I'm confused. I thought OneDrive worked like Dropbox that you could save a file to particular path on your local disk and it would synchronize it to the cloud. I don't understand what import/export functionality you would need unless you are trying to directly manipulate files on the cloud. Disclaimer I use Dropbox so I am going based on my knowledge of how Dropbox works.
  1. Helpful 1
There are no comments made yet.
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Thursday, 14 March 2024 16:05 PM UTC
  2. PowerBuilder
  3. # 4

Hi Avi,

 

You can use Microsoft's docs to get an idea how to do this using its REST API: https://learn.microsoft.com/en-us/onedrive/developer/rest-api/getting-started/?view=odsp-graph-online

Once you know how to do this with REST all that remains to do is use PowerBuilder's HTTPClient to authenticate and make the requests.

 

Regards,
Francisco

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.