Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved How to read/write files from Cloud storage?

  1. How-to
0
Votes
Undo
  1. Hung Doan
    Hung Doan
  2. PowerBuilder
  3. Wednesday, 17 February 2021 15:02 PM UTC

Version: PB2019

I have a window in my PB app that read/write from files.  Currently the files are stored in a network drive and we are migrating those files to cloud storage. I do have access to the cloud location of the files.

How do I read/write the file from a cloud storage?

Example of link to file location:

https://mnxxx.sharepoint.com/sites/HDS/Shared%20Documents/Forms/AllItems.aspx?RootFolder=%2Fsites%2FOTTS%2FShared%20Documents%2FGeneral&FolderCTID=0x0120001604D6B9A37D2548B1E7A7F262CA8BD7

Currently I use these functions: GetFileOpenName(), FileOpen(), FileRead(), ImportString(), FileClose()

 

connect to database from Powerclient from outside
PB2019 R2 - null reference at execute a SP
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 17 February 2021 15:19 PM UTC
  2. PowerBuilder
  3. # 1

sharepoint is its own thing.  if you use sharepoint, then the question would be how to access sharepoint files

 

'files' imply a specific storage process.  Azure supports cloud file stores and you can access your files via standard file processing if you are running current operating systems.  I am guessing that AWS may support this too.  The downside to this is the cost is higher than the more typical storage of files in blob storage.

 

blob/block storage is what most people think of when talking about "cloud" files.  To use this you need to either write your api access to the blob storage, or use software to emulate a disk drive. 

for the api, every provider has its own api to access them (azure, aws, dropbox, etc).  There have been several elevate presentations on this in the past several years - specifically azure blob storage and dropbox

 

for software, there are several products available. i've used cloudberry drive in the past, there are many others 

 

 

 

Comment
Hung Doan
  1. Hung Doan
  2. Wednesday, 17 February 2021 15:39 PM UTC
Mike, thank you for your response!

The cooperation is migrating the files structure to sharepoint! For this window, I am restricted to these read/write files because they come from external sources.

Currently when I use the FileOpen(), PB opens a dialog box so I can traverse the file tree to the file. How do I replace that dialog box process where my files are in sharepoint now? Is is possible without additional API codes or other products.

Thanks!

  1. Helpful
mike S
  1. mike S
  2. Wednesday, 17 February 2021 15:50 PM UTC
So everything works fine and you just want to prefill the directory?
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 17 February 2021 15:33 PM UTC
  2. PowerBuilder
  3. # 2

Adding to what Mike said, I would recommend watching this Dropbox webcast: https://www.appeon.com/developers/library/videos/using-dropbox-rest-api-powerbuilder.html

 

Comment
Kevin Ridley
  1. Kevin Ridley
  2. Wednesday, 17 February 2021 16:41 PM UTC
Agreed. Pretty sure there's a REST Api for Sharepoint.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 17 February 2021 16:47 PM UTC
Yup, these days pretty much everything is made available through REST APIs. So you master REST APIs and whole new world opens up to PB apps. But of course these are third-party services usually not free... so need to get the boss to cough up money! Hahahaha
  1. Helpful
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.