Excel File

This Data bridge leverages the BPPI API by reading a file content (Excel format supported xls, xlsx, xlsm, xlsb, odf, ods and odt) and pushing those data into a BPPI Repository Table (it's also possible to execute some To Do lists afterwards). Using this bridge is pretty easy as you just have to launch a command line (CLI).

Python Library

This Connectivity leverage the Python pm4py package.

Capabilities

Read Excel files (xls, xlsx, xlsm, xlsb, odf, ods and odt) by leveraging the native Pandas capabilities.

• Read an excel spreadsheet and load it into the BPPI Repository
• It's possible to choose the sheet to load (by default it takes the first one)

Launch via the command line

• -sourcetype (Mandatory) excel
• -configfile (Mandatory) Config file with all configuration details (INI format, see the template below) if a file is specified for the -configfile parameter the parameter file must follow the INI format rules. Example/Template -> see the config.ini-template (rename it as an *.ini file)
• -filename (Mandatory) file to load (CSV format)
• -sheet [Optional] Sheet nema (by default takes the first one

Example

Launch the program in the shell (windows or linux) command line like this:

$ python3 bppibridge.py -sourcetype excel -filename {myfile.xslx} -configfile {config.ini}