FASTER Web Report Parser

Unofficial tools to help with integrations with the FASTER Web fleet management system.

It includes support for two main FASTER Web report types.

• Parsers for select "Standard" CSV reports, mostly associated with inventory. Includes:

  • W200S - Inventory Summary Report
  • W223 - Inventory Transaction Details Report
  • W235 - Inventory Snapshot
  • W600 - Pick List Values Report

• Parsers for select "Standard" XLSX reports, mostly associated with inventory. Includes:

  • W200 - Inventory Report
  • W217 - Direct Charge Transactions
  • W223 - Inventory Transaction Details Report

Important Notes

⚠️ When parsing reports, use the files as exported from FASTER Web.
Reports that are opened and resaved in Excel will lose formatting required by the parsers.

⚠️ Excel exports from search results and other tables are not valid Excel files.
No parsers can be written for them!

Installation

npm install @cityssm/faster-report-parser

Usage

import { parseW223ExcelReport } from '@cityssm/faster-report-parser/xlsx'

const parsedReport = parseW223ExcelReport('C:/path/to/report.xlsx')

console.log(parsedReport.data[0].storeroomDescription)
// => "MAIN STOREROOM"

More Code for FASTER Web

Userscripts for FASTER Web
Fixes some of the common irks when using FASTER Web.