if scribus.selectionCount() == 1:

areaname = scribus.getSelectedObject()

position= scribus.getPosition(areaname)

vpos = position[1]

hpos = position[0]

size = scribus.getSize(areaname)

width = size[0]

height = size[1]

scribus.deleteObject(areaname)

return vpos, hpos, width, height

else:

scribus.messageBox("csv2table", "please select ONE Object to mark the drawing area for the table")

"""opens a csv file, reads it in and returns a 2 dimensional list with the data"""

csvfile = scribus.fileDialog("csv2table :: open file", "*.csv")

if csvfile != "":

try:

reader = csv.reader(file(csvfile))

datalist=[]

for row in reader:

rowlist=[]

for col in row:

rowlist.append(col)

datalist.append(rowlist)

return datalist

except Exception, e:

scribus.messageBox("csv2table", "Could not open file %s"%e)

else:

"""takes a 2 dimensional list object and returns the numbers of rows and cols"""

datainfo = dict()

datainfo["rowcount"]=len(list)

datainfo["colcount"]= len(list[0])

""""takes the area and data info and calculates the prper cell size"""

csize=dict()

csize["v"]= areainfo["vsize"] / datainfo["rowcount"]

csize["h"]= areainfo["hsize"] / datainfo["colcount"]

userdim=scribus.getUnit() # get unit and change it to mm

scribus.setUnit(scribus.UNIT_MILLIMETERS)

cellwidthleft = 0

cellwidthright = 0

# Set starting position

hposition = 28

vposition = 20

data = getCSVdata()

di= getDataInformation(data)

ncol = len(data[0])

nrow = len(data)

scribus.messageBox("Table", " " + str(ncol) + " columns, " + str(nrow) + " rows ") #jpg

ColWidthList = []

TableWidth = 0

RowHeightList = []

TableHeight=0

i = 0

for row in data:

if i == 0:

c = 0

for cell in row:

ColWidth = 40

ColWidthList.append(ColWidth)

TableWidth = TableWidth + ColWidth

c = c + 1

RowHeight = 15

RowHeightList.append(RowHeight)

TableHeight = TableHeight + RowHeight

i = i+1

objectlist=[] # here we keep a record of all the created textboxes so we can group them later

i = 0

scribus.progressTotal(len(data))

scribus.setRedraw(False)

rowindex = 0

new_row_indication = 1

new_page_indication = 1

firstorigin_indicator = 1

while rowindex < len(data):

c = 0

origin_cd = data[rowindex][0].strip()

origin = data[rowindex][1].strip()

origin_complete = origin + ' (' + origin_cd + ")"

headerorigin = origin_complete

origin_added = 0

destination_cd = data[rowindex][2].strip()

destination = data[rowindex][3].strip()

destination_complete = destination + ' (' + destination_cd + ")"

fareplan = data[rowindex][4].strip()

fareplan_type = data[rowindex][5].strip()

fareplan_complete = fareplan + ' ' + fareplan_type[:1]

fare = data[rowindex][6].strip()

fare = float(fare)

fare = "{0:.2f}".format(fare)

fare_onboard = data[rowindex][7].strip()

fare_onboard = float(fare_onboard)

fare_onboard = "{0:.2f}".format(fare_onboard)

cellheight_market = 5

cellheight_market_dos = 5

try:

last_origin = data[rowindex - 1][1].strip()

except:

last_origin = origin

try:

last_destination = data[rowindex - 1][3].strip()

except:

last_destination = destination

cellsize = ColWidthList[c]

cellHeight = RowHeightList[i]

# Check to see if near bottom of the page, if so wrap it over

if (vposition > 227):

hposition = hposition + cellsize

vposition = 20

new_row_indication = 1

# If at end, reset and create new page

if (hposition > 174):

scribus.newPage(-1)

hposition = 28

vposition = 20

new_page_indication = 1

firstorigin_indicator = 0

if new_row_indication == 1:

textbox = scribus.createText(hposition, 16, cellsize/2, 4) # create a textbox.

objectlist.append(textbox)

scribus.setStyle('FareplanHeader', textbox)

scribus.insertText('Fareplan', 0, textbox)

c = c + 1

textbox = scribus.createText(hposition+(cellsize/2), 16, cellsize/2, 4) # create a textbox.

objectlist.append(textbox)

scribus.setStyle('FareplanHeader', textbox)

scribus.insertText('Amount', 0, textbox)

c = c + 1

# if (firstorigin_indicator == 1):

# headerorigin = origin_complete

# textbox = scribus.createText(20, 10, cellsize*4, 4) # create a textbox.

# objectlist.append(textbox)

# scribus.setStyle('HeaderOrigin', textbox)

# scribus.insertText(headerorigin, 0, textbox)

# c = c + 1

# Origin textbox

if (rowindex < len(data)):

if ((origin != last_origin) or (rowindex == 0)):

# Add 'btwn' text

textbox = scribus.createText(hposition, vposition, cellsize, 4) # create a textbox.

objectlist.append(textbox)

scribus.setStyle('Headings', textbox) # set it in the style 'Headings' as defined in Scribus.

scribus.insertText('btwn', 0, textbox) # insert the origin into the textbox.

# scribus.setDistances(1,1,1,1) # set the distances.

vposition = vposition + 4 # Shift position of cell down.

c = c + 1

textbox = scribus.createText(hposition, vposition, cellsize, cellheight_market_dos) # create a textbox.

objectlist.append(textbox)

scribus.setStyle('Headings', textbox) # set it in the style 'Headings' as defined in Scribus.

scribus.insertText(origin_complete, 0, textbox) # insert the origin into the textbox.

while (scribus.textOverflows(textbox) > 0):

cellheight_market_dos += 1

scribus.sizeObject(cellsize, cellheight_market_dos, textbox)

vposition = vposition + cellheight_market_dos # Shift position of cell down.

c = c + 1

# Add 'and' text

textbox = scribus.createText(hposition, vposition, cellsize, 4) # create a textbox.

objectlist.append(textbox)

scribus.setStyle('andStyle', textbox) # set it in the style 'andStyle' as defined in Scribus.

scribus.insertText('and', 0, textbox) # insert the origin into the textbox.

vposition = vposition + 4 # Shift position of cell down.

c = c + 1

origin_added = 1

firstorigin_indicator = firstorigin_indicator + 1

# Insert the origin at the top margin

if (firstorigin_indicator == 1 or rowindex == 0):

headerorigin = origin_complete

textbox = scribus.createText(28, 10, cellsize*4, 4) # create a textbox.

objectlist.append(textbox)

scribus.setStyle('HeaderOrigin', textbox)

scribus.insertText(headerorigin, 0, textbox)

c = c + 1

# Destination textbox

if ((destination != last_destination) or (rowindex == 0) or (origin_added == 1)):

textbox = scribus.createText(hposition, vposition, cellsize, cellheight_market) # create a textbox.

objectlist.append(textbox)

scribus.setStyle('Headings', textbox) # set it in the style 'Headings' as defined in Scribus.

scribus.insertText(destination_complete, 0, textbox) # insert the destination into the textbox.

while (scribus.textOverflows(textbox) > 0):

cellheight_market += 1

scribus.sizeObject(cellsize, cellheight_market, textbox)

vposition = vposition + cellheight_market # Shift position of cell down.

c = c + 1

rowindex = rowindex + 1

# Fareplan textbox

fareplan_box_height = 5

if fare_onboard != '0.00':

fareplan_box_height = 10

textbox = scribus.createText(hposition, vposition, cellsize/2, fareplan_box_height) # create a textbox.

objectlist.append(textbox)

scribus.insertText(fareplan_complete, 0, textbox) # insert the fareplan into the textbox.

hposition = hposition+(cellsize / 2) # Shift position of cell right.

c = c+1

# Fare textbox

textbox = scribus.createText(hposition, vposition, cellsize/2, 5) # create a textbox.

objectlist.append(textbox)

scribus.insertText(fare, 0, textbox) # insert the fare into the textbox.

c = c+1

if fare_onboard != '0.00':

vposition = vposition + 5 # Shift position of cell down.

textbox = scribus.createText(hposition, vposition, cellsize/2, 5) # create a textbox.

objectlist.append(textbox)

scribus.setStyle('OnBoard', textbox)

scribus.insertText(fare_onboard, 0, textbox) # insert the fare into the textbox.

hposition = hposition - (cellsize / 2) # Shift position of cell back.

vposition = vposition + 5 # Shift position of cell down.

c = c+1

else:

hposition = hposition - (cellsize / 2) # Shift position of cell back.

vposition = vposition + 5 # Shift position of cell down.

i = i+1

new_row_indication = 0

new_page_indication = 0

scribus.deselectAll()

scribus.groupObjects(objectlist)

scribus.progressReset()

scribus.setUnit(userdim) # reset unit to previous value

scribus.docChanged(True)

scribus.statusMessage("Done")

"""The main_wrapper() function disables redrawing, sets a sensible generic

status bar message, and optionally sets up the progress bar. It then runs

the main() function. Once everything finishes it cleans up after the main()

function, making sure everything is sane before the script terminates."""

try:

scribus.statusMessage("Importing .csv table...")

scribus.progressReset()

main(argv)

finally:

# Exit neatly even if the script terminated with an exception,

# so we leave the progress bar and status bar blank and make sure

# drawing is enabled.

if scribus.haveDoc() > 0:

scribus.setRedraw(True)

scribus.statusMessage("")