All functions

averyLabel()

Generate labels for avery products

checkAlias()

Get index id by name.

createBarcode()

Create labels with barcode

dbAddDesigns()

Add design for a trial

dbAddFertilization()

Insert or Update fertilization into expDB

dbAddGene()

Add gene information into database

dbAddGeneAllele()

Add gene allele information into database

dbAddGenotype()

Add genotypes into expDB

dbAddIrrigatons()

Insert or Update irrigation into expDB

dbAddLog()

Add log from expDB

dbAddMethods()

Insert or Update methods into expDB

dbAddMets()

Insert and update met into expDB

dbAddNodes()

Add nodes into expDB

dbAddPhenotype()

Add design for a trial

dbAddResearcher()

Insert and update researcher into expDB

dbAddSites()

Insert or update site into expDB

dbAddSource()

Insert and update source into expDB

dbAddTraits()

Insert or update trait into expDB

dbAddTrialSoil()

Add soil for a trial

dbAddTrials()

Insert or Update trial into expDB

dbAddWeather()

Add weather records into expDB

dbAppendTable()

Append a table into db and check the column name

dbExportMet()

Export trials weather records to met file

dbGenotypeCheckName()

Check genotype names

dbGetDBName()

Get the database file name

dbGetDryWeightPerStem()

Get the dry weight per stem

dbGetFertilization()

Get fertilization from database

dbGetFieldMaturity()

Estimation of maturity

dbGetFieldPopulation()

Estimation of plant populations

dbGetFieldStemNumber()

Estimation of stem number per unit area

dbGetFieldTillerNumber()

Estimation of tiller number per unit area

dbGetGene()

Get the gene information

dbGetGenotype()

Get the genotype information

dbGetIrrigation()

Get irrigation from database

dbGetLog()

Get log from expDB

dbGetMetInfo()

Get met information

dbGetOrganFinalLeafNumber()

Get the final leaf number

dbGetOrganHaunIndex()

Get Haun Index

dbGetPhenotype()

Get phenotype values through a group of conditions

dbGetPhenotype_()

Get phenotype values through a group of conditions

dbGetPlantFlowering()

Estimation of flowering time

dbGetPlantHeading()

Estimation of heading time

dbGetPlantStemElongation()

Estimation of stem elongation

dbGetPlantStemNumber()

Estimation of stem number per plant

dbGetPlantTillerNumber()

Estimation of tiller number per plant

dbGetSites()

Get site into expDB

dbGetSource()

Get source from expDB

dbGetStemTillerNumber()

Estimation of stem/tiller number per unit area or plant

dbGetTraits()

Get trait list

dbGetTreatmentColumns()

Get the unique columns for a treatment

dbGetTrials()

Get trials by a groups of conditions.

dbGetWeather()

Get weather records from expDB

dbGetZadoksStage()

Obtain the key phenology stage

dbImportXLSX()

Import data from excel file

dbInsertUpdateByRow()

Insert new rows or update existing rows to a specific table according to a specific column (unique) by each row

dbListTrials()

List all trials

defaultMeasurement()

Import a normal measurement

expdbConnect()

Connect to expDB

expdbCreateDB()

create to expDB

expdbDisconnect()

Didconnect to expDB

generateName()

Generate unique name with digest method

getAlias()

Alias of column names

getIdByUniqueIndex()

Get index id by unique_columns.

harvestQuadratDetail()

Process quadrat (detail) harvestQuadratDetail

measurementLeafSize()

Import the measurement of leaf size

sqlIn()

Paste a vector to format used for SQL in

system_file()

#' Write tables into xlsx files #' #' @param file The xlsx file #' @param ... Pairs of table and values #' @export write2Xlsx <- function(file, ...) tbls <- list(...) sheet_name <- names(tbls) newWB <- XLConnect::loadWorkbook(filename = file, create = TRUE) for(i in seq(along = tbls)) XLConnect::createSheet(newWB, name = sheet_name[i]) writeWorksheet( newWB, data = as.data.frame(tbls[[i]]), sheet = sheet_name[i], header = TRUE, rownames = NULL) saveWorkbook(newWB) System based file path

xlsxToR()

Read xlsx files

yearDay2Date()

Convert year and day of year to date