DataPallas Report Bursting

Split PDF and Excel reports into multiple files using burst tokens.

75|8|Updated Dec 20, 2023
One-click install
npx skills add https://github.com/flowkraft/datapallas --skill datapallas-report-bursting
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: DataPallas Report Bursting
Source: https://github.com/flowkraft/datapallas/tree/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/_ai-hub/.skills/datapallas-report-bursting
Command: npx skills add https://github.com/flowkraft/datapallas --skill datapallas-report-bursting

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you convert a single PDF or Excel export into many output files by splitting documents at meaningful “burst tokens” (like invoice numbers or email addresses) instead of manually separating pages or rows.

Core Features & Use Cases

  • PDF bursting by token delimiters: place tokens inside curly brackets (e.g., {customer_id}) so each distinct token value creates its own output PDF (defaulting to ${burst_token}.pdf).
  • Excel bursting by distinct sheets or column values: either output one file per distinct sheet name (default) or generate one file per distinct value in a specified token column using a configuration/metadata sheet.
  • Merged-file bursting: merge multiple PDFs first, then burst the merged result to produce token-based outputs in a single workflow.

Quick Start

Configure your report so the burst token appears in the document (wrap it in curly braces for PDFs, or set up the Excel bursting method/metadata sheet for Excel), then burst the document so each token value generates its own PDF or Excel output file.

Frequently Asked Questions about DataPallas Report Bursting

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I split a single PDF report into multiple files by invoice number?

PDF bursting splits a single report into multiple output files by using burst tokens wrapped in curly braces, such as {invoice_number}. Each distinct token value found in the document automatically generates its own separate PDF output file.

What is the best way to automate payslip generation from an Excel export?

Excel bursting automates payslip generation by splitting an Excel export into separate files based on distinct sheet names or specific column values. You configure a burst metadata sheet to define the splitting method and token column indices for the outputs.

Can I merge multiple PDFs together and then burst the combined document?

Yes, merged-file bursting allows you to combine multiple PDFs into a single document and then burst the merged result. This workflow uses your embedded curly-braced tokens to produce token-based individual PDF outputs in one process.

How does token splitting work for batch document exports?

Token splitting works by scanning your source document for delimited text values that act as split points. In PDFs, tokens must be curly-braced, while Excel bursting uses a metadata sheet to map sheet or column indices to distinct token values for file generation.

Do I need a metadata sheet for Excel bursting by column values?

Yes, to burst an Excel file by distinct column values, you need a burst metadata sheet. This sheet must specify the splitting method, sheet and column indices, and the token values used to generate the individual Excel output files.

What format do burst tokens need to be in for PDF document automation?

For PDF document automation, burst tokens must be embedded as curly-braced text, like {customer_id}. The bursting process scans for these delimiters to determine the split points and creates a separate PDF for each distinct token value.