AttributeError: module 'tableauserverclient' has no attribute 'ExcelRequestOptions' #1122

Activity

1. bcantoni

   added

   bug

   on Sep 25, 2022
2. bcantoni commented on Sep 25, 2022

   

   bcantoni

   on Sep 25, 2022

   Contributor

   More actions

   @jtsai01-bsc could you show the code in your export.v.1.0.py script that's failing? The library version of export.py doesn't include an Excel option, so I'm assuming you've added that.
3. jtsai01-bsc commented on Sep 26, 2022

   

   jtsai01-bsc

   on Sep 26, 2022

   Author

   More actions

   @jtsai01-bsc could you show the code in your export.v.1.0.py script that's failing? The library version of export.py doesn't include an Excel option, so I'm assuming you've added that.

   1. The class ExcelRequestOptions(RequestOptionsBase) is in C:\Tableau\Tidal\server-client-python-master\tableauserverclient\server\request_options.py,
   2. The populate_excel(self, view_item: ViewItem, req_options: Optional["ExcelRequestOptions"] = None) and _get_view_excel(self, view_item: ViewItem, req_options: Optional["ExcelRequestOptions"]) are in C:\Tableau\Tidal\server-client-python-master\tableauserverclient\server\endpoint\views_endpoint.py,
   3. Please see the attached export.v.1.0.txt.
      export.v.1.0.txt
4. bcantoni commented on Sep 26, 2022

   

   bcantoni

   on Sep 26, 2022

   Contributor

   More actions

   Did a little more digging here. Support for populate_excel for views was added in #968. It looks like it's not fully functional because ExcelRequestOptions isn't included in the proper init places:

   $ python
   Python 3.9.7 (default, Aug 31 2021, 14:25:50)
   [Clang 12.0.0 (clang-1200.0.32.21)] on darwin
   Type "help", "copyright", "credits" or "license" for more information.
   >>> import tableauserverclient as TSC
   >>> TSC.CSVRequestOptions
   <class 'tableauserverclient.server.request_options.CSVRequestOptions'>
   >>> TSC.ExcelRequestOptions
   Traceback (most recent call last):
     File "<stdin>", line 1, in <module>
   AttributeError: module 'tableauserverclient' has no attribute 'ExcelRequestOptions'

   @jorwoods would you mind taking a look at this? I notice the test you added also had a copy/paste error where it was still referencing the CSV request options, so that's probably why this was missed.
5. jtsai01-bsc commented on Sep 26, 2022

   

   jtsai01-bsc

   on Sep 26, 2022

   Author

   More actions

   Did a little more digging here. Support for populate_excel for views was added in #968. It looks like it's not fully functional because ExcelRequestOptions isn't included in the proper init places:

   $ python
   Python 3.9.7 (default, Aug 31 2021, 14:25:50)
   [Clang 12.0.0 (clang-1200.0.32.21)] on darwin
   Type "help", "copyright", "credits" or "license" for more information.
   >>> import tableauserverclient as TSC
   >>> TSC.CSVRequestOptions
   <class 'tableauserverclient.server.request_options.CSVRequestOptions'>
   >>> TSC.ExcelRequestOptions
   Traceback (most recent call last):
     File "<stdin>", line 1, in <module>
   AttributeError: module 'tableauserverclient' has no attribute 'ExcelRequestOptions'

   @jorwoods would you mind taking a look at this? I notice the test you added also had a copy/paste error where it was still referencing the CSV request options, so that's probably why this was missed.

   Thank you, Brian and Jorwoods!

   Please let me know when i can download the new version of TSC library and try the ExcelRequestOptions.
6. jorwoods commented on Sep 26, 2022

   

   jorwoods

   on Sep 26, 2022

   Contributor

   More actions

   @jtsai01-bsc Technically, you can use it now if you import it directly, manually.

   from tableauserverclient.server.request_options import ExcelRequestOptions
7. jtsai01-bsc commented on Sep 26, 2022

   

   jtsai01-bsc

   on Sep 26, 2022

   Last edited by jtsai01-bsc

   Author

   More actions

   TSC.ExcelRequestOptions

   Sorry, Jorwoods. Can you please add more detail and step.
   I add this to export.py; however i am getting the same error.

   import argparse
   import logging

   import tableauserverclient as TSC
   from tableauserverclient.server.request_options import ExcelRequestOptions
8. jorwoods commented on Sep 27, 2022

   

   jorwoods

   on Sep 27, 2022

   Contributor

   More actions

   Nevermind. I forgot it was an internal reference error and not that you were trying to access it, but couldn't.
9. jorwoods commented on Sep 28, 2022

   

   jorwoods

   on Sep 28, 2022

   Contributor

   More actions

   0.23 was released that contains the fix.

   👍React with 👍1Reacted by Brian Cantoni
10. bcantoni

    closed this as completedon Sep 28, 2022
11. jtsai01-bsc commented on Sep 28, 2022

    

    jtsai01-bsc

    on Sep 28, 2022

    Author

    More actions

    Awesome. Thank you so much! I will wait for v.0.23.