Open-source program for VR state agencies
In order to build the Visual Studio, you will need to install 3 NuGet packages in order to build the solution.
Within the RSA911EditChecker project, right-click on the References, and select Manage NuGet Packages.
Search for and install these 3 NuGet packages. Once installed, you should see the following from the Installed tab:
To download the tool, go to the RSA-911 Edit Checker home page and click the blue “Download Now” button.
To start this process, you will need temporary administrator access. Do the following:
Please note: RSA-911 Edit Checker will install a version of SQL 2012 Express to perform the edit checks. The installation of SQL Express may require user account control changes, which may require admin permissions to the workstation. Some IT assistance may be required.
There’s an open-source license end user license agreement (EULA) that must be accepted for installation.
For Chrome browser users, click up arrow and select “Keep”
Then select up arrow and click on “Open”
For Internet Explorer browser users, click “Run”
Run the installation
Accept the EULA
Download required files will take less than 30 seconds.
When you install the RSA-911 Edit Checker for the first time, the installer may upgrade your .NET Framework to v4.6.1 and install SQL Express 2012 if you do not have those tools installed on your workstation.
First-time users will need to install SQL Server 2012 Express, which takes a few minutes.
The installation of SQL Express may require user account control changes, which may require admin permissions to the workstation. IT assistance may be required.
Click “install” and “run” app
Successful download message:
The RSA-911 Edit Checker should now be on your screen (screenshot below)
Note: If this is a first-time install then the RSA edit checks and community checks are automatically installed in your My Documents folder, RSA-911 Edit Checker rules (see screen shot below).
Note: When rules are subsequently updated using the RSA-911 Edit Checker tool, the RSA edit checks and community edit checks are removed and completely replaced. Please don’t make any changes to the RSA edit checks or community checks because your changes will be lost when you choose to update the rules. So, if you would like to add your own reasonableness checks or agency edit checks place them in a separate folder alongside the RSA edit checks and community checks and the tool will find them automatically and will preserve them across future updates of the tool or the rules.
4. Click “Generate Error Report” to see errors identified that will be generated into an Excel file.
A prompt will display asking if you want to generate the error file with no PII (personally identifiable information). The only PII info in the report is the unique identifier.
The default is “no” because you will need this info to resolve your edit checks (see below). Choose yes if you are going to send the report to GitHub for analysis or any other place that’s not secure.
See below for example of an error report, loaded into Excel:
Explanation of items in the options menu:
Update Rules – RSA edit checks and community checks will be completely removed and refreshed with the rules downloaded from the web site.
Export Extract with no PII – Generates an export of the RSA-911 extract with no PII so that it can be sent to GitHub for analysis or any other place that’s not secure.
Help – Navigates to page with FAQs and a setup guide to use the tool (these will be forthcoming in later release).
About – Shows the version of the RSA-911 Edit Checker tool and the version of the RSA-911 Edit Specification used to generate the rules.
License – Navigates to the end user license agreement enacted when you installed the tool.
How do I use the RSA-911 Edit Checker?
Go to the web page and click on download link.
What RSA-911 Edit Specification is being used?
The tool incorporates the latest rules and data validation items. To find the version being used in your software, go to Options –> About and a dialog box will display with your current RSA-911 Edit Specification version number. (see screenshots below)
What RSA-911 Policy Directive is being used?
We generate the rules from the RSA-911 Edit Specification. There could be a RSA-911 Directive change that has not yet been reflected in the RSA-911 Edit Specification. The rules will be updated as the RSA publishes an update to the RSA-911 Edit Specification.
What technical skills are needed to run the tool?
The tool is intended to be run by anyone with access to RSA-911 extract file. Resolving the errors would require a professional with general knowledge of the VR industry.
How do I report an issue?
Email us at RSA911support@RSA911editchecker.com
Or if you have a GitHub account, follow these steps to post an issue, which could be a question, an error that you noticed or an idea for a future enhancement.
How do I modify a rule?
Agencies can modify rules and propose a change that would be accepted by the GitHub moderator. They can propose rules for inclusion into the Community Checks.
How do I add a rule?
Members of the open-source community can propose an additional rule in the GitHub community.
What technical skills are needed to add rules?
Each rule is defined by an XML file. The rule enforcement is accomplished with a SQL query contained within the XML file. To add a rule requires both XML and SQL knowledge. Contributors can reference existing XML and SQL examples with the 817 RSA-911 edit checks, as well as the community checks.
What’s a “reasonableness” check?
It’s a check that identifies outlier data and finds obvious errors, such as a wage that’s over $1,500,000 a year or a participant that’s younger than 12-years old. These checks are intended to improve the integrity of the data and are separate from and not enforced by RSA. These checks can be added or maintained as agency-specific checks, or proposed for community check submission.
What’s a community check?
If an agency believes that a reasonableness check can be used by other agencies it can be proposed to the open-source community. If the open-source community agrees then that reasonableness check is included in the community checks, available to all agencies.
How secure is the RSA-911 Edit Checker with respect to the data?
The RSA 911 Edit Checker tool runs locally on your machine and your data is never sent anywhere else. We have also incorporated the following security protections within the tool to help protect PII while on your desktop.
Is there a workaround for the “SQL Express 2012 not installed” error messaging I’m getting?
Run as an administrator. Do note that the installation does need to occur using the user’s identity and running Internet Explorer as Administrator to provide the installation the enhanced security that it needs.
Please remove the RSA-911 Edit Checker, launch Internet Explorer with right-click so you can run as Administrator, and then run the installation from that Internet Explorer session. This will give you the temporary raised security you need to install SQL Express while also still installing as the user rather than the local administrator.
Is there a workaround for the “What is the EULA agreement” error I’m getting (IT won’t allow the user to push the download button without review first)?
Feel free to pass on the following EULA to the IT department:
This is free and unencumbered software released into the public domain.
Anyone is free to copy, modify, publish, use, compile, sell, or
distribute this software, either in source code form or as a compiled
binary, for any purpose, commercial or non-commercial, and by any
means.
In jurisdictions that recognize copyright laws, the author or authors
of this software dedicate any and all copyright interest in the
software to the public domain. We make this dedication for the benefit
of the public at large and to the detriment of our heirs and
successors. We intend this dedication to be an overt act of
relinquishment in perpetuity of all present and future rights to this
software under copyright law.
THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND,
EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR
OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
OTHER DEALINGS IN THE SOFTWARE.
For more information, please refer to <https://unlicense.org>
Follow these steps in Visual Studio to suggest an improvement to the code. Your suggestion will be reviewed by the community.
Step 1: Create a branch.
Then select Commit All.
Select Sync and then click Push (ensure you are still on your branch)
Your branch will now show up in GitHub online, but you have not yet created a Pull Request for review.
Go online to the github repository: www.github.com. Sign in with your account and click on the RSA911Admin\RSA911Editchecker repository.
You will see your change in “recently pushed branches.” Create a Pull Request.
Enter a comment and click Create Pull Request
You will now see a screen that a review is required. A moderator will review your request.
You will get an email when your Pull Request been reviewed. If there are comments, review them and make the necessary changes and resubmit.
Click on the link from the github email or go back to github.com and go into the repository to view your pull request.
Go back to Visual Studio and manually delete the branch from your local:
Go to Branches. Right click your branch and “Delete.” Delete it from the top section and from underneath remotes/origin.
