Excel Template Mapper

A professional web application for Excel template mapping and data transformation.

Architecture

• Backend: Django REST API with SQLite database
• Frontend: React application with Material-UI and Tailwind CSS
• Deployment: Docker containers on Azure (backend) and Netlify (frontend)

Quick Start

Using Docker (Recommended)

# Clone the repository
git clone <repository-url>
cd mapping_factwise

# Build and run with Docker Compose
cd BOM
docker-compose up --build

Access the application:

• Frontend: http://localhost:3000
• Backend API: http://localhost:8000

Local Development

1. Backend Setup:

   cd BOM/backend
   python -m venv venv
   source venv/bin/activate  # Windows: venv\Scripts\activate
   pip install -r requirements.txt
   python manage.py migrate
   python manage.py runserver

2. Frontend Setup:

   cd BOM/frontend
   npm install
   npm start

Features

• Excel file upload and processing
• Column mapping interface
• Data transformation with custom formulas
• Template management
• Export functionality
• Responsive web interface

Deployment

• Backend: Azure Container Instances
• Frontend: Netlify static hosting
• Database: SQLite (production ready for small-medium scale)

Tech Stack

• Django 4.x
• React 18
• Material-UI v5
• Tailwind CSS
• AG Grid
• Docker