{ "_id": "6a4f4c8d21b18e1548500499", "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-07-09 07:19:21 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/f090abef1223b08d86209e4e3f2c1d54ce61d6273d4dff467720afd28f85c235", "_filesize": 321253, "_sha256": "f090abef1223b08d86209e4e3f2c1d54ce61d6273d4dff467720afd28f85c235", "_expires": "2026-10-17T07:23:55.000Z", "_created": "2026-07-09T07:19:21.000Z", "_published": "2026-07-09T07:23:57.305Z", "_jobs": [ { "job": 86061882259, "time": 116, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8191659883" }, { "job": 86061882261, "time": 117, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8191660032" }, { "job": 86061882240, "time": 212, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8191681714" }, { "job": 86061882263, "time": 169, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8191675338" }, { "job": 86061392081, "time": 176, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8191617650" }, { "job": 86061882212, "time": 121, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8191661131" }, { "job": 86061882222, "time": 71, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8191644144" }, { "job": 86061882252, "time": 84, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8191649748" }, { "job": 86061882276, "time": 64, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8191641916" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/tomroh/actions/runs/29001005998", "_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": "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": [ { "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", "followers": 28, "description": "Data Scientist, Software Developer" }, "_downloads": { "count": 695, "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/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE", "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.416640507338281, "_indexed": true, "_nocasepkg": "bcputility", "_universes": [ "tomroh" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.6", "date": "2026-07-09T07:21:27.000Z", "distro": "resolute", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/0ad580aa3e0799a94b259e91854a1408cb360ed1919978a01f6f9e42f470d98d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/29001005998" }, { "r": "4.6.1", "os": "linux", "version": "0.4.6", "date": "2026-07-09T07:21:26.000Z", "distro": "resolute", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/999f0196e749aa77aa9a717b091b07b8d7d5b066f68c45af72446f76b659bf67", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/29001005998" }, { "r": "4.5.3", "os": "mac", "version": "0.4.6", "date": "2026-07-09T07:22:32.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/7d3baf0ab5f4922410925cef8be6f7ab9f0b1e5d73f070ca11a899e11ee0355f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/29001005998" }, { "r": "4.6.1", "os": "mac", "version": "0.4.6", "date": "2026-07-09T07:22:12.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/e5be92847814a775b03b4d60f994ec99f9fe6a1b493a48c7d183d2f7d19c2687", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/29001005998" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.6", "date": "2026-07-09T07:21:41.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/743e349db6b8ffda5642bec524bd420bad1ed3c4a27576966895de806059bd42", "status": "success", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/29001005998" }, { "r": "4.7.0", "os": "win", "version": "0.4.6", "date": "2026-07-09T07:20:34.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/8d21e79e949f145b968e858f261449f4ab90c52dd1047ae319b331437c84e640", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/29001005998" }, { "r": "4.5.3", "os": "win", "version": "0.4.6", "date": "2026-07-09T07:20:54.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/d7ba446ed147731c30aad3a4458aec9580bc66a107298ef1d73f727de5e321bd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/29001005998" }, { "r": "4.6.1", "os": "win", "version": "0.4.6", "date": "2026-07-09T07:20:31.000Z", "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5", "fileid": "https://r2.ropensci.org/c25b5e81311c92d7f3e1e72fd113264538a9474055e9c7ba199758409c6595f2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomroh/actions/runs/29001005998" } ] }