# Automate Data Entry

Needed a script for data entry. System has a GUI and I decided to use **pyautogui** to type the information in for me. This script was created for a specific purpose but could be adapted if needed.

I created a list of what values I needed to enter. Each item has 3 fields that need to be entered:

- Code
- Description
- Min Entry

All of the fields are strings and are set in the ```VALUES``` variable.

Highlights of the script:

- Set an interval of 0.5 seconds for **pyautogui**
- Set a sleep for 10 seconds to place the cursor in the correct spot on the screen for entry
- Calls to ```press('enter', interval=INTERVAL)``` advance the cursor to the next field and next row in the GUI
- A sleep call was added to ```val_code_entry``` function as a failsafe if the script needs to be halted via ```Ctrl+C```


Script:

```python
#!/usr/bin/env python3

"""Add codes to system."""

from time import sleep
from pyautogui import press, typewrite


INTERVAL = 0.5

# Sample Code, Description, and Min Entry values
VALUES = [
    ['Code01', 'CODE 1', 'C01', ],
    ['Code02', 'CODE 2', 'C02', ],
    ['Code03', 'CODE 3', 'C03', ],
    ['Code04', 'CODE 4', 'C04', ],
]


def val_code_entry(code: str, description: str, min_entry: str, sleep_: int = 3):
    """Code entry process."""
    typewrite(code, interval=INTERVAL)
    press('enter', interval=INTERVAL)
    typewrite(description, interval=INTERVAL)
    press('enter', interval=INTERVAL)
    typewrite(min_entry, interval=INTERVAL)
    press('enter', interval=INTERVAL)
    press('enter', interval=INTERVAL)
    press('enter', interval=INTERVAL)
    sleep(sleep_)


def main():
    """Main function."""
    for value in VALUES:
        val_code_entry(code=value[0],
                       description=value[1],
                       min_entry=value[2]
                       )


if __name__ == "__main__":
    print('Sleeping for 10 seconds for cursor placement...')
    sleep(10)
    main()
``` 

Ran the script and it worked. Saved my time and errors.

Enjoy! Happy Coding.

## REFERENCES
- [PyAutoGUI’s documentation](https://pyautogui.readthedocs.io/en/latest/)
- [pyautogui GitHub](https://github.com/asweigart/pyautogui)