{
  "_id": "6aedb8809ceaa78f200a1f0d",
  "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-11-06 11:19:02 UTC",
    "User": "root"
  },
  "Author": "Thomas Roh [aut, cre]",
  "Maintainer": "Thomas Roh <thomas.roh@delveds.com>",
  "_user": "tomroh",
  "_type": "src",
  "_file": "bcputility_0.4.6.tar.gz",
  "_fileid": "https://r2.ropensci.org/15c51400cf970f8a2869991f26fbaa2abffb076124ea10dea5f6a830594c580c",
  "_filesize": 318317,
  "_sha256": "15c51400cf970f8a2869991f26fbaa2abffb076124ea10dea5f6a830594c580c",
  "_expires": "2027-02-14T11:22:39.000Z",
  "_created": "2026-11-06T11:19:02.000Z",
  "_published": "2026-11-06T11:22:40.864Z",
  "_upstream": "https://github.com/tomroh/bcputility",
  "_status": "success",
  "_maintainer": {
    "name": "Thomas Roh",
    "email": "thomas.roh@delveds.com"
  },
  "_jobs": [
    {
      "job": 127863923391,
      "time": 98,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13497108901"
    },
    {
      "job": 127863923198,
      "time": 101,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13497698373"
    },
    {
      "job": 127863923288,
      "time": 182,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13497947580"
    },
    {
      "job": 127863923462,
      "time": 182,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13497678599"
    },
    {
      "job": 127862851913,
      "time": 154,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13498117333"
    },
    {
      "job": 127863923402,
      "time": 106,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "13497887571"
    },
    {
      "job": 127863923374,
      "time": 55,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13497569377"
    },
    {
      "job": 127863923431,
      "time": 67,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13497158747"
    },
    {
      "job": 127863923342,
      "time": 56,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13498666322"
    }
  ],
  "_buildurl": "https://github.com/r-universe/tomroh/actions/runs/42209012904",
  "_commit": {
    "id": "bf58d10b916be5797353a10ca635d25fa7e91ad5",
    "author": "Thomas Roh <thmsroh@gmail.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #36 from tomroh/devel\n\n",
    "time": 1757177091
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_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": 476,
    "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.2",
  "_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.401400540781544,
  "_indexed": true,
  "_nocasepkg": "bcputility",
  "_universes": [
    "tomroh"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4.6",
      "date": "2026-11-06T11:20:45.000Z",
      "distro": "resolute",
      "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5",
      "fileid": "https://r2.ropensci.org/400a9e730a852a549670f7112a71a8db17b5716b0c9e1aafa7bf58d416b891f1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tomroh/actions/runs/42209012904"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.4.6",
      "date": "2026-11-06T11:20:49.000Z",
      "distro": "resolute",
      "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5",
      "fileid": "https://r2.ropensci.org/b75a6fe471a34ab949279e74d3b333326788cfe930b9f8cc08c97dcca0043755",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tomroh/actions/runs/42209012904"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4.6",
      "date": "2026-11-06T11:21:35.000Z",
      "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5",
      "fileid": "https://r2.ropensci.org/d8a87516b79c770f0d9b433d58e4da6f169eb9f78dad2d75e88b313db82ca77f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tomroh/actions/runs/42209012904"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.4.6",
      "date": "2026-11-06T11:21:26.000Z",
      "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5",
      "fileid": "https://r2.ropensci.org/f40cf497b39042218ded4a77a8b5fd640d4387812fe8533a7a61639a9cce5936",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tomroh/actions/runs/42209012904"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4.6",
      "date": "2026-11-06T11:20:57.000Z",
      "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5",
      "fileid": "https://r2.ropensci.org/2cda90552e9a211d9cdec2d57e5879a8c590e549456a92f815d9c31f9ebf8a1d",
      "status": "success",
      "buildurl": "https://github.com/r-universe/tomroh/actions/runs/42209012904"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4.6",
      "date": "2026-11-06T11:19:57.000Z",
      "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5",
      "fileid": "https://r2.ropensci.org/f8771837c3310533f8096ca69ae08a3461d6d78853c2b6178ec80863207581df",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tomroh/actions/runs/42209012904"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4.6",
      "date": "2026-11-06T11:20:09.000Z",
      "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5",
      "fileid": "https://r2.ropensci.org/3eb0bc5914d7a716813a906ce69094f3a439e7955e2fd82d8a98997268688e3b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tomroh/actions/runs/42209012904"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.4.6",
      "date": "2026-11-06T11:20:03.000Z",
      "commit": "bf58d10b916be5797353a10ca635d25fa7e91ad5",
      "fileid": "https://r2.ropensci.org/722416c4103222ea1bef8ff0baa1da2d5bcba10b5bb6fe27aa5787c1bfd6738c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tomroh/actions/runs/42209012904"
    }
  ]
}