cancel
Showing results for 
Search instead for 
Did you mean: 
ndragisic
Community Member

canvasDataCli unpacking & adding headers

Jump to solution

Greetings, I am using the new canvasDataCli and I have successfully synced my data but was wondering if someone could provide sample syntax for unpacking the files and adding headers?

1 Solution

Accepted Solutions
ndragisic
Community Member

I answered my own question and made a little text doc with the following to assist. You can edit to place in your file paths. ======= ENABLE COPY PASTE IN CMD ======= 1) Open Cmd 2) Right click Cmd Header 3) Click Properties 4) Make sure QuickEdit Mode checked 5) Click OK ======= COPY FROM HERE ======= ctrl C ======= PASTE TO CMD =======  right click anywhere ======= GET DATA (SYNC) ======= Paste below into command Action will sync CanvasData to canvasDataFiles folder ============================ canvasDataCli -c E:\canvasDataFiles\config.js sync ======= UNPACK DATA ======= Paste below into command Action will unzip files to unpackedFiles folder ============================ canvasDataCli -c E:\canvasDataFiles\config.js unpack -f account_dim assignment_dim assignment_fact conversation_dim conversation_message_dim conversation_message_participant_fact course_dim course_section_dim course_ui_navigation_item_dim course_ui_navigation_item_fact discussion_entry_dim discussion_entry_fact discussion_topic_dim discussion_topic_fact enrollment_dim enrollment_fact enrollment_rollup_dim enrollment_term_dim external_tool_activation_dim external_tool_activation_fact group_dim group_fact group_membership_fact pseudonym_dim pseudonym_fact quiz_dim quiz_fact quiz_question_answer_dim quiz_question_answer_fact quiz_question_dim quiz_question_fact quiz_question_group_dim quiz_question_group_fact quiz_submission_dim quiz_submission_fact quiz_submission_historical_dim quiz_submission_historical_fact requests role_dim submission_comment_dim submission_comment_fact submission_comment_participant_dim submission_comment_participant_fact submission_dim submission_fact user_dim wiki_dim wiki_fact wiki_page_dim wiki_page_fact 

View solution in original post

2 Replies
ndragisic
Community Member

I answered my own question and made a little text doc with the following to assist. You can edit to place in your file paths. ======= ENABLE COPY PASTE IN CMD ======= 1) Open Cmd 2) Right click Cmd Header 3) Click Properties 4) Make sure QuickEdit Mode checked 5) Click OK ======= COPY FROM HERE ======= ctrl C ======= PASTE TO CMD =======  right click anywhere ======= GET DATA (SYNC) ======= Paste below into command Action will sync CanvasData to canvasDataFiles folder ============================ canvasDataCli -c E:\canvasDataFiles\config.js sync ======= UNPACK DATA ======= Paste below into command Action will unzip files to unpackedFiles folder ============================ canvasDataCli -c E:\canvasDataFiles\config.js unpack -f account_dim assignment_dim assignment_fact conversation_dim conversation_message_dim conversation_message_participant_fact course_dim course_section_dim course_ui_navigation_item_dim course_ui_navigation_item_fact discussion_entry_dim discussion_entry_fact discussion_topic_dim discussion_topic_fact enrollment_dim enrollment_fact enrollment_rollup_dim enrollment_term_dim external_tool_activation_dim external_tool_activation_fact group_dim group_fact group_membership_fact pseudonym_dim pseudonym_fact quiz_dim quiz_fact quiz_question_answer_dim quiz_question_answer_fact quiz_question_dim quiz_question_fact quiz_question_group_dim quiz_question_group_fact quiz_submission_dim quiz_submission_fact quiz_submission_historical_dim quiz_submission_historical_fact requests role_dim submission_comment_dim submission_comment_fact submission_comment_participant_dim submission_comment_participant_fact submission_dim submission_fact user_dim wiki_dim wiki_fact wiki_page_dim wiki_page_fact 

View solution in original post

Thank you for this!

Until I saw this, I was confused as to why I couldn't get the unpack command to work with comma separation on multiple tables, based on the doc example. canvas-data-cli/README.md

But using the spaces as you've shown here works great!

Also unpack works fine with fetch,  as long as you have a schema.json file in the download directory.

This is different from the CLI readme which states unpack only works after sync.