Application Express :: Automatic Save File From Apex To User Local Directory
Jun 13, 2012how can save pdf file from apex to user local directory on button click?
View 2 Replieshow can save pdf file from apex to user local directory on button click?
View 2 Repliesi recently installed an apex plugin but after deinstalling the plugin some of the functionality was still there.I suspected the plugin uploaded a js library and a css file.I found the functions apex_javascript.add_library and apex_css.add in the plugin.Where does apex save the files that are uploaded using those functions?I want do remove then.
Oracle DB: 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionAPEX: 4.1.1.00.23
I'm looking for a solution to hyperlink to a local file (i.e. C:/test.txt). I want that the user clicks on a "browse file" button like the file browse item. after the user selected a file or just a folder the path should be shown in a display only item. this item should be clickable...
Is it possible to create a "Browse file" dialog? I know that to link to a file is possible with some HTML tags in the "pre element text" and "post element text" fields. something like "<a href="... but I don't know how this works.
I have a requirement to :
1) at the click of button, some data will be written to XML file and after writting to file, it should get saved to some location on local machine(c: emp), without asking user, where to save.
How to do this in oracle form?
Also is it possible to read file from local machine?
I want to print a report using the apex, but it looks like you need to configure BI, Is there an easy way to print it online and not print the page, which is page report.
View 3 Replies View RelatedI have an application where I generate a excel using data in a table and write excel file in oracle directory.Now my requirement is to open that file from local machine .How can i achieve it.I am using Apex 4.2,Oracle 10g .
View 1 Replies View RelatedHow can I access this "file:///C:/Users/RI/m_1.html" external file within the apex page?
I created a page and button for link but struggling for above.
While I try to download a file using the below code; an HTTP 404 error is coming although the proc is being called and the parameter is correctly being passed.
create or replace procedure download_myfile1(p_id in number)
as
v_mime varchar2(255);
v_length number;
[code]...
It shows a POP up window by which u can save or opens the file. But no pop up displayed in this case.
I want my application to provide an end-user with ability to upload the files from their machine to SFTP server directly. So far, I have managed to write the function which uses java source and allows to upload files from the database. It works just fine.
The function looks as follows:
FUNCTION SFTP_CMD (
V_USER IN VARCHAR2,
V_PASS IN VARCHAR2,
V_HOST IN VARCHAR2,
[code]..
where V_FILE_SRC represents location of the file to be uploaded. The thing is that the FILE BROWSE apex item does not allow to specify the file location, it identifies it somehow automatically, when you press the button 'Choose file'. The question is how can I catch file's path, so that I can pass it to V_FILE_SRC parameter in my function? Should I write my own plugin? or hack FILE BROWSE item? =)
We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.
When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.
The APEX listener appears to be more than just a Java PL/SQL gateway.
Is there a minimum version of APEX the APEX Listener supports?
We have integrated Oracle Access Manager 11gR1 with Oracle Apex 4.1. The OAM-Apex integration is working fine. Now we want an additional header variable to be passed from OAM to the Apex application. This new header variable will be user's sAMAccountName in Active Directory. OAM is integrated with AD and the AD users are successfully able to access the Apex applications.
The three header variables which are configure in OAM right now are:
Header variable name Value
1. OAM_REMOTE_USER $user.userid
2. OAM_REMOTE_USER_EMAIL $user.attr.mail
3. OAM_REMOTE_USER_GROUPS $user.groups
We need an additional header variable as mentioned below:
Header variable name: OAM_SAMACCOUNTNAME
Value: $user.attr.samaccountname
The new header variable was added in the OHS server's dads.conf file like shown below:
=========== dads.conf =============
...
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_GROUPS
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_EMAIL
PlsqlCGIEnvironmentList HTTP_OAM_SAMACCOUNTNAME
But we are not able to read the value of this attribute in the Apex application.On the Apex application, we have a text box which shows the value of this header variable. This textbox is attached with the following stored procedure call to fetch the header variable:
===================
begin
:P1_HEADER_VALUE := owa_util.get_cgi_env( 'HTTP_OAM_SAMACCOUNTNAME' );
end;
The textbox shows the correct value if HTTP_OAM_REMOTE_USER is passed to the get_cgi_env method but does not shows anything when HTTP_OAM_SAMACCOUNTNAME is passed to the same method. if I am missing some configuration to pass the HTTP_OAM_SAMACCOUNTNAME haeder variable from OAM to Apex.
How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?
View 3 Replies View RelatedI have a translated application in Apex, my Apex version is 4.2.1.00.08. The application is in production version, many people are using it on daily basis. The application's primary language is English, and it has translations for 5 languages. Everything is working fine now; even if there are minor changes in the application, we are able to seed it, download the XLIFF files and than publish the modifications into all translations. Simple so far. My problem is that I wanted to 'clone' the application including its translations to a new one since I plan to rebuild some parts of it. I want to keep the current version untouched, not to bother users. The new application should be in the same workspace, with a new ID. I have tried a couple of approaches: Copy the primary application enabling the option 'copy translation' - this creates a new app, and also seems to create new translated applications, which are empty (not seeded, not published). Export the primary application and than import it with a manually defined new application ID. Than do the same with the translated applications and set the proper IDs in the translation mapping part of Shared components > Translation. When I try to run the primary application, it is working, but for translated versions... Only an error saying that the application page does not exist. The purpose is to clone the whole thing by keeping the connection between the primary and the translated applications, so that if I change something in the primary application, it can be seeded into the translated ones later. In the same time I want to keep translations as well, since there are thousands of strings...
View 2 Replies View RelatedI have a requirement like, I received .dat files and placed in my local directory and there is a process/method where this data which is there in .dat file will insert into my oracle external tables?Any link of the example with clear steps?
View 9 Replies View RelatedHaving an issue with logging into URL.... Just went through the install for APEX 4.2 for
Oracle 11.2.0.1 on Linux 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux.
Installed Apex with Embedded PL/SQL Gateway.Explicitly followed all the online instructions step-by-step, installation was success and config for EPG had no issues. Changed the ADMIN pw as instructed. Checked that EPG is running on port 8080. Ran this script to grant connect:
DECLARE ACL_PATH VARCHAR2(4000);BEGIN -- Look for the ACL currently assigned to '*' and give APEX_040200 -- the "connect" privilege if APEX_040200 does not have the privilege yet. SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;[code]....
that lets power users to connect to everywhere',
'APEX_040200', TRUE, 'connect'); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');END;/COMMIT;
When I go to log in it says "Invalid Login Credentials". I tried changing the admin pw several times but keep getting the same message.
I am trying to update a collection and a table.I got some example code and installed on oracle.com, but I just can't seem to get it to work.I always get an errorORA-20001: Current version of data in database has changed since user initiated update process.I think the problem lies with comparing the checksums, but I cannot spot the mistake
View 2 Replies View RelatedI am wanting to open up an Item's Help popup feature using a different button.
I understand I need to call:
javascript:popupFieldHelp($('1234567','&SESSION.');
Where 1234567 is the items id.
So my question is how do I get the items ID?
I thought it was something similar:
$('#P1_ITEM_TEST').attr('id')
But this returns P1_ITEM_TEST, I want the ID or Sequence of the item.
We'll soon start an upgrade of our Forms / Reports 6i Application to 11g. I was wondering, maybe, it would be nice to add some value for the upgrade process as a whole, using some of Apex new features like web mobile interface or maybe an integration between Forms an Apex, for example to provide users with the powerful features of Interactive Reports, just to name one.
I have found this interesting link: URL.... (not a 100% clear for me, but at least it is a start).Obviously, to make it attractive, one would expect automatic login between the two Apps. As far as i know, this could be done like this:
1) Using SSO. With that a Portal / Forms / Reports/ Discoverer/ version would be mandatory (too expensive for some clients).
2) Oracle Access Manager? Not sure, can Oracle Forms connect to Access Manager? or LDAP? How about the licensing costs?. Not a clue.
3) Make all Apex pages public? Not feasible.
4) Now this one: in our forms application, every user authenticates within the application and we internally map that application user to an actual database user. At all times we hold metadata info about the current user (app, and DB), as well as application context. So this is my question:
It is possible to create an Apex app, with database authentication method, and somehow pass the metadata from forms, and have a kind of custom login procedure that does all the application to DB user conversion process and application context setting?
I'd like to upload a video file (250MB) into our Apex app and have users click a link (Display Only item perhaps) and have the video launch either in Apex, or Windows Media Player. I've tried loading it into the Shared Components - Images, but it failed b/c the file was too large. I was considering loading it into a database table, but was hoping there might be an easier way. Right now we just have a link to the video on YouTube, but want something more professional.
View 2 Replies View RelatedI have a requirement to view the PDF content in the apex page region, I am using Apex 3.2 and Oracle 10 Enterprise edition. I Uploaded the PDF file in the shared component under static file. Now i need to view the content of the PDF file. method to view the PDF content.
I saw the link in denes blog here he shows how the PDF is getting displayed. but there is no steps of methods mentioned
[URL]...
I have a requirement to connect to APEX application from outside (a java program). The basic requirement is to post some data to APEX DB by a scheduled task.
View 3 Replies View RelatedI'm attempting to configure printing via the APEX listener and I'm struggling to understand it. I currently use Oracle HTTP server as the web server for APEX. I have installed the APEX listener and configured it. If I connect via the APEX listener, PDFs work correctly. If I connect via the Oracle HTTP server, I get an error with PDFs. Am I required to connect with the APEX listener for PDF printing? I thought I could configure APEX listener for PDF printing on the backend and still connect via Oracle HTTP server. I'm use APEX 4.2.3, APEX Listener 2.0.5, and Oracle DB 11.1.0.7.
View 5 Replies View RelatedI would like to run this procedure using a URL ... I have apex installed. What URL would I use. This procedure is compiled in the database. I have been trying to look thru the APEX installation guide for an example but I must be missing it somewhere.
CREATE OR REPLACE PROCEDURE ORASYSAD.HELLOWORLD is htp.print ('<hl>Hello World</hl>'); end;
I've created a system for managing football within APEX and it is at a stage now whereby the user can view any number of the tables through Reports and insert data into these tables through Tabular Forms. Its using triggers and sequences to allow for new primary keys to be generated each time within these Tabular Forms so I'm at a stage now where I'm really quite pleased with it..
The last thing I'm needing to do now is have it update certain fields when certain records are entered.
Clubs
clubId
clubname
gamesplayed
clubPoints
clubtotalgoals
Results
club1 (clubId foreign key from clubs table)
club2 (clubId foreign key from clubs table)
club1goals (the amount of goals, type Number)
club2goals (the amount of goals, type Number)
club1points (points earned, Type Number)
club2points (points earned, Type Number)
When filling out a result, the user will enter the following (as an example):
club1 - 1 (club with ID, 1)
club2 - 12 (club with ID, 12)
club1goals - 2 (the first club scored 2 goals)
club2goals - 0 (the second club scored 0 goals)
club1points - 3 (the first club picked up 3 points)
club2points - 0 (the second club picked up 0 points)
The result is then entered into the results table and what I am hoping to achieve at this stage is the following:
1) in the clubs table, the gamesplayed is incremented by 1 for both clubs as a result of playing this fixture
2) club1 has however many goals club1 scored added to its current clubtotalgoals field (in this case, it is of course 2)
3) club1 has however many points club1 earned to its current clubPoints field. (In this case it would be 3)
I am using APEX 4.0. I have created a master detail page , the business logic is “ We can save master record only if there is at least one detail record exist.”
But current wizard developed page has functionality that I have to save master first then only I can add detail record. I want to save them together.
I have seen the Skill builder plugin for Save Before Exit, and it looks great.
Unfortunately, my project is using apex 3.2.
Is there a recommended way to achieve this for a tabular for in apex 3.2.
How to save and edit a Word template and excel (extension. doc and. xls), which can be opened to allow the document and record all changes made by the user of the pacification.
View 0 Replies View RelatedI have one question. Is there any way to get some users data from active directory? I already have authentication scheme wich interact with AD, but now I need to get e-mail address from user who will login into application. Our Apex version is 4.1.
View 2 Replies View RelatedI have a requirement create graphs, charts and maps based on data from a data warehouse (dw).
As I see things, there are two possibilities: Graphs, charts and maps based on an XML fileGraphs, charts and maps based on Oracle tables Both would contain small data sets that will allow for quick response.
The intent of these graphs, charts and maps is to generate a dashboard that would allow the user to quickly drill down to the desired warehouse data. The proof of concept has already been validated using the Oracle table scenario.
My question is whether or not this could be accomplished reading xml files for generating the same set of dashboard items? My Oracle database and APEX environments configuration are as follows:
NLSRTL 11.2.0.1.0 Production Oracle Database 11g Enterprise Edition 11.2.0.1.0 64bit Production PL/SQL 11.2.0.1.0 Production TNS for Solaris: 11.2.0.1.0
ProductionApplication Express 4.2.2.00.11APEX Listener Release 2.0.2. / Tomcat
An Oracle database directory has been setup and is accessible to our APEX application.
db11gxe , apex 4.0 , firefox 24. I want to do automatic row fetch when the value of a select list changes ?but first i should ofcourse create a tabular form to fetch the data into it , but what i want is ,if i fetch 2 rows then the report contains only two rows , if i fetch 3 , the report contains only 3, if i fetch nothing , the report has nothing ?
View 0 Replies View Related