Time-format support

[glebovpavel]

Now date in hh24:mi are shown in Excel as 00:00. That must be fixed.

[ma-schroeder]

Hi Pavel,

this is still not working unfortunately. I tested it on apex.oracle.com with plugin version 2.04.

This is the IR with HIREDATE with default data and my added column UPDATED (type is date and dateformat in apex is DD.MM.YYYY HH24:MI for both columns):

And this is the excel export:

[glebovpavel]

@ma-schroeder Fixed in 2.10

[ma-schroeder]

Hi Pavel,

i am very sorry, but the error is still there with a german application setting:

The export still shows 22.09.2016 0:00 like in the above screenshots.

But when i switch to "English (United States) (en-us)" in the application settings it actually works.

The databse colum is of type Date and the format mask of that column in the IR settings is "DD.MM.YYYY HH24:MI". I tested it on apex.oracle.com with APEX version 5.1.2 and locally on 5.1.1. I re-uploaded and executed the script "install_all_packages.sql" and imported the plugin-file from version 2.10

Btw. the Version still shows 2.08 unter Shared Components > Plugins.

[glebovpavel]

Hi Mathias, thank you for quick-testing!

send me please debug.txt like described in page 3 in Instructions.pdf.
In last version i add additional logging for date/timestamp formats. P.S. Unfortunately i can take a look at the problem only after 3 weeks...

Regards, Pavel

[ma-schroeder]

Hi Pavel,

here is a zip-file with all three files:

• Excel.xlsx
• log.txt
• report_data.xml

log_txt_and_xml_and_xlsx.zip

Dont worry and thank you very much for this plugin!

Regards, Mathias

[glebovpavel]

@ma-schroeder Hi, please take a look at the least version. Only IR_TO_XML.sql was really changed.

[ma-schroeder]

Hi Pavel,

nice, its working now. Thank you very much.