Python 3 Script to Import Many ElastiCubes
Introduction
The attached script is intended to loop through all ElastiCube folders in your ElastiCubeData folder and import them.
Business Case
This solution has a couple of possible use cases. The first is to facilitate migrating a Sisense environment with a large number of ElastiCubes. The second would be in the case of disaster recovery, where a number of ElastiCubes must be reattached.
Requirements
Python 3 must be installed.
There should be at least one ElastiCube folder in your ElastiCubeData folder that is intended to be imported.
Step 1
Download the attached Python3 Script to your ElastiCubeData folder(usually C:\ProgramData\Sisense\PrismServer\ElastiCubeData).
Step 2
Open a IDLE (Python Editor) window as an Administrator. Note: You will get a prompt to allow changes for each ElastiCube unless you run as an Administrator.
Step 3
Load the script into IDLE and run. This can take some time to import all ElastiCubes depending on how many you have and the size. Enjoy!
Script:
import os
import subprocess
def ImportEC(ECube):
cmdline = ["cmd", "/q", "/k", "echo off"]
cmd = subprocess.Popen(cmdline, stdin=subprocess.PIPE, stdout=subprocess.PIPE)
batch = b"""\
cd C:\Program Files\Sisense\Prism
psm ecube attach path="C:\ProgramData\Sisense\PrismServer\ElastiCubeData\ElasticubeToImport"
set /p
exit
"""
ECubeBytes = bytes(ECube, 'utf-8')
batch = batch.replace(rb'ElasticubeToImport', ECubeBytes)
print(batch)
cmd.stdin.write(batch)
cmd.stdin.flush()
result = cmd.stdout.read()
EC_List = next(os.walk('.'))[1]
for EC in EC_List:
print('Python appending EC: ' + EC)
ImportEC(EC)Updated 02-15-2024
