Etendo BI Bundle

Javapackage: com.etendoerp.etendobi.extensions

Overview

In this section, the user can find technical information about the Etendo BI Bundle.

Etendo BI Connector

Technical Aspects

To ensure proper functioning of the script, follow the steps below:

Note

The following steps can only be used for Linux OS.

rsync must be installed in our system, since this is the tool we use to connect to the server.
Terminal
```
sudo apt install rsync
```
Make sure you have at least python3.7 or above installed on your system. You can verify the installation by running
Terminal
```
python3 --version
```
If it is not installed, run
Terminal
```
sudo apt update && sudo apt install python3
```
And then verify that the version is correct.
It is highly likely that pip3 comes bundled with the installation of python3. Verify if it is installed by running
Terminal
```
pip3 --version
```
Then ensure to have an updated version of it
Terminal
```
sudo pip3 install --upgrade pip
```
If it is not installed, run
Terminal
```
sudo apt install python3-pip
```
The user needs to install libpq-dev to ensure seamless communication and compatibility between our python script and the postgresql database.

To install it, run
Terminal
```
sudo apt install libpq-dev
```
The following libraries need to be installed using pip3 for them to work: psycopg2, pandas and requests. You can install them by running:
Terminal
```
pip3 install psycopg2-binary
```
Terminal
```
pip3 install pandas
```
Terminal
```
pip3 install requests
```

Etendo BI Connector

After the execution of the process, two new directories should be created in the filesystem. One will contain the logs files, one for the rsync execution that will contain information about the file upload to the server; another file called syncScript.log.{datetime}, that will contain information about the script execution (most of this information can be seen in the Logs Monitor window, but if for any reason the window cannot receive this information, it should be able to be seen using this .log file).

In this example, in the path where the script is allocated, a new directory named “Etendo” should be created. Inside it, there should be two folders for the organization that set the background process (F&B US West Coast).

drwxrwxr-x 1 <user> <group> 9,1K jun 8 16:52 ETPBIC_SyncScript.py

drwxrwxr-x 4 <user> <group> 4,0K jun 8 17:39 Etendo/

Inside the Etendo/ folder, we have:

drwxrwxr-x 2 <user> <group> 4,0K jun 8 16:54 F+B_US_West_Coast_logs/

drwxrwxr-x 2 <user> <group> 4,0K jun 8 16:54 F+B_US_West_Coast_output/

The output directory, will contain all the CSVs that should have been uploaded to the server.

Info

Remember that the main folder is created using the prefix of the “Client” variable that is set on BI Connection window. If two connections have the same value for “Client” variable, these directories will be overwritten.

This is the content of Ete_Example.csv and BASE_Example.csv files:

Info

Remember that since any column is not being overridden, these files are the same.

On the other hand, this is the content of FULL_Example.csv:

Warning

Make sure to have the corresponding permissions to connect to Files, since an incorrect configuration can lead to an error.