mis-cli v1.1.0

v1.1.0

Summary

This release improves data loading validation, adds richer selection in row replace, and expands submission import/export coverage.

Highlights

• VR_CUSTOM SQL now aggregates VR03.
• Row replace supports campus-first selection with per-campus file choices.
• CSV loader validates SB00 format and annotates load results.
• Submission import/export now includes additional folders and Final dat.

Changes

• Revise VR_CUSTOM SQL files to aggregate VR03.
• Update row_replace.py:
  • Campus selection via multi-select.
  • File selection per campus with ALL option.
  • Confirmation step before execution; Ctrl+C prompts to restart or exit.
• Update csv_loader.py:
  • Only loads rows with SB00 matching ^@\d{8}$.
  • Adds a LOADED flag in output and writes annotated files.
• Update finalize_sub.py / import_sub.py:
  • Include External Files/sg_loader, External Files/csv_loader, External Files/manual_download.
  • Include Final dat at the top level.

Notes

• Oracle table naming behavior remains unchanged (uppercase).
• Copy operations continue to overwrite/merge existing files.

mis-cli v1.0.0

v1.0.0

Summary

First stable release of MIS-CLI, a command-line tool for California college MIS file processing and submission workflows.

Highlights

• MIS data extraction and preparation.
• DAT file editing, compilation, and staging.
• Invalid character and row detection.
• Database loaders for DWH.
• OneDrive submission import/export.
• Term instance management.
• Windows Explorer integration.

Installation

1. Download mis-cli.zip from this release.
2. Extract the files.
3. Run the included batch file.
4. Complete the initial configuration prompts.

Notes

• Designed for NOCCCD and California Community College MIS workflows.
• Requires Oracle client and database access.
• See README.md for full documentation.