CHALLENGE DETAIL

Extract IRS e-file

OVERVIEW

CODE

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.

REQUIREMENTS

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.
 

SUBMISSION DETAILS

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.

PARTICIPATION


DISCUSSION

antenna
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
aerochaitanya
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
jeffdonthemic
Check out the "Can I view other submitters code?" on the FAQ page.
jeffdonthemic (admin), May 01, 2012 at 08:27 AM
chok68
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
mess
We are having time tracking down sample XML files
mess (admin), May 03, 2012 at 11:36 AM
avidev9
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
jeffdonthemic
Let me ask the person running the challenge and see.
jeffdonthemic (admin), May 03, 2012 at 11:20 AM
antenna
It would be nice, if he can answer the questions as well.
antenna, May 03, 2012 at 11:22 AM
avidev9
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
jeffdonthemic
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
jeffdonthemic
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
antenna
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
avidev9
+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
mess
That is ok
mess (admin), May 07, 2012 at 07:07 AM
avidev9
@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
avidev9
can the xml contain more than one record at a time?
avidev9, May 05, 2012 at 09:15 AM reply
mess
No it should only be one
mess (admin), May 07, 2012 at 07:06 AM
avidev9
@jeff Any words about the styling? Can I use jQuery?
avidev9, May 05, 2012 at 10:15 AM reply
mess
You may use JQuery
mess (admin), May 07, 2012 at 07:06 AM
antenna
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
mess
Correct only the xml
mess (admin), May 07, 2012 at 07:06 AM
avidev9
@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
antenna
@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
forcexperts
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
mess
We decided to simply it get this task done for the first phase.
mess (admin), May 07, 2012 at 18:34 PM
audaciousdev
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
mess
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.



PARTICIPATION

8 members participating with 5 registered

TECHNOLOGIES

Salesforce.com

WINNER SELECTED

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.

PRIZES

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

ASSETS

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

SHARE

Chrome Extension

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