template_array, 'Template Array (tpl)');
$fields = array();
$constants = array();
foreach ($template->template_array as $table => $table_array) {
if (!is_array($table_array)) {
continue;
}
foreach ($table_array['field'] as $field) {
if (preg_match('/table field/', $field['type'])) {
$field['table'] = $table;
$sheet = $field['spreadsheet sheet'];
$column = $field['spreadsheet column'];
$fields[$sheet.'-'.$column][] = $field;
} elseif ($field['type'] == 'constant') {
$field['table'] = $table;
$constants[] = $field;
}
}
}
?>
Constants -These values are applied to all records in the Spreadsheet
| Field Name | Value | Chado Database |
|---|
| Table | Field |
|---|
|
|
|
|
Fields -Below is a mapping between Spreadsheet columns and the Chado Database
| Field Name | Spreadsheet | Chado Datbase |
|---|
| Worksheet | Column | Table | Field |
|---|
|
|
|
|
|