{ "_id": "6a104a1aacfb0bcc41c9f9d1", "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-05-10 08:23:31 UTC", "User": "root" }, "Author": "Thomas Roh [aut, cre]", "Maintainer": "Thomas Roh ", "MD5sum": "052c5848da7f76e4b1293576b6e04ca1", "_user": "tomroh", "_type": "src", "_file": "bcputility_0.4.6.tar.gz", "_fileid": "342201ce9dc7d05f0b68cefec84424697ebd58c5eab63cc56d8913c643500dcc", "_filesize": 319703, "_sha256": "342201ce9dc7d05f0b68cefec84424697ebd58c5eab63cc56d8913c643500dcc", "_created": "2026-05-10T08:23:31.000Z", "_published": "2026-05-22T12:20:42.280Z", "_distro": "noble", "_jobs": [ { "job": 77378168747, "time": 110, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6902285375" }, { "job": 77378169134, "time": 109, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6902285151" }, { "job": 77378169177, "time": 74, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6902342132" }, { "job": 77378169046, "time": 91, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6902333991" }, { "job": 77378168310, "time": 145, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6902274363" }, { "job": 77378168431, "time": 97, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7160321801" }, { "job": 77378169096, "time": 88, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6902282973" }, { "job": 77378169176, "time": 71, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6902281560" }, { "job": 77378169146, "time": 264, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6902301319" } ], "_buildurl": "https://github.com/r-universe/tomroh/actions/runs/25623907183", "_status": "success", "_host": "GitHub-Actions", "_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" }, "_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": 680, "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-05-10T08:25:25.000Z", "distro": "noble", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "5716911bcc8fb317e5d115c3dc44fa46a5562ea935449acb080e3709492a0fe9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/25623907183" }, { "r": "4.6.0", "os": "linux", "version": "0.4.6", "date": "2026-05-10T08:25:25.000Z", "distro": "noble", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "2224718375f6da46b5cb7b8609c5779ee94ca54e8b5a5bba2c36fbb2d462a9fa", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/25623907183" }, { "r": "4.5.3", "os": "mac", "version": "0.4.6", "date": "2026-05-10T08:35:16.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "8fd7306057268cd45cb14e62ac941853d123a2c29e8d4052da531181862a3c8e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/25623907183" }, { "r": "4.6.0", "os": "mac", "version": "0.4.6", "date": "2026-05-10T08:33:47.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "cf8c42a8243fd2fb03ad87487868e220929e2c45c8ed0df90091a84db90a98a4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/25623907183" }, { "r": "4.7.0", "os": "win", "version": "0.4.6", "date": "2026-05-10T08:24:58.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "e9a03664f8853b8eef7d0f3ef163a0b66aae8b703b3f5f3c1f0c084688a9793c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/25623907183" }, { "r": "4.5.3", "os": "win", "version": "0.4.6", "date": "2026-05-10T08:24:43.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "0aa9848816a3d3db9f1f3ec807679a0e134717f4c9531c4ea5951c5cc71b70d8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/25623907183" }, { "r": "4.6.0", "os": "win", "version": "0.4.6", "date": "2026-05-10T08:27:54.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "2eec1738fd0b2459f43e7246bd5f6ec3033c4e687c8edf3c5f1fd1cf036555f3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/25623907183" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.6", "date": "2026-05-22T12:20:23.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "ac3c5a928dd077b14ac04591306b1a18903996bdf06203d5181d8506a853c29b", "status": "success", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/25623907183" } ] }