Skip to main content

Automated entry of job application data into Connecticut's DOL ReEmployCT portal.

Project description

Connecticut Dep. of Labor ReEmployCT Automated Data Entry

Python application Upload Python Package

A Python CLI that automates entry of unemployment benefits data (weekly work search and certification) into Connecticut's DOL ReEmployCT portal. (More information on ReEmployCT)

Weekly job application data from an Excel file that the user actively maintains is accessed and automatically entered into ReEmployCT through a web browser instance controlled by Selenium. The program automates as much of the process as possible, such as login, data entry, page navigation, and secure user credential handling. The user will only need to interact for data entry review/confirmation and for captchas that need to be solved. Once the user finishes any required interaction then the program automatically takes back control. The program will walk you through setting everything up to get you on your way (see Setup first).

Disclaimer:

Users of this project are solely responsible for its use. The author assumes no liability for user actions or outcomes resulting from the use of ReEmployCT, including any automated interactions. Users are required to always exercise caution and review any data that is entered into ReEmployCT.

It is important to note that this project locally handles the user credentials of their ReEmployCT account for convenience. While these credentials are encrypted for security purposes, it is crucial to understand the potential risks associated with the storage of encrypted credentials and the plain-text storage of the encryption key. The author disclaims any responsibility for the security of user credentials and advises users to assess and manage the associated risks accordingly.

Requirements

  • Firefox
  • Excel
  • Python 3.10.10 or higher. (only tested on 3.10.10)
  • User job application data must only include U.S. addresses (ReEmployCT requirement)
  • Minimum of 3 work searches (job applications) per week (ReEmployCT requirement)
  • Currently only job applications are supported by this program as data entries into ReEmployCT from the Excel file. (Job applications are defined as "employer contacts" by CT DOL). In other words, a valid work search such as a job fair attendance can not be entered by this program and instead would need to be entered into ReEmployCT manually.

How to use

Video Tutorial

Automated Connecticut Weekly Unemployment Benefits

Install (PyPI)

pip install reemployct-data-entry

Setup (Python)

You first need to get your copy of the Excel file that the program knows how to read job application data from:

from reemployct_data_entry import entry

This will import the module you'll use to run the program, but also provide you with the path to the provided Excel template. Make a copy of workSearch_template.xlsx, save it wherever (and rename it whatever) you want. Open your copy, remove the row that contains the example job application, and start adding your own data (in the same format as the example row).

Tip: You can use CTRL + ; on a cell in Excel to enter the current date. The format is MM/DD/YYYY which is what the program expects.

Run

You can either run from the CLI with:

entry.main()

Or simply click entry.py to run it.

User Credentials

To make the entire process streamlined, you can save your ReEmployCT login credentials when prompted by the CLI. Your credentials are encrypted and stored locally in the project folder in credFile.ini (only the username is left as plaintext). The encryption key is stored in key.key. You also have the option when saving your credentials to set an expiry time so that you will need to save a new set of credentials on a certain date.

Resetting saved credentials

  1. Delete credFile.ini from the project folder
  2. You will be prompted for new credentials when you run entry.main()

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

reemployct_data_entry-2.0.9.tar.gz (42.5 kB view details)

Uploaded Source

Built Distribution

reemployct_data_entry-2.0.9-py3-none-any.whl (46.4 kB view details)

Uploaded Python 3

File details

Details for the file reemployct_data_entry-2.0.9.tar.gz.

File metadata

  • Download URL: reemployct_data_entry-2.0.9.tar.gz
  • Upload date:
  • Size: 42.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.9.20

File hashes

Hashes for reemployct_data_entry-2.0.9.tar.gz
Algorithm Hash digest
SHA256 22e8474919e0f2272a1eef87805874859d71a7f64d72f7d452c27dd1ebfcc27a
MD5 ad30c652af26ac7e45eea88dc5b5ccb2
BLAKE2b-256 76586a67abd4ec4ee436ce0e042c4b5780dcd8839050eac199e6c6431a195601

See more details on using hashes here.

File details

Details for the file reemployct_data_entry-2.0.9-py3-none-any.whl.

File metadata

File hashes

Hashes for reemployct_data_entry-2.0.9-py3-none-any.whl
Algorithm Hash digest
SHA256 e70d51c8d047768e89a16c4001995de6928806e92a33f024c21f1da75022d979
MD5 ed5c07a7bd951c92836222d11013eb00
BLAKE2b-256 7e261de6412192cc17e814e9e80094826e2dcb042790a91e653a6c61e061ecc4

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page