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

No Data Unpacking, so No Data Loading #21

Open tessbond opened 5 years ago

tessbond commented 5 years ago

I will post my issue here and then the solution I found in case anyone has a similar problem.

I got everything installed and worked my way to step 9, but no matter how I tried, the data wouldn't unpack. I reinstalled and started over and tried every possible permutation I could think of over several days. The query would run, the data would download, the next query query would appear to run, but the unpack folder stubbornly remained empty.

I had other hot projects come up at work so I had to walk away from this for a few days. I finally managed to come back to this with fresh eyes, determined to figure it out and make it work. As I was slowly and carefully walking my way through the steps and re-running the [dbo].[CanvasData_General_DownloadSchemaAndTables] process, I suddenly realized why data was downloading but not unpacking.

It looks for 7-zip to be in C:\Program Files\7-zip. Because I had downloaded and installed 7-zip years ago on this particular server, it never occurred to me to check this. Our install has 7-zip at C:\7-zip instead of in Program Files.

I dug through the source code and modified the location of 7-zip, restarted the instructions at step 8 (the one where you build the CanvasDataStore database), and everything is running just like it is supposed to, now. The data is downloading, unpacking, and I'm currently waiting to see the glorious sight of data! in tables! that I can query!

I hope my experience helps someone else who may be struggling. Thanks for reading.