Parses select Excel (XLSX) and CSV reports from the FASTER Web Fleet Management System into usable data objects.
Useful when developing integrations between FASTER Web and other systems.
# | Report Name | CSV | XLSX |
---|---|---|---|
W114 | Asset Master List | ✔️ | |
W200 | Inventory Report | ✔️ | |
W200S | Inventory Summary Report | ✔️ | |
W217 | Direct Charge Transactions | ✔️ | |
W223 | Inventory Transaction Details Report | ✔️ | ✔️ |
W235 | Inventory Snapshot | ✔️ | |
W311 | Active Work Orders by Shop | ✔️ | |
W600 | Pick List Values Report | ✔️ |
Reports that are opened and resaved in Excel will lose formatting required by the parsers.
No parsers can be written for them!
npm install @cityssm/faster-report-parser
import { parseW223ExcelReport } from '@cityssm/faster-report-parser/xlsx'
const parsedReport = parseW223ExcelReport('C:/path/to/report.xlsx')
console.log(parsedReport.data[0].storeroomDescription)
// => "MAIN STOREROOM"
💡 Schedule exporting the necessary reports in FASTER Web to an FTP, then download those reports for parsing.
- basic-ftp does a great job downloading from FASTER Web FTP sites!
💡 Schedule downloading reports from the FTP based on the export schedule defined in FASTER Web.
- node-schedule makes it easy to schedule downloading new reports using parameters very similar to the scheduling parameters in FASTER Web.
💡 Make use of other APIs and import tools to integrate with other systems.
-
@cityssm/dynamics-gp - Unofficial integrations with the Microsoft Dynamics GP financial system.
-
@cityssm/worktech-api - Unofficial integrations with the WorkTech work order management system.
FASTER Web Helper
A service to support integrations with the FASTER Web fleet management system.
Userscripts for FASTER Web
Fixes some of the common irks when using FASTER Web.