this post was submitted on 15 Jul 2023
12 points (87.5% liked)

Selfhosted

40152 readers
510 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

  1. Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don't duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 1 year ago
MODERATORS
ruud@lemmy.world
Loki@lemmy.world
CannaVet@lemmy.world
HybridSarcasm@lemmy.world
devve@lemmy.world
HybridSarcasm@lemmy.hybridsarcasm.xyz
12
Help finding the right software. (compuverse.uk)
submitted 1 year ago* (last edited 1 year ago) by Ceedling@compuverse.uk to c/selfhosted@lemmy.world
12 comments fedilink hide all child comments
 

I keep running my head into a wall working on a project and I am hoping you guys can help me. I have created a database that contains the addresses of contacts. What I need to accomplish is generating paper reports of these addresses. So, for example, I may have 25 addresses on one report related by some other data point. I figured that I should easily be able to pull info from my database and fill a PDF template with it that I could then print out, but this has proven harder than expected.

So far, I've tried airtable and notion (I know, but I was temporarily having server issues and I need to get this project done) I've also tried baserow and nocodb, and yet I can't seem to figure out how to generate printable reports from my data.

Does anyone else know of an option? I've seen a recommendation for creating a spreadsheet or word document as a template that you then copy/paste your data into, but that feels... inelegant? Would something like appsmith or budibase be capable of this? Or is there some other (preferably self-hosted) software to accomplish this? I appreciate any help you can give me.

Edit: Sorry everyone, I guess I didn't make it very clear. First off, I've been using the programs above to make my dB's. So for instance, my nocodb is set up to use mysql. I didn't generate the dB on my own, and admittedly, I've never interacted with a db directly using SQL markup before.I was hoping my goal could be accomplished with a low/no-code option as my coding skills are rudimentary right now.

As someone asked, for a printable-report, yes PDF is an option. As would a word document or spreadsheet, for that matter, just so long as I can get it into a nice, print-friendly format.

I do appreciate all the suggestions so far, and will look into them. Thanks!

you are viewing a single comment's thread
view the rest of the comments
[–] Ceedling@compuverse.uk 1 points 1 year ago (3 children)

I'd love to take a look at that if possible

[–] TheInsane42@lemmy.world 1 points 1 year ago

Ok, will post it tomorrow.

[–] TheInsane42@lemmy.world 1 points 1 year ago

Oh, 1st of all, I have to make a small correction, I use an odt as base document.

You run this in the directory with the odt file and a temp directory t

cd t
unzip ../${document_template}.odt
sed -i "s/ReplaceThis/${var1}/g" content.xml
sed -i "s/ReplaceThisToo/${var2}/g" content.xml
zip -r ../${document_target}.odt .
cd ../
libreoffice --headless --convert-to pdf:writer_pdf_Export ${document_target}.odt

The file content.xml is the actual text of the document, the rest is just the dressing (formatting). What you need to do is make sure the text you want to replace (ReplaceThis in the example) is unique apart from the spots where you want the text to be replaced. Check the content.xml to be sure, but be warned, the content.xml is a 2 line file with line 1 being the xml header. (it's a terrible layout of the xml) Use an file editor you know well to find the words you want to replace. Also, be warned, correcting small typos in the odt results in garbage in the content.xml. You need to replace the whole word as 1 action. (Editing history has it's uses, but is an issue here)

Instead of converting it to file you can print it as well. (DDG result)

libreoffice --headless --print-to-file --printer-name the_printer_name --outdir /tmp ${document_target}.odt
lpr -U username /tmp/filename.ps -P the_printer_name
rm /tmp/filename.ps
[–] TheInsane42@lemmy.world 0 points 1 year ago (1 children)

Oh, 1st of all, I have to make a small correction, I use an odt as base document.

You run this in the directory with the odt file and a temp directory t

cd t
unzip ../${document_template}.odt
sed -i "s/ReplaceThis/${var1}/g" content.xml
sed -i "s/ReplaceThisToo/${var2}/g" content.xml
zip -r ../${document_target}.odt .
cd ../
libreoffice --headless --convert-to pdf:writer_pdf_Export ${document_target}.odt

The file content.xml is the actual text of the document, the rest is just the dressing (formatting). What you need to do is make sure the text you want to replace (ReplaceThis in the example) is unique apart from the spots where you want the text to be replaced. Check the content.xml to be sure, but be warned, the content.xml is a 2 line file with line 1 being the xml header. (it's a terrible layout of the xml) Use an file editor you know well to find the words you want to replace. Also, be warned, correcting small typos in the odt results in garbage in the content.xml. You need to replace the whole word as 1 action. (Editing history has it's uses, but is an issue here)

Instead of converting it to file you can print it as well. (DDG result)

libreoffice --headless --print-to-file --printer-name the_printer_name --outdir /tmp ${document_target}.odt
lpr -U username /tmp/filename.ps -P the_printer_name
rm /tmp/filename.ps
[–] Ceedling@compuverse.uk 2 points 1 year ago

Awesome! Thanks so much for taking the time to post. I'll have to dig a little more into that, looks really interesting