Function buildSheetSuggestedHeaderMappings

src/mapper/utils.ts:28–62

(
  sheet: SheetDefinition,
  csvHeaders: string[]
)

}

function buildSheetSuggestedHeaderMappings(
  sheet: SheetDefinition,
  csvHeaders: string[]
): ColumnMapping[] {
  const mappings: ColumnMapping[] = [];

  csvHeaders.forEach((header) => {
    const foundField = sheet.columns.find((column) => {
      if (!allowUserToMapColumn(column)) {
        return false;
      }

      const keywords = [
        column.id,
        ...(column.suggestedMappingKeywords || []),
      ].map((k) => normalizeValue(k));

      const normalizedHeader = normalizeValue(header);

      return keywords.includes(normalizedHeader);
    });

    if (!foundField) {
      return;
    }

    mappings.push({
      csvColumnName: header,
      sheetId: sheet.id,
      sheetColumnId: foundField.id,
    });
  });

  return mappings;
}

export const buildSuggestedHeaderMappings = (
  sheetDefinitions: SheetDefinition[],