Script that generates a flat import descriptor based on the headers of a CSV

generate-import-descriptor.sh

#!/bin/bash
# Generates a flat import descriptor based on the headers of a CSV
FILENAME=$1

if [ ! -e "$FILENAME" ]; then
  echo "Could not find file: $FILENAME"
  exit 1
fi

echo "{"
echo "  name : \"default\","
echo "  families : [ {"
echo "    name : \"info\","
echo "    columns : [ {"

# Loop over fields and put in the relevant description lines
FIRST=true
for x in `head -1 $FILENAME | tr -d '\r' | tr , '\n'`; do
  if [ "$FIRST" != "true" ]; then
    echo  "    }, {"
  fi
  echo  "      name : \"$x\","
  echo  "      source : \"$x\""
  FIRST=false
done
echo "    } ]"
echo "  } ],"

FIRSTFIELD=$(head -1 $FILENAME | sed -e "s/,.*//")
echo "  entityIdSource : \"$FIRSTFIELD\","
echo "  version : \"import-1.0\""
echo "}"