template_array as $priority => $table_array) { if (!is_array($table_array)) { continue; } $table = $table_array['table']; $record = $table_array['record_id']; foreach ($table_array['fields'] as $field) { if (preg_match('/table field/', $field['type'])) { $field['table'] = $table; $field['record'] = $record; $sheet = $field['spreadsheet sheet']; $column = $field['spreadsheet column']; $fields[$sheet.'-'.$column][] = $field; } elseif ($field['type'] == 'constant') { $field['table'] = $table; $field['record'] = $record; $constants[] = $field; } } } ?>

Template Description

**Constants** -These values are applied to all records in the Spreadsheet
Record Name	Field Name	Value	Chado Database
Record Name	Field Name	Value	Table	Field

**Fields** -Below is a mapping between Spreadsheet columns and the Chado Database
Record Name	Field Name	Spreadsheet		Chado Datbase
Record Name	Field Name	Worksheet	Column	Table	Field