knitr::opts_chunk$set( collapse = TRUE, comment = "#>", fig.path = "man/figures/README-", out.width = "100%" )
:construction: :construction: :construction: Package under construction - watch this space for updates :construction: :construction: :construction:
Use sdrUpload to upload Excel spreadsheets from a specified directory to a named database, and move the files to an 'archive' folder.
Install opendatascot from GitHub with:
# install.packages("devtools") devtools::install_github("thomascrines/sdrUpload")
If the above does not work, you can install from source:
install.packages("your/directory/sdrUpload", repos = NULL, type="source", lib = "your/R/package/library/directory")
Write data from Excel sheets contained in a source directory to SDR database tables, and move files to an archive folder:
sdr_upload(source = "C:\\example_source", archive = "C:\\example_archive", database = "DatabaseName", server = "ServerName")
Delete a table from a specified connection:
sdr_delete_table(table = "TableName", database = "DatabaseName", server = "ServerName")
Return a list of tables in a database:
sdr_list_tables(database = "DatabaseName", server = "DatabaseServer")
Return data from a database table:
sdr_list_tables(database = "DatabaseName", server = "ServerName", table = "TableName")
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.