Removed case sensitivity from Excel imports

We’ve modified the Excel import in BeBanjo to remove case sensitivity. This note describes this change in full, and as usual you can contact support or your Technical Account Manager for further clarification.

Casing matters a lot to computers. For a computer this is different to THIS which is different to This. But for us humans? Well, most of the time we probably just left caps lock on…

This caused headaches with BeBanjo’s Excel import. Previously the Excel import was very particular - if you had a metadata key named (English) Title, your column name had to match the key name exactly. If you were copying and pasting spreadsheets quickly or trying to create columns from memory (rather than from our nifty template!) you might end up not matching the casing. This meant a failed upload and some playing around to find the exact error.

We’ve now relaxed this constraint - as long as you match the key or attribute name in your excel column, we’ll take care of the rest!

References

• movida#8886 Excel import column names are case sensitive