• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • File handling (Powerserver and Powerbuilder Classic)

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

Resolved File handling (Powerserver and Powerbuilder Classic)

  1. How-to
0
Votes
Undo
  1. David Vasconcelos
    David Vasconcelos
  2. PowerBuilder
  3. Wednesday, 10 October 2018 17:10 PM UTC

What is the appropriate way to handle file access. We don't want files to exist on a persons PC/laptop. 

Scenario, we have a variety of files including word and excel docs.  When we run using PB 2017 client server we connect/disconnect (I,e.map) to the appropriate network directories which allow us to open/read and modify files.  When we convert from PB2017 to PowerServer what is the recommended/best approach to access files. Since we are now running on the web we want to make sure these files or directories are not hacked.

Thanks in advance.

Dave V.

We're (All) at Elevate - Absentee Ballot for Midte...
Which Oracle Database versions are supported
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 10 October 2018 17:49 PM UTC
  2. PowerBuilder
  3. # 1

Hi Dave;

  Suggestion: What about saving sensitive file data in the database within a Blob based column? Then read the file data from the DB using a SelectBlob command right into a PB control or appropriate variable. Then there would be no sensitive data to clean-up afterwards.

Food for thought.

Regards ... Chris

Comment
There are no comments made yet.
David Vasconcelos
David Vasconcelos Accepted Answer Pending Moderation
  1. Wednesday, 10 October 2018 17:57 PM UTC
  2. PowerBuilder
  3. # 2

Thanks Chris, I believe we would still have the same issue.  If it was a word doc then we would need to save the blob data to a file before opening it in word, which means the doc would exist on there drive or a mapped drive.  (unfortunately that would be a project on its own to convert the thousands of docs into the db)

Is it "OK" to actually map a drive for file access from WEB (note the drive would be invisible to the user, UNC would be used for file access so that the drive would not show up on the users file explorer)

Dave V.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 10 October 2018 18:03 PM UTC
Yes, a UNC approach would work as well from a PS Web application. I have done that before successfully. The only consideration I found was to make sure that the web browser had sufficient rights to access the UNC on each related user's PC.

  1. Helpful
There are no comments made yet.
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Thursday, 11 October 2018 08:09 AM UTC
  2. PowerBuilder
  3. # 3

Hi Dave,

what about using the Appeon File Service?

Documents will be stored on the server, you can give different users access to different (sub)folders, and use different  credentials to authenticate.

Best,

.m

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.