Standardizing the formatting of column headers before ingesting a .csv upload
We recently had an issue where due to a capitilization discrepancy PV did not ingest/update a column value in our systems (End Date). PlayVox was expecting the column header "End date" but our sheet had "End Date" instead. This went unnoticed for awhile which ended up causing some SLA issues down the line. W propose PV "standardize" the column headers when parsing the text. For example, doing a simple LOWER() or TRIM() would have eliminated such an error. An added bonus to that would be if PV was somehow able to notify us when expected column headers != what was uploaded. (i.e "Hey! I was expecting the column "End date" but did not find it. Please double-check!")
1
vote
Cecelia Auerswald
shared this idea