IA Projects Suite

A comprehensive Streamlit-based application suite with shared architecture for Excel processing and data management.

🚀 Features

Applications Included

• 📊 Excel Merger: Merge multiple Excel files with formatting preservation
• 💰 Zental Supplier Remittances: Process supplier remittance files and generate payment summaries
• 📈 SME Daily Tracker: Convert daily tracking Excel files to standardized templates

Architecture Highlights

• Shared Components: Reusable UI components across all apps
• Centralized Configuration: Single source of truth for app settings
• Consistent UX: Unified design and user experience
• Modular Design: Easy to add new applications

🛠️ Installation

1. Clone the repository

   git clone https://gitlab.com/sagarbarkade/internal-automation-projects.git
   cd internal-automation-projects
   

2. Install dependencies

   pip install -r requirements.txt
   

3. Run the application

   streamlit run main_refactored.py
   

📦 Project Structure

internal-automation-projects/
├── main_refactored.py          # Main application launcher
├── main.py                     # Legacy main file
├── shared/                     # Shared architecture
│   ├── components/            # Reusable UI components
│   ├── config/               # Centralized configurations  
│   ├── utils/                # Common utilities
│   └── database/             # Shared data models
├── apps/                     # Individual applications
│   ├── excel_merger/         # Excel file merging app
│   ├── zental/               # Supplier remittances app
│   ├── sme_daily_tracker/    # Daily tracking converter
│   └── pdf_table_extractor/  # PDF table extraction app
├── config/                   # Legacy configuration
├── database/                 # Database utilities
├── frontend/                 # Legacy frontend
├── templates/                # App templates
├── utils/                    # Legacy utilities
├── requirements.txt          # Python dependencies
├── Dockerfile               # Docker configuration
├── docker-compose.yml       # Docker Compose setup
├── .gitlab-ci.yml          # CI/CD pipeline
└── add_new_app.py          # App creation utility

🎯 Adding New Applications

With the shared architecture, adding new apps is streamlined:

1. Create app structure in apps/new_app/
2. Add configuration to shared/config/app_configs.py
3. Create UI using shared components
4. Register in main launcher

🔧 Configuration

All app configurations are centralized in shared/config/:

• base_settings.py - Common settings
• app_configs.py - App-specific configurations

📋 Requirements

• Python 3.8+
• Streamlit 1.28.0+
• pandas
• openpyxl
• Other dependencies listed in requirements.txt

🚦 Usage

1. Launch the application: streamlit run main_refactored.py
2. Select an application from the sidebar
3. Follow the on-screen instructions for each app
4. Upload files and process according to app functionality

🤝 Contributing

1. Fork the repository
2. Create a feature branch
3. Make your changes using the shared architecture
4. Submit a pull request

📄 License

This project is licensed under the MIT License.

📞 Support

For questions or support, please open an issue in the GitLab repository.