data2SOMEC: Import raw survey data to the SOMEC database.

In RoyChristian/ECSASconnect: Import and export data from the Eastern Canada Seabirds at Sea (ECSAS) and the Suivi des oiseaux en mer de l'est du Canada (SOMEC) databases

Import raw survey data to the SOMEC database.

Description

This function takes an excel file with the data from a mission and imports it into the SOMEC access database.

Usage

data2SOMEC(input,dbpath,prefix,old=FALSE)

Arguments

input	Name and path to the .xlsx file to add to the SOMEC access database.
dbpath	Name and path to the SOMEC access database.
prefix	Name of the prefix used to build the id of a mission. The prefix will be pasted to the start date of the mission to build the id (e.g. "HUD").
old	Logical. TRUE if raw data file has old names, FALSE otherwise.

Details

The new data will be appended to the database, namely to the three tables transects, observations and missions.

Value

Lines are added to the access database.

Author(s)

Francois Rousseu

See Also

new_mission, SOMEC2ECSAS, buildSOMEC

RoyChristian/ECSASconnect documentation built on May 8, 2024, 11:30 a.m.