A configurable Microsoft Windows .NET C# utility application that allows data stewards to automate the cleanup and publishing of multiple Excel datasets at once to Socrata promoting data transparency.
1) User launches executable
2) Winform appears with a checkbox list of reports to select
3) User checks desired reports
4) User clicks Ok
System Functions per report selected:
5) Excel report opened
6) All macros specified in config file for the report is ran
7) If specified in config file, the results are posted to Socrata
Once a macro is defined for an Excel data set, a data steward can clean-up and publish several data sets at once automatically with one click of a button promoting efficiency and transparency.
transparency, .NET, C#, Socrata, quick win
Formal Project Launch
Planned Completion On: