Add Survey.type to bulk import

[holmbergius]

Is your idea related to a problem? Please describe. Giraffe Conservation Foundation requested the addition of Survey.type to the bulk import. The field already exists in the database and is supported on the Survey object.

Describe the solution you'd like Allow Survey.type to be an importable column in the bulk import spreadsheet.

NOTE: Survey support in the bulk import is often reflected on the Occurrence object. Further questions need to be asked before this ticket is started.

• In which database field will this data be stored?
• Does this field need to be searchable via Occurrence Search and/or Encounter Search?

Describe alternatives you've considered Historically, GCF has been putting this in Survey.id, which it is not a good fit for.

Additional context NA

[naknomum]

@holmbergius there is currently this field on Occurrence:

String fieldSurveyCode; // i.e. project-specific sighting no. (redundant w/ id, or is that UUID?o)

perhaps this is the right place for it to go?

there already exists ways to populate this via bulk import, however, it seems that one of these is Survey.id which is called "not a good fit" above. so i am guessing this is not where we want this to end up.

        String fieldSurveyCode = getStringOrInt(row, "Survey.id", colIndexMap, verbose,
            missingColumns, unusedColumns, feedback);
        if (fieldSurveyCode == null)
            fieldSurveyCode = getString(row, "Occurrence.fieldSurveyCode", colIndexMap, verbose,
                missingColumns, unusedColumns, feedback);
        if (fieldSurveyCode != null) occ.setFieldSurveyCode(fieldSurveyCode);