Open Design Engine

#!/usr/bin/env python

#Converts a Google Spreadsheet that's been downloaded in CSV 

#format to Redmine's table format. The output is sent to STDOUT.

#File: googleSheetConvert.py

#License: Apache 2.0

import sys

#Check to make sure we got the right number of arguments

if (len(sys.argv) == 2):

    #Assume that the file name is the 1st argument (no checks)

    fileName = sys.argv[1]

else:

    print "Usage: googleSheetConvert.py CSV_FILE" 

    quit()

#Line counter variable

lineCounter = 0

#Holds the edited line

editedLine = ""

#Step through the lines of the file

with open(fileName) as f:

    for line in f:

        #Check to see if this is the first (header) line

        if (lineCounter == 0):

            #Make sure the headers end up in bold

            editedLine = line.replace(",", "|_.")

            #Mark the beginning and the end of the line

            editedLine = "|_." + editedLine

            editedLine = editedLine.replace("\n", "|") 

            print editedLine

        else:

            #Delimit the columns

            editedLine = line.replace(",", "|")

            #Mark the beginning and end of the line

            editedLine = "|" + editedLine

            editedLine = editedLine.replace("\n", "|")

            print editedLine

        lineCounter += 1