Each "HMIS Coordinated Entry Assessment - [...]" can have its own embedded Assessment. Your Customer Experience team representative will help you set things up correctly, using these correspondences between the FormBuilder setup and what will be in the AssessmentQuestion.csv file:

  Your embedded FormBuilder must have a section label that is used in AssessmentQuestionGroup (Column E) in the AssessmentQuestions.csv. Because this should be unique per Assessment, it cannot use the default label "Section 1."

  If you are importing Assessments, the embedded forms must have a row in AssessmentQuestions.csv with "Assessment Form Name" in the AssessmentQuestionGroup (Column E), and also in the AssessmentQuestion (Column G) columns. The name of the embedded form would be entered in AssessmentAnswer (Column H).

If a field is updated in the source database, all of the other fields on the corresponding csv will be considered updated. For example, if you update a client's Date of Birth in the source database, all demographic fields in the client.csv will be considered updated, and when uploaded or imported into the destination database, all are going to be overwritten to have the values from the upload/import file.

Forms embedded in a completed HMIS Coordinated Entry Assessment have the answers to their questions in the AssessmentQuestions.csv file, and are included in the Assessment.csv and AssessmentResults.csv. 

Forms that are NOT embedded in a completed HMIS Coordinated Entry Assessment are exported in "FB" files that use the following naming convention: FB_[unique number]_[FormBuilder Name].csv.

The User.csv file has to contain each and every user ID that is in any other file. That means it can contain both Foothold Staff IDs (in cases where the last change to the record was done by Foothold Staff, usually in Program.csv or ProgramCoC.csv) and "0" (which is used as a placeholder for those records where the user could not be determined, e.g. because the records are very old). In both cases all the other information is cleared out and the dates default to "today."

This error indicates that the CSV files you have tried to upload have an Export Directive of "1" for "Delta Refresh."  

If you believe you should be authorized to do a "Delta Refresh," please ask your database administrator to contact the Help Desk to request that you be given the HMIS CSV External Uploaders - Delta Refresh permission.

If you believe you should instead be doing a "Full Refresh," please be sure that the Export Directive in your Export.csv file is changed to 2.  

There are four standard CSV files related to Coordinated Entry FormBuilder forms and expected to be in use to meet HUD requirements:

  Event.csv - This file pulls the data on the HMIS Coordinated Entry Event and has one row per record.

  Assessment.csv - This file pulls the data on the HMIS Coordinated Entry Assessment and has one row per record.  This form is a wrapper around an embedded FormBuilder form that contains the actual assessment tool.

  AssessmentQuestions.csv - This file pulls the questions and data from the FormBuilder that is embedded in the HMIS Coordinated Entry Assessment.  It has one row per question per record.

  AssessmentResults.csv - This file pulls the question and data from the Field Transformation question in the embedded FormBuilder for the HMIS Coordinated Entry Assessment.  It has one row per question per record.

Additionally, to upload non-HMIS Coordinated entry forms, a Foothold employee can assist you in setting the forms to Include in HMIS CSV Upload in both databases. You would  then upload using the Full+ export type in order to create a CSV file, which would be named FB_[unique number]_ [FormBuilder Name].csv.  If a database is set to use HMIS Consents and the program is set to "Consumer Choice," then consents are among the FormBuilder csv files that will be included in an upload.

A "Full Refresh" indicates that all records in the specified program will be uploaded to the destination database. "Delta Refresh" gives you the option to upload just records that have had changes, in which case records will not be completely overwritten; instead, only the parts of a client record that have been updated in the source database will be imported into the destination database.

Since multiple assessment results from the same FormBuilder can be included in the export, the field label (or report label, if it is set) will populate on the export in the AssessmentResultType (column E) in the AssessmentResults.csv. Similarly, if importing, you will populate the AssessmentResultType to match what you have as the field label/report label. 

The "Delta Refresh" import or upload includes clients who were active during the Export Start Date / Export End Date date range, plus any clients whose records were edited during the date range (even if they were discharged before the Export Start Date).

Currently, all "Full Refresh" HMIS uploads must have the start date of 10/1/2016 in order to ensure that every program does an upload for all clients that will need to have accurate data in the destination database, covering the same time period as the LSA (the last 3 years). The end date is also not editable at this time; it is set to be today's date for the same reason - so that a complete roster is uploaded. 

Currently, all "Full Refresh" HMIS uploads must have the start date of 10/1/2019 in order to ensure that every program does an upload for all clients that will need to have accurate data in the destination database. The end date is not editable at this time; it is set to be today's date for the same reason - so that a complete roster is uploaded.

If the Full+ export type is turned on in your AWARDS database, it means that you at least sometimes do uploads that involve the Services.csv, or uploads which involve FormBuilder/HMIS Consent csv files, which are included in the Full+ upload. Best practice is to always use the Full+ setting if it is turned on in your database, which is why it is the default export type when available.