seanharding

It's a fair point, but I'll say I'd rather stick with my current InDesign solution than get into Access and LibreOffice (if for no other reason than that I have no Windows computers and am not going to set one up for Access, and the LibreOffice UX was pretty bad last time I tried it). It's true that at its core the data is relational. In fact, the source of truth is a relational database. But it's a webapp I don't own, so I don't have direct access to the DB. I can get the data via API or CSV downloads. Going from the "real" database, through the API or export transformations, and then reconstituting it into some relational db, whether it be Access, mysql, or anything else, feels like a headache beyond what I want to deal with. Regarding docx vs. IDML, I view this as more of a page layout problem than a word processing problem, but maybe that's just the way my brain works. I want finer control of object positioning, typography, etc. than the typical word processor is really designed to provide (even if they try). I'm very experienced with InDesign, and before that Quark and PageMaker, so it's kind of my comfort zone. Really the only reason I'm looking to change is that these days I don't do as much of that kind of work, and the InDesign cost is starting to feel like a waste of money... Anyway, thanks for the great input, everyone. This gave me some ideas to start experimenting with and see if it's worth diving fully into.

I probably just need to dig into it and try it to figure this out, but the thing I'm worried about is that some of my styles are very complex (not just bold, italic, font size, etc., but tweaks to kerning, hanging indents, before-and-after paragraph spacing, and so on). So I need a way to represent those without having to reapply it every time. I was thinking IDML might be better suited to carrying those through even if I don't keep InDesign (which I do currently have, but I've been considering getting rid of it because I don't use it that much so it's hard to justify the ongoing cost just for this one hobby project).

Thanks Walt. I also just saw that Publisher apparently now supports IDML files. I've never worked with IDML before, but from a quick skim it sounds like it might work. Any thoughts on the pros and cons of IMDL vs. DOCX? Would either of those allow me to programmatically apply a style by name (e.g. "sectionhead"), and then have the specifics of that style defined in Publisher? I'm trying to avoid having to hardcode actual formatting in the program or intermediate file, and also to not have to manually go through 30 pages applying styles every time. The nice thing about my current setup is that I can instantly change anything about the layout just by updating the styles in the template.

I'm trying to figure out if there's a way to do what I want to do in Publisher. Basically, I have a CSV file with a bunch of fields. Some of those fields are used to group items under headings, subheadings, etc., and then other fields will be used to put together rows under the headings. So it's not a simple mail merge like creating labels or something. It needs some fairly complex logic. Currently I am doing this in InDesign with an InDesign JSX script that reads the CSV file, does the transformations, and adds the results into a text box that flows across multiple pages (however many are needed) in my document. That document is created from a template that already has the character and paragraph styles I need in order to style the document the way I want (so the script doesn't do any formatting other than applying the styles, which are defined in the template). I can think of two possible ways to do this, but it's not clear to me that either is possible today in Publisher. One would be to use some kind of script similar to what I'm doing in InDesign to, within Publisher, process the data and place it in a templated file. The second is if the Publisher document format is straightforward and/or documented, I could write code to actually generate the document outside of Publisher. But maybe there are other options as well; I am open-minded about how to achieve this. Any thoughts on whether this is possible today, or might be at some point in the future? For anyone who cares, here's a blog post I wrote many years ago about the specific thing I'm doing in InDesign (though I have since changed it to just read from a CSV export rather than talking to the API over HTTP).