# expand csv partslist, replacing unknown fields with data
# from preferred parts list

# Copyright 2015 by Bdale Garbee <bdale@gag.com>, GPL v3

BEGIN { 
	PARTFILE = "../altusmetrum/preferred-parts"
	partcount = 0
	while (getline <PARTFILE > 0) {
		partcount++
		parts[$1, $2, $3] = $0
	}
	FS = ","
}

{
	split(parts[$1,$2,$3],field,"\t")

	printf "\"%s\",\"%s\",\"%s\"", $1, $2, $3

	if ( $4 == "unknown") printf ",\"%s\"", field[4]
	else printf ",\"%s\"", $4

	if ( $5 == "unknown") printf ",\"%s\"", field[5]
	else printf ",\"%s\"", $5

	printf ",\"%s\"", $6

	if ( $7 == "unknown") printf ",\"%s\"", field[6]
	else printf ",\"%s\"", $7

	if ( $8 == "unknown") printf ",\"%s\"", field[7]
	else printf ",\"%s\"", $8

	if ( $9 == "unknown") printf ",\"%s\"", field[8]
	else printf ",\"%s\"", $9

	printf ",%s,\"%s\"\n", $10, $11
}