# Connecticut Dep. of Labor ReEmployCT Automated Data Entry
[](https://github.com/ariffjeff/ReEmployCT-Data-Entry/actions/workflows/python-app.yml)
[](https://github.com/ariffjeff/ReEmployCT-Data-Entry/actions/workflows/python-publish.yml)
A Python CLI that automates entry of unemployment benefits data (weekly work search and certification) into Connecticut's DOL [ReEmployCT portal](https://reemployct.dol.ct.gov). ([More information on ReEmployCT](https://portal.ct.gov/dol/Unemployment-Benefits))
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](#user-credentials). 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](#setup-python) 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
- 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](https://www.youtube.com/watch?v=Ff6FEwIE0Bw)
### Install ([PyPI](https://pypi.org/project/reemployct-data-entry/))
```
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()`
Raw data
{
"_id": null,
"home_page": "https://github.com/ariffjeff/ReEmployCT-Data-Entry",
"name": "reemployct-data-entry",
"maintainer": null,
"docs_url": null,
"requires_python": "<4.0.0,>=3.10.10",
"maintainer_email": null,
"keywords": "unemployment, benefits",
"author": "Ariff Jeff",
"author_email": "ariffjeff@icloud.com",
"download_url": "https://files.pythonhosted.org/packages/f5/f9/3244a2be81747e677d9dc19ebfc19aed7be7bc3e6a265bbd67beb435bdb3/reemployct_data_entry-2.0.6.tar.gz",
"platform": null,
"description": "# Connecticut Dep. of Labor ReEmployCT Automated Data Entry\n[](https://github.com/ariffjeff/ReEmployCT-Data-Entry/actions/workflows/python-app.yml)\n[](https://github.com/ariffjeff/ReEmployCT-Data-Entry/actions/workflows/python-publish.yml)\n\nA Python CLI that automates entry of unemployment benefits data (weekly work search and certification) into Connecticut's DOL [ReEmployCT portal](https://reemployct.dol.ct.gov). ([More information on ReEmployCT](https://portal.ct.gov/dol/Unemployment-Benefits))\n\nWeekly 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](#user-credentials). 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](#setup-python) first).\n\n### Disclaimer:\nUsers 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.\n\nIt 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.\n\n## Requirements\n- Firefox\n- Excel\n- User job application data must only include U.S. addresses (ReEmployCT requirement)\n- Minimum of 3 work searches (job applications) per week (ReEmployCT requirement)\n- 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.\n\n## How to use\n### Video Tutorial\n[Automated Connecticut Weekly Unemployment Benefits](https://www.youtube.com/watch?v=Ff6FEwIE0Bw)\n\n### Install ([PyPI](https://pypi.org/project/reemployct-data-entry/))\n```\npip install reemployct-data-entry\n```\n\n\n\n### Setup (Python)\nYou first need to get your copy of the Excel file that the program knows how to read job application data from:\n```\nfrom reemployct_data_entry import entry\n```\nThis 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).\n\nTip: 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.\n\n\n### Run\nYou can either run from the CLI with:\n```\nentry.main()\n```\nOr simply click `entry.py` to run it.\n\n## User Credentials\nTo 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.\n\n### Resetting saved credentials\n1. Delete `credFile.ini` from the project folder\n2. You will be prompted for new credentials when you run `entry.main()`\n\n",
"bugtrack_url": null,
"license": "AGPL-3.0-only",
"summary": "Automated entry of job application data into Connecticut's DOL ReEmployCT portal.",
"version": "2.0.6",
"project_urls": {
"Homepage": "https://github.com/ariffjeff/ReEmployCT-Data-Entry",
"Repository": "https://github.com/ariffjeff/ReEmployCT-Data-Entry"
},
"split_keywords": [
"unemployment",
" benefits"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c418c7708e684d4723dc6ea25e416910ba0346d9024b08726aec8b9679c32a3d",
"md5": "b31f7a38821cb0211601319f4455e166",
"sha256": "a9da7d0d614cbb8d87664b15faff629eb43b9b1244b8cdcfc9a2a34681995871"
},
"downloads": -1,
"filename": "reemployct_data_entry-2.0.6-py3-none-any.whl",
"has_sig": false,
"md5_digest": "b31f7a38821cb0211601319f4455e166",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<4.0.0,>=3.10.10",
"size": 46389,
"upload_time": "2024-04-10T02:36:54",
"upload_time_iso_8601": "2024-04-10T02:36:54.700294Z",
"url": "https://files.pythonhosted.org/packages/c4/18/c7708e684d4723dc6ea25e416910ba0346d9024b08726aec8b9679c32a3d/reemployct_data_entry-2.0.6-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "f5f93244a2be81747e677d9dc19ebfc19aed7be7bc3e6a265bbd67beb435bdb3",
"md5": "93977ce54e372cd25407ca37cce75103",
"sha256": "dcf3048401f678464a138c6d3502b51f150519f2c82fde0314afe1cec38ba2ef"
},
"downloads": -1,
"filename": "reemployct_data_entry-2.0.6.tar.gz",
"has_sig": false,
"md5_digest": "93977ce54e372cd25407ca37cce75103",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<4.0.0,>=3.10.10",
"size": 42348,
"upload_time": "2024-04-10T02:36:56",
"upload_time_iso_8601": "2024-04-10T02:36:56.617180Z",
"url": "https://files.pythonhosted.org/packages/f5/f9/3244a2be81747e677d9dc19ebfc19aed7be7bc3e6a265bbd67beb435bdb3/reemployct_data_entry-2.0.6.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-04-10 02:36:56",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "ariffjeff",
"github_project": "ReEmployCT-Data-Entry",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"requirements": [],
"lcname": "reemployct-data-entry"
}
JSON
