search

abtassociates / eva

Eva is a HUD application to aid HMIS Leads with data analysis. It is an open-source project intended for local use by HMIS Administrators in Continuums of Care (CoCs) around the U.S. and its territories.
GNU Affero General Public License v3.0
14 stars 4 forks source link

Current Living Situation NULL Request #459

Closed RogelinaL closed 10 months ago

RogelinaL commented 10 months ago

Hello,

When attempting to upload into EVA, the following error prevents us from using EVA to review overall DQ issues.

Issue: Nulls not allowed or incorrect data type Type: Error Guidance: Either there is a column with nulls where they are not allowed, or there is a column with an incorrect data type. Please take a look at the HMIS CSV Format Specifications for the data types and null requirements associated with the file and column listed in the detail and make the necessary updates. Detail: The CurrentLivingSituation column in the CurrentLivingSituation file contains nulls or incorrect data types.

We have identified approximately 150 cases categorized as NULL for this particular issue. It would be helpful if we could still upload these cases to see other Data Quality (DQ) issues related to measure outcomes. Specifically, we would like to know if the current living situation can be included as a field allowing null values. This will help us provide DQ guidance, and complete thorough system measure quality plans with our partnered agencies. Most HMIS reporting requirements involve specific outcome measures that do not require current living situation data but are more outcome-focused.

We have been using other reports in our HMIS, such as APR/Audit/ReportWriter, to complete the DQ review and action plan and resolve LSA issues. Our current vendor has extended their projection date of updating these reports to the FY2024 Data Standards, so we would like to incorporate EVA into our analysis process.

We understand this may not be possible, but we wanted to ask in case it is. We appreciate your support and guidance on this matter!

Best Regards, Ro with Fresno&Madera COC HMIS Team

kiadso commented 10 months ago

Hi @RogelinaL

While you are waiting on your vendor to correct their export, you may delete all the rows in CurrentLivingSituation.csv that contain nulls in CurrentLivingSituation. If you choose to do so, be sure that when you open the csv, you are opening it in a text editor, and not in Excel. Once you've made the deletions, you can zip the files and use the new zip file to upload to Eva.

Thanks- Eva dev team