CD2 DAP - scheduling syncdb with cron

I have everything working as I would like. Postgres has all the schema and tables and I can successfully run the syncdb on all the tables in Terminal (I am on a mac). I would like to schedule the syncdb with cron but I have hit a wall. Right now the error is that dap is not available or found. Anyone sucessfully using cron to automate the syncdb?

Find more posts tagged with

cd2

DAP Query API

Canvas Data CLI

Accepted answers

reynlds

No problems here (outside of the occasional DAP service issue). Been running a CRON job for years on this. I wrap the DAP client in a Bash script (linux). Here is the latest iteration of this process allowing you to do everything through arguments: https://github.com/reynlds-illinois/enterprise_learning_systems/blob/main/canvas_data_2/cd2.sh

Adding the "-l" switch on the shebang line helps!

Here is the line in crontab for performing a sync with error-level logging. It kicks off every 6 hours 6 days a week:

05 00,06,12,18 * * 0-5 /var/lib/canvas-mgmt/bin/cd2.sh syncdb error

All comments

reynlds

Adding the "-l" switch on the shebang line helps!

Here is the line in crontab for performing a sync with error-level logging. It kicks off every 6 hours 6 days a week:

05 00,06,12,18 * * 0-5 /var/lib/canvas-mgmt/bin/cd2.sh syncdb error

Unanswered Questions

UI for weekly progression idea
UI for weekly progression idea that rest in the Schedule tab of the **K-12 UI** of Canvas it's incomplete and I really would not take it and push it into instance but I am going to post it here because in the past people like @James && @robotcars || @Steve_25 have had terrific input in the past... maybe w/their eyes and…
add `desc` or `asc` to a few api calls that are already sorted by date\time\index such as `due_at`
A case for this argument: I live in thee K-12 realm which means we have way too many assignments... which means that at times a simple last 10 assignments of a course question(last 10 date wise) will take us 300 assignments to answer Solution for this example in particular: I would love to make this modified version of an…
Integrate a React App (Not Canvas) to be Canvas LMS SSO.
Hey Community: I want to ask first if Canvas LMS as a Identity provider is only supported with SAML? What other protocols are supported? My use case is that I have a React App hosted on cloud provider (AWS) and SpringBoot as a backend (Service provider). I want to integrate Canvas SSO as a Identity provider (IdP). I…
Donot have valid data to test certain APIs
Hi , I’m working on validating the API test cases for CANVAS Api and need suitable test data to verify the 200 OK status code responses. I am using free for teachers version account. PFA Ecel sheet about the end points I am checking for.
Getting Canvas LTI Data
I am attempting to programmatically access the LTI usage data presented in the Canvas Apps Dashboard (total launches, unique users, subaccounts, courses over time). Could anyone advise on the best method to replicate this information by using the Canvas Rest API calls or Canvas Data 2?