{
  "_id": "6a1817a3acfb0bcc41daff7a",
  "Package": "xml2relational",
  "Type": "Package",
  "Title": "Converting XML Documents into Relational Data Models",
  "Description": "Import an XML document with nested object structures and\nconvert it into a relational data model. The result is a set of\nR dataframes with foreign key relationships. The data model and\nthe data can be exported as SQL code of different SQL flavors.",
  "Version": "0.1.0",
  "Authors@R": "person(\"Joachim\", \"Zuckarelli\", role = c(\"aut\", \"cre\"), email = \"joachim@zuckarelli.de\", comment = c(ORCID=\"0000-0002-9280-3016\"))",
  "Maintainer": "Joachim Zuckarelli <joachim@zuckarelli.de>",
  "License": "GPL-3",
  "BugReports": "https://github.com/jsugarelli/xml2relational/issues",
  "URL": "https://github.com/jsugarelli/xml2relational/",
  "Encoding": "UTF-8",
  "ByteCompile": "true",
  "RoxygenNote": "7.1.0",
  "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libxml2-dev",
  "Repository": "https://jsugarelli.r-universe.dev",
  "Date/Publication": "2022-02-10 19:03:31 UTC",
  "RemoteUrl": "https://github.com/jsugarelli/xml2relational",
  "RemoteRef": "HEAD",
  "RemoteSha": "f8254675ff427566461c6638b55058edc3592a7b",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-28 10:20:24 UTC",
    "User": "root"
  },
  "Author": "Joachim Zuckarelli [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-9280-3016>)",
  "MD5sum": "04362b44bf5a3fc1df64d4b25a53717a",
  "_user": "jsugarelli",
  "_type": "src",
  "_file": "xml2relational_0.1.0.tar.gz",
  "_fileid": "c3a364283b998989d20e7036f64b909dafd77cf832b212f60e8d501b6555a5da",
  "_filesize": 131477,
  "_sha256": "c3a364283b998989d20e7036f64b909dafd77cf832b212f60e8d501b6555a5da",
  "_created": "2026-05-28T10:20:24.000Z",
  "_published": "2026-05-28T10:23:31.502Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78270665629,
      "time": 136,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7263439894"
    },
    {
      "job": 78270665666,
      "time": 139,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7263440839"
    },
    {
      "job": 78270665612,
      "time": 91,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7263427251"
    },
    {
      "job": 78270665595,
      "time": 69,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7263420798"
    },
    {
      "job": 78270190517,
      "time": 188,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7263399385"
    },
    {
      "job": 78270665604,
      "time": 102,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7263430224"
    },
    {
      "job": 78270665623,
      "time": 79,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7263423319"
    },
    {
      "job": 78270665766,
      "time": 65,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7263419617"
    },
    {
      "job": 78270665763,
      "time": 62,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7263418879"
    }
  ],
  "_buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/26568751370",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/jsugarelli/xml2relational",
  "_commit": {
    "id": "f8254675ff427566461c6638b55058edc3592a7b",
    "author": "Joachim Zuckarelli <38797219+jsugarelli@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #2 from DavisVaughan/fix/replace-na-double-to-character\n\nReplace with `\"0\"` not `0`, since the columns are always character",
    "time": 1644519811
  },
  "_maintainer": {
    "name": "Joachim Zuckarelli",
    "email": "joachim@zuckarelli.de",
    "login": "jsugarelli",
    "twitter": "@jsugarelli",
    "description": "Follow me on Twitter: @jsugarelli",
    "uuid": 38797219,
    "orcid": "0000-0002-9280-3016"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.5.0",
      "role": "Depends"
    },
    {
      "package": "xml2",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "fs",
      "role": "Imports"
    },
    {
      "package": "stats",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    }
  ],
  "_owner": "jsugarelli",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_topics": [
    "relational-database",
    "relational-model",
    "sql",
    "xml",
    "xml-serialization"
  ],
  "_stars": 11,
  "_contributors": [
    {
      "user": "jsugarelli",
      "count": 3,
      "uuid": 38797219
    },
    {
      "user": "davisvaughan",
      "count": 1,
      "uuid": 19150088
    }
  ],
  "_userbio": {
    "uuid": 38797219,
    "type": "user",
    "name": "Joachim Zuckarelli",
    "description": "Follow me on Twitter: @jsugarelli"
  },
  "_downloads": {
    "count": 176,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/xml2relational"
  },
  "_devurl": "https://github.com/jsugarelli/xml2relational",
  "_searchresults": 5,
  "_rbuild": "4.6.0",
  "_assets": [
    "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",
    "extra/xml2relational.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/jsugarelli/xml2relational",
  "_realowner": "jsugarelli",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2020-05-11"
    },
    {
      "version": "0.1.1",
      "date": "2022-02-10"
    }
  ],
  "_exports": [
    "getCreateSQL",
    "getInsertSQL",
    "savetofiles",
    "toRelational"
  ],
  "_help": [
    {
      "page": "getCreateSQL",
      "title": "Exporting the relational data model and data to a database",
      "concept": [
        "xml2relational"
      ],
      "topics": [
        "getCreateSQL"
      ]
    },
    {
      "page": "getInsertSQL",
      "title": "Exporting the relational data model and data to a database",
      "concept": [
        "xml2relational"
      ],
      "topics": [
        "getInsertSQL"
      ]
    },
    {
      "page": "savetofiles",
      "title": "Saving the relational data",
      "concept": [
        "xml2relational"
      ],
      "topics": [
        "savetofiles"
      ]
    },
    {
      "page": "toRelational",
      "title": "Converting an XML document into a relational data model",
      "concept": [
        "xml2relational"
      ],
      "topics": [
        "toRelational"
      ]
    },
    {
      "page": "xml2relational",
      "title": "Package 'xml2relational'",
      "topics": [
        "xml2relational"
      ]
    }
  ],
  "_readme": "https://github.com/jsugarelli/xml2relational/raw/HEAD/README.md",
  "_rundeps": [
    "cli",
    "cpp11",
    "dplyr",
    "fs",
    "generics",
    "glue",
    "lifecycle",
    "lubridate",
    "magrittr",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "utf8",
    "vctrs",
    "withr",
    "xml2"
  ],
  "_score": 3.7403626894942437,
  "_indexed": true,
  "_nocasepkg": "xml2relational",
  "_universes": [
    "jsugarelli"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-05-28T10:22:48.000Z",
      "distro": "noble",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "28b750aeb65e5914bff3f18d1086be728364bdfaf7c47b552e25d77d62b29996",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/26568751370"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-05-28T10:22:51.000Z",
      "distro": "noble",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "14956b8c5f579d93abb0d2f6369fec358c3d965f5e33c3cd895d076c6cb9da98",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/26568751370"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-05-28T10:22:07.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "18183b3e6aa81e927102efa7a4a944bcd68086f3e573fbc6549bcf185904cc21",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/26568751370"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-05-28T10:21:46.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "ce8f9dae6c40c7e24c87ee88d5579f0ec10f1d6c68ac76b5bca86ab7d4b0efb3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/26568751370"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-05-28T10:22:25.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "bc7db1a05236cabc3259a15dcce7db63e5251fe7e13970eb68b1d23b0b22e0bc",
      "status": "success",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/26568751370"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-05-28T10:21:47.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "36b03eb2cc6b6c588c10fc7329e56ef29f7ace76c924de3d0a1b39295f0a384e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/26568751370"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-05-28T10:21:35.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "f5ce29d589194c07203270c3de9398ff2fa9244a7601665ff1fc73e803f47e28",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/26568751370"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-05-28T10:21:32.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "ed8d9941a7a2f690297cd946165a877408b7bdb33cf23800245a2bfd5722d643",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/26568751370"
    }
  ]
}