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.

Sign up for GitHub

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

Jump to bottom

8. 資料匯出 #29

Closed
3 tasks
trashmai opened this issue Nov 21, 2018 · 3 comments
Closed
3 tasks

8. 資料匯出 #29

trashmai opened this issue Nov 21, 2018 · 3 comments
Assignees
@kelp404
Projects
API v0 development
Milestone
資料上傳、編輯及維護 WF4 WF...

Comments

@trashmai
Copy link

trashmai commented Nov 21, 2018 •
edited by ghost
Loading

  • on demand 獨立 API 後端用完整資料(不分頁)產生 CSV，要檢查使用者權限
    - [ ] 傳到 S3
  • 提供是否已產生完成的訊息
  • 提供 CSV 下載連結

Related to #19
Related to TaiBIF/camera-trap-webapp#67
@trashmai trashmai added this to To do in API v0 development via automation Nov 21, 2018
@ghost ghost added this to the 資料上傳、編輯及維護 WF4 WF5 WF6 milestone Nov 23, 2018
@kelp404 kelp404 self-assigned this Nov 27, 2018
@kelp404
Copy link
Collaborator

kelp404 commented Nov 28, 2018

Hello @trashmai @cjk-halodule

我有兩個問題

  1. MultimediaAnnotation.tokens 這個陣列只會有一筆資料嗎？
    2018-11-28 9 06 09

  2. 匯出 CSV 的時候時間怎麼算或是直接用哪個欄位的資料？
    2018-11-28 9 06 53

@trashmai
Copy link
Author

trashmai commented Nov 28, 2018 •
edited
Loading

  1. tokens 可能會有一筆以上的資料。參考 MultimediaAnnotation._id == 185a54bec9b096a343608c870f61f88d，以此為例會輸出成 2 個 rows。這 2 個 rows 的
    projectTitle, site, subSite, cameraLocation, dateTime 等資訊會相同。
  2. 時間直接 (dateTime) 用 MultimediaAnnotation.corrected_date_time 欄位值。

P.S. 上面的例子是新匯入 jupyter.taibif.tw 的資料

kelp404 added a commit that referenced this issue Nov 29, 2018
@kelp404
Updated the export logic from the comment.
50c4ed3 
#29 (comment)
ghost pushed a commit that referenced this issue Nov 29, 2018
Merge pull request #55 from TaiBIF/feature-29
1de6ab3 
Added an API GET /project/:id/multimedia-annotations.csv?site=&subSite= #29
kelp404 added a commit that referenced this issue Nov 29, 2018
@kelp404
Check the user have the permission of the project. #29
dbd93af
@kelp404
Copy link
Collaborator

kelp404 commented Nov 30, 2018

API 文件已補上 https://github.com/TaiBIF/camera-trap-api/wiki/export-csv
此 API 需要登入後才可下載。

@kelp404 kelp404 closed this as completed Nov 30, 2018
API v0 development automation moved this from To do to Done Nov 30, 2018
@kelp404 kelp404 mentioned this issue Dec 3, 2018
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kelp404 kelp404

Labels
None yet
Projects
No open projects
API v0 development
  
Done
Milestone
資料上傳、編輯及維護 WF4 WF5 WF6
Development

No branches or pull requests
2 participants
@trashmai @kelp404