Name: CHRISUpdate
Owner: U.S. General Services Administration
Description: null
Created: 2017-07-19 02:00:26.0
Updated: 2018-03-14 19:29:00.0
Pushed: 2018-05-24 12:44:53.0
Homepage: null
Size: 239
Language: C#
GitHub Committers
User | Most Recent Commit | # Commits |
---|
Other Committers
User | Most Recent Commit | # Commits |
---|
Imports different types of CSV files and inserts data into the database if files exist.
The repository may contains an app config that points to external config files. These external config files not controlled by version control will need to be created and configured prior to running the application. The files required and the default configuration can be found below. For those on the development team, additional details can be found in the documentation on the google drive in the GIT team drive.
Things to do before your first commit
Make a new branch for development. All pre-existing branches are protected and cannot be pushed to directly.
You can publish a new branch and do pull requests to have your changes incorporated into the project.
Once you have created a new branch you will need to create the config files. (see below for more info on this)
Default version of these files are provided in the repo with the .example extension
Copy these files into the project bin\Debug folder and change the extension to .config using the previous filename
Or create new files that contain the code as seen below and place them in the bin\Debug folder
Do not push your config files to the repository. Pull requests that include these files will be rejected.
Current config files that will need to be added.
ConnectionStrings.config
AppSettings.config
Default settings for these files will follow this line
ConnectionStrings.config file should contain the following lines.
nectionStrings>
dd name="GCIMS" connectionString="Server=[IP Address]; Port=[port]; user id=[username]; password=[password];persist security info=True;database=hspd; pooling=true;" providerName="MySql.Data.MySqlClient" />
dd name="HR" connectionString="Server=[IP Address]; Port=[port]; user id=[username]; password=[password];persist security info=True;database=employees; pooling=true;" providerName="MySql.Data.MySqlClient" />
nnectionStrings>
AppSettings.config should contain the following lines.
Settings>
key="KEY" value="REPLACEME" />
key="CHRISFILENAME" value="C:\Temp\chris\smallfile.dat"/> <!-- CHRISData.dat || smallfile.dat -->
key="SEPARATIONFILENAME" value="CHRISGCIMSEXEMPOUT.dat"/> <!-- SeparationData.dat -->
key="ORGFILENAME" value="OrgData.dat"/>
key="LOADPII" value="false"/>
pSettings>
Executable file that pulls files from a file path and inserts the data into a database using the connection string.
Fork this repository, make changes in your fork, and then submit a pull-request, remembering not to upload any system specific configuration files, PII, or sensitive data of any type.
GSA