Jesper Rønn-Jensen jesperronn

Converting a Word Document to Markdown in One Move

The Problem

A lot of important government documents are created and saved in Microsoft Word (*.docx). But Microsoft Word is a proprietary format, and it's not really useful for presenting documents on the web. So, I wanted to find a way to convert a .docx file into markdown.

Installing Pandoc

On a mac you can use homebrew by running the command brew install pandoc.

The Solution

$ echo 'gem "webpacker"' >> Gemfile
$ bundle install
$ rails webpacker:install
$ yarn add [email protected] jquery popper.js

diff --git a/config/webpack/environment.js b/config/webpack/environment.js
index d16d9af..86bf1a7 100644

Load lib files in production (Rails 5)

If you have your code defined in classes in lib/ folder you may have problems to load that code in production.

Autoloading is disabled in the production environment by default because of thread safety.

Change config/application.rb:

    config.autoload_paths << Rails.root.join("lib")
 config.eager_load_paths &lt;&lt; Rails.root.join("lib")

	1. Dump the data only sql to file
	$ pg_dump --data-only --inserts YOUR_DB_NAME > dump.sql
	2. scp to local

	3. Remove the SET statements at the top
	such as:
	SET statement_timeout = 0;
	SET client_encoding = 'SQL_ASCII';

	4. Remove the setval sequence queries

	/**
	* Caches the return value of get accessors and methods.
	*
	* Notes:
	* - Doesn't really make sense to put this on a method with parameters.
	* - Creates an obscure non-enumerable property on the instance to store the memoized value.
	* - Could use a WeakMap, but this way has support in old environments.
	*/
	export function Memoize(target: any, propertyName: string, descriptor: TypedPropertyDescriptor<any>) {
	if (descriptor.value != null) {

	source: http://www.markbrilman.nl/2011/08/howto-convert-a-pfx-to-a-seperate-key-crt-file/

	`openssl pkcs12 -in [yourfile.pfx] -nocerts -out [keyfile-encrypted.key]`

	What this command does is extract the private key from the .pfx file. Once entered you need to type in the importpassword of the .pfx file. This is the password that you used to protect your keypair when you created your .pfx file. If you cannot remember it anymore you can just throw your .pfx file away, cause you won’t be able to import it again, anywhere!. Once you entered the import password OpenSSL requests you to type in another password, twice!. This new password will protect your .key file.

	Now let’s extract the certificate:

	`openssl pkcs12 -in [yourfile.pfx] -clcerts -nokeys -out [certificate.crt]`

	# Blog post for this: https://medium.com/@sabman/running-rails-5-0-1-postgis-using-docker-compose-2-a0ce5e5fbaba#.j6scfvmw6

	APP_NAME=dockerized-rails
	rails _5.0.1_ new $APP_NAME -d postgresql
	cd $APP_NAME
	mkdir -p containers/development
	RAILS_ENV=development

	# 1. create a Dockerfile for development
	cat > ./containers/development/Dockerfile <<EOF

	APP_NAME=dockerized-rails
	RAILS_ROOT=/usr/app/${APP_NAME}
	RAILS_ENV=production

	cd $APP_NAME

	# Before we start we'll make sure that we have a scaffolded app just to make sure we can test everything is working.

	docker-compose up
	docker-compose run app bundle exec rails generate scaffold post title body:text published:boolean RAILS_ENV=development

	version: 2
	jobs:
	build:
	docker:
	- image: ruby:2.3.3-alpine
	working_directory: /home/circleci/masutaka.net
	steps:
	- setup_remote_docker:
	# https://circleci.com/docs/2.0/docker-layer-caching/
	reusable: true