focus-export
FOCUS export
Writes billing data in FOCUS columns, one CSV per source and period. FOCUS gives every provider the same column names and meanings, so files from different providers can sit in one table. scripts/focus_export.py convert maps the columns of a billing file to FOCUS with a column map in JSON, parses dates and amounts, and validates every row. check validates an existing FOCUS file. The other finops skills read the files this skill writes.
Check before use: FOCUS spec version. The column list in scripts/focus_export.py (COLUMNS) and the allowed ChargeCategory values follow one release of the FOCUS Cost and Usage columns. Compare both with the current release on the FOCUS site of the FinOps Foundation before a file goes to anyone outside the team.
Inputs
- Source file (required): a CSV export from a provider, a FOCUS export, or invoice lines typed into a CSV.
- Provider: the name to write into
ServiceProviderName,HostProviderNameandInvoiceIssuerName. - Period: the days to keep, as
--start(first day) and--end(day after the last day). - Output: default
finops/focus/<provider>-<YYYY-MM>-to-<YYYY-MM>.csv.
Steps
- Set up. Copy the script and the example map without overwriting: