Hi,
I am wondering if anyone has created a process that they could point me to that allows a user to upload a file from their PC, via an ApEx page and stores the file on a sharepoint site. It would be a bonus if the process could return the location of the file, so that could be saved in a record.
The situation I have is that we have an application that is used to track projects deploying within our business. A scope document (word doc) is completed by the project team and has a lot more detail about the project then we store in the database, and I want to allow the project team to upload a copy of the scope document via an ApEx page (the page they currently use to edit aspects of their project in our application).
Ideally the process would
- Automatically append the unique ID of the project to the name of the file
- Return the sharepoint location URL of the file after it is uploaded, so that can be stored in our database. My hope is then have a button on the edit page use this URL so that anyone who brings up the project record, can easily click the button to "retrieve" (eg. open) the save document from sharepoint.
Has anyone done anything like this.
We are running ApEx 4.2 (11g)
Thanks