Skip to content

M26 - PICKUPGRP/PICKUP_SUB Extraction & Improved Logging

Choose a tag to compare

View all tags
@bhuertgen bhuertgen released this 10 Mar 12:05
v2.26.0
c276e1c

🎉 Release M26.20260310.1239

✨ New Features

PICKUPGRP & PICKUP_SUB Tables

  • Automatic extraction of pickup group definitions and memberships
  • PICKUPGRP: Groups that can answer calls (domain, switch_name, pickupgrpnum, displ, info)
  • PICKUP_SUB: Member assignments to pickup groups (domain, switch_name, extension, pickupgrpnum)

Debug Mode (-Debug Parameter)

  • Detailed diagnostic output in log files
  • CSV file sizes and line counts for each API query
  • Hashtable entry counts during table loading
  • API exit codes for troubleshooting
  • Database state information

Improved Logging Structure

  • Phase-based headers for better progress tracking
  • PHASE 1: INITIALISIERUNG
  • PHASE 2: API-ABFRAGEN (Batch)
  • Clearer status messages and progress visualization

🔧 Improvements

  • Fixed -Debug parameter linking to DiagnosticMode variable
  • Enhanced error handling with exit code verification
  • Better diagnostic information throughout the ETL pipeline
  • Improved .gitignore with *.txt and PICKUP/ directory exclusion

📚 Documentation

New Wiki Pages:

  • API-Parameter.md - Complete parameter documentation
  • Home.md - Quickstart guide and feature overview

Updated Documentation:

  • README.md with all new parameters and features
  • Wiki pages with M26 highlights
  • Parameter tables and usage examples

📋 Version Details

  • Script Version: M26.20260310.1239
  • Release Date: 2026-03-10
  • Previous: M22.20260215.1931

🔗 Files

Main scripts:

  • getall_cfw.ps1 - Enhanced ETL with PICKUPGRP/PICKUP_SUB extraction
  • os4k2excel-server.ps1 - Web interface (uses enhanced getall_cfw.ps1)

Documentation:

  • README.md - Main documentation
  • Wiki/API-Parameter.md - New API documentation
  • Wiki/Home.md - New quickstart guide
  • CLAUDE.md - Development guidelines

💡 Usage Examples

Basic export with debug mode:
```powershell
.\getall_cfw.ps1 -ApiHost "10.10.206.18" -ApiUser "engr" -ApiPassword "secret" -Debug
```

With all options:
```powershell
.\getall_cfw.ps1 -ApiHost "10.10.206.18" -ApiUser "engr" -ApiPassword "secret" -OutputPath "C:\Exports" -MarkDuplicate -ShowSecrets -Debug \``

Web server:
```powershell
.\os4k2excel-server.ps1 -ApiHost "10.10.206.18" -ApiUser "engr" -ApiPassword "secret" -WebPassword "team2024" -SmtpServer "mail.firma.de" -SmtpFrom "os4k@firma.de" \``

🎯 For Users

  • Run with -Debug flag to generate detailed diagnostic logs when troubleshooting
  • PICKUPGRP and PICKUP_SUB data is automatically extracted and available for future reporting
  • Improved logging makes progress tracking easier
  • New documentation in Wiki for complete API parameter reference

Release created: 2026-03-10
Maintainer: bhuertgen

Assets 2
Loading