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

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.

CHALLENGE DETAIL

Extract IRS e-file

OVERVIEW

REQUIREMENTS

SUBMISSION DETAILS

PARTICIPATION

DISCUSSION

PARTICIPATION

TECHNOLOGIES

WINNER SELECTED

PRIZES

ASSETS

SHARE

Chrome Extension

MAIN LINKS

MEMBER LINKS

SPOKES

PLATFORMS