Skip to main content


Showing posts from February, 2010


Talk about a busy week ahead... I'm about to head to the airport and hop a flight to Denver, CO, where I will be presenting Troubleshooting Oracle APEX at the RMOUG 2010 Training Days. If you're in the Denver area, it's not too late to register, but you have to do it on-site at the Colorado Convention Center.
Later this week on Friday, I will be presenting at MAOP 2010, which will be held in the Oracle Reston office. There, I will be presenting a shorter version of Troubleshooting Oracle APEX as well as Extreme Makeover: APEX Edition. MAOP only has a few slots left, so be sure to register soon to reserve yours soon.
Be sure to say hello if you're at either event.

Uploading XLS Files with APEX Listener EA2

Kris Rice just posted that the APEX Listener EA2 is available for download.

Quoting Kris on the new features:

New /listenerAdmin with real-time statisticsMechanism for logging DB RequestsCapability to upload .xls files into an APEX Collection
The last of these features interests me the most, as we get that request all of the time.  The de facto solution is to save your Excel data as CSV, then upload that.  Not very elegant.

So before even completing my first cup of coffee this morning, I decided to try it out.

Downloading the new listener was as snap, as was re-deploying the .war file.  Took no time at all, and I was up and running.

Next, I created a quick little application that simply had a File Browse item on the page and a button whose request value is set to 'XLS2COLLECTION', as per Kris's instructions.  I ran the application, located an XLS file, and clicked "Go".  Upon checking the session state for collections, the results were a little different than Kris…