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

Resolved Upload documents in Powerbuilder web app

  1. How-to
0
Votes
Undo
  1. mathews rutto
    mathews rutto
  2. PowerServer 2020 or older (Obsolete)
  3. Friday, 13 December 2019 05:59 AM UTC

Hi There,

I need help on how do i upload a document into my powerbuilder web app running on powerserver.

The document can be any format e.g pdf, word, jpf, png etc

User can also retrieve.

Thank you in advance.

PowerServer Toolkit performance settings
Decimal precision issues
Accepted Answer
mathews rutto
mathews rutto Accepted Answer Pending Moderation
  1. Tuesday, 17 December 2019 13:57 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Thank you so much for your feed back,

i was able to archive.

Comment
There are no comments made yet.
Responses (3)
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 13 December 2019 17:52 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

if you are just saving the docs in your database, just use the blob sql statements:

           UPDATEBLOB / SELECTBLOB

 

to save them outside the database, an alternative to setting up the appeon file service is use azure/aws (and other providers) blob rest services to store the documents.  You would use their rest api's to store and retrieve the files.

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Monday, 16 December 2019 06:17 AM UTC
Don't forget to record also the filename in some field of the table, extension included, so you'll know how to save it on disk to be able to show the file again after having retrieved it. (I think some people might know a way to show a blob without writing it first to disk, but not me).
  1. Helpful
There are no comments made yet.
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Friday, 13 December 2019 06:13 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Hi Mathews,

1) install the Appeon File Service under your server (e.g. MS IIS)

https://docs.appeon.com/appeon_online_help/pb2019/workarounds_and_api_guide/ch01s03s04.html#deploy_file_server_iis

2) configure the file types you want to upload/download

https://docs.appeon.com/appeon_online_help/pb2019/workarounds_and_api_guide/ch01s03s04.html#Configuring_the_Appeon_File_Server_weblogic

3) include in your PS application appeon_workaround.pbl and use following APIs to upload and download files

of_logonfileserver
of_logofffileserver
of_appeonupload
of_appeondownload
of_FileExists

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.