EMU-CFE / CanvasDataViewer

CanvasDataViewer is used to automatically download Canvas Data files into a SQL Server database where you can query and analyze the information.
29 stars 8 forks source link

Install Updates #9

Open rodmiddleton opened 7 years ago

rodmiddleton commented 7 years ago

Thank you so much for providing this to the community. It did work for me initially but now it fails with datatime conversion but I can not find where it is occurring. I see you have updated the project. How would I update my installation with your new updates? Just install over the existing?

Thanks

wjones20 commented 7 years ago

Hi,

Yes, we saw that error too. It was an error in our coding--the production tables were created with DATETIME2 as the datatype, but the CONVERT statement had been hardcoded to convert to DATETIME. What was weird is that the bad coding worked for a while, but then broke a few weeks ago when they did a regular Canvas update. Anyway. Yes, the new T-SQL file for creating CanvasDataStore (CanvasDataStore_042417_1332.sql) should fix the error. That file is created to drop/create everything, so you should be able to just run it on your current database. If there’s a problem with that then you should delete your current database, create a new empty CanvasDataStore, and run the file. Please let me know if you have any problems so we can keep tweaking it.

Thanks,

Bill


Bill Jones, MA, MS Director, Instr Tech & Info Mngmt Extended Programs ph: (734) 487-9043

Eastern Michigan University fax: (734) 487-6695

Ypsilanti, MI 48197 email: wjones20@emich.edu


From: rodmiddleton [mailto:notifications@github.com] Sent: Monday, May 8, 2017 8:46 AM To: EMU-CFE/CanvasDataViewer CanvasDataViewer@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [EMU-CFE/CanvasDataViewer] Install Updates (#9)

Thank you so much for providing this to the community. It did work for me initially but now it fails with datatime conversion but I can not find where it is occurring. I see you have updated the project. How would I update my installation with your new updates? Just install over the existing?

Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/EMU-CFE/CanvasDataViewer/issues/9, or mute the thread https://github.com/notifications/unsubscribe-auth/AS3lqxzG3gwwHMyz3Wzi95Toh5pj5gtHks5r3w6YgaJpZM4NT5dk .

rodmiddleton commented 7 years ago

Thanks for you quick response. I finally got back to this and ended up deleting the databases and starting over with the process. It creates all the tables but it doesn't appear to download anything else. It ends pretty quickly on both jobs. All tables empty and nothing in the download directory. Do not see any errors. Any suggestion on troubleshooting?

Thanks

aanders-emu commented 7 years ago

Hi Ron,

I just tried a fresh install and found an issue with our instructions (missing a file on the step 7 list) .

Make sure the "DownloadLatestSchemaAndTables.bat" file is in "C:\Program Files\nodejs" directory and try to run the process again.

I've done this and the process is now running as expected.

Thanks for the heads up.

rodmiddleton commented 7 years ago

Just getting back and did a fresh install and getting the procedures to run but very quickly with the following output: output NULL 7-Zip [64] 16.04 : Copyright (c) 1999-2016 Igor Pavlov : 2016-10-04 NULL Scanning the drive for archives: NULL NULL Command Line Error: Cannot find archive NULL

Any suggestions?

Thanks Rod

wjones20 commented 7 years ago

Rod – Apologies, we’ll need to pick this up early next week and get back to you then. Thanks for contacting us with your problem. --Bill


Bill Jones, MA, MS Director, Instr Tech & Info Mngmt Extended Programs ph: (734) 487-9043

Eastern Michigan University fax: (734) 487-6695

Ypsilanti, MI 48197 email: wjones20@emich.edu


From: rodmiddleton [mailto:notifications@github.com] Sent: Wednesday, June 7, 2017 12:58 PM To: EMU-CFE/CanvasDataViewer CanvasDataViewer@noreply.github.com Cc: Bill Jones wjones20@emich.edu; Comment comment@noreply.github.com Subject: Re: [EMU-CFE/CanvasDataViewer] Install Updates (#9)

Just getting back and did a fresh install and getting the procedures to run but very quickly with the following output: output NULL 7-Zip [64] 16.04 : Copyright (c) 1999-2016 Igor Pavlov : 2016-10-04 NULL Scanning the drive for archives: NULL NULL Command Line Error: Cannot find archive NULL

Any suggestions?

Thanks Rod

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/EMU-CFE/CanvasDataViewer/issues/9#issuecomment-306858137, or mute the thread https://github.com/notifications/unsubscribe-auth/AS3lq4xe9LTq3jN5m8diwMAK4_6u8Ts9ks5sBtaZgaJpZM4NT5dk .

aanders-emu commented 7 years ago

Hi Rod,

I'm Andrew, co-author of this viewer and author of the bit you seem to be having trouble with. I should be able help you with this.

From that output it seems the 7zip path-ing is incorrect. I know that is typically hard-coded in the procedure to C:/CanvasDataUnzips. If you've changed this "default" directory to something else, you'll need to update @unzipDir variable in the [dbo].[CanvasData_General_DownloadSchemaAndTables] to correspond to it.

If this you need more assistance, please reply.

Regards, Andrew

Andrew Anders University LMS Coordinator Center for E-Learning Eastern Michigan University 101 Boone Hall Ypsilanti, MI 48197

On Wed, Jun 7, 2017 at 12:58 PM, rodmiddleton notifications@github.com wrote:

Just getting back and did a fresh install and getting the procedures to run but very quickly with the following output: output NULL 7-Zip [64] 16.04 : Copyright (c) 1999-2016 Igor Pavlov : 2016-10-04 NULL Scanning the drive for archives: NULL NULL Command Line Error: Cannot find archive NULL

Any suggestions?

Thanks Rod

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/EMU-CFE/CanvasDataViewer/issues/9#issuecomment-306858137, or mute the thread https://github.com/notifications/unsubscribe-auth/AS3o3SNTrU_zozqPTk6RjIJ2Evat780kks5sBtaZgaJpZM4NT5dk .