[ARCHIVED] How to tell if a course is published?

[rubyn]

Are all courses included in the hosted data or just published?  Would like to see the published courses - currently we use /api/v1/accounts/:account_id/course where published=true.  Don't see a similar filed in course_dim...

[bneporadny]

I'm not seeing a way to do this either via the Hosted Data Service.  I'm kinda of surprised there isn't a "Status" column on the course_dim table.

We currently utilize the Provisioning Report to tell which courses have and have not been published for our next upcoming term, so that we can work with those instructors who haven't published their courses by the terms start date.

[msmith]

the predicate would be (workflow_state='completed') or (workflow_state='available)

We will update the docs and I think we might as an is_published field so this is easier to figure out.

[msmith]

sorry, there is a typo in that, the predicate should be:

(workflow_state='completed') or (workflow_state='available')

[jnuckles]

We don't have any courses that show a workflow other than created or deleted. We have thousands of published courses but none of ours show as available (or completed).

[samuel-vanhorne]

Has this been resolved? Are unpublished (but created) courses labeled as "claimed" in the course_dim table, and are published courses "available"?

[jnuckles]

Yes, this did get resolved. Our courses now have a correct workflow column in Canvas Data.

[hong_chau]

Hi jnuckles,

Just to clarify: workflow_state ="Workflow status indicating the current state of the course, valid values are: completed, created, deleted, available, claimed"

Completed=concluded

Created=???

Deleted=deleted

Claimed=unpublished

Available=published

Also, could you clarify the difference between created and claimed?

Thanks,

Hong

[jnuckles]

Sorry, I don't have any details beyond what you have described. My guess would be that created and claimed have more to do with keeping track of the behind-the-scenes Canvas course creation process.