Step 1: Clone the Expertflow CX repository
git clone -b <Branch-Name> https://efcx:RecRpsuH34yqp56YRFUb@gitlab.expertflow.com/cim/cim-solution.git <Branch-Name>
Step 2: Navigate to the reports artifacts directory
cd <Branch-Name>/kubernetes/external/metabase-reports/metabase_reporting_update_tool/
From here onward, we assume the repo contains "campaigns" and "survey" directories with their respective report artifacts within "/metabase_reporting_update_tool". If the directory structure changes, update the commands below accordingly.
To import Campaigns reports
python3 metabase_import.py https://<Metabase-FQDN>/metabase/api/ <admin-email> <admin-password> <metabase-db-display-name> campaigns <collection-name-on-metabase>
To import Survey reports
python3 metabase_import.py https://<Metabase-FQDN>/metabase/api/ <admin-email> <admin-password> <metabase-db-display-name> survey <collection-name-on-metabase>
-
<metabase-db-display-name> = It is the database name that we set while configuring a DB on metabase.
-
<collection-name-on-metabase> = It is the collection that we create on metabase interface.
example: python3 metabase_import.py https://rm-03.expertflow.com/metabase/api/ <admin-email> <admin-password> mtt02 campaigns Campaigns_mtt02_test