Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

匯入課程資源網的課程 #67

Open
skyhong2002 opened this issue Jan 27, 2023 · 2 comments
Open

匯入課程資源網的課程 #67

skyhong2002 opened this issue Jan 27, 2023 · 2 comments

Comments

@skyhong2002
Copy link
Member

skyhong2002 commented Jan 27, 2023

利用教育部課程資源網匯入三校課程

欄位包含但不限於:

  • 系統序號,建立時間,開課年度,開課學期名稱,級別名,校名,課程名稱,
  • 科系,科系英文名稱,學程,年級,開課老師,學分數,課程大綱,課程連結,備註
  • 男學生修課人數,女學生修課人數,部別_,學制學程_,部校訂_,半全年_,
  • 科目類別_,教學型態_,必選修_,全英語教學_,跨校選修_,系科屬性_,總修課人數,_授課語言,課號,

感覺可能要配合細部資料調一下 Schema
cc @JacobLinCool

@skyhong2002 skyhong2002 converted this from a draft issue Jan 27, 2023
@skyhong2002 skyhong2002 self-assigned this Jan 27, 2023
@skyhong2002
Copy link
Member Author

目前遇到的問題:

  • 課程資料透過 csv 下載時會包含多餘的逗點導致無法順利轉成 course pack
    因為有多餘逗點的儲存格不只有一個,所以我還找不到方法把他們挑出來

@JacobLinCool
Copy link
Member

應該不需要調我們的 schema

多餘訊息可以全部先丟 extra,還是你覺得哪些共同資訊欄位值得拉出 extra 的可以說一下?

@skyhong2002 skyhong2002 removed their assignment Feb 11, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: 🏗 In progress
Development

No branches or pull requests

2 participants