{
  "_id": "6ad1c23ed3c80a766859bd81",
  "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-10-16 06:17:49 UTC",
    "User": "root"
  },
  "Author": "Joachim Zuckarelli [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-9280-3016>)",
  "_user": "jsugarelli",
  "_type": "src",
  "_file": "xml2relational_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/6fe3d925a9812c6f71f7fec763f0f36888421a17e4fc30c3335d281c018495f6",
  "_filesize": 133797,
  "_sha256": "6fe3d925a9812c6f71f7fec763f0f36888421a17e4fc30c3335d281c018495f6",
  "_expires": "2027-01-24T06:20:44.000Z",
  "_created": "2026-10-16T06:17:49.000Z",
  "_published": "2026-10-16T06:20:46.714Z",
  "_buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/38860144352",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 116841239919,
      "time": 100,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12028619491"
    },
    {
      "job": 116841239979,
      "time": 87,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12028717579"
    },
    {
      "job": 116841239922,
      "time": 135,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12028064259"
    },
    {
      "job": 116841240040,
      "time": 97,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12028253814"
    },
    {
      "job": 116840414092,
      "time": 165,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12029181636"
    },
    {
      "job": 116841239957,
      "time": 83,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12028529704"
    },
    {
      "job": 116841239950,
      "time": 67,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12028917888"
    },
    {
      "job": 116841239893,
      "time": 63,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12028098877"
    },
    {
      "job": 116841239959,
      "time": 69,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12028738732"
    }
  ],
  "_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"
  },
  "_distro": "resolute",
  "_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",
    "followers": 20,
    "description": "Follow me on Twitter: @jsugarelli"
  },
  "_downloads": {
    "count": 249,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/xml2relational"
  },
  "_devurl": "https://github.com/jsugarelli/xml2relational",
  "_searchresults": 5,
  "_rbuild": "4.6.1",
  "_assets": [
    "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",
    "extra/xml2relational.html"
  ],
  "_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-10-16T06:19:38.000Z",
      "distro": "resolute",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "https://r2.ropensci.org/fd79397b9bb6ad182d7f89ef4bbb0ef9eb8875bd501941baf209a4b61558996f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/38860144352"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-10-16T06:19:22.000Z",
      "distro": "resolute",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "https://r2.ropensci.org/a1f7416e31270a1d7a0f0b4e76e0fb5e8b41c2ce77de3d356f781c07279b86dd",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/38860144352"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-16T06:20:16.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "https://r2.ropensci.org/eb9044b564a2cad6b73a3fb6836588df57c4d9283a54754fb4bd1a9ab2468609",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/38860144352"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-16T06:19:35.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "https://r2.ropensci.org/fb9cafeccd77a6f69a4ed7e22e9fa9651a40b0bc72f79f297e8371f0a2ace678",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/38860144352"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-10-16T06:19:30.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "https://r2.ropensci.org/a5767204e3ca7305db96e6acbfb1e1100bcc0376fefdfbabd0d31aaae6aa0bf3",
      "status": "success",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/38860144352"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-16T06:18:58.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "https://r2.ropensci.org/5b1d6312676dd75ad86b56c7081905ca638dc947fae28ed2ee9a960eb714cc4b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/38860144352"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-16T06:18:54.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "https://r2.ropensci.org/54369edf22272de2e4db6fe6ef74acb83e1c1bc776c0f44aeb7814b97192f3c4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/38860144352"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-16T06:18:59.000Z",
      "commit": "f8254675ff427566461c6638b55058edc3592a7b",
      "fileid": "https://r2.ropensci.org/04995a15213f55ca1ab1f3124bc4ceaa5e3a5be91d205cacb909fc9e0f83132b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/jsugarelli/actions/runs/38860144352"
    }
  ]
}