[Bug]: Server sync fails after QFX file import about actual-server HOT 5 CLOSED

Oh, you’re proxying via Nginx. That may have a lower body size limit (1 MiB by default per this Stack Overflow post). Actual has its own limits but at present the largest supported body size of any content type is 50 MB, so you should set client_max_body_size to at least that big. Closing the issue since this isn’t related to Actual’s server directly but happy to reopen if there’s something we can do to clarify/avoid this!

from actual-server.

This was indeed the problem, thanks!

By the way my nginx config ends up being a lot simpler than the one in your example in the docs, might be easier for someone who hasn't set up their own server before:

server {
    root /var/www/html;
    server_name my.site www.my.site;

    client_max_body_size 50m;

    listen [::]:443 ssl ipv6only=on; # managed by Certbot
    listen 443 ssl; # managed by Certbot
    ssl_certificate /etc/letsencrypt/live/my.site/fullchain.pem; # managed by Certbot
    ssl_certificate_key /etc/letsencrypt/live/my.site/privkey.pem; # managed by Certbot
    include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot
    ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot

    location / {
        proxy_pass http://127.0.0.1:5006;
    }
}

from actual-server.

Interesting, thanks for reporting! We should probably increase this limit. If you go to the Network tab, can you send a screenshot of the failing request’s request headers (or at least tell me the value of Content-Length in the request headers if you’re not comfortable sharing the whole screen)? I’m curious how far we need to bump the limit (which I believe is currently 20 MB).

from actual-server.

Oh, also this probably isn't the place for it but while I'm here making documentation suggestions, I found it confusing that I had to click server > sign out to get out of an instance of the app to import a file, as the docs don't make that obvious and the label around the Export data button seems to imply the button should be on that very page:

Export your data as a zip file containing db.sqlite and metadata.json files. It can be imported into another Actual instance by clicking the “Import file” button and then choosing “Actual” on the Files page.

PS Thanks for building this & making it open source

PPS fyi I'm primarily using this as a tool to mark transactions from various bank accounts/credit cards with category labels, exporting the data, and then using sqliteviz.com to analyze my finances. I'm not using the "budget" features at all and if there's any kind of "getting started" guide for developers I might find the motivation to build some data analysis tools for myself in one of the pages and PR them :)

from actual-server.

By the way my nginx config ends up being a lot simpler than the one in your example in the docs, might be easier for someone who hasn't set up their own server before:

Interesting! Maybe we should update that section of the docs.

Oh, also this probably isn't the place for it but while I'm here making documentation suggestions, I found it confusing that I had to click server > sign out to get out of an instance of the app to import a file, as the docs don't make that obvious and the label around the Export data button seems to imply the button should be on that very page:

That’s a good point! the process is now [file name] → “Close file” to get to the import dialog. Will open a PR to fix that.

I'm not using the "budget" features at all and if there's any kind of "getting started" guide for developers I might find the motivation to build some data analysis tools for myself in one of the pages and PR them :)

We currently don’t have a super thorough getting started guide but if you clone the frontend repo you should be able to run yarn and then yarn start:browser to start the frontend locally. (We should also put this in the docs!)

from actual-server.