: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.