bex2csv.py

import csv
import glob
import plistlib

clientProject = 'My Project'
for filename in glob.glob("*.bex"):
    root = plistlib.readPlist(filename)
    with open(filename+'.csv', 'wb') as out:
        out = csv.writer(out, delimiter='|')
        out.writerow(['Slip', 'Start', 'End', 'Duration (minutes)'])
        for slip in root.objects:
            slip = dict(slip)
            desc = slip.pop('name')
            who = slip.pop('owner.name')
            timeEntries = slip.pop('timeEntries')

            print who, desc
            print slip
            tags = 'from_billings_app'
            for te in timeEntries:
                date = te.startDateTime.date()
                # For newer versions of python, use this line
                # delta = (te.endDateTime - te.startDateTime).total_seconds()
                delta = (te.endDateTime - te.startDateTime).seconds
                minutes = int(delta/60)
                if minutes>=1:
                    out.writerow([desc, te.startDateTime, te.endDateTime, minutes])