zackbatist

# install and run packages
# install.packages("bib2df")
# install.packages("rcrossref")
library(bib2df)
library(rcrossref)

# import the bibtex to a data frame
# biblio.bib is a file in the working directory
df <- bib2df("biblio.bib")

zackbatist

/**
 * getHex.gs
 * =getHex(cell("address",A1)) returns hex code for background colour of cell A1
 * taken from https://stackoverflow.com/questions/28962526/google-spreadsheets-sort-filter-by-background-fill
 */

function getHex(input) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var cell = ss.getRange(input);
  var result = cell.getBackground();

zackbatist

#QueryInputs is a list or dataframe containing selectInput values
#We would just have to update the QueryInputs object and then re-run QueryResults to refresh the output and regenerate the table (I hope)
QueryResults <- function(QueryInputs) {
  Level2 <- dbReadTable(pool, 'level2')
  filtered <- Level2
  if (!is.null(QueryInputs$Locus)) {
    filtered <- filtered %>% filter(Locus %in% QueryInputs$Locus)
  }
  if (!is.null(QueryInputs$Blank)) {

zackbatist

• Instructor Training
• University of Toronto Libraries
• July 18-19, 2019
• 9:00 am - 4:30 pm
• Instructors: Greg Wilson, Cam Macdonell
• Website: https://cmacdonell.github.io/2019-07-18-ttt-UTL/
• Etherpad: https://pad.carpentries.org/2019-07-18-ttt-UTL
• Code of Conduct: https://docs.carpentries.org/topic_folders/policies/code-of-conduct.html

Personas

zackbatist

These notes are meant to document the processes through which I migrate data from MaxQDA 2020 to a Neo4j graph database.

Some of these processes depend on certain coding conventions when marking up documents in MaxQDA, which will be documented elsewhere soon.

Some processes documented here generated results that needed to be hand-edited, and therefore this is not meant to be used as an aide for reproducible research. Instead, it is a series of processes that I'm sharing in case others might find them useful.

Migrating the code system

Creating nodes from codes

Export a table with all codes.

zackbatist

Prepare textfile with codes marked up as html tags (<>)

This is a proposed workflow for exporting a MAXQDA document as html with semantic tags, inspired by Anselm (https://github.com/edsu/anselm). Once it's all formatted as text it will presumably be much easier to work with.

A significant challenge that this is meant to resolve is that MAXQDA does not export character-level positions of codings, only paragraph-level positions. But it stores this info in the database, I just have to get it out and assign it to the relevant parts of the text.

I need to consult with someone who is more knowledgable with CSS to design better tag templates that would allow tags to be formatted according to custom styles. For example, the ID schema may be used to apply style to sets of codes based on their semantic position in the code tree. Some ideas to check out:

• Include all parental codes in the code name, so instead of:

``