Thank you for the quick reply and example. Definitely something I will try. I seem to forget that python is running in a docker instance within Ubuntu and not Windows. Your explanation makes sense to why it can't find the local drives. I did read about importing 'win32com' which gave you access to the windows client subsystem but I think that doesn't work with Ubuntu either. I'm guessing there is a package out there that would give me access to the Windows subsystems but I just haven't found it.
Sure hope Docker and Windows Server can get this problem ironed out soon so we can install Jupyter on a Windows server box.
Thanks again for this information.
Scott
------------------------------
Scott
Cognos Administrator
Wenatchee WA
------------------------------
Original Message:
Sent: Tue May 19, 2020 03:55 PM
From: JANNE LIND
Subject: Jupyter notebook example to read network Excel file then save to CA
Please check my example in the Matt Denham's session AMA Thread
https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?MessageKey=8d9a88c1-12b6-468b-93c6-4432e007e858&CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=digestviewer#bm8d9a88c1-12b6-468b-93c6-4432e007e858
However this is yet another example of loading Excel from website. The issue with the network drive location is that Notebook might not be aware of the filesystem e.g. my Notebook is in Docker container on Ubuntu, so it is not aware of Windows network around it at least by default.
You should be able to generate URL for your Excel for example by placing the Excel file on Sharepoint or other enterprise ready fileshare service. It does not need to be openly available in the internet.
------------------------------
JANNE LIND
Original Message:
Sent: Tue May 19, 2020 03:03 PM
From: Scott Taylor
Subject: Jupyter notebook example to read network Excel file then save to CA
Based on todays User Group Days discussion, it looks like Jupyter notebooks is the only way to update Excel data files and refresh them on Cognos. I'm looking for an example that does that simply. Current examples only read downloaded files but I would like it to read network accessed files. Should be able to do it but I can't find a python pkg in Jupyter that gives that type of control. Must be there somewhere.
If you have a simple example of this, could you share it? Would really appreciate it as I'm trying to prove out a concept to our IT guys why we need a server powered Jupyter server box instead of Windows 10.
Thanks.
------------------------------
Scott
Cognos Administrator
Wenatchee WA
------------------------------
#CognosAnalyticswithWatson