Application Express :: Uploading Multibyte CSV File?
Jul 9, 2012
I have multibyte CSV files (extract from BI) : Excel says "Unicode txt" and when I save them from Excel in "Text CSV", they get half the size on the disk.
here is the piece of code where the uploaded file get converted from blob to clob then to varchar2 (CSV Util from Oleg.Lihvoinen [URL]...
SELECT blob_content
INTO v_blob_data
FROM wwv_flow_files
WHERE NAME = p_file_name;
[code]...
I have tried different values for "blob_csid := 873 ;" (and by the way, the list of possible values for this code is very difficult to find : I know, there is a function CS_name to CS_ID but a list would be great), but without any visible effect.If I use the Apex CSV uploader app, the result is the same than with this code.
is an example :
�O�R�A�C�L�E�
instead of :
ORACLE
How I can have these files imported whithout an Excel conversion ?
View 9 Replies
ADVERTISEMENT
Sep 28, 2012
I get an ERR-7621 from Apex whenever I do anything in an application the tries to read a file. For example importing images, css files, themes, or applications. Even the data loader app will get the error if you choose to load a "csv" file. The following appears in my Apex Listener Log (version 2 early adopter). I am running 4.1.1 of Apex and also have another server running the same where the problem does not exist. Following is the log output whenever the load occurs:
Sep 28, 2012 11:21:18 AM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
[Code].....
View 1 Replies
View Related
Jun 20, 2012
I got error "Upload New Image must be specified. Click browse to select an image from your local computer" while i upload image in shared components>image>create ...
my logo is saved in local drive D. when i browse file and click to upload it gives error that i mentioned. This is happening with every uploading weather its image or weather its plugin.
View 1 Replies
View Related
Oct 26, 2012
I have been searching the forum (and Google) looking for tips on how to ensure users can only upload files of specific formats (Word, PDF, etc) for specific document types as defined within the application (e.g. Curriculum Vitae (Word), Copy of Transcripts (PDF)).
While I have used this research to start work on a server-side solution, I would like to know if there is an apex-friendly way to "validate" a file-browse item based on mime-type.
View 2 Replies
View Related
Dec 9, 2011
my application run very well on xp but with vista the webutil can't upload a file.
View 10 Replies
View Related
Apr 18, 2013
When i am uploading data in an excel file to my Forms(Windows) the screen works fine but when i am uploading the same excel file to my forms in AIX(Where the application is running) the data is uploaded with decimal points.
The field is a char type and no format mask is set.
E.g. :
Actual data: In Form(Windows) In Form (AIX)
4080026 4080026 4080026.0
View 5 Replies
View Related
May 28, 2013
When i am uploading data in an excel file to my Forms(Windows) the screen works fine . But when i am uploading the same excel file to my forms in AIX(Where the application is running) the data is wrongly uploaded . The field is a number type and no format mask is set.
E.g. :
Actual data:---------- In Form(Windows)------In Form (AIX)
3101513480750030000 3101513480750030000 3101513480750029800
I am using below code to copy the value
cell_value :=Client_OLE2.get_num_property(cell, 'Value');
COPY(cell_value,'data.field'||k);
View 3 Replies
View Related
Oct 21, 2010
I'm uploading data from excel to our database using forms thru webutil. The problem is when I open the same excel file while the upload process is in progress, the uploading stops, BUT not displaying any error. Not even when I chick Help->Show error.
How could I prevent this error and how to trap and display error message?
View 8 Replies
View Related
Feb 4, 2012
how to create link for uploading file from report
View 2 Replies
View Related
Aug 15, 2012
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.
View 2 Replies
View Related
Feb 5, 2013
I need to change "File Character" when I export application with Apex 4.2.1.00.08 version, but this option, is not possible. The ComboBox already select with
"Unicode UTF-8]', but I need "ISO-8859-1 - Europa Ocidental",
how can I do change it?
View 1 Replies
View Related
Jan 28, 2013
I am migrating my application from Apex 3 version to Apex 4.0.2. In previous version , downloading a file was working fine.
But now, it is not working..Is there any changes to be done with the properties?
I was using wpg_docload.download_file to download the file.
View 3 Replies
View Related
Jun 18, 2012
I have a table with full path and name of a document or a URL.
Users can now open one of these documents by klicking on a link.
P:Document est.doc
or
URL....
Some times this document no longer exisits. How do I make sure the user gets a correct error message? URL....How do I make sure the user gets a correct error message?
View 4 Replies
View Related
May 26, 2013
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 Related
Apr 10, 2013
My application has several update-able forms. And I build a single staging table to store all these records.
The user wants a button on the last form and by clicking on this button they want to export the file(updated records from all the forms) in ASCII format.
if its do-able or not in apex since I haven't come across this kind of request earlier and didn't find the same in this forum?
Versions: 10g DB, Apex 4.1.
View 6 Replies
View Related
Dec 13, 2012
I'm trying to upload a xml file into a table but I don't know which separator do I have to select to show the columns well. I does not recognize the columns.
View 5 Replies
View Related
Nov 14, 2012
I want to add video file to apex like photo .
View 0 Replies
View Related
Oct 5, 2012
In my apex application needs to import data files, through end users. The fields in this file are not separated by any character (structure is not classic CSV), but have a fixed width.
How to do?
Scenario 1:
import file to a temporary table with a blob column, create a trigger for this table via a PL / SQL code meet end table
Scenario 2:
using DBMS_LOB libraries to read directly file
Scenario 3:
?
Milos.
(Apex 4.1.0.00.32, db:10.2.0.4 )
View 9 Replies
View Related
Sep 16, 2013
I'm starting with APEX, I would like to know how to insert the contents of a file. Csv in a table, how to map a file to a table, how to insert file contents. Xls in a table.
View 1 Replies
View Related
Mar 14, 2013
I would like to ask if is possible to translate the "Browse..." button of File Browse item.
For me it seems that the button cannot be translated to a different language. I have tried to export the XLIFF and there is no string like "Browse...", also I have tried to edit it manually in translation repository, but the string is not present here.
View 3 Replies
View Related
Oct 28, 2012
I am having an interactive report with an email subscription.
My question is, how can I make the default attachment as a .csv file instead of the .htm file?
View 2 Replies
View Related
Jun 5, 2013
How to make an item as a mandatory field dynamically with the change of another item in different regions
View 8 Replies
View Related
May 21, 2013
How 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.
View 5 Replies
View Related
Jul 9, 2012
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.
View 7 Replies
View Related
Feb 4, 2013
I want to upload file using restful service This is my code to send file to rest service
MultipartEntity reqEntity = new MultipartEntity(HttpMultipartMode.BROWSER_COMPATIBLE);
FileBody bin = new FileBody(f);
FormBodyPart bodypart = new FormBodyPart("file", bin);
reqEntity.addPart(bodypart);
[code]...
But how can i retrive at server side in restful service using plsql?
View 0 Replies
View Related
Oct 18, 2012
I have a stored procedure that returns pdf as a blob.
Is there any way that this can be streamed to the browser without saving it?
View 1 Replies
View Related
Aug 2, 2012
I am trying to upload big files to individual table with BLOB column. During upload process after long time approx. 2h I get the following error message:
[#|2012-08-01T19:03:01.667+0200|WARNING|sun-appserver2.1|java.lang.Class|_ThreadID=27;_ThreadName=httpSSLWorkerThread-8082-2;_Reques
tID=4cec5fc8-b9e1-4017-a859-8759ec1f5d37;|oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:236)
java.io.IOException: ORA-01013: user requested cancel of current operation
[code]....
I am using Glassfish Server v2.1.1 with APEX Listener v1.1.3.243.11.40...The Timeout parameters for JDBC settings in APEX Listener are default. Thus I would expect to abort earlier to be an issue of JDBC Connection?
View 1 Replies
View Related
Jul 16, 2012
I am using jasper integration package ..from www.opal-consulting.de using apex 4 and i Am currently able to generate pdf invoice..using jasper and store in a database.. table.
I need to generate the pdf invoice in the background ..without displaying in my screen..Without downloading on my machine..And store directly into the database table..
Below is my existing part of code..
DECLARE
l_blob BLOB;
l_mime_type VARCHAR2 (100);
l_blob2 BLOB;
l_mime_type2 VARCHAR2 (100);
mport varchar2(200);
[code]....
View 9 Replies
View Related
Oct 16, 2012
Not able to understand what's wrong with the code. I am trying to import data to a table using a CSV file. I have exported the data (CSV) from the interactive report and I am just trying to insert the same data to the table, through a process. When, I tried to do so; its throwing an error message saying NO_DATA_FOUND and file is not getting inserted into wwv_flow_files table.
But when I removed the data from the CSV file for the comments field and then tried importing the file, the process worked. I don't understand whats the problem with the code.
I have a sample app setup in my workspace for this weird problem.
[URL]
Workspace details:
CSV file with comments field and data in it - when trying to import - throws an error message NO_DATA_FOUND
CSV file with comments field and without data in it - tried importing - this worked
View 2 Replies
View Related
Oct 26, 2012
I am using Oracle APEX 4.0. I want to create a tabular form with one column as File Browse field.I've created form using APEX_ITEM and file browse item using pure HTML tags as we do not have any such item in APEX_ITEM. So these fields are appearing now but how do I save uploaded files in APEX_APPLICATION_FILES and then in my table?
View 3 Replies
View Related