ghidinelli

Here are some helper queries I used to generate a CSV file from Trac (0.12, but probably applicable to any 0.10 or higher build) that could be imported into Pivotal Tracker:

-- Some of the logic is based on https://github.com/hinnerk/Trac2Pivotal which works with sqlite3 Trac instances.  
-- I don't know Python and ours is PostgreSQL based so I rolled these queries instead.

-- in order to make text formatting, headers and a few other key text features work in the Pivotal/Github Markdown, we 
-- create this function which is based on: https://gist.github.com/619537/94091aa59bdf6d6e5ad2fbb063465b2d160156ad
CREATE OR REPLACE FUNCTION public.wiki2markdown(wiki text) RETURNS text LANGUAGE sql AS $function$
SELECT 
	regexp_replace(

ghidinelli

#!/bin/sh

exec 2>&1

echo "Starting ColdFusion 10 cfusion..."

RUNTIME_USER="apache"

export CF_DIR="/opt/coldfusion10/cfusion"