couldn't load date formats from excel to my apex collection page

[adikirankannuri]

In Excel i given Name, Email Address, date format and calling them through plugin but the issue is the date column is not loading into the apex page

[antonscheffer]

Could you share that Excel? With dummy values in the mail id column would be fine.

[adikirankannuri]

The date format which I want to insert is DD-Mon-YYYY, What do you think? Is there any possible way.

ADI.xlsx

[grlicaa]

Hi,

I also have an "Date" issue in version 1.0.0

Here is also my excel file if it helps MassenImport_Test_1_37_Zeilen.xlsx

While testing, I've also noticed that attributes type has changed, from "Yes/No" to "text". If possible switch that back, it is more developer friendly "Yes" / "No".

I'm forced to use older version "0.906" in which Dates are working. I've just changed:

  cursor c_api( b_app_id number, b_page_id number, b_item_name varchar2 )
  is
    select api.attribute_01 

For

  cursor c_api( b_app_id number, b_page_id number, b_item_name varchar2 )
  is
    select api.attributes.storage_type attribute_01 

To gain APEX 24.2 compability back. I hope, dates will be fixed so I can move to the last best version :)

@antonscheffer Thank you for creating and maintaining this plugin!

[antonscheffer]

I've found the problem with the date issue. It is already in the demo at https://apex.oracle.com/pls/apex/f?p=33308. I hope to have some spare time this weekend to update the plugin version at github. For users of the 1.000 version. just replacing the plugin file parse_xlsx.prc will fix the issue. https://github.com/antonscheffer/excel2collections/blob/master/plugin/parse_xlsx.prc

[antonscheffer]

@grlicaa The reason for the change of the parameters to text. The Yes/No attribute can not be based on a Page Item, it is only a slider checkbox in the App Builder And with Text that is possible:

[antonscheffer]

Should be fixed

[adikirankannuri]

Hi Anton Scheffer,

I’ve found a solution to the date issue—there’s no need to parse the new file you shared. When entering dates in the Excel date column, simply prefix the value with a single quotation mark ('). This resolves the problem effectively.

Best regards, [KANNURI ADIKIRAN]