# Vera Medical CRM - Quick Setup Guide

## 🚀 Get Started in 3 Steps

### Step 1: Install Python Dependencies

```bash
pip install -r requirements.txt
```

### Step 2: Import the Data

```bash
python import_data.py
```

**Wait for completion** - This will take a few minutes to process 305,679 records.

### Step 3: Start the Application

```bash
python app.py
```

Open your browser and visit: **http://localhost:5050**

---

## ✅ What You Get

### A Complete CRM System with:

✨ **Dashboard**
- Real-time statistics
- Recent cases overview
- Top clients ranking
- Quick action buttons

📁 **Cases Management**
- 305,679+ cases from 2003-2025
- Search and filter capabilities
- Full CRUD operations
- Detailed case views

👥 **Claimant Management**
- Personal information
- Contact details
- Associated cases
- Create/edit profiles

🏢 **Client Management**
- Insurance companies
- Adjuster contacts
- Case statistics
- Company profiles

---

## 🎯 Default URLs

| Feature | URL |
|---------|-----|
| Dashboard | http://localhost:5050/ |
| Cases | http://localhost:5050/cases |
| Claimants | http://localhost:5050/claimants |
| Clients | http://localhost:5050/clients |

---

## 📊 Data Overview

After import, you'll have:

- ✅ **305,679** cases imported
- ✅ **~45,000** claimants
- ✅ **~80** insurance companies
- ✅ **~150** law firms
- ✅ **~250** lawyers
- ✅ **~300** insurance adjusters

All data is **normalized** and **indexed** for fast queries!

---

## 🔍 Features

### Search & Filter
- Search cases by claimant name or case ID
- Filter by status (Active/Closed/All)
- Paginated results (50 per page)

### CRUD Operations
- **Create** new cases and claimants
- **Read** detailed information
- **Update** existing records
- **Delete** (with confirmation)

### Related Data
- View claimant's all cases
- See client's case statistics
- Track law firm associations
- Link adjuster contacts

---

## 🎨 Modern UI

Built with **Tailwind CSS** for:
- 📱 Responsive design (mobile-friendly)
- 🎨 Beautiful gradients and colors
- ⚡ Fast, intuitive navigation
- 🔍 Easy-to-use search

---

## 💡 Pro Tips

1. **Use Search:** The search is indexed and very fast - use it liberally!

2. **Filter Active Cases:** Use the status filter to focus on open cases only

3. **Quick Navigation:** Use breadcrumbs and back buttons to navigate efficiently

4. **View Related Data:** Click on claimant/client names to see their full profiles

5. **Create from View:** When viewing a claimant, you can create a new case for them directly

---

## ⚠️ Troubleshooting

### Database Not Found
```
⚠️  Database not found. Please run import_data.py first.
```
**Solution:** Run `python import_data.py`

### Port In Use
```
Error: Address already in use
```
**Solution:** Change port in app.py or kill the process using port 5050

### Missing Dependencies
```
ModuleNotFoundError: No module named 'flask'
```
**Solution:** Run `pip install -r requirements.txt`

---

## 📞 Need Help?

1. Check `README.md` for detailed documentation
2. Review `VMdata_Schema_Analysis.md` for database structure
3. Contact your IT administrator

---

## 🎉 Ready to Go!

Your Vera Medical CRM is now set up and ready to use. Enjoy managing your cases efficiently!

---

*Setup Guide v1.0 - October 2025*