Small Modifications to Open Source C# Software(repost)
$100-500 USD
Cancelled
Posted almost 14 years ago
$100-500 USD
Paid on delivery
I require a few simple modifications to an open source software package. The software is called ClearCanvas. It is written in C# and developed in Visual Studio 2008. The source code and information on how to compile it can be found at [login to view URL]
## Deliverables
I require a few simple modifications to an open source software package. The software is called ClearCanvas. It is written in C# and developed in Visual Studio 2008. The source code and information on how to compile it can be found at [login to view URL]
I Will Provide:
(1) A full demo of how the application works.
(2) A working VMware virtual machine with the software installed and loaded with test data.
Required Modifications:
(1) Add a column called “Worksheet?? to this screen. If the user has attached a worksheet (see item 2), the row will contain a paper clip icon or something similar to indicate that a worksheet has been attached. If no worksheet has been attached, the row will be blank.
See [login to view URL]
(2) Add an item to the context menu to allow “worksheets?? to be attached to that row in the database. An example of the menu contents is shown below. Each item in the context menu corresponds to an Excel spreadsheet (aka worksheet) that the user can attach to that record in the database. The Excel spreadsheets will be supplied. When the user selects a worksheet from the list, the spreadsheet opens up in Excel, allowing the user to do their edits. When the user saves the Excel spreadsheet, it gets written to a folder on their computer. The folder to write to will be specified in a configuration file.
Add Worksheet
-->Worksheet1
-->Worksheet2
-->Worksheet3
See [login to view URL]
(3) Add “Open Worksheet?? to the context menu. If the row does not have a worksheet attached, Open Worksheet will be grayed out. If the row has a worksheet attached, Open Worksheet will be selectable. Clicking Open Worksheet will open the Excel spreadsheet for editing.
Additional Information:
* After finishing the coding, you will be upload the changes to an SVN repository. I will provide the URL for the SVN repository.
Edit: 2010-06-20
Here's some additional detail for item (2) of the project. I don't think this will increase the complexity of the project - just clarifies how it should work.
Additional Information for item (2):
====================================
Each entry in the context menu corresponds to an Excel template that they user can "attach" to the row. When the user selects an entry from the context menu, the process has to do the following:
(a) Generate a GUID that will be used for the file name (see c).
(b) Create a directory with today's date in the worksheet_target_directory. The directory will be in the format YYYYMMDD. For example, the directory might be c:\worksheet_store\20100620\
(c) Copy the selected Excel template from the template_directory to the directory created in (b). The GUID generated in (a) will be used for the filename. For example, the full file name might be c:\worksheet_store\20100620\[login to view URL]
(d) Store the YYYYMMDD and GUID portion of the file name in the database so that it can be opened for editing later (part 3 of the project). For example, the name stored in the database might be 20100620\97012341234123411.xls.
(e) Open the file created in (c) in Excel.
The solution must support Excel 2003 and Excel 2007.
The application will use an xml configuration file. An example of the configuration file is shown below.
<template_directory>c:\excel_templates\</template_directory>
<worksheet_target_directory>c:\worksheet_store\</worksheet_target_directory>
<worksheets>
<worksheet>
<filename>[login to view URL]</filename>
<menu_title>context menu item 1</menu_title>
</worksheet>
<worksheet>
<filename>[login to view URL]</filename>
<menu_title>context menu item 2</menu_title>
</worksheet>
<worksheet> </worksheet>
</worksheets>