Automations

This Python-based desktop application is designed to restructure and format raw Excel files into clean, standardized financial templates.

Built with Tkinter, the interface prompts users to select an Excel workbook and choose a target template style, such as inventory reserves, fixed assets, or materials write-offs.

The program utilizes the openpyxl library to parse inconsistent source data, extracting header information, item names, quantities, and numerical values.

For complex reports like materials write-offs, it groups hierarchical data by document date and structures parent-child relationships systematically.

It automatically applies a unified Times New Roman layout, hides gridlines via styled borders, and adjusts row heights and column widths to specific dimensions.

Additionally, it incorporates system-specific UUID validation to restrict usage to licensed computers.

This Python-based Windows utility is designed to batch-update dates and years inside Microsoft Word documents.

Utilizing a Tkinter GUI, it lets users choose between incrementing found dates by one month or one year.

The application uses regular expressions to detect common date formats and standalone years marked with a Cyrillic suffix.

It natively edits .docx files using the python-docx library and converts older .doc files via local MS Word automation.

The script recursively traverses directories, skipping specified folders like "опов" and displaying detailed update summaries.

Additionally, it features hardware-based UUID licensing verification and assets handling for standalone executable compilation.

This Python-based desktop application is designed to automate the batch printing of documents and images on Windows system

It features a graphical user interface built with Tkinter, allowing users to select which file formats—such as Word, Excel, PDF, or images—to print.

The program recursively scans a chosen folder structure, excluding specific directories like "опов" and skipping temporary files.

By leveraging the PyWin32 library, it queues matching documents to the default system printer with safety delays between jobs.

A local tracking log is maintained to record successfully processed files, preventing duplicate prints in subsequent runs.

Finally, it includes hardware-based UUID validation to restrict unauthorized execution and supports packaging as a standalone executable.

A bot that uploads PDFs to a Wordpress website.

The bot:

Opens the Chrome browser,
Logs into the website,
Navigates to the plugin "PDF Poster",
Moves the first PDF file in a designated "done" folder,
Uploads the file,
Visits the specific location on the site,
Accesses Elementor and places the PDF in the desired position,
Repeats the process for each remaining PDF until they are all uploaded.

A bot that downloads data form a doctor and dentists software.

The bot:

Opens the Chrome browser and configures its settings for downloading,
Logs into the software,
Navigates to the database,
Sets the desired year,
Sets the desired month,
Downloads the data for the selected month and sets it to the next month,
Repeats the process for each remaining year until all the data is donwloaded.
Alerts the user by logging into the bot's Facebook account and sending a message indicating that the database for the current doctor or dentist has been successfully downloaded.