Scott Rohde save point  over 9 years ago

Commit id: a5a049cb7e30841d8e760b7403797ad4c1e097ee

deletions | additions      

       

\end{enumerate}  %% In what follows, the term "field" always refers either to a column name used in the heading of the uploaded CSV file or to an entry in that column in some particular row of the file. On the other hand, and the term "column" may either refer to a column of data in the uploaded CSV file or to an attribute of a trait or yield datum in the traits or yields table of the database. %% ## **Detailed \subsection{Detailed  CSV Data File Specifications**  %% ### **Required fields**:  %% 1. Specifications}  \subsubsection{Required fields}:  \begin{enumerate}  \item  For yields uploads, the only required field is a `yield` \verb|yield|  column. %% 2. \item  For trait uploads, there must be at least one column whose label exactly matches the variable name for the trait value being specified. (Leading and trailing spaces are permitted, but letter case must exactly match the name of the variable specified in the database.) %% ### **Information \end{enumerate}  \subsubsection{Information  that is required but that _may_ \textit{may}  be specified interactively for the entire dataset.**  %% dataset.}  (Data values may be specified interactively only if there is a single value that pertains to the whole data set.) %% #### **Information \subsubsubsection{Information  that references existing database entries**  %% 1. entries}  \begin{enumerate}  \item  Citation %% * \begin{itemize}  \item  If only one citation for the entire dataset exists, it may be specified%%  interactively by choosing a citation on the citations page instead of%%  including citation information in the CSV file. %% * \item  Otherwise, specify the citation in the CSV table, either by doi or by%%  author, year, and title. %% * \item  If a DOI is available for all citations in the data set, the citation%%  corresponding to each row may be specified in a `citation_doi` \verb|citation_doi|  column. In%%  this case, the `citation_author`, `citation_year`, \verb|citation_author|, \verb|citation_year|,  and `citation_title`  %% \verb|citation_title|  columns must not be in the column heading list. (If such information is%%  already included in the data set, to keep such columns for purely%%  informational purposes, the string `-ignore` \verb|-ignore|  may be appended to each of%%  these headings. One might want to do this, for example, to keep a visual%%  record of the author, year, and title even when it is the citation doi%%  that is being used to determine how the data will associated with a%%  citation in the database.) Each value in the `citation_doi` \verb|citation_doi|  column must%%  exactly match the `doi` \verb|doi|  attribute of some row in the `citations` \verb|citations| table  except%%  that case and leading and trailing spaces are ignored. %% * \item  Conversely, if a DOI is not available for all citations in the data set,%%  or if it is preferred to specify the citation by author, year, and title,%%  then the `citation_doi` \verb|citation_doi|  column should _not_ \textit{not}  be included and the columns %% `citation_author`, `citation_year`, \verb|citation_author|, \verb|citation_year|,  and `citation_title` \verb|citation_title|  must all be%%  present. (Again, if some DOI information is already included and you wish%%  to retain it for purely informational purposes, simply give the column%%  some descriptive name other than `citation_doi` \verb|citation_doi|  and it will be ignored by%%  the upload code.) \end{itemize}  %% 2. \item  Site %% * \begin{itemize}  %% \item  If all of the data in the data set pertains to a single site, that site %% may be specified interactively.  %% * \item  Otherwise, a `site` column is required. The value must match an existing %% `sitename` column value in the `sites` table of the database. (Letter  %% case, leading and trailing spaces, and extra internal spaces are ignored  %% when searching for a match.)  %% 3. \end{itemize}  %% \item  Species %% * \begin{itemize}  %% \item  If all of the data in the data set pertains to a single species, that %% species may be specified interactively.  %% * \item  Otherwise, the `species` column is required. The value must match an %% existing `scientificname` column value in the `species` table of the  %% database. (Again, letter case, leading and trailing spaces, and extra  %% internal spaces are ignored when searching for a match.)  %% 4. \end{itemize}  %% \item  Treatment %% * \begin{itemize}  %% \item  If a single treatment and a single citation applies to all of the data in %% the data set, the treatment may be specified interactively provided that  %% the citation is specified interactively as well.  %% * \item  Otherwise, a `treatment` column is required. The value must match an %% existing `name` column value in the `treatments` table of the database.  %% (Again, letter case, leading and trailing spaces, and extra internal  %% spaces are ignored when searching for a match.)  %% \end{itemize}  \end{enumerate}  %% #### **Other information**