I'll create a Flask web application with all the requested features. Here's the complete setup: from flask import Flask, render_template, request, redirect, url_for, flash, jsonify import os from werkzeug.utils import secure_filename import pandas as pd import pyodbc from datetime import datetime app = Flask(__name__) app.secret_key = 'your_secret_key_here' app.config['UPLOAD_FOLDER'] = 'uploads' app.config['ALLOWED_EXTENSIONS'] = {'xlsx', 'xls'} # Ensure upload folder exists os.makedirs(app.config['UPLOAD_FOLDER'], exist_ok=True) def allowed_file(filename): return '.' in filename and \ filename.rsplit('.', 1)[1].lower() in app.config['ALLOWED_EXTENSIONS'] def process_excel(filepath): try: df = pd.read_excel(filepath) # Add your processing logic here # Example: df = df.dropna() return True, "File processed successfully" except Exception as e: return False, str(e) def connect_to_database(connection_details): try: if connection_details['SRC_USE_TRUSTED'] == 'on': conn_str = f"DRIVER={connection_details['SRC_ODBC_DRIVER']};SERVER={connection_details['SRC_SERVER']};DATABASE={connection_details['SRC_DATABASE']};Trusted_Connection=yes;" else: conn_str = f"DRIVER={connection_details['SRC_ODBC_DRIVER']};SERVER={connection_details['SRC_SERVER']};DATABASE={connection_details['SRC_DATABASE']};UID={connection_details['SRC_USERNAME']};PWD={connection_details['SRC_PASSWORD']};" conn = pyodbc.connect(conn_str) cursor = conn.cursor() # Fetch data query = f"SELECT * FROM {connection_details['SRC_TABLE_NAME']}" df = pd.read_sql(query, conn) # Process data (add your logic here) # Example: df = df.dropna() conn.close() return True, "Data fetched and processed successfully", df except Exception as e: return False, str(e), None @app.route('/') def home(): return render_template('index.html') @app.route('/insert-data') def insert_data(): return render_template('insert_data.html') @app.route('/view-reports') def view_reports(): return render_template('view_reports.html') @app.route('/upload-excel', methods=['POST']) def upload_excel(): if 'file' not in request.files: flash('No file part', 'error') return redirect(url_for('insert_data')) file = request.files['file'] if file.filename == '': flash('No selected file', 'error') return redirect(url_for('insert_data')) if file and allowed_file(file.filename): filename = secure_filename(file.filename) filepath = os.path.join(app.config['UPLOAD_FOLDER'], filename) file.save(filepath) success, message = process_excel(filepath) if success: flash('File uploaded and processed successfully!', 'success') else: flash(f'Error processing file: {message}', 'error') return redirect(url_for('insert_data')) flash('Invalid file type', 'error') return redirect(url_for('insert_data')) @app.route('/connect-database', methods=['POST']) def connect_database(): connection_details = request.form.to_dict() success, message, data = connect_to_database(connection_details) if success: flash(message, 'success') # Here you would typically save the processed data return redirect(url_for('insert_data')) else: flash(f'Error: {message}', 'error') return redirect(url_for('insert_data')) if __name__ == '__main__': app.run(debug=True) Data Management App

{% with messages = get_flashed_messages(with_categories=true) %} {% if messages %} {% for category, message in messages %}

{% endfor %} {% endif %} {% endwith %} {% block content %}{% endblock %}

{% block scripts %}{% endblock %} {% extends "base.html" %} {% block content %}

Welcome to Data Management

Choose an option below to get started

Insert New Data View Existing Reports

{% endblock %} {% extends "base.html" %} {% block content %}

Insert New Data

ODBC Driver

Server

Database

Table Name

Use Trusted Connection

Username

Password

{% endblock %} {% block scripts %} {% endblock %} {% extends "base.html" %} {% block content %}

View Reports

Reports functionality will be implemented here.

Reports dashboard coming soon

{% endblock %} Flask==2.3.2 pandas==2.0.3 openpyxl==3.1.2 pyodbc==4.0.39 Werkzeug==2.3.6 To run the application: 1. Install dependencies with `pip install -r requirements.txt` 2. Start the Flask app with `python app.py` 3. Access the application at http://localhost:5000