AnsweredAssumed Answered

Canvas Data Loader

Question asked by Tabitha Locklear on Jan 29, 2019
Latest reply on Sep 26, 2019 by James Jones

Are any of you using the Canvas Data Loader with a Windows OS & MySQL database?

I am new to the Canvas Admin title, and I'm trying to pull data from the Canvas Data Portal. I have tried doing one table at a time and using Excel but I wanted something that would automatically import the tables into the MySQL database.

I've installed the Canvas-Data-Loader, I have ran the process twice and it seems to hang without completing.

Out of the 101 files it downloaded it has only imported 73 tables into the database. I don't know where to go to see the logs for the process. The command prompt just sits there like the process is still running.

I don't see a directory for which it unpacks the files before importing them into the database.

 

If anyone is using it, could you point me in the right direction to get this process to run a little more smoothly and explain a little more about how this process works? Where does it unpack the .gz files?

If you are using something that works better could you please share?

Outcomes