Read table from Citavi database (via SQL)

read_Citavi_ctv6(path = NULL, CitDBTableName = "Reference")

Arguments

path	Path to the local Citavi project file (.ctv6).
CitDBTableName	Name of the table to be read from the connected Citavi database (via `DBI::dbReadTable()`). Set to "Reference" by default. Shows all table names when set to NULL (via `DBI::dbListTables`).

Value

A tibble

Details

The underlying core functions are DBI::dbConnect() RSQLite::SQLite(), DBI::dbReadTable() and DBI::dbListTables.

Examples

# example Citavi project
example_path <- example_file("3dupsin5refs/3dupsin5refs.ctv6")

# import reference (=default) table
CitDat <- read_Citavi_ctv6(example_path)
CitDat %>% dplyr::select(Title, Year, Abstract, DOI)
#> # A tibble: 5 x 4
#>   Title                        Year  Abstract                       DOI         
#>   <chr>                        <chr> <chr>                          <chr>       
#> 1 More, Larger, Simpler: How ~ 2018  Traditionally, cultivar evalu~ "10.2135/cr~
#> 2 Heritability in Plant Breed~ 2019  In plant breeding, heritabili~ ""          
#> 3 Hritability in Plant Breedi~ 2019  In plant breeding, heritabili~ ""          
#> 4 Heritability in plant breed~ 2019  In plant breeding, heritabili~ "10.1534/ge~
#> 5 Estimating broad-sense heri~ 2019  Broad-sense heritability is d~ "10.2135/cr~

# show table names
read_Citavi_ctv6(example_path, CitDBTableName = NULL)
#>  [1] "Annotation"              "Category"               
#>  [3] "CategoryCategory"        "Changeset"              
#>  [5] "DBVersion"               "EntityLink"             
#>  [7] "Group"                   "ImportGroup"            
#>  [9] "ImportGroupReference"    "Keyword"                
#> [11] "KnowledgeItem"           "KnowledgeItemCategory"  
#> [13] "KnowledgeItemGroup"      "KnowledgeItemKeyword"   
#> [15] "Library"                 "Location"               
#> [17] "Periodical"              "Person"                 
#> [19] "ProjectSettings"         "ProjectUserSettings"    
#> [21] "Publisher"               "RecycleBin"             
#> [23] "RecycleBinConstraint"    "Reference"              
#> [25] "ReferenceAuthor"         "ReferenceCategory"      
#> [27] "ReferenceCollaborator"   "ReferenceEditor"        
#> [29] "ReferenceGroup"          "ReferenceKeyword"       
#> [31] "ReferenceOrganization"   "ReferenceOthersInvolved"
#> [33] "ReferencePublisher"      "ReferenceReference"     
#> [35] "ReferenceTranslator"     "SeriesTitle"            
#> [37] "SeriesTitleEditor"       "TaskItem"