adamhooper

Demonstrates the effect of dominant baseline for each of its possible values on text positioning in an SVG.

Each browser/ mobile browser seems to handle these a bit differently. Here are some issues:

• Retrieving bounding boxes only works correctly after the font is loaded (and there is no easy way to find out when this happens)
• The bounding box width does not reflect the actual extent of a text, but how far it advances the cursor. That means that in an italic letter 'f' in many fonts, part of the f will actually lie outside of the bounding box
• The baseline-shift style does not work in FF
• dominant-baseline values are interpreted different among browsers

All in all its best just use 'alphabetical' (which is consistent across browsers) and do any further vertical positioning by manually by using the x,y or dx,dy or the transform attributes. Also, if one needs to find out about the actual bounds of a text, one cannot rely on the getBBox() or the getBoundingClientRect() DOM methods, but has to use

adamhooper

1. Download a bunch of PSTs into a directory
2. Download psts-to-files.sh and fiddle-with-rtf-bodies.rb to the same directory
3. Install readpst
4. chmod +x psts-to-files.sh fiddle-with-rtf-bodies.rb
5. Run ./psts-to-files.sh
6. Upload the files directory to www.overviewdocs.com

This works best for <20,000 emails. The scripts convert email messages to RTF to preserve formatting, and Overview can take a while to import all those files.

If you want to handle even more emails, you can upload a CSV. This takes away all attachments -- and occasionally some body text. Here's what to do:

adamhooper

To upload 1M+ emails from Outlook ".pst" files to Overview, you'll need to be comfortable on the command-line.

1. Install LibPFF. On ubuntu, sudo apt-get install pff-tools. On anything else, you'll need to Comple from source.
2. Download this gist's files somewhere
3. cd to the directory where you have a bunch of .pst files
4. Run /path/to/gist/psts-to-pffexports.sh. This will create a bunch of subfolders and files.
5. Run /path/to/gists/pffexports-to-emails-csv.rb. This will create emails.csv.
6. Rename emails.csv to whatever name you want to see in Overview
7. Upload the CSV to Overview

adamhooper

class Account < ActiveRecord::Base
  belongs_to :supplier
end

adamhooper

class Supplier < ActiveRecord::Base
end

adamhooper

require 'net/http'
require 'timeout'
require 'mysql2' # https://github.com/brianmario/mysql2

def download_to_database(url, sql_statement)
  Timeout::timeout(5) do # BUG. Never do this.
    res = Net::HTTP.get_response(url)
    sql_statement.execute(url.to_s, res.code, res.body)
  end
end

adamhooper

require 'net/http'
#require 'timeout'
require 'mysql2' # https://github.com/brianmario/mysql2

def download_to_database(url, sql_statement)
  res = Net::HTTP.start(
    url.host,
    url.port,
    use_ssl: url.scheme == 'https',
    open_timeout: 5,

adamhooper

#!/usr/bin/env python3

import email.message
import mailbox

# Just ignore these lines.
# Python's mbox reader finds a way to return Messages that don't
# have these super-important methods. This hack adds them.
setattr(email.message.Message, '_find_body', email.message.MIMEPart._find_body)
setattr(email.message.Message, '_body_types', email.message.MIMEPart._body_types)

adamhooper

#!/usr/bin/env node
'use strict'

const fs = require('fs')
const util = require('util')

const paths = []
for (let i = 1; i <= 20000; i++) {
  paths.push(`small-files/${i}.txt`)
}

adamhooper

<?xml version="1.0"?>
<!DOCTYPE fontconfig SYSTEM "fonts.dtd">
<fontconfig>
  <dir prefix="default">.</dir>
</fontconfig>