Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at cf.Objective() 2012 (Minneapolis, MN) with: Erik Meier and Jesse Shaffer

Matt Koch

Member since Jan 7, 2010

Recent Blog Comments By Matt Koch

  • Initial Thoughts On POI Utility ColdFusion Custom Tag Output

    Posted on Jun 29, 2012 at 3:17 PM

    @Will, Nice one. Changed the 2 lines in poiutility and can read xlsx like a charm. Thanks for sharing. Have you messed with trying to create a new xlsx in the poi custom tag document.cfm file at all yet? Thanks a lot, Matt... read more »

  • Making SOAP Web Service Requests With ColdFusion And CFHTTP

    Posted on Jan 2, 2012 at 10:46 AM

    Hi Ben Just an fyi. I ended up building a new CFC using the org.apache.http.impl.client.DefaultHttpClient with javaloader to maintain the session as the cookies are handled on the back end while posting multiple different requests back and forth with the NetSuite API. This has allowed us to use t... read more »

  • Making SOAP Web Service Requests With ColdFusion And CFHTTP

    Posted on Dec 10, 2011 at 7:24 PM

    Hi Ben I am attempting to use the NetSuite Webservice API's ssoLogin functionality to maintain a session with cookies' returned from ssoLogin. I have all the code setup and working with raw xml and cfhttp and was attempting to use your smooth CFHTTPSession component to maintain the cookies., I re... read more »

  • Maintaining Sessions Across Multiple ColdFusion CFHttp Requests

    Posted on Dec 7, 2011 at 10:43 AM

    Hey Ben Once again, great work, great code, and thanks. I wondered if you or anyone has ever tried to use this code to persist cookies from a NetSuite API login (or ssoLogin). When posting to the ssologin I do receive back some cookies (JSessionID and NSVer) and I see that they are persisted and ... read more »

  • Populating An Existing, Formatted Excel Document Using ColdFusion And POI

    Posted on Jun 28, 2011 at 2:00 PM

    Ben Certainly could have played around more before asking but found that the variable to save the workbook is set in the document end tag. I simply added to the "start" of the document tag.. cfif Len( ATTRIBUTES.Name ) cfset "CALLER.#ATTRIBUTES.Name#" = VARIABLES.Workbook ... read more »

  • Populating An Existing, Formatted Excel Document Using ColdFusion And POI

    Posted on Jun 24, 2011 at 2:19 PM

    Hi Ben I posted on one of the POI Tag pages about this and then found this post that shows how to loop through a template using the POI Utility , but now that we use the poi custom tags, wondering how you would use a template, replace out cells with tags (e.g. ~~Start Date~~~) with data from a data... read more »

  • POI Utility Freeze Frames, Bug Fixes, And Branded Templates

    Posted on Jun 23, 2011 at 11:06 PM

    Hey Ben Long time no post on one of the various blogs about the POI custom tags for me :) I am attempting to use the tag with a 'template' for the first time to read in a branded file with all sorts of pre-defined cells. What I can't figure out (or find a post about) is how to edit cells that a... read more »

  • Initial Thoughts On POI Utility ColdFusion Custom Tag Output

    Posted on Jan 30, 2011 at 9:50 PM

    @Ben So one more big post for you on this topic that fuses many questions i've had over the life of the poi custom tags and offers a pretty slick solution that I think you and others may appreciate. The Task: Turn an existing cf page that creates html tables and other elements that is currently wo... read more »

  • Initial Thoughts On POI Utility ColdFusion Custom Tag Output

    Posted on Jan 28, 2011 at 2:38 PM

    @Angela Unfortunately I have not been able to add the xlsx to this tag - i was hoping someone out there figured it out. I did add other good stuff to it like locking cells and sheets and adding print headers and footers, but not the xlsx yet. @Ben As many folks noted, and contrary to my earlier ... read more »

  • Communicating With The Client Whilst Inside A ColdFusion Custom Tag

    Posted on Jan 11, 2011 at 2:00 AM

    Retraction of my last comment. Once I got deep into this and tested big excel files mapping to big new poi:document generated excel files in the cfthread with the loop, things got wierd. I like the session variable, ajax polling method described above and may implement that with some of the poi us... read more »

  • Initial Thoughts On POI Utility ColdFusion Custom Tag Output

    Posted on Jan 7, 2011 at 12:23 PM

    @Ben Ohh yeah - and I got your proof of concept working with the progress indicator flushing progress even when in the custom tag for poi! Wrapped your example code around our creation page and with a little bit of tweaking got it working! Only real change is on the beginning of the loop added lo... read more »

  • Initial Thoughts On POI Utility ColdFusion Custom Tag Output

    Posted on Dec 19, 2010 at 7:54 PM

    Ben The poi custom tags still rule. I have added support for header,footer,password protecting sheets, and unlocking/locking cells on those sheets. I have also added a way to use the javaloader with the custom tags to make this all more portable and easy to upgrade as the poi jars keep upgrading. ... read more »

  • Loading Java Classes With coldfusion.runtime.java.JavaProxy

    Posted on Nov 19, 2010 at 11:19 AM

    Hi Ben (and maybe Mark :) ), I just started using javaloader for the great combine.cfc that combines and minifies and then gzips all static js, css, etc to rapidly shrink the pages our application serves. If you are not using this, I strongly recommend as it is great! I love the portability of th... read more »

  • POI ColdFusion Custom Tags First Release

    Posted on Nov 5, 2010 at 2:48 AM

    Sorry the loop in the paste above is not correct it should be <cfloop from="1" to="#listlen(ATTRIBUTES.HeaderFooter)#" index="j"> Matt... read more »

  • POI ColdFusion Custom Tags First Release

    Posted on Nov 5, 2010 at 2:46 AM

    Hey Ben I had added the ability to pass headers and footers for printing, as well as setup a default print area to fit layout in 1 page width to the POIUtility.CFC I just went ahead and added them into the sheet.cfm in case any one searches for print area, printer header and footer, etc. You can ... read more »

  • Communicating With The Client Whilst Inside A ColdFusion Custom Tag

    Posted on Oct 11, 2010 at 4:51 PM

    Yes!! You did it... nice one. For our purposes of creating an Excel file in a popup or modal, using this cfthread method to use the poi custom tag while outputting which piece of information in the process we are on, will work great! Less hits on the server than polling and less overhead than a pu... read more »

  • POI ColdFusion Custom Tags First Release

    Posted on Sep 24, 2010 at 10:53 AM

    @Ben, Nice - i knew if you wrote out how one couldn't do it you'd probably stumble on how one actually can do it. I have not used cfthread before so will need to research and play with that some but let me know if you come up with something as I will not be able to get to this for a minute and you... read more »

  • POI ColdFusion Custom Tags First Release

    Posted on Sep 15, 2010 at 12:35 PM

    @Ben, How about if the majority of the page was created in a cfsavecontent and then output at the end of the page so that we could output progress as the page is running before calling poi:document. Do you think that would work to start with the first poi:Sheet call in a savecontent through the la... read more »

  • POI ColdFusion Custom Tags First Release

    Posted on Sep 13, 2010 at 8:30 PM

    Hey Ben This poi utitlity is really great and I have been able to do a lot with it. My only issue is that on some of my longer pages i like to have output to the page saying which company we are processing or a percentage of where we are in the page, etc. It seems when invoking the poi you can n... read more »

  • POI Utility Now Supports Formulas And Cell Aliasing In Custom Tags

    Posted on Jan 13, 2010 at 12:17 AM

    Hi Ben I found a small bug in the custom tags... in cell.cfm on line 214 originally i believe... <cfset VARIABLES.DocumentTag.CellAliases[ "@#ATTRIBUTES.Alias#" ] = ( VARIABLES.DocumentTag.ColumnLookup[ Fix( VARIABLES.RowTag.CellIndex / ArrayLen( VARIABLES.DocumentTag.ColumnLookup ) ) ] & ... read more »