What is the 14 digit number after the name in downloaded submission file?

[JobayerAhmmed]

When I Download Submissions from SpeedGrader, and extract the zip file, I find all the students' submission files. Each file name contains LastNameFirstName_6digitnumber_14digitnumber_SubmissionFileName.

My question is, what is this 6digitnumber_14digitnumber ?

I want to calculate how many hours late an assignment is submitted. I assume this 6digitnumber_14digitnumber might be somehow related to the submission date and time.

Please tell me if there is any way to calculate the late submission hours from the file name.

[ColtonSwapp]

Hello @JobayerAhmmed 

Thanks for posting this in the Canvas Community! I believe I know part of the answer to this question. 

The first number you see there indicates the Canvas_User_ID for the user. For example, If a users Canvas Id ends in 887 (Yourschool.instructure.com/users/887) it will show that number when you download the submission. The second number you see there indicates the submission ID. These numbers are mostly used for looking at the API for the submissions that were made to an assignment. It does not have any relevance on the how late an assignment submission actually is. 

You can look at the API of a submission if you know those two numbers. The ApI would look something like this:

Yourschool.instructure.com/api/v1/courses/your-course-#/assignments/your-assignment#/submissions.  

If you need to see how late a submission was, the best option is to look at the details in Speedgrader.  

Hopefully this helps! 

-Colton 

[Ron_Bowman · Accepted solution]

@JobayerAhmmed -

What @ColtonSwapp told you provides information on those numbers (though the ones I see or not as large as what you state) - which you can't use for determining how late a submission is.

Looking on Speedgrader will show you that information, but it may not be what you want.  if you are grading student by student, then it will be fine.

As a side note I am assuming that you have a due date/time that is earlier than the until date/time so that there actually is a late window.

If this is for assignments, then without using API's, you will have to look at the submission times on speedgrader - that gives you an idea of how late it is and this may be your best option.

If you can work with excel and you have several files you need to look at (highly unlikely), go to new analytics for the course, then reports and then late assignments.  You get a csv file that lists all late assignments and has the submission date and times for those assignments.  Unfortunately, it only has the due date - not date and time, so you would have to add that information.   From the information provided there, you can use excel calculations to figure out how late an assignment is.  I did this a few years ago when I wanted to check if students were submitting information for two quizzes in the amount of time allotted.  I have the information, but do not recall how I came up with the formulas.  Probably not worth it for just a few late submissions

[JobayerAhmmed]

@Ron_Bowman 
Thank you very much. It helped a lot. Using the data from analytics, I can now calculate the late submission hours.