NetComm IP Portfolio Application

A comprehensive patent decision tracking and management system with a native macOS desktop interface.

Quick Start

# Start the decision tracking application
./start.sh

# Or start the web configuration app
./start.sh web

Requirements

• macOS (Sonoma/Sequoia)
• PostgreSQL (Postgres.app)
• Python 3.11+
• Database: patent_portfolio

Installation

1. Install PostgreSQL

Download and install Postgres.app

2. Create Database

createdb patent_portfolio

3. Run Database Migrations

cd database/migrations
# Apply your SQL migration files
psql -d patent_portfolio -f 001_initial_schema.sql

4. Install Dependencies

The startup script will automatically:

• Create a Python virtual environment (if needed)
• Install required packages (psycopg2-binary)

Or manually install:

python3 -m venv .venv
source .venv/bin/activate
pip install psycopg2-binary

Applications

Decision Tracking App (Default)

The main desktop application for managing patent decisions, approvals, and workflows.

./start.sh decision
# or simply
./start.sh

Features:

• Decision management and tracking
• Approval workflows
• Application linking
• Real-time database updates

Web Configuration App

Database configuration and setup utility.

./start.sh web

Manual Start

If you prefer to start manually:

# Activate virtual environment
source .venv/bin/activate

# Start decision app
cd frontend
python3 mac_decision_app.py

# Or start web app
python3 mac_web_app.py

Project Structure

netcomm-ip-portfolio/
├── start.sh              # Convenient startup script
├── README.md            # This file
├── .venv/               # Python virtual environment
├── frontend/            # Application code
│   ├── mac_decision_app.py
│   └── mac_web_app.py
├── database/            # Database schemas and migrations
│   └── migrations/
├── scripts/             # Utility scripts
└── docs/                # Documentation

Database Configuration

Update database credentials in the application files:

frontend/mac_decision_app.py:

user="YOUR_USERNAME"
password="YOUR_PASSWORD"

Troubleshooting

PostgreSQL not running

# Start Postgres.app manually
open -a Postgres

# Or check if it's running
psql -d postgres -c '\q'

Database doesn't exist

createdb patent_portfolio

Missing dependencies

source .venv/bin/activate
pip install psycopg2-binary

Permission issues

chmod +x start.sh

Testing

A comprehensive CRUD test suite is available:

psql -d patent_portfolio -f ../patent_portfolio_crud_tests.sql

This test suite validates all 29 tables across 113 tests:

• ✅ All CREATE operations
• ✅ All READ operations
• ✅ All UPDATE operations
• ✅ All DELETE operations

Support

For issues or questions, please check:

1. PostgreSQL is running (Postgres.app)
2. Database patent_portfolio exists
3. Database credentials are correct in application files
4. Virtual environment is activated

License

Internal use - NetComm IP Portfolio Management