CODEWITHSUNDEEP
oracle-databaseoracle-apex
Scouse_Bob
Scouse_Bob

Reputation: 546

Question on changing the APEX data load wizard to give default target columns

Within the data load wizard that comes with APEX 18.1, after you choose your csv file to be uploaded you are offered a "TARGET COLUMN" drop down LOV which defaults to "DO NOT LOAD". It is possible to tell APEX which values you want in this LOV. I have done this.

My issue is, that this is quite laborious. Your users will not necessarily know which value you want them to pick from the LOV to map the related column when they are using a csv file with no header. As they are going to be doing.

Does anyone know how to change the "DO NOT LOAD" value in the LOV to another value? If I could get it to default to a column of my choosing, this would be great. Alternatively, there's a "SOURCE COLUMN" field in the wizard.

Getting the "SOURCE COLUMN" field to denote which column I wish users to map to the LOV value would be something also. Has anyone faced this before? Does anyone know if it is possible to do what I am suggesting as a work around? Thanks for looking and for your thoughts.

Upvotes: 1

Views: 1573

Answers (1)

TineO
TineO

Reputation: 1033

APEX does the column mapping automatically by checking the name of the column in the csv(the first row is names usually).

So if the names of the columns match in the table and the csv, it will connect them by itself. What you can also do is set column aliases.

If you want to edit the existing data load, you can go to Shared Components- Data Load definitions and pick the one you are using in there.

Then you can set column aliases there. But afaik you can only do one alias per column there.

Upvotes: 1

Related Questions