When importing thousands of Excel files into one table, all tables are stored on the RAM until all of them are uploaded. This may cause very high memory and might even fail the build.
This python script will combine all existing and future Excel files into one CSV file which will make the entire build operation and maintenance simpler.
- Install python 2.7
- Add this PyRunner.dll to C:\Program Files\Sisense\Prism\Server\Plugins
- Download the exportxls.py file, and edit it to your preference file location and place it in C:\Program Files\Sisense\Prism\Server\Plugins.
- Create a "Pre Execution Plugins"
- On your selected cube, by opening it in the desktop ECM > Clicking on the Elasticube button > Pre & Post execution plugins > Add a new "Pre Execution Plugins" and name it "PyRunner"
- Add the following XML
-
<attributes Program="exportxls.py" pythonPath="C:\Python27\python.exe"></attributes>