Challenge Overview
Project Overview
Welcome to the "create copy/paste utlility" contest! The goal of this contest is to create an easy way to copy and paste multiple rows of data from Excel into Salesforce.com while setting some static values for each record that is created in Salesforce.
A jquery tool already exists that may serve as a great starting point for this contest here: http://handsontable.com/
This contest is focused on creating a tool that will allow for easy creation of records on one object within Salesforce.com.
Competition Task Overview
Key Requirements
1. The solution should be very user friendly and is intended as a time saver and an alternative to manual rekeying of data or using data loader tools. Users are accustomed to managing and manipulating their data in offline spreadsheets and providing ease of use will be key to user adoption
2. Test in all the required browsers.
3. Provide ALL installation step by step, create details notes needed for your tool.
Detailed Requirements
1. As a user, I can click on a Quick Entry button that brings up a page supporting the following flow:
2. I can select from a number of picklists (3) where I can preselect field values that will appear on every row I will be adding:
2.1 Fields: Quarter, Country, Record Type
2.2 These field values will persist for every row that is pasted
3. I can then copy and paste a number of rows up to a certain number (eg, 25) from an offline Excel spreadsheet into an grid or import wizard (assuming the copied cells have the same number of columns as the grid I am pasting into)
4. I can view the copied values prior to saving and make corrections
5. I can click Save to commit the values as custom object records.
6. Salesforce will create individual records with the fields populated for the columns from the Excel spreadsheet
7. Salesforce will populate the Quarter, Country, Record Type values as specified by the user initially, for every record that is created along with the pasted values in the appropriate fields
Specific HTML/CSS/JavaScript Requirements
- Validate your code - reviewers may accept minor validation errors, but please comment your reason for any validation errors. Use the validators listed in the scorecard.
- Use CSS to space out objects, not clear/transparent images (GIFs or PNGs) and use proper structural CSS to lay out your page. Only use table tags for tables of data/information and not for page layout.
- No inline CSS styles - all styles must be placed in an external stylesheet.
- Use semantically correct tags - use H tags for headers, etc. Use strong and em tags instead of bold and italic tags.
- Element and Attribute names should be in lowercase and use a "-" or camel naming to separate multiple-word classes (i.e.. "main-content", or "mainContent).
- Label all CSS, JavaScript, or HTML hacks with explanations so others will understand.
- Your code must render properly in all browsers listed in the scorecard in both Mac and PC environments.
JavaScript Libraries/Plugins
All JavaScript must not have a copyright by a third party. You are encouraged to use your own scripts, or scripts that are free, publicly available and do not have copyright statements or author recognition requirements anywhere in the code.
- You are allowed to use the JQuery JavaScript library for this contest.
Browser Requirements
- IE8, IE9
- FF 7+
- Safari 5
- Chrome Latest
References
Hands on table: http://handsontable.com/
See attachment for a sample of what the copy/paste utility would need to do. The cells highlighted in yellow would be pasted by a user from an Excel spreadsheet; the cells in white would remain static for each record created in Salesforce.
Final Submission Guidelines
Submission Deliverables
- You must include Deployment Guide.
- Include screenshots or a video of functionality if possible.
Submission Guidelines
1. Provide an SRC package (Ant or Eclipse) of your code.
2. Provide a detailed document of your solution including details for installation and setup. Provide any details about governor limits or any other limitations to your solution.
3. Provide a simple video of you solution in action. If English is not your first language feel free to annotate your video with text.
4. Not required: Provide access to your dev org. If the package does not install due to missing dependencies or conflicts in the judges org, access to your org may be helpful. If you do provide this you should also install the ‘Enable All Trusted IP Ranges for a Salesforce Org’ by Ray Dehler. This will prevent the judge for asking you the activation code.
5. Provide 95% test coverage for your solution