[GH-ISSUE #1522] [Bug]: An unknown error occurred while importing #7508

Closed
opened 2026-04-10 17:22:20 -05:00 by GiteaMirror · 7 comments
Owner

Originally created by @adambowles on GitHub (Aug 13, 2023).
Original GitHub issue: https://github.com/actualbudget/actual/issues/1522

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

Occurred while importing my nYNAB budget

What error did you receive?

An unknown error occurred while importing. Please report this as a new issue on Github.

image
image

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

No response

Operating System

Linux

Originally created by @adambowles on GitHub (Aug 13, 2023). Original GitHub issue: https://github.com/actualbudget/actual/issues/1522 ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### What happened? Occurred while importing my nYNAB budget ### What error did you receive? An unknown error occurred while importing. Please report this as a new issue on Github. ![image](https://github.com/actualbudget/actual/assets/10128574/07891411-1604-4cfa-98ea-1175fbad18a9) ![image](https://github.com/actualbudget/actual/assets/10128574/60f515db-7459-497b-bb82-c72c4c060902) ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? _No response_ ### Operating System Linux
GiteaMirror added the bugimporters labels 2026-04-10 17:22:20 -05:00
Author
Owner

@MatissJanis commented on GitHub (Aug 14, 2023):

👋 Is this on v23.8.0 or v23.8.1? If on v23.8.0 - please upgrade. If on v23.8.1 - we'd really appreciate if you could provide a redacted export so we could reproduce the issue.

<!-- gh-comment-id:1677956713 --> @MatissJanis commented on GitHub (Aug 14, 2023): 👋 Is this on v23.8.0 or v23.8.1? If on v23.8.0 - please upgrade. If on v23.8.1 - we'd really appreciate if you could provide a redacted export so we could reproduce the issue.
Author
Owner

@adambowles commented on GitHub (Aug 14, 2023):

It's on 23.8.1

In what way would you like the export files redacted? Are there any tools I can use to do this for you? Or shall I manually do it?

<!-- gh-comment-id:1677959863 --> @adambowles commented on GitHub (Aug 14, 2023): It's on 23.8.1 In what way would you like the export files redacted? Are there any tools I can use to do this for you? Or shall I manually do it?
Author
Owner

@MatissJanis commented on GitHub (Aug 14, 2023):

In what way would you like the export files redacted? Are there any tools I can use to do this for you? Or shall I manually do it?

Sadly there are no tools for this AFAIK. So if you're happy to share your REAL budget - that's totally fine. But most folks prefer to keep their real data private. In which case you can open up the export manually and just replace the data entries with gibberish. And possibly delete a lot of unnecessary data.

<!-- gh-comment-id:1677961670 --> @MatissJanis commented on GitHub (Aug 14, 2023): > In what way would you like the export files redacted? Are there any tools I can use to do this for you? Or shall I manually do it? Sadly there are no tools for this AFAIK. So if you're happy to share your REAL budget - that's totally fine. But most folks prefer to keep their real data private. In which case you can open up the export manually and just replace the data entries with gibberish. And possibly delete a lot of unnecessary data.
Author
Owner

@adambowles commented on GitHub (Aug 14, 2023):

My import file is 360k lines! I'll look into isolating the offending lines and upload asap

<!-- gh-comment-id:1677984910 --> @adambowles commented on GitHub (Aug 14, 2023): My import file is 360k lines! I'll look into isolating the offending lines and upload asap
Author
Owner

@adambowles commented on GitHub (Aug 14, 2023):

Okay I had an object in the months.categories array that had a budgeted value of e.g. 77499 and an activity of -77500

Seems like this value is in 1/10ths of a penny and I somehow managed to budget £77.499
When I rounded this value up manually in the export file it works and imports perfectly

Sample object

{
    "id": "d7d89d25-8c07-47cd-9646-94fc24a79677",
    "category_group_id": "6e5d1fae-7da8-40cd-8418-ee7dfaf8fd8f",
    "name": "🏚 Home maintenance",
    "hidden": false,
    "original_category_group_id": null,
    "note": "",
    "budgeted": 77499, // <-- here
    "activity": -77500,
    "balance": 0,
    "goal_type": null,
    "goal_day": null,
    "goal_cadence": null,
    "goal_cadence_frequency": null,
    "goal_creation_month": null,
    "goal_target": 0,
    "goal_target_month": null,
    "goal_percentage_complete": null,
    "goal_months_to_budget": null,
    "goal_under_funded": null,
    "goal_overall_funded": null,
    "goal_overall_left": null,
    "deleted": false
},
<!-- gh-comment-id:1678027040 --> @adambowles commented on GitHub (Aug 14, 2023): Okay I had an object in the `months.categories` array that had a `budgeted` value of e.g. `77499` and an `activity` of `-77500` Seems like this value is in 1/10ths of a penny and I somehow managed to budget £77.499 When I rounded this value up manually in the export file it works and imports perfectly Sample object ```json5 { "id": "d7d89d25-8c07-47cd-9646-94fc24a79677", "category_group_id": "6e5d1fae-7da8-40cd-8418-ee7dfaf8fd8f", "name": "🏚 Home maintenance", "hidden": false, "original_category_group_id": null, "note": "", "budgeted": 77499, // <-- here "activity": -77500, "balance": 0, "goal_type": null, "goal_day": null, "goal_cadence": null, "goal_cadence_frequency": null, "goal_creation_month": null, "goal_target": 0, "goal_target_month": null, "goal_percentage_complete": null, "goal_months_to_budget": null, "goal_under_funded": null, "goal_overall_funded": null, "goal_overall_left": null, "deleted": false }, ```
Author
Owner

@MatissJanis commented on GitHub (Aug 15, 2023):

I'm actually still unable to reproduce. I updated the budgeted values in this sample export and attempted to import in https://demo.actualbudget.org and am not seeing any issues.

Could you provide an example nYNAB export that causes the above error?

<!-- gh-comment-id:1678539857 --> @MatissJanis commented on GitHub (Aug 15, 2023): I'm actually still unable to reproduce. I updated the `budgeted` values in [this sample export](https://github.com/actualbudget/actual/blob/master/packages/desktop-client/e2e/data/ynab5-demo-budget.json) and attempted to import in https://demo.actualbudget.org and am not seeing any issues. Could you provide an example nYNAB export that causes the above error?
Author
Owner

@adambowles commented on GitHub (Aug 15, 2023):

Minimal exmaple, see line 209:

{
    "budget": {
        "id": "0d24b053-9777-4a1a-9898-33c3782f791e",
        "name": "broken budget",
        "last_modified_on": "2023-08-15T16:03:06+00:00",
        "date_format": {
            "format": "YYYY-MM-DD"
        },
        "currency_format": {
            "iso_code": "GBP",
            "example_format": "123,456.78",
            "decimal_digits": 2,
            "decimal_separator": ".",
            "symbol_first": true,
            "group_separator": ",",
            "currency_symbol": "£",
            "display_symbol": true
        },
        "first_month": "2023-08-01",
        "last_month": "2023-08-01",
        "accounts": [],
        "payees": [
            {
                "id": "fc007a6e-c584-4031-b61c-6f8807703e27",
                "name": "Starting Balance",
                "transfer_account_id": null,
                "deleted": false
            },
            {
                "id": "3066f9f3-6c2a-43cf-adb7-17877c295671",
                "name": "Manual Balance Adjustment",
                "transfer_account_id": null,
                "deleted": false
            },
            {
                "id": "03652066-cfe1-4fe6-ab26-cad4c1edb92a",
                "name": "Reconciliation Balance Adjustment",
                "transfer_account_id": null,
                "deleted": false
            }
        ],
        "payee_locations": [],
        "category_groups": [
            {
                "id": "a9d1678a-fe5a-4e16-8868-802c12178024",
                "name": "Internal Master Category",
                "hidden": false,
                "deleted": false
            },
            {
                "id": "7138491a-cd00-4f4c-93e6-e92e3ce4b0fe",
                "name": "Credit Card Payments",
                "hidden": false,
                "deleted": false
            },
            {
                "id": "ba688574-43f0-4093-b98a-f775d59ed53d",
                "name": "Bills",
                "hidden": false,
                "deleted": false
            },
            {
                "id": "e2b24b99-ccea-46c9-aa3c-d7c665c335ad",
                "name": "Hidden Categories",
                "hidden": false,
                "deleted": false
            }
        ],
        "categories": [
            {
                "id": "150dd54c-02e3-443c-8b3a-6cff9d1acfc3",
                "category_group_id": "a9d1678a-fe5a-4e16-8868-802c12178024",
                "name": "Inflow: Ready to Assign",
                "hidden": false,
                "original_category_group_id": null,
                "note": null,
                "budgeted": 0,
                "activity": 0,
                "balance": 0,
                "goal_type": null,
                "goal_day": null,
                "goal_cadence": null,
                "goal_cadence_frequency": null,
                "goal_creation_month": null,
                "goal_target": 0,
                "goal_target_month": null,
                "goal_percentage_complete": null,
                "goal_months_to_budget": null,
                "goal_under_funded": null,
                "goal_overall_funded": null,
                "goal_overall_left": null,
                "deleted": false
            },
            {
                "id": "79b1f8a0-bb4a-4dbe-a073-76b5b41c8356",
                "category_group_id": "a9d1678a-fe5a-4e16-8868-802c12178024",
                "name": "Uncategorized",
                "hidden": false,
                "original_category_group_id": null,
                "note": null,
                "budgeted": 0,
                "activity": 0,
                "balance": 0,
                "goal_type": null,
                "goal_day": null,
                "goal_cadence": null,
                "goal_cadence_frequency": null,
                "goal_creation_month": null,
                "goal_target": 0,
                "goal_target_month": null,
                "goal_percentage_complete": null,
                "goal_months_to_budget": null,
                "goal_under_funded": null,
                "goal_overall_funded": null,
                "goal_overall_left": null,
                "deleted": false
            },
            {
                "id": "ae884f8b-462c-4cf1-8592-dfab4143541d",
                "category_group_id": "ba688574-43f0-4093-b98a-f775d59ed53d",
                "name": "Rent/Mortgage",
                "hidden": false,
                "original_category_group_id": null,
                "note": null,
                "budgeted": 123000,
                "activity": 0,
                "balance": 123000,
                "goal_type": "NEED",
                "goal_day": null,
                "goal_cadence": 1,
                "goal_cadence_frequency": 1,
                "goal_creation_month": null,
                "goal_target": 0,
                "goal_target_month": null,
                "goal_percentage_complete": null,
                "goal_months_to_budget": null,
                "goal_under_funded": null,
                "goal_overall_funded": null,
                "goal_overall_left": null,
                "deleted": false
            }
        ],
        "months": [
            {
                "month": "2023-09-01",
                "note": null,
                "income": 0,
                "budgeted": 0,
                "activity": 0,
                "to_be_budgeted": 0,
                "age_of_money": null,
                "deleted": false,
                "categories": [
                    {
                        "id": "150dd54c-02e3-443c-8b3a-6cff9d1acfc3",
                        "category_group_id": "a9d1678a-fe5a-4e16-8868-802c12178024",
                        "name": "Inflow: Ready to Assign",
                        "hidden": false,
                        "original_category_group_id": null,
                        "note": null,
                        "budgeted": 0,
                        "activity": 0,
                        "balance": 0,
                        "goal_type": null,
                        "goal_day": null,
                        "goal_cadence": null,
                        "goal_cadence_frequency": null,
                        "goal_creation_month": null,
                        "goal_target": 0,
                        "goal_target_month": null,
                        "goal_percentage_complete": null,
                        "goal_months_to_budget": null,
                        "goal_under_funded": null,
                        "goal_overall_funded": null,
                        "goal_overall_left": null,
                        "deleted": false
                    },
                    {
                        "id": "79b1f8a0-bb4a-4dbe-a073-76b5b41c8356",
                        "category_group_id": "a9d1678a-fe5a-4e16-8868-802c12178024",
                        "name": "Uncategorized",
                        "hidden": false,
                        "original_category_group_id": null,
                        "note": null,
                        "budgeted": 0,
                        "activity": 0,
                        "balance": 0,
                        "goal_type": null,
                        "goal_day": null,
                        "goal_cadence": null,
                        "goal_cadence_frequency": null,
                        "goal_creation_month": null,
                        "goal_target": 0,
                        "goal_target_month": null,
                        "goal_percentage_complete": null,
                        "goal_months_to_budget": null,
                        "goal_under_funded": null,
                        "goal_overall_funded": null,
                        "goal_overall_left": null,
                        "deleted": false
                    },
                    {
                        "id": "ae884f8b-462c-4cf1-8592-dfab4143541d",
                        "category_group_id": "ba688574-43f0-4093-b98a-f775d59ed53d",
                        "name": "Rent/Mortgage",
                        "hidden": false,
                        "original_category_group_id": null,
                        "note": null,
                        "budgeted": 77499,
                        "activity": 77500,
                        "balance": 0,
                        "goal_type": "NEED",
                        "goal_day": null,
                        "goal_cadence": 1,
                        "goal_cadence_frequency": 1,
                        "goal_creation_month": null,
                        "goal_target": 0,
                        "goal_target_month": null,
                        "goal_percentage_complete": null,
                        "goal_months_to_budget": null,
                        "goal_under_funded": null,
                        "goal_overall_funded": null,
                        "goal_overall_left": null,
                        "deleted": false
                    }
                ]
            }
        ],
        "transactions": [],
        "subtransactions": [],
        "scheduled_transactions": [],
        "scheduled_subtransactions": []
    },
    "server_knowledge": 52
}
<!-- gh-comment-id:1679211035 --> @adambowles commented on GitHub (Aug 15, 2023): Minimal exmaple, see line 209: ```json { "budget": { "id": "0d24b053-9777-4a1a-9898-33c3782f791e", "name": "broken budget", "last_modified_on": "2023-08-15T16:03:06+00:00", "date_format": { "format": "YYYY-MM-DD" }, "currency_format": { "iso_code": "GBP", "example_format": "123,456.78", "decimal_digits": 2, "decimal_separator": ".", "symbol_first": true, "group_separator": ",", "currency_symbol": "£", "display_symbol": true }, "first_month": "2023-08-01", "last_month": "2023-08-01", "accounts": [], "payees": [ { "id": "fc007a6e-c584-4031-b61c-6f8807703e27", "name": "Starting Balance", "transfer_account_id": null, "deleted": false }, { "id": "3066f9f3-6c2a-43cf-adb7-17877c295671", "name": "Manual Balance Adjustment", "transfer_account_id": null, "deleted": false }, { "id": "03652066-cfe1-4fe6-ab26-cad4c1edb92a", "name": "Reconciliation Balance Adjustment", "transfer_account_id": null, "deleted": false } ], "payee_locations": [], "category_groups": [ { "id": "a9d1678a-fe5a-4e16-8868-802c12178024", "name": "Internal Master Category", "hidden": false, "deleted": false }, { "id": "7138491a-cd00-4f4c-93e6-e92e3ce4b0fe", "name": "Credit Card Payments", "hidden": false, "deleted": false }, { "id": "ba688574-43f0-4093-b98a-f775d59ed53d", "name": "Bills", "hidden": false, "deleted": false }, { "id": "e2b24b99-ccea-46c9-aa3c-d7c665c335ad", "name": "Hidden Categories", "hidden": false, "deleted": false } ], "categories": [ { "id": "150dd54c-02e3-443c-8b3a-6cff9d1acfc3", "category_group_id": "a9d1678a-fe5a-4e16-8868-802c12178024", "name": "Inflow: Ready to Assign", "hidden": false, "original_category_group_id": null, "note": null, "budgeted": 0, "activity": 0, "balance": 0, "goal_type": null, "goal_day": null, "goal_cadence": null, "goal_cadence_frequency": null, "goal_creation_month": null, "goal_target": 0, "goal_target_month": null, "goal_percentage_complete": null, "goal_months_to_budget": null, "goal_under_funded": null, "goal_overall_funded": null, "goal_overall_left": null, "deleted": false }, { "id": "79b1f8a0-bb4a-4dbe-a073-76b5b41c8356", "category_group_id": "a9d1678a-fe5a-4e16-8868-802c12178024", "name": "Uncategorized", "hidden": false, "original_category_group_id": null, "note": null, "budgeted": 0, "activity": 0, "balance": 0, "goal_type": null, "goal_day": null, "goal_cadence": null, "goal_cadence_frequency": null, "goal_creation_month": null, "goal_target": 0, "goal_target_month": null, "goal_percentage_complete": null, "goal_months_to_budget": null, "goal_under_funded": null, "goal_overall_funded": null, "goal_overall_left": null, "deleted": false }, { "id": "ae884f8b-462c-4cf1-8592-dfab4143541d", "category_group_id": "ba688574-43f0-4093-b98a-f775d59ed53d", "name": "Rent/Mortgage", "hidden": false, "original_category_group_id": null, "note": null, "budgeted": 123000, "activity": 0, "balance": 123000, "goal_type": "NEED", "goal_day": null, "goal_cadence": 1, "goal_cadence_frequency": 1, "goal_creation_month": null, "goal_target": 0, "goal_target_month": null, "goal_percentage_complete": null, "goal_months_to_budget": null, "goal_under_funded": null, "goal_overall_funded": null, "goal_overall_left": null, "deleted": false } ], "months": [ { "month": "2023-09-01", "note": null, "income": 0, "budgeted": 0, "activity": 0, "to_be_budgeted": 0, "age_of_money": null, "deleted": false, "categories": [ { "id": "150dd54c-02e3-443c-8b3a-6cff9d1acfc3", "category_group_id": "a9d1678a-fe5a-4e16-8868-802c12178024", "name": "Inflow: Ready to Assign", "hidden": false, "original_category_group_id": null, "note": null, "budgeted": 0, "activity": 0, "balance": 0, "goal_type": null, "goal_day": null, "goal_cadence": null, "goal_cadence_frequency": null, "goal_creation_month": null, "goal_target": 0, "goal_target_month": null, "goal_percentage_complete": null, "goal_months_to_budget": null, "goal_under_funded": null, "goal_overall_funded": null, "goal_overall_left": null, "deleted": false }, { "id": "79b1f8a0-bb4a-4dbe-a073-76b5b41c8356", "category_group_id": "a9d1678a-fe5a-4e16-8868-802c12178024", "name": "Uncategorized", "hidden": false, "original_category_group_id": null, "note": null, "budgeted": 0, "activity": 0, "balance": 0, "goal_type": null, "goal_day": null, "goal_cadence": null, "goal_cadence_frequency": null, "goal_creation_month": null, "goal_target": 0, "goal_target_month": null, "goal_percentage_complete": null, "goal_months_to_budget": null, "goal_under_funded": null, "goal_overall_funded": null, "goal_overall_left": null, "deleted": false }, { "id": "ae884f8b-462c-4cf1-8592-dfab4143541d", "category_group_id": "ba688574-43f0-4093-b98a-f775d59ed53d", "name": "Rent/Mortgage", "hidden": false, "original_category_group_id": null, "note": null, "budgeted": 77499, "activity": 77500, "balance": 0, "goal_type": "NEED", "goal_day": null, "goal_cadence": 1, "goal_cadence_frequency": 1, "goal_creation_month": null, "goal_target": 0, "goal_target_month": null, "goal_percentage_complete": null, "goal_months_to_budget": null, "goal_under_funded": null, "goal_overall_funded": null, "goal_overall_left": null, "deleted": false } ] } ], "transactions": [], "subtransactions": [], "scheduled_transactions": [], "scheduled_subtransactions": [] }, "server_knowledge": 52 } ```
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#7508