Administration

Data source, sync and column governance for the DMS status portal.

Daily data upload

Manually refresh the portal by uploading the latest SCANNING_SEARCH_FINAL.xlsx from OneDrive. Data is indexed instantly and served to all searches on this device.

SCANNING_SEARCH_FINAL.xlsx (bundled)

9,781 rows · original snapshot

Tip: exports must include the same header row as the original workbook (OSOURCE NUMBER, DMS NUMBER, Status, Vendor, Bill No…). The largest sheet — or one named BACK END DATA — is auto-selected.

Data source

OneDrive file path

Refresh interval (minutes)

Microsoft Graph / OneDrive

Live OneDrive sync requires connecting the Microsoft OneDrive connector. Until then, the portal serves a snapshot of SCANNING_SEARCH_FINAL.xlsx(9,781 rows).

Sync status

Dataset loaded

9,781 rows

Columns auto-detected

37 columns

OneDrive live sync

Not connected — using snapshot

Cache & indexing

Client-side, instant search

Searchable columns

Fields available to search from the portal.

OSOURCE NUMBERDMS NUMBERStatusPlantBill Receive dateScan DatePosting NumberParking numberPark DatePost DateScan UserPark UserPost UserBill TypeBill Sub TypeVendorVendor NameBill NoBill DateAccountant RemarksGST NumberFBP NameMSME StatusManual.Rej.ByManual.Rej.DtCompany CodeBill AmountTDS DeductionDeductionFinal AmountPurch.Doc.DATECOURIER NUMBERSENDER'S NAMESCANNINGDONE BYDATE WISE

Output columns

Fields shown in the result card and table.