{ "_id": "6a4a1c1f0b5cb829d370858a", "Package": "bcputility", "Type": "Package", "Title": "Wrapper for SQL Server bcp Utility", "Version": "0.4.6", "Authors@R": "person(\"Thomas\", \"Roh\", email = \"thomas.roh@delveds.com\", role = c(\"aut\", \"cre\"))", "Description": "Provides functions to utilize a command line utility that\ndoes bulk inserts and exports from SQL Server databases.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "RoxygenNote": "7.2.3", "SystemRequirements": "bcp Utility", "URL": "https://bcputility.delveds.com,\nhttps://github.com/tomroh/bcputility", "BugReports": "https://github.com/tomroh/bcputility/issues", "Config/pak/sysreqs": "libabsl-dev cmake libgdal-dev gdal-bin libgeos-dev\nlibssl-dev libproj-dev libsqlite3-dev libudunits2-dev", "Repository": "https://tomroh.r-universe.dev", "Date/Publication": "2025-09-06 16:44:51 UTC", "RemoteUrl": "https://github.com/tomroh/bcputility", "RemoteRef": "HEAD", "RemoteSha": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-09 07:16:28 UTC", "User": "root" }, "Author": "Thomas Roh [aut, cre]", "Maintainer": "Thomas Roh ", "_user": "tomroh", "_type": "src", "_file": "bcputility_0.4.6.tar.gz", "_fileid": "https://r2.ropensci.org/cf3a620734a71c9bf3ae83e3fa01d0814acb649975635417670e2941a9f1c35b", "_filesize": 318092, "_sha256": "cf3a620734a71c9bf3ae83e3fa01d0814acb649975635417670e2941a9f1c35b", "_expires": "2026-10-13T08:55:57.000Z", "_created": "2026-06-09T07:16:28.000Z", "_published": "2026-07-05T08:55:59.197Z", "_jobs": [ { "job": 85208661774, "time": 115, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7500960035" }, { "job": 85208661647, "time": 111, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7500959019" }, { "job": 85208661667, "time": 186, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7501190271" }, { "job": 85208661565, "time": 196, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7501185770" }, { "job": 85208661462, "time": 146, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7500923252" }, { "job": 85208661557, "time": 96, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7500953755" }, { "job": 85208661527, "time": 86, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7500950624" }, { "job": 85208661623, "time": 75, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7500947117" }, { "job": 85208661733, "time": 64, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7500943838" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/tomroh/actions/runs/27190148969", "_status": "success", "_upstream": "https://github.com/tomroh/bcputility", "_commit": { "id": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "author": "Thomas Roh ", "committer": "GitHub ", "message": "Merge pull request #36 from tomroh/devel\n\n", "time": 1757177091 }, "_maintainer": { "name": "Thomas Roh", "email": "thomas.roh@delveds.com" }, "_distro": "noble", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.5.0", "role": "Depends" }, { "package": "data.table", "role": "Imports" }, { "package": "sf", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "blob", "role": "Suggests" } ], "_owner": "tomroh", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-36", "n": 2 } ], "_tags": [], "_topics": [ "database", "spatial", "sql", "sqlserver" ], "_stars": 18, "_contributors": [ { "user": "tomroh", "count": 84, "uuid": 6668593 }, { "user": "jtisack", "count": 2, "uuid": 12753178 } ], "_userbio": { "uuid": 6668593, "type": "user", "name": "Thomas Roh", "description": "Data Scientist, Software Developer" }, "_downloads": { "count": 655, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/bcputility" }, "_devurl": "https://github.com/tomroh/bcputility", "_pkgdown": "https://bcputility.delveds.com", "_searchresults": 28, "_rbuild": "4.6.0", "_assets": [ "extra/bcputility.html", "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/tomroh/bcputility", "_realowner": "tomroh", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2021-07-13" }, { "version": "0.2.0", "date": "2021-08-06" }, { "version": "0.3.0", "date": "2022-02-20" }, { "version": "0.4.0", "date": "2023-01-17" }, { "version": "0.4.3", "date": "2024-05-09" }, { "version": "0.4.6", "date": "2025-09-08" } ], "_exports": [ "bcpExport", "bcpImport", "bcpVersion", "checkTableExists", "createTable", "dropTable", "int", "makeConnectArgs", "mapDataTypes", "sqlcmdVersion", "varBinary", "varChar" ], "_help": [ { "page": "bcpExport", "title": "Export data from SQL Server", "topics": [ "bcpExport" ] }, { "page": "bcpImport", "title": "Import data to SQL Server", "topics": [ "bcpImport" ] }, { "page": "createTable", "title": "Create or drop table", "topics": [ "checkTableExists", "createTable", "dropTable" ] }, { "page": "makeConnectArgs", "title": "Create a named list of connection arguments to translate to bcp and sqlcmd options", "topics": [ "makeConnectArgs" ] }, { "page": "mapDataTypes", "title": "Determine SQL Server data types from data frame. Follows SQL Server data type size constraints and chooses the smallest data type size.", "topics": [ "int", "mapDataTypes", "varBinary", "varChar" ] }, { "page": "SQLServerCLIVersions", "title": "Check bcp and sqlcmd versions", "topics": [ "bcpVersion", "sqlcmdVersion", "SQLServerCLIVersions" ] } ], "_pkglogo": "https://github.com/tomroh/bcputility/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/tomroh/bcputility/raw/HEAD/README.md", "_rundeps": [ "class", "classInt", "data.table", "DBI", "e1071", "KernSmooth", "MASS", "proxy", "Rcpp", "s2", "sf", "units", "wk" ], "_score": 4.401400540781544, "_indexed": true, "_nocasepkg": "bcputility", "_universes": [ "tomroh" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.6", "date": "2026-06-09T07:18:26.000Z", "distro": "noble", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/92a400ca42512a2b34b41814a7c7d0dbf2ecc77d0fa240ecd8176450b954408f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/27190148969" }, { "r": "4.6.0", "os": "linux", "version": "0.4.6", "date": "2026-06-09T07:18:23.000Z", "distro": "noble", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/7078365fa9860fd1188c187ab2a2cbfcde90e5543ee55983175714f36776e1db", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/27190148969" }, { "r": "4.5.3", "os": "mac", "version": "0.4.6", "date": "2026-06-09T07:29:53.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/4e5e94650e6abcd69a29504a16bbcc1b6c0c32e86d42ba283dcc7ecd95f6de29", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/27190148969" }, { "r": "4.6.0", "os": "mac", "version": "0.4.6", "date": "2026-06-09T07:29:38.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/6f5152894d511b200f2cea69856694b1b4c57c582884c1788ab9fec831ebe77d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/27190148969" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.6", "date": "2026-06-09T07:18:17.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/9bcc89c4bf9a4d862abae091a2c7f2293e64dca26d21d64f55bc0e46f9038391", "status": "success", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/27190148969" }, { "r": "4.7.0", "os": "win", "version": "0.4.6", "date": "2026-06-09T07:17:54.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/3791160e65ba385de980dc9e4027dc776892e44b607e2ba7f9c3f59db3e2f871", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/27190148969" }, { "r": "4.5.3", "os": "win", "version": "0.4.6", "date": "2026-06-09T07:17:43.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/4184fe17dd90ae0145caef3e94ffdc98f547b1f6784ad5e8e1b8fd71f02cdf82", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/27190148969" }, { "r": "4.6.0", "os": "win", "version": "0.4.6", "date": "2026-06-09T07:17:33.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/cdb14fe293e7d2607916cfb755a98a0c8cccee855933e17b3f9a0b408432de58", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/27190148969" } ] }