{ "_id": "6ac63c52f511ae58c09a863b", "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-10-07 10:02:05 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/545d725438649464b32d4aa4367ebbafbdbc9f85a1cfc475c4b6b4840cd4f539", "_filesize": 318334, "_sha256": "545d725438649464b32d4aa4367ebbafbdbc9f85a1cfc475c4b6b4840cd4f539", "_expires": "2027-01-15T12:34:24.000Z", "_created": "2026-10-07T10:02:05.000Z", "_published": "2026-10-07T12:34:25.905Z", "_buildurl": "https://github.com/r-universe/tomroh/actions/runs/37604290904", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 112737247202, "time": 111, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11474935161" }, { "job": 112737247193, "time": 101, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11474247861" }, { "job": 112737247215, "time": 152, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11482092678" }, { "job": 112737247284, "time": 143, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11482515523" }, { "job": 112736069278, "time": 178, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11474192947" }, { "job": 112737247104, "time": 123, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11474361585" }, { "job": 112737247349, "time": 73, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11473689727" }, { "job": 112737247413, "time": 82, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11474018709" }, { "job": 112737247319, "time": 64, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11473789190" } ], "_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": "resolute", "_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": [], "_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", "followers": 28, "description": "Data Scientist, Software Developer" }, "_downloads": { "count": 536, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/bcputility" }, "_devurl": "https://github.com/tomroh/bcputility", "_pkgdown": "https://bcputility.delveds.com", "_searchresults": 29, "_rbuild": "4.6.1", "_assets": [ "extra/bcputility.html", "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_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", "proxy", "Rcpp", "s2", "sf", "units", "wk" ], "_score": 4.416640507338281, "_indexed": true, "_nocasepkg": "bcputility", "_universes": [ "tomroh" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.6", "date": "2026-10-07T10:04:01.000Z", "distro": "resolute", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/046ab1bde105572614c9df63d5ca4fccfc04f2615c47c5bd4441adb98ff7307b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/37604290904" }, { "r": "4.6.1", "os": "linux", "version": "0.4.6", "date": "2026-10-07T10:03:51.000Z", "distro": "resolute", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/f726cb217540d9f000f8d29b00f9e8b0ecd357a32a5d364971b9dcc61225ac8a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/37604290904" }, { "r": "4.5.3", "os": "mac", "version": "0.4.6", "date": "2026-10-07T12:30:49.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/2c6de975f017d69585d01f031a4e6dc308d010d78a5a26f592a40d1873f98b92", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/37604290904" }, { "r": "4.6.1", "os": "mac", "version": "0.4.6", "date": "2026-10-07T12:33:20.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/fbc1761a896c3e50353c118ab5da7737e7ac8f0701bf2005b8a8f82eb733deb2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/37604290904" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.6", "date": "2026-10-07T10:04:18.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/359f4688e5967aa8b222c591d8f6c99d303f2dca92bf3e115b3390076d29775a", "status": "success", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/37604290904" }, { "r": "4.7.0", "os": "win", "version": "0.4.6", "date": "2026-10-07T10:03:17.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/5315259eef728c4538ccf99663f085dc046f4280610cb7b99f483cf770665841", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/37604290904" }, { "r": "4.5.3", "os": "win", "version": "0.4.6", "date": "2026-10-07T10:03:28.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/5c876142f7bf91033ea4f108a202c96a3c87a439f9d7e2d090b1421e781ece33", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/37604290904" }, { "r": "4.6.1", "os": "win", "version": "0.4.6", "date": "2026-10-07T10:03:11.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/5e0747998b6d6193d994d4e577efcf0ac8a1d70ddd8c6728572c37d80b423edd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/37604290904" } ] }