Skip to main content

Team Installation Script

Save this script as install_packages.bat and share with your team for quick setup.

The Script​

install_packages.bat
@echo off
echo ========================================
echo  NetSuite Report Development Setup
echo ========================================
echo.

echo Checking Python installation...
python --version >nul 2>&1
if %errorlevel% neq 0 (
    echo.
    echo ERROR: Python is not installed or not in PATH!
    echo.
    echo Please install Python from https://www.python.org/downloads/
    echo IMPORTANT: Check "Add Python to PATH" during installation!
    echo.
    pause
    exit /b 1
)

echo Python found!
python --version
echo.

echo Checking pip installation...
python -m pip --version >nul 2>&1
if %errorlevel% neq 0 (
    echo pip not found. Installing pip...
    python -m ensurepip --default-pip
    if %errorlevel% neq 0 (
        echo Trying alternative pip installation...
        curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
        python get-pip.py
        del get-pip.py
    )
)
echo.

echo Upgrading pip to latest version...
python -m pip install --upgrade pip
echo.

echo Installing required packages...
pip install pandas xlsxwriter numpy openpyxl jupyter
echo.

echo ========================================
echo  Installation Complete!
echo ========================================
echo.
echo Installed packages:
echo   - pandas (data processing)
echo   - xlsxwriter (Excel creation)
echo   - numpy (calculations)
echo   - openpyxl (Excel reading)
echo   - jupyter (notebook support)
echo.
echo Next steps:
echo   1. Open VS Code
echo   2. Install "Python" extension by Microsoft
echo   3. Install "Jupyter" extension by Microsoft
echo   4. Open .ipynb notebook files
echo.
pause

How to Use​

  1. Copy the script above
  2. Open Notepad
  3. Paste the content
  4. Save as install_packages.bat (make sure "Save as type" is "All Files")
  5. Right-click the file → "Run as administrator"

What the Script Does​

  1. Checks Python Installation - Verifies Python is installed and in PATH
  2. Shows Python Version - Confirms which version is installed
  3. Installs pip - If pip is not found, installs it using ensurepip or downloads from bootstrap.pypa.io
  4. Upgrades pip - Ensures the package manager is up-to-date
  5. Installs Packages - Installs all required dependencies:
    • pandas - Data manipulation library
    • xlsxwriter - Excel file creation
    • numpy - Numerical calculations
    • openpyxl - Excel file reading
    • jupyter - Notebook support
  6. Shows Next Steps - Guides the user to complete VS Code setup

Troubleshooting​

Script says "Python is not installed"​

  1. Download Python from https://www.python.org/downloads/
  2. During installation, check "Add Python to PATH"
  3. After installation, restart Command Prompt
  4. Run the script again

Installation takes too long​

Some corporate networks block or slow down pip. Try:

pip install pandas xlsxwriter numpy openpyxl jupyter -i https://pypi.org/simple/ --trusted-host pypi.org

Permission errors​

Make sure you right-click and select "Run as administrator"