HackerTrans
TopNewTrendsCommentsPastAskShowJobs

Harlekuin

no profile record

Submissions

Show HN: AutoDocument – Multi-Source Document Generation

autodocument.app
7 points·by Harlekuin·vor 2 Jahren·0 comments

Ask HN: Would you have an interest in a Document Automation project?

2 points·by Harlekuin·vor 3 Jahren·2 comments

Ask HN: Why aren't SQL queries compiled?

5 points·by Harlekuin·vor 3 Jahren·10 comments

comments

Harlekuin
·vor 9 Monaten·discuss
AutoDocument: https://github.com/TomMalkin/AutoDocument

Imagine your basic Excel spreadsheet -> generating document files, but add:

- Other sources like SQL queries

- User form (e.g. "Generate documents for Client Category [?]")

- Chaining sources in order like SQL queries with parameters based on the user form

- Split at multiple points (5 records in a csv, 4 records in a sql result = 20 generated documents)

- Full Jinja2 templating with field substitution but also if/for blocks that works nicely with .docx files

- PDF output

- output file names using the same templating: "/BusinessDrive/{{ client_id }}/Invoice - {{ invoice_id}}.pdf"

All saved in reproducible workflows (for example if you need to process a .csv file you receive each morning)
Harlekuin
·vor 4 Jahren·discuss
Australia is a kangaroo with nipple tassels and a missing toe - pretty spot on
Harlekuin
·vor 4 Jahren·discuss
Funny coincidence, the logo is very similar to a convenience store we have in Australia: https://nightowl.com.au/