PSI Tools

Synchronize and search inspection data via SharePoint to assist with auto-filling database records into forms.

# PSI Tools > ## ⚠️ FOR INTERNAL USE ONLY > > This extension is an internal tool for the Quality team. It is **not** for public, > personal, or third-party use, and must **not** be shared, published, or installed > outside the organisation. > > A browser side-panel extension that connects to the company SharePoint to > streamline Pre-Shipment Inspection (PSI) reporting workflows. Every feature assumes > an authenticated corporate SharePoint session and the team's own list structure. --- ## Features - **Data Search** — Look up records by PO Number or Model Code with auto cross-search and inline autocomplete; each result opens its owning module for editing. - **Model Management** — View, add, and edit model records on SharePoint, with real-time duplicate check and read-only audit info (last modified / by). - **Inspection Data** — Track PO results and defects across linked lists. Inspection tab (model, lot, sample size, inspector, result, lot action, defect rate) and Defect tab (description, qty, severity, category, photo evidence, batch paste), with live search, filters, sortable columns, a KPI/chart dashboard, and Excel export. - **PO Data Sync** — Import PO data from Excel (.xlsx / .xlsm / .xls) with date-range filtering, batch sync of new/updated records, and a full execution log. - **Auto Input** — One-click fill of the internal PSI Report form across 9 field groups (category, model, PO info, brand, specs, supplier, inspection details, AQL, signatures). - **Multi-file Uploader** — Attach up to 6 files to a report's attachment cells in one pass, with per-file filename validation against the record's Model + PO. Launch from Utilities or from a search result. - **Utilities** — Color reference, serial number decoder, AQL sampling plan (ANSI/ASQ Z1.4), and the multi-file uploader. **Database setup** (finding the Site URL, creating or repairing the Model / PO lists) is no longer part of PSI Tools. Since 10.3.0 it lives in the separate **PSI DB Setup** extension. Run it once, then paste its three values into SharePoint Connection (Settings group on the home panel). --- ## Permissions | Permission | Why it's needed | |---|---| | `sidePanel` | Renders the UI as a persistent side panel | | `tabs` | Opens/manages SharePoint tabs for authenticated sessions and locates the active PSI Report tab for Auto Input | | `scripting` | Auto-fills the internal PSI Report form and attaches files to it; also runs SharePoint REST calls inside the page's own authenticated session | | `storage` | Saves settings (`storage.sync`) and color history / last-used Excel sheet (`storage.local`). No credentials or inspection data are stored | | `clipboardRead` | Decodes pasted QR/barcodes (Serial Number Check) and pastes defect screenshots (Inspection Data) | | `downloads` | Writes the Excel exports (Model List, Inspection Data) through the browser's own Save-As dialog | | `downloads.open` | Launches the exported file from the "Export complete" dialog — nothing else is opened | **Host permissions:** the company SharePoint tenant (SharePoint data + REST API) and the internal PSI Report site (form auto-fill only). The exact hosts are listed in `manifest.json`. No data is sent to any third party — every network call uses the user's existing corporate session (`credentials: "include"`). The extension stores no passwords, tokens, or API keys. --- **Internal use only.** Do not redistribute.