makeHailInRpt: makeHailInRpt

In Maritimes/bio.portsampling: A suite of tools for Port Samplers

makeHailInRpt

Description

This function generates an excel file where the first sheet lists all the groundfish hailins for the current and next day, and the subsequent sheets include breakdowns of the catch.

Usage

makeHailInRpt(
  thePath = file.path("C:", "DFO-MPO", "PORTSAMPLING"),
  fn.oracle.username = "_none_",
  fn.oracle.password = "_none_",
  fn.oracle.dsn = "_none_",
  usepkg = "rodbc"
)

Arguments

thePath	default is C:\DFO-MPO\PORTSAMPLING. This is where you would like your reports saved
fn.oracle.username	default is '_none_' This is your username for accessing oracle objects. If you have a value for this stored in your environment (e.g. from an rprofile file), this can be left and that value will be used. If a value for this is provided, it will take priority over your existing value.
fn.oracle.password	default is '_none_' This is your password for accessing oracle objects. If you have a value for this stored in your environment (e.g. from an rprofile file), this can be left and that value will be used. If a value for this is provided, it will take priority over your existing value.
fn.oracle.dsn	default is '_none_' This is your dsn/ODBC identifier for accessing oracle objects. If you have a value for this stored in your environment (e.g. from an rprofile file), this can be left and that value will be used. If a value for this is provided, it will take priority over your existing value.
usepkg	default is 'rodbc'. This indicates whether the connection to Oracle should use 'rodbc' or 'roracle' to connect. rodbc is slightly easier to setup, but roracle will extract data ~ 5x faster.

Author(s)

Mike McMahon, [e-mail]

See Also

Other Mar.portsampling: makePushButton(), updatePortsampling()

Maritimes/bio.portsampling documentation built on April 19, 2022, 3:20 a.m.