Телеграмм чат группы orclapex страница 11

and there're loads of workarounds of how to parse CSV and load it into your table which in its place can be used as a data source for your APEX report

источник

12:17пожаловаться #6

Sergey Konov in Oracle APEX

ok, thank you )

источник

12:24пожаловаться #7

2018 June 02

Santosh Killari in Oracle APEX

Somebody please advice me, is it possible to import Excel (.xls) file into database table,?? That I want to give this option to front end user.

источник

10:36пожаловаться #8

Oleksandr Sydorchuk in Oracle APEX

Yes, it is.

источник

10:41пожаловаться #9

Santosh Killari in Oracle APEX

Oh..Could you please suggest me ,how to implement this?? I mean is there any plugin or something else??

источник

10:42пожаловаться #10

Alexey Vihristyk in Oracle APEX

Oracle Apex supports loading data through from excel when a user opens an xls file, selects the desired data area, copies it to the clipboard and adds it to the text field on the Apex page

источник

10:49пожаловаться #11

Alexey Vihristyk in Oracle APEX

Another option is to load the file into the base (blob) and then parse the excel file using PL / SQL

источник

10:50пожаловаться #12

Oleksandr Sydorchuk in Oracle APEX

https://youtu.be/JctydtUs-eY

YouTube

Options for loading Excel data into APEX applications

UKOUG TECH17 presentation by Philip Ratcliffe

источник

10:51пожаловаться #13

Sergei Kaplunov in Oracle APEX

And more complex but more powerful option is to use Apache Poi java library and write code to parse manually.

источник

10:56пожаловаться #14

Oleksandr Sydorchuk in Oracle APEX

Try it http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/schema/50/Data_Load_Wizard/Data_Load_Wizard.html#section4

Oracle

Creating a Data Load Wizard for Your Application with Oracle
Application Express 5.0

Add short description here.

источник

11:01пожаловаться #15

Santosh Killari in Oracle APEX

Thank you for quick response, worth information. I will try these workarounds.

источник

11:04пожаловаться #16

Oleksandr Sydorchuk in Oracle APEX

Santosh Killari

Thank you for quick response, worth information. I will try these workarounds.

I prefer and recommend to you use native apex data loading. You also can do data mapping by yourself and skip it for the end user. So it'll be 3 pages instead of 4.

источник

11:16пожаловаться #17

Andrew K in Oracle APEX

Hi! What limitations have native apex data loader? Can it load 10k rows? 100k? With 100-200 columns.
(When i had same task - developed separate java service, using Apache POI with event-based parser, but it was in apex 4.2 times)

источник

11:54пожаловаться #18

Alexey Vihristyk in Oracle APEX

Andrew K

Apex standard upload copy/paste method max 32k, csv file upload method limited you server settings

источник

12:02пожаловаться #19

Alexey Vihristyk in Oracle APEX

I’m upload csv file 5M rows

источник

12:03пожаловаться #20