Extract IRS e-file



There is nothing more painful then applying for student loans.  This sample app will help facilitate applying for financial aid by pulling in tax information from an existing file.   This is for a proof of concept and the import is the most important functionality.


Extract IRS e-file data from the e-file document and parse it into an application form.  As this is an application form for financial aid, it would require the dump of all e-file data into said form in some organized manner.
Required Development:
- Simple Application for a student (custom object, custom fields)
- Import Process for an IRS e-file (download 2011 package
- You will import only the IRS1040.xsl
- Extract data points from the IRS e-file
- Import into custom fields on the Application object

VisualForce page will be the front end
- Login Page for returning users.  ID & Password. (authenticated sites)
- Welcome Back Page.  
- Basic data presented (name & address).  
- Question ... Would like to speed up your Application Process?  Click "yes" if you have your IRS IRS e-data file to upload.


Provide all code and preferablly an unmanaged package.

A video along with your submission would be preferred.

Your submission will be judged by a panel of peers based upon this criteria. If you would like to request an extension, please read Can challenge deadlines be extended for more time? on our FAQ. We do not want to grant extensions unless there is a valid reason.



I am very confused with requirements. Not clear about how can we parse an XSL file to populate data into a student application sobject. Even not sure what does "extract data points ..." mean ? Can you shed some more light here !
antenna, May 01, 2012 at 06:39 AM reply
I wanted to see the code for some of the solutions for challenges that have been closed in the past.How can i see it in cloudspokes?
aerochaitanya, May 01, 2012 at 08:23 AM reply
Check out the "Can I view other submitters code?" on the FAQ page.
jeffdonthemic (admin), May 01, 2012 at 08:27 AM
Hi. Can you provide some sample XMLs? I think generating some of those by hand is difficult. Thanks
chok68, May 02, 2012 at 00:15 AM reply
We are having time tracking down sample XML files
mess (admin), May 03, 2012 at 11:36 AM
Was busy with another challenge and was unable to see this one! @jeff Cannot be this extended by few days?
avidev9, May 03, 2012 at 10:58 AM reply
Let me ask the person running the challenge and see.
jeffdonthemic (admin), May 03, 2012 at 11:20 AM
It would be nice, if he can answer the questions as well.
antenna, May 03, 2012 at 11:22 AM
Well writing the parser by just seeing the xsl is very difficult some sample files will be really appreciated
avidev9, May 04, 2012 at 13:22 PM reply
We are making some samples files right now. We'll extend the challenge to compensate for the this time.
jeffdonthemic (admin), May 04, 2012 at 13:27 PM
I just posed a sample XML file in the Assets section. A couple more to follow.
jeffdonthemic (admin), May 04, 2012 at 13:55 PM reply
Thanks for posting the XML, As this would require setting up Salesforce Sites + Customer Portal (for authenticated users), this is not packable into unmanaged package (correct me if I'm wrong). So how should we submit, just the vanilla source of pages, object and classes (etc) ?
antenna, May 04, 2012 at 20:13 PM reply
+1 for antenna...@jeff Should we include only the classes and pages in the package as the Portal site must be enabled in the destination org manually.... Please clarify!
avidev9, May 06, 2012 at 05:37 AM
That is ok
mess (admin), May 07, 2012 at 07:07 AM
@Mess this means we will be essentially developing two visualforce pages! One the welcome back page and another the IRS Form? Please correct me if I am wrong!
avidev9, May 07, 2012 at 08:07 AM
can the xml contain more than one record at a time?
avidev9, May 05, 2012 at 09:15 AM reply
No it should only be one
mess (admin), May 07, 2012 at 07:06 AM
@jeff Any words about the styling? Can I use jQuery?
avidev9, May 05, 2012 at 10:15 AM reply
You may use JQuery
mess (admin), May 07, 2012 at 07:06 AM
One last question, this line in requirements "- You will import only the IRS1040.xsl", is no more valid ? User will upload XML file as per the samples, instead of XSL ?
antenna, May 05, 2012 at 20:17 PM reply
Correct only the xml
mess (admin), May 07, 2012 at 07:06 AM
@Mess this means we will be essentially developing two visualforce pages! One the welcome back page and another the IRS Form? Please correct me if I am wrong!
avidev9, May 07, 2012 at 09:54 AM reply
@Mess, waiting for your response on packaging the submission, as its a sites page, shall I create an admin user for a provided email. That way the judge panel can easily explore the metadata ? Please suggest !
antenna, May 07, 2012 at 10:15 AM reply
Based on the "IRS1040.xsl" file, I believe the XML that we need to parse is a whole lot bigger with much more information than what is there in XML files supplied in the Assets section. Without the complete XML structure, I think the task is not doable. Please let me know if my understanding is incorrect, and whether it's possible that we can be provided with a complete XML file and/or schema of the input XML file?
forcexperts, May 07, 2012 at 18:29 PM reply
We decided to simply it get this task done for the first phase.
mess (admin), May 07, 2012 at 18:34 PM
Is it possible to extend by one day please? I'm close to completion and need some more time.
audaciousdev, May 08, 2012 at 09:20 AM reply
Unfortunately we will not be able to extend this challenge.
mess (admin), May 08, 2012 at 09:33 AM

The discussion board is closed for this challenge.


8 members participating with 5 registered



Ended May 08, 2012 at 6:03 PM
Winner Announced on May 16, 2012
View the challenge results
Give us your feedback about this challenge.


Total: $1,700
1st $1200
2nd $500


  1. cloudspokes_efilesample.xml
  2. cloudspokes_efilesample2.xml
  3. cloudspokes_efilesample3.xml
  4. cloudspokes_efilesample4.xml


Chrome Extension

Install the CloudSpokes Chrome Extension for quick and easy access to the latest CloudSpokes challenges, your payments, leaderboards and more!