Skip to content

Latest commit

 

History

History
31 lines (23 loc) · 1.53 KB

File metadata and controls

31 lines (23 loc) · 1.53 KB

Automate Manual Repetitive Data Entry Tasks

This project contains two small modules one is sales order (JavaFX) which will take the data from the excel and other is automated data entering module which is developed in python.

Demo

Prerequisites

You must have following programs/packages in order to run this project.

Approach

  • First need to clone this respiratory.
  • Configure your database schema credentials in src/database/DbConnection.
  • Copy database script from database/script.sql and execute in your database IDE (SQL Developer/SQL++, TOAD, etc).
  • Run this project as part of java code through NetBeans IDE or command prompts.
  • You will see a form as a pop up where data needed to be entered from automation/Sales Orders.xlsx
  • Run python script which is in automation/script.py using py automation/script.py
  • The python script will execute and take the data from excel and start entering into the form and automate save.
  • The python script will iterate 10 times as there is a break statement in the python script.

Find it on youtube. https://youtu.be/_jb6M0vqCLs