basecamp helper software(repost)

We need a Ruby On Rails application for ruby 1.9 or 1.8 + rails + rspec/unit tests + mysql+innodb. It should work with Basecamp ([login to view URL]) account using basecamp API: [login to view URL] We will provide Basecamp account for testing. ## Deliverables We need a Ruby On Rails application for ruby 1.9 or 1.8 + rails + rspec/unit tests + mysql+innodb. It should work with Basecamp ([login to view URL]) account using basecamp API: [login to view URL] We will provide Basecamp account for testing. 1) This software will help as copying timetracking info of basecamp tickets into google spreadsheet/excel. We check each timetracking record manually before copying. 2) Create a page with a form and two input fields: a) basecamp token b) basecamp todo list item URL to parse This URL should match one of four allowed formats: i) [login to view URL] ii) [login to view URL] iii) [login to view URL] iv) [login to view URL] 60882527 - is a todo_list_item id c) submit button. 3) After user submits form a) Extract todo_list_item_id from URL (2.b) using regexps b) Show error message in case of wrong input format c) Make API requests to obtain todo_list_item info and time_entries info. + make essential api requests to obtain person's names etc d) Show error message in case of wrong token/API/http error e) Display html table with a list of timetracking records (person, date, hours, description). f) Display a list of textarea fields. one textarea for each person. With name of person above textarea. Textarea consist of just one line with a line feed in the end. Format of this line: =HYPERLINK("[login to view URL]","TaskA")\t3.33\tCompleted - \t - means tabs. - 3.33 - means hours used. use "." as decimal delimiter. This is a total of hours used by particular person (you will have to sum() it). - "Completed" - a constant value, should be hardcoded in HTML view as we will translate it. - OURSITE - hardcoded - 333333 - project ID - 777777 - todo item ID This textarea will be used for manual copy-paste into Google Spreadsheet 4) All API calls should be done outside controller (move it to lib/ or to model). 5) No design/graphics required. Even no CSS needed. However page should look neat. 6) basecamp API token (2.a) should be saved in cookies. And re-used on next page load. 7) Typical use-case: a) User copies todo item URL into clipboard [login to view URL] using browser function "copy link address/copy link location". b) user paste url into form (2) c) user clicks submit d) user copy-paste text from textarea (3.f) into google spreadsheet.