I'm making a magazine. I have already made the entire "backend", meaning I have a database system where I can easily insert new contents, juggle it around in an "order" for each issue, edit it, etc., and dump it all as a plaintext "finished issue".
However, it strikes me that most of the world probably will be put off by a plaintext magazine, and want a beautiful printed PDF or some kind of digital file or something.
I have played around with "Scribus", an open source magazine GUI program, but found it very cryptic and limiting. However, I suspect that it's the best out there that exists which doesn't cost money, and money is very much an issue for me...
I'm trying to find out if there is some way to, if not fully automate, then at least allow me to dump some kind of "contents file" in a format that "desktop publishing" software understands and can thus allow me to easily "place around" the content and design it without forcing me to sit there and manually copying and pasting all the text fields from my "backend" system all the time, but instead just allow me to dump such a file, open some GUI program and have it insert my "content pieces" as objects which I can move around.
I assume that this is (roughly) how they have been doing things since the early days of desktop publishing in the 1980s, but of course, all software costs a ton of money and requires you to give up all your personal information to the company, which are both serious issues for me. On the other hand, Scribus seems to be the only desktop publishing program that is free, even after 35 years of this being a thing, so I don't know what to do now.