Yes, that why I recommand jinja. as it can be used in OpenXML as well as latex or anything in plain text.
Let’s say you want to place a table that corresponds to a certain pattern, you could add it to your file conditionally.
In your Word document, you could add that :
{% for job in jobs %}
{% if job.style == 1 %}
{{ job.name }} | {{ job.date}} | ...
{% else %}
- {{ job.name }}
- {{ job.date}}
- ...
{% endif %}
{% endfor %}
I don’t know .NET but you can probably call a Jinja tools
Also for the resume, you might be insterested in Rx Resume
I’m using docxtpl which uses jinja placeholder to set values.
For your solution, you should use jinja
It’s used for whatever text files you want, htlm, txt, latex, MD, etc. And you can put code into the document (see my examples document in the post)
I'm looking for a solution to generate document (ideally docx but pdf is ok) from a database
Ex: I have a project entry (with client info, dates, information about the project, etc.) and I want to generate documents from a tender templates, containing selected entries from the database.
Here is what I tried until now :
* Custom database ([tinyDB](https://tinydb.readthedocs.io/en/latest/index.html)) + custom webpage form + a docx template with [jinja ](https://jinja.palletsprojects.com/en/3.1.x/)markups served by a homemade webpage hosted on [pythonanywhere ](https://www.pythonanywhere.com/)(lot of work and not reliable as I'm doing everything myself)
* [Nocodb ](https://nocodb.com/)form and database (no document generation yet) (self-hosted or on cloud)
* [Airtable](https://airtable.com/) (closed source and on cloud) for forms, database and document generation
Airtable is what I'm currently trying because it's the only one that I found that have lot of support and adds on.
There are a few options on Airtable for document generation, lot of which cost around $30/month which is why I'm looking for a viable alternative. Ideally I would like to be able to upload my already made templates.
More point to the solution if it's supports geodata
I'm considering keeping airtable and using the api to generate document with the python program I used on the first point, but I'd like to know if there is more options.
**EDIT2: to be concise: I'm looking for an alternative to Airtable + Make. Ideally, FOSS and self-hostable or on cloud**
Edit: precision: I need to create a document that contains multiple items of the db.
Ex: I need to create a resume with different experiences that are saved in the database
Here is an example of a template:
![](https://lemmy.world/pictrs/image/ece26e50-1789-4464-b284-3bc597ee09ed.png)
Recently, Radarr and Sonarr stopped working, and I don't know why or where to look.
Host: Kubuntu 22.04
Kernel: 3.2.0-39-generic (64 bits)
Docker: 24.0.5, build 24.0.5-0ubuntu1~22.04.1
Image: linuxserver/sonarr 3.0.10.1567 and linuxserver/radarr 5.2.6.
Every other app, including other servarr app (readarr, lidarr, etc.) is working
Apps is giving me the following message:
```
[Info] Bootstrap: Starting Sonarr - /app/sonarr/bin/Sonarr.exe - Version 3.0.10.1567
[Info] AppFolderInfo: Data directory is being overridden to [/config]
[Info] Router: Application mode: Interactive
[Info] MigrationLogger: *** Checking database for required migrations data source=/config/sonarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
[Info] MigrationLogger: *** Checking database for required migrations data source=/config/logs.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
[Info] OwinHostController: Listening on the following URLs:
[Info] OwinHostController: http://192.168.1.100:8989/
[Info] OwinHostController: http://localhost:8989/
[Info] SonarrBootstrapper: Starting Web Server
[Fatal] ConsoleApp: The requested address is not valid in this context. This can happen if another instance of Sonarr is already running another application is using the same port (default: 8989) or the user has insufficient permissions
Press enter to exit...
```
I checked, and nothing seems to use the same port:
```
~$ sudo netstat -nlp | grep 8989
tcp 0 0 0.0.0.0:8989 0.0.0.0:* LISTEN 48005/docker-proxy
tcp6 0 0 :::8989 :::* LISTEN 48011/docker-proxy
```
And I don't think permission is at fault since other docker apps works fine.
Where should I look to fix that?
Edit: the compose file
```
version: '3.8'
services:
Sonarr:
container_name: sonarr
image: linuxserver/sonarr
ports:
- '8989:8989' # sonarr
environment:
- PUID=1000
- PGID=1000
- TZ=Canada/Eastern
volumes:
- '/etc/timezone:/etc/timezone:ro'
- '/etc/localtime:/etc/localtime:ro'
- '/bibliotheque1/configs/sonarr:/config'
- '/bibliotheque1:/data'
- '/bibliotheque2:/data2'
restart: unless-stopped
radarr:
container_name: radarr
image: linuxserver/radarr
environment:
- PUID=1000
- PGID=1000
- TZ=Canada/Eastern
ports:
- '7878:7878'
volumes:
- '/etc/timezone:/etc/timezone:ro'
- '/etc/localtime:/etc/localtime:ro'
- '/bibliotheque1/configs/radarr:/config'
- '/bibliotheque1:/data'
- '/bibliotheque2:/data2'
restart: unless-stopped
```
edit2: added all the details of the logs
edit 3:
I don't think the issue is actually the port since I've got the same issue when I'm switching to a different port, and if I stop the container, its ports no longer appears in the netstats commands.
Might be permission issue (but no idea what that would mean in its context) or something else.
## Edit 4 and kinda solution
It IS a permission issue, although I'm not getting why it's happening
If the config file is in another volume, the container starts no problem. But if I try to starts with the old directory, it gave the error message.
```
volumes:
- '/bibliotheque1/configs/radarr_test:/config'
```
But there is no difference in the owner of this repository
Why can't the container access it?
```
drwxr-xr-x 7 $USER $USER 4096 mar 19 2023 heimdall
drwxr-xr-x 6 $USER $USER 4096 déc 26 11:39 radarr
drwxr-xr-x 6 $USER $USER 4096 déc 26 11:43 radarr_test
drwxr-xr-x 6 $USER $USER 4096 déc 26 11:43 sonarr
drwxr-xr-x 6 $USER $USER 4096 déc 26 11:43 sonarr_test
drwxr-xr-x 4 $USER $USER 4096 aoû 28 23:07 plex
```
I'll use my backups and use a different directory, but I want to know what went wrong...
Yes, that why I recommand jinja. as it can be used in OpenXML as well as latex or anything in plain text.
Let’s say you want to place a table that corresponds to a certain pattern, you could add it to your file conditionally. In your Word document, you could add that :
I don’t know .NET but you can probably call a Jinja tools
Also for the resume, you might be insterested in Rx Resume