import sys
import md5

print "--- oase2ics ---"
print "opening CSV file..."
rawData = open(sys.argv[1]).readlines()
print "importing",len(rawData),"appointments"
outputIcs = "BEGIN:VCALENDAR\nVERSION:2.0\nPRODID:-//oase2ics//NONSGML v1.0//EN\n"
rawData.pop(0)
for item in rawData:
    itemParts = item.split(",")
    outputIcs = outputIcs + "BEGIN:VEVENT\n"
    outputIcs = outputIcs + "UID:" + md5.new(item).hexdigest() + "\n"
    startTimeHour = itemParts[2].replace(" ", "").split(":")[0]
    startTimeHour = str((int(startTimeHour[0:2])-2)) + startTimeHour[2:]
    if len(startTimeHour) == 1:
        startTimeHour = "0" + startTimeHour
    startTimeMinute = itemParts[2].replace(" ", "").split(":")[1]
    outputIcs = outputIcs + "DTSTAMP:" + itemParts[0].replace("-", "") + "T" + startTimeHour + startTimeMinute + "00Z\n"
    outputIcs = outputIcs + "DTSTART:" + itemParts[0].replace("-", "") + "T" + startTimeHour + startTimeMinute + "00Z\n"
    endTimeHour = itemParts[3].replace(" ", "").split(":")[0]
    endTimeHour = str((int(endTimeHour[0:2])-2)) + endTimeHour[2:]
    if len(endTimeHour) == 1:
        endTimeHour = "0" + endTimeHour
    endTimeMinute = itemParts[3].replace(" ", "").split(":")[1]
    outputIcs = outputIcs + "DTEND:" + itemParts[0].replace("-", "") + "T" + endTimeHour + endTimeMinute + "00Z\n"
    summary = itemParts[5]
    if "Uren" in summary:
        summary = summary.split("Uren")[0]
    if "Sluitingsdatum" in summary:
        summary = summary.split("Sluitingsdatum")[0]
    outputIcs = outputIcs + "SUMMARY:" + summary[1:6] + " - " + summary[7:-1] + "\n"
    outputIcs = outputIcs + "LOCATION:" + itemParts[4] + "\n"
    outputIcs = outputIcs + "END:VEVENT\n"
outputIcs = outputIcs + "END:VCALENDAR"
newFilePath = sys.argv[1].replace(".csv", ".ics")
outputFile = open(newFilePath, "w")
outputFile.write(outputIcs)
outputFile.close()
print "done, ICS generated"