📁 VINA File Manager

A modern, feature-rich file management system with advanced search and metadata organization

Features • Installation • Usage • Screenshots • Contributing

---

📋 Table of Contents

• About
• Features
• Requirements
• Installation
• Usage
• Project Structure
• Database Schema
• Contributing
• License
• Acknowledgments

---

🎯 About

VINA File Manager is a sophisticated desktop application designed for efficient document and file management. Built with PyQt5, it provides an intuitive interface for organizing, searching, and managing files with rich metadata support including categories, clients, versions, and custom item names.

Perfect for businesses and teams that need to:

• 📚 Organize large collections of documents
• 🔍 Quickly search files by multiple criteria
• ⭐ Mark and filter favorite files
• 📊 Track file versions and metadata
• 🎨 Work in a comfortable dark or light theme

---

✨ Features

🔍 Advanced Search

• Real-time search across multiple fields:
  • Filename
  • Item name
  • Category
  • Client name
  • Version number

📁 File Management

• ➕ Add individual files or entire folders
• 🖱️ Drag & drop support for quick file import
• 📂 Open files or navigate to their folders
• 🗑️ Remove files from database

🏷️ Metadata Organization

• Categories: Organize files by type or department
• Clients: Track files by customer or project
• Versions: Maintain version history
• Item Names: Custom descriptive names for files
• Auto-complete: Dropdown suggestions for categories and clients

⭐ Favorites System

• Mark important files as favorites
• Filter view to show only favorites
• Quick toggle between all files and favorites

🎨 User Interface

• 🌗 Dark/Light mode toggle
• 📊 Clean, modern table view
• 🎯 Context menu for quick actions
• 📱 Responsive column resizing
• 🔄 Auto-refresh functionality

💾 Data Persistence

• SQLite database for reliable storage
• Automatic metadata tracking
• Last modified date tracking

---

📦 Requirements

• Python 3.6 or higher
• PyQt5 5.12 or higher
• SQLite3 (included with Python)

Optional (for building executables)

• PyInstaller
• Inno Setup (for Windows installer)

---

🚀 Installation

Method 1: Using Python (Development)

1. Clone the repository

   git clone https://github.com/yourusername/File-manager-project.git
   cd File-manager-project

2. Install dependencies

   pip install PyQt5

3. Run the application

   python "VINA File_manager.py"

Method 2: Using Pre-built Executable

1. Download the latest release from the Releases page
2. Run VINA File_manager.exe
3. The application will create a files_advanced.db database file automatically

---

💻 Usage

Getting Started

1. Launch the application

   • Run the executable or Python script
   • The database will be created automatically on first launch

2. Add Files

   • Click ➕ เพิ่มไฟล์ (Add File) to select individual files
   • Click 📁 เพิ่มโฟลเดอร์ (Add Folder) to import all files from a folder
   • Or simply drag and drop files/folders into the window

3. Enter Metadata

   • When adding files, you'll be prompted for:
     • Item Name: A descriptive name for the file
     • Category: File category (with auto-complete)
     • Client: Client or project name (with auto-complete)
     • Version: Version number or identifier

4. Search Files

   • Type in the search box to filter files in real-time
   • Search works across all metadata fields

5. Manage Files

   • Double-click a file to open it
   • Right-click for context menu options:
     • Open file
     • Open folder
     • Edit metadata
     • Toggle favorite status
     • Delete from database

6. View Favorites

   • Click ⭐ แสดงรายการโปรด (Show Favorites) to filter
   • Toggle back to show all files

7. Switch Themes

   • Click 🌗 สลับโหมดสว่าง/มืด (Toggle Dark/Light Mode)

---

📂 Project Structure

File-manager-project/
│
├── VINA File_manager.py      # Main application file
├── VINA File_manager.spec    # PyInstaller spec file
├── files_advanced.db          # SQLite database (auto-generated)
├── logo.png                   # Application logo
├── logo.ico                   # Application icon
├── developer.png              # Developer information image
│
├── build/                     # Build artifacts
│   └── VINA File_manager/
│
├── dist/                      # Distribution files
│   ├── VINA File_manager.exe
│   └── ...
│
└── compile setup/            # Installation setup files
    ├── set.iss
    └── VINA File_manager.exe

---

🗄️ Database Schema

The application uses SQLite with three main tables:

files Table

Column	Type	Description
id	INTEGER	Primary key
filename	TEXT	Original filename
item_name	TEXT	Custom item name
filepath	TEXT	Full file path
category	TEXT	File category
client	TEXT	Client/project name
version	TEXT	Version identifier
favorite	INTEGER	Favorite flag (0 or 1)
last_modified	TEXT	Last modification date

category_list Table

Column	Type	Description
id	INTEGER	Primary key
name	TEXT	Category name (unique)

client_list Table

Column	Type	Description
id	INTEGER	Primary key
name	TEXT	Client name (unique)

---

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request. For major changes, please open an issue first to discuss what you would like to change.

How to Contribute

1. Fork the repository
2. Create your feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

---

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

---

🙏 Acknowledgments

• Built with PyQt5
• Database powered by SQLite
• Developed for VINA Sport Company

---

Made with ❤️ for efficient file management

⭐ Star this repo if you find it helpful!