Python package for the Dell RPA Team
Dell Python RPA Package
What is it?
This Python package serves as a toolkit with custom built with functions useful to different teams within Dell.
Install the package while off of the corporate network using:
pip install dell_python_rpa -U
Create a file in the python project directory where you will be importing this package named "configuration.yml" which houses your network credentials in the following format
Do not store this file in a shared directory
credentials: user_name: 'example_username' password: 'example_password'
MIDAS API Module
This module is a wrapper for a Dell internal API to get real-time order information from OFS and BOSS. To utilize it, pass a python list of Order Numbers into each function along with a parameter of to get order data returned in the form of a Pandas Dataframe . This includes all 5 web-service APIs currently exposed by MIDAS designed to return all information about the status, attributes, or history of an order.
# Importing Order Status Module from dell_python_rpa.order_status import * orders=['208432234','208435401','208457058'] general_order_info=get_order_info(orders) ofs=get_ofs_status(orders) boss_status=get_boss_status(orders) properties=get_ofs_properties(orders) boss_status_history=get_boss_status_history(orders)
This module includes functions which are useful to the Global Production Planning Organization including querying Michael Bishop's DB and getting the latest CSR Data.
# Importing GPP Module from dell_python_rpa.gpp import * # Query Michael Bishops Database, results are a Pandas Dataframe # By default, the function will query the "BACKLOG" database # Use the db_name parameter if to specify a different db if necessary directory_of_sql_file='Queries\gpp_bishop_example.sql' result=bishops_query(directory_of_sql_file) # Get current CSR data in Pandas Dataframe csr=get_csr()
This module includes the functionality to execute a query on the UDM/FDL Oracle database. The data returned will be in the datatype of a Pandas Dataframe. In order to use this module, you will need access to the database and the 'configuration.yml' file discussed above in the same directory as the python file calling the udm function. The udm_query_2 function is the latest generation version which takes the directory of a SQL file as a parameter and also allows a second parameter which allows you to modify the query at runtime with parameters which can be calculated as part of your program. It does this by replacing the text -- INSERTVALUEHERE in your sql query, so if you are going to use this capability, please include that string in your file.
# Importing UDM Module from dell_python_rpa.udm import * # Execute a query without modifying it directory_of_sql_file='Queries\example_sql_file.sql' result=udm_query_2(directory_of_sql_file) # Modify a query before executing it directory_of_sql_file='Queries\example_sql_file.sql' query_modifier='AND SO.SYSTEM_QTY > 10' result=udm_query_2(directory_of_sql_file, query_modifier)