I need a VB.NET Application that will convert .csv files to various formats via explorer context menu item and sub menu items.
Will also require a packaged installer for the application that will setup the contect menus items and install the app.
## Deliverables
The Program will allow a user to sellect a .csv file or files and/or folders, then using the windows explorer right-click menu, select an conversion format from multiple sub items.
**Contect Menu Items**
There will be 2 main menu items in the explorer contect menu, they? will be 1.) XConvert To >
2.) Open With XConvert
Menu Item 1 Sub items will be:
a.) Excel WorkBook (.xls)
b.)? Text File Tab Delimited? (.txt)
c.)? Text File? Space Delimited? (.txt)
d.) XML File (.xml)
**Contect Menu Command Actions**
Upon selecting any of the above sub items the Xconvert application will launch in momeory only, no gui and convert the file to the selected file format using the default configuration settings for that format, these settings are loaded from the registry and are set first by the installer and then can be modified from within the Xconvert application for each file format.
The converted file(s) are saved to the same path as the source file. if there is a conflict the rename dialog should be shown allowing the user to change the filename and save again.
If Item 2.) Open With XConvert is selected then the XConvert application will be launched and visible to the user.
**XConvert Application**
Once opened the XConvert application will display its main MDI form that contains:
- a Menu bar with standard menu items necessary to interact will the files.
- a Sortable and filterable grid displaying 7 columns (FileName, Path, ConverTo, DestinationPath, File Prefix, File Suffix, Status.
ConverTo? Column - will be a combo box that will select between the output file formats
File Prefix? Column - will allow the user to enter a Text Prefix to add to the converted file filename.
File Suffix? Column - .... to end of converted filename.
DestinationPath Column - will contain a browse button and text entry where the user can choose to browse for a destination or can just paste in a folder path.
Status Column - is used to display whether the file has been converted successfully or not. When Successful the cell will be highlighted Green and the text Complete loaded in the cell.
- At the top under the menu will be 2 option buttons in a groupbar, one will be "Set Individual", and the other "Set Global"
**Set Global**
When Set Global is selected the Grid items are grayed out and disabled and the files convertTo, File PRefix/Suffix and Destiantion Path will be set via the gloabal controls under the option buttons (ComboBox for COnvertTo, Text Boxes for Prefix/Suffix, and Browse Button and text box for selecting the destination folder via save dialog.) These settings will be updated to the default settings in the registry.
**Set Indivdual**
When Set Indivdual The grid items are enabled and each file can have its unique settings selectd from the grid columns, this will not effect the default settings in the registry.
Also with this option selected the user should be able to multi-select rows in the grid and from a right-click menu set the column values directly from? a configuration popup? triggered by the menu.? The configuration popup will have exactly the same settable values and controls as the items under the set global option button, but when the user presses the Apply button on the popup on those rows selected will inherit the settings.
**Convert
**At the bottom of the page will be a Convert,? Clear and Cancel buttons. CANCEL - Selecting Cancel stops the file conversion where is and prompts the user to continue or cancel the conversion. Cancelling the conversion returns the user to the main screen with the current settings.
CLEAR -? Selecting the clear button clears all conversion settings and returns them to the defaults form the registry.
CONVERT - Selecting Convert starts the conversion process a file at a time, converting to the selected format, adding prefix/suffix and saving to destination path.
**Defaults
**The defaults that are set by the installer will be
ConvertTo = Excel Workbook (.Xls)
Prefix/Suffix = Null
Destination Path = Original Path
**Excel Workbook Format
**If the coder cannot show an easy way to convert to this format, then the coder will download the trial verison of Syncfusion XLSIO and use it.