Build Concatenation Function in FIMS

Build a concatenation function on FIMS side which takes various fields from 
spreadsheet and creates output fields that are constructed from the various 
input fields.  

There are two steps here:

1) additions in the configuration file:
Add to configuration file the specification for an OUTPUT attribute column that 
accepts one or more fields as INPUT plus a delimiter.

Some examples of this are

location:
INPUT fields: latitude,longitude OUTPUT location = 
(columns="latitude,longitude" delimiter = “,” required="all")
For location to be meaningful, MUST have both values else location is not 
meaningful so required = "all"

date:
INPUT fields: year, month, day OUTPUT date = (columns="year,month,day" 
delimiter = "-" required="firstinline") 
With possible output constructs like:
YYYY-MM-DD
YYYY-MM
YYYY
For date to be meaningful, must have at least year, but can't do anything if 
there is a month but no year or day and no month, thus "firstinline" rule.

list:
INPUT fields, identificationtype1, identificationtype2 OUTPUT 
identificationtype (columns="idtype1,idtype2" delimiter ="," required="none")
any of these values are useful so required = "none"

So, valid values for required = "all, none, firstinline"

2) Changes in Code, which creates the output fields BEFORE They get put into 
the database.

Original issue reported on code.google.com by jdec...@gmail.com on 7 Jan 2015 at 9:18

biocodellc / biocode-fims

Build Concatenation Function in FIMS #84