原始匯出 csv 檔案內容如下:

"主旨","開始日期","開始時間","結束日期","結束時間","全天","提醒開啟/關閉","提醒日期","提醒時間","會議召集人","出席者","列席者","會議資源","地點","私人","津貼","帳目資訊","敏感度","描述","優先順序","類別","顯示時間為"
"讀書會本公司專用企業版MSN介紹","2006/11/10","下午 03:30:00","2006/11/10","下午 05:00:00","false","false","2006/11/10","下午 03:15:00",,,,,"","假",,,"普通",,"普通",,"2"
"95/10 KPI績效表計算","2006/11/20","下午 05:00:00","2006/11/20","下午 05:30:00","false","false","2006/11/20","16:45:00",,,,,"","false",,,"普通",,"普通",,"2"

1.用純文字編輯器,切忌使用 Excel 編輯,會把雙引號忽略掉
2.存檔時記得改用 UTF-8 編碼,否則中文會亂碼
3.時間原本的下午或上午改成 24hr 制
4.把所有的 "真" 還有 "假" 改成 "true" or "false"
5.最後把欄位描述改成英文的,內容如下:

"Subject","Start Date","Start Time","End Date","End Time","All day event",,,,,,,,,,,,,"Description",,,,
"讀書會本公司專用企業版MSN介紹","2006/11/10","15:30:00","2006/11/10","17:00:00","false","false","2006/11/10","下午 03:15:00",,,,,"","假",,,"普通",,"普通",,"2"
"95/10 KPI績效表計算","2006/11/20","17:00:00","2006/11/20","17:30:00","false","false","2006/11/20","16:45:00",,,,,"","false",,,"普通",,"普通",,"2"

其他不相干的欄位就算了吧 orz

parrotchang 發表在 痞客邦 PIXNET 留言(0) 人氣()