I want to upload files to database, but I faced with some problems. I used "fileUpload" component and I can upload .txt format only, regarding any other ones it does not work. In Chrome, there is an error "cannot find application", but in Mozzila Firefox there is no error appeared (no reaction), but also does not upload a file. I tried in another PC, it worked well. Can you help me with it? What am I supposed to do? There are Panel XML and code which I used. Thank you in advance.

Yerkin.

XML:

<panel preferredHeightPolicy="Dynamic">
  <tableLayout cellSpacing="5">
    <row heightPolicy="Dynamic">
      <cell hAlign="Full" vAlign="Full">
        <textLabel label="Upl File"/>
      </cell>
      <cell hAlign="Full" vAlign="Full">
        <fileUpload name="FileUploader" domain="DefaultBLOB"/>
      </cell>
    </row>
    <row heightPolicy="Dynamic">
      <cell hAlign="Full" vAlign="Full">
        <textLabel label="Id Lot"/>
      </cell>
      <cell hAlign="Full" vAlign="Full">
        <textField name="lot"/>
      </cell>
    </row>
    <row heightPolicy="Dynamic">
      <cell hAlign="Full" vAlign="Full">
        <textLabel label="Att Lot File Desc"/>
      </cell>
      <cell hAlign="Full" vAlign="Full">
        <textField name="FILE_DESC"/>
      </cell>
    </row>
    <row>
      <cell>
        <button label="Save" uploadOnEvent="buttonPress" uploadFrom="testUploadPanel.FileUploader">
          <events>
            <buttonPress action="fileUpload"/>
          </events>
        </button>
      </cell>
    </row>
  </tableLayout>
</panel>

Code:

procedure fileUpload
is
    id_file_test number;
    upl_file_name varchar2(50);
  begin

    id_file_test := att_lot_seq.nextval; 
    upl_file_name := api_component.getUploadedFileName('testUploadPanel.FileUploader');
    insert into t_att_files_lots(id_att_file, att_lot_file_name, att_lot_file, att_lot_file_desc, id_lot)
    values(id_file_test, upl_file_name, 
                         api_component.getValueBL('testUploadPanel.FileUploader'), 
                         api_component.getValueTX('testUploadPanel.FILE_DESC'), 
                         api_component.getValueTX('testUploadPanel.lot'));

    commit;

    api_dialog.setVisible('uploadDlg', 'N');
    api_datasource.executeQuery('T_ATT_FILES_1');      
end;

asked 31 Jul '14, 12:03

Yerkin's gravatar image

Yerkin
265
accept rate: 25%

edited 01 Aug '14, 06:45

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5


Hello Ibrahim,

Eventually I found where was a problem. I did not have permissions to write in your folders by default cause I use Windows 8.1. Then I edited permission to "full Control" to my user and now it works. Thanks very much.

link

answered 02 Aug '14, 04:44

Yerkin's gravatar image

Yerkin
265
accept rate: 25%

Hi Yerkin,

I'm glad that the problem is solved. Thanks for sharing the solution too.

Best,
Ibrahim

(02 Aug '14, 09:53) Ibrahim Sand... ♦♦

Hi Yerkin,

I tried the scenario you have described in Chrome version 36.0.1985.125 m and cannot replicate the problem, I'm successfully uploaded files of various types.

  • Can you specify the operating system of the PCs in which this problem occurs and does not occur?
  • Can you specify the Formspider and the DB version you are using?
  • Also, please send the Tomcat "logs" folder and the file you are trying to upload to contact[at]theformspider.com?

Thanks in advance,
Ibrahim

link

answered 01 Aug '14, 07:01

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×4

Asked: 31 Jul '14, 12:03

Seen: 912 times

Last updated: 02 Aug '14, 09:53


© Copyright Gerger 2017