So I just finished an utility that I use for data management and manipulation. I developed it for myself and for the people in our company who works with it, so I thought I'd share it. If anyone finds it useful, great. If anyone doesn't like it, don't use it.
Basically what the utility does is to allow importing data from SQL, Excel, CSV, ODBC, etc. It can import data into multiple tabs or it can be merged into a single grid. From there, the tabs can be exported to Excel files (either a single sheet or a workbook with multiple sheets) or as csv (comma or tab delimited or a custom delimiter). When exporting to csv, the app will automatically remove the delimiter from the content to ensure that the program importing the file, doesn't mess up the columns. The app can even generate SQL Insert and Update statements by mapping columns to SQL Field names. All the tabs and their settings can be saved as a project so that the app can connect to the same data sources as before and retrieve updated data while keeping settings used for generating sql statements for instance.
I've attached some screen prints below.
I uploaded the installation to CNET.
The app requires the .NET Framework 4.0 to run and the installation is completely contained in a single folder (no system files updated). The only registry entries that are created is to create a file association for .PrDmp files which is again cleaned up on uninstall.
http://download.cnet.com/PeopleRes-Data-Manager/3000-2065_4-75932537.html?tag=mncol;1
Basically what the utility does is to allow importing data from SQL, Excel, CSV, ODBC, etc. It can import data into multiple tabs or it can be merged into a single grid. From there, the tabs can be exported to Excel files (either a single sheet or a workbook with multiple sheets) or as csv (comma or tab delimited or a custom delimiter). When exporting to csv, the app will automatically remove the delimiter from the content to ensure that the program importing the file, doesn't mess up the columns. The app can even generate SQL Insert and Update statements by mapping columns to SQL Field names. All the tabs and their settings can be saved as a project so that the app can connect to the same data sources as before and retrieve updated data while keeping settings used for generating sql statements for instance.
I've attached some screen prints below.
I uploaded the installation to CNET.
The app requires the .NET Framework 4.0 to run and the installation is completely contained in a single folder (no system files updated). The only registry entries that are created is to create a file association for .PrDmp files which is again cleaned up on uninstall.
http://download.cnet.com/PeopleRes-Data-Manager/3000-2065_4-75932537.html?tag=mncol;1
Attachments
Last edited: