Automate Inbound Shipment Confirmation in IBM Sterling using Selenium Python

Automate Inbound Shipment Confirmation in IBM Sterling using Selenium Python

In IBM Sterling WMS with version 9x.  Below Selenium script using Python code to Automate the Inbound Shipment Confirmation process.

Steps involved in Inbound Shipment Confirmation:

1. Open Internet Explorer Browser (IBM Sterling works fine in this Browser)
2. Open Login Screen
3. Input Username and Password to Login
4. Click Login form
5. Open Inbound Shipment Console (Out of the Box screen)
6. Input Seller, Buyer
7. Click "Create Shipment" button to Create the Shipment
8. Scroll down bit to Input Item Details to create Item into the Shipment
9. Input ItemID, ProductClass and Quantity
10. Save the Shipment
11. Confirm the Shipment

Selenium Python Code:

from selenium import webdriver
from selenium.common.exceptions import TimeoutException
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support.select import Select
import time

driver = webdriver.Ie()
driver.get("http://localhost:7001/smcfs/console/login.jsp")
#time.sleep(5)

# Set value to Username
userName  = driver.find_element_by_name("UserId")
userName.send_keys("myusername")

# Set value to Password
passWord  = driver.find_element_by_name("Password")
passWord.send_keys("mypassword")

# Submit the Form
submitForm  = driver.find_element_by_name("btnLogin")
submitForm.click()

time.sleep(3)

#Open Inbound Shipment Console
driver.get("http://localhost:7001/smcfs/console/poshipment.detail?CurrentDetailViewID=YOMD7332")
driver.fullscreen_window

#Set Seller
setSeller  = driver.find_element_by_name("xml:/Shipment/@SellerOrganizationCode")
setSeller.send_keys("MODT")

#Set Buyer
setBuyer  = driver.find_element_by_name("xml:/Shipment/@BuyerOrganizationCode")
setBuyer.send_keys("KOMP")
time.sleep(3)

# Create Shipment
submitForm  = driver.find_element_by_xpath('//*[@type="button" and @class="button"]')
submitForm.click()
time.sleep(3)

# Scroll window
driver.execute_script("window.scrollTo(0, 200)")

#Add Item Details
driver.find_element_by_name("xml:/Shipment/ShipmentLines/ShipmentLine_1/@ItemID").send_keys("XXRXF00003")
Select(driver.find_element_by_name('xml:/Shipment/ShipmentLines/ShipmentLine_1/@ProductClass')).select_by_visible_text('Y001')
driver.find_element_by_name("xml:/Shipment/ShipmentLines/ShipmentLine_1/@Quantity").send_keys("10")

# Save Shipment
driver.find_element_by_xpath('//*[@type="button" and @class="button"]').click()
time.sleep(2)

# Confirm Shipment
driver.find_element_by_id("scbutton2").click()

Automate Login in IBM Sterling WMS using Selenium Python

In IBM Sterling WMS with version 9x.  Hope it will work for lower version too using below code.

After executing below code, it will automatically open Internet Explorer browser -> Open Sterling login screen (pls change URL for your code) -> Target Username field and set as anderson -> Target Password field and set as password and then click -> Submit button which will get logged in into the Sterling application.

1. Open Internet Explorer Browser (IBM Sterling works fine in this Browser)
2. Open Login Screen
3. Input Username and Password to Login
4. Click Login form

from selenium import webdriver
from selenium.common.exceptions import TimeoutException
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support.select import Select
import time

driver = webdriver.Ie()
driver.get("http://localhost:7001/smcfs/console/login.jsp")
#time.sleep(5)

# Set value to Username
userName  = driver.find_element_by_name("UserId")
userName.send_keys("anderson")

# Set value to Password
passWord  = driver.find_element_by_name("Password")
passWord.send_keys("password")

# Submit the Form
submitForm  = driver.find_element_by_name("btnLogin")
submitForm.click()

Purpose of ETL Tool?

ETL (Extracting, Transforming and Loading):

An ETL tool is a software, mainly used for Extracting, Transforming and Loading data.

 

In today’s data-driven world a huge amount of data is generated from various organizations, machines, and gadgets, irrespective of their sizes. For example, your mobile, each time you browse the web, some amount of data is generated.

 

Let’s go through each step of the trio process (Extract, Transform, Load)

1. Extract: Extraction of data is the most important step of ETL which involves accessing the data from all the Storage Systems. The storage systems can be the RDBMS, Excel files, XML files, flat files, ISAM (Indexed Sequential Access Method), hierarchical databases (IMS), visual information etc. Being the most vital step, it needs to be designed in such a way that it doesn’t affect the source systems negatively. Extraction process also makes sure that every item’s parameters are distinctively identified irrespective of its source system.

2. Transform: Transformation is the next process in the pipeline. In this step, entire data is analyzed and various functions are applied on it to transform that into the required format. Generally, processes used for the transformation of the data are conversion, filtering, sorting, standardizing, clearing the duplicates, translating and verifying the consistency of various data sources.

3. Load: Loading is the final stage of the ETL process. In this step, the processed data, i.e. the extracted and transformed data, is then loaded to a target data repository which is usually the databases. While performing this step, it should be ensured that the load function is performed accurately, but by utilizing minimal resources. Also, while loading you have to maintain the referential integrity so that you don’t lose the consistency of the data. Once the data is loaded, you can pick up any chunk of data and compare it with other chunks easily.

Purpose of SOAP UI tool?

SoapUI is an open-source web service testing application for service-oriented architectures (SOA) and representational state transfers (REST). Its functionality covers web service inspection, invoking, development, simulation and mocking, functional testing, load and compliance testing.

 

Purpose of JMeter Tool?

Apache JMeter may be used to test functional and performance both on static and dynamic resources (files, Servlets, Perl scripts, Java Objects, Data Bases and Queries, FTP Servers and more).

 

Apache JMeter can be used to simulate a heavy load on a server, network or object to test its strength or to analyze overall performance under different load types. You can also use it perform a functional test on websites, databases, LDAPs, web services etc.

 

Apache Jmeter can be used in IBM Sterling WMS to automate the warehouse process like Inbound flow, Outbound flow, Return flow not only that but also Automate the Onboarding process of a Customer. This saves huge manual intervention of task effort into a fraction of minutes itself.