template_array, 'Template Array (tpl)'); $fields = array(); $constants = array(); foreach ($template->template_array as $table => $table_groups) { if (!is_array($table_groups)) { continue; } foreach ($table_groups as $group => $table_array) { foreach ($table_array['field'] as $field) { if (preg_match('/table field/', $field['type'])) { $field['table'] = $table; $field['group'] = $group; $sheet = $field['spreadsheet sheet']; $column = $field['spreadsheet column']; $fields[$sheet.'-'.$column][] = $field; } elseif ($field['type'] == 'constant') { $field['table'] = $table; $field['group'] = $group; $constants[] = $field; } } } } ?>

Template Description

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

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