The actual_mint_importer from youngcw

Importing multiple files

Since Mint limits export to about 10k entries, I had to export to several files. The first import seemed to work great.

The second file, it crashes as some categories already exist.

I think line 98 should trap the exception and just add the existing ID instead.

Error: out-of-sync-migrations or _actual_app_crdt__WEBPACK_IMPORTED_MODULE_0__ is undefined

Using Actual Budget Client version: v23.12.0, Server version: v23.12.1 via docker.

I attempted running the import in an empty budget file and a partially filled budget file. They all returned the same error.

ran docker build -t actual_mint_importer https://github.com/youngcw/actual_mint_importer.git

ran docker run -e ACTUAL_SERVER_PASSWORD=longpassword -e ACTUAL_SYNC_ID=d8c319...8c716e6b -e ACTUAL_SERVER_URL=https://actual.example.com -e IMPORTER_CACHE_DIR=./cache -v ./transactions.csv:/data/transactions.csv actual_mint_importer

It returned the following:

[                                                      
  'Account 1',
  'Account 2',
  '...',
  'Account 35'
]
[
  'Category 1',           'Category 2',   'Category 3',
  'Category 4',             '...',             'Category 99'
]
open file
connect
Database is out of sync with migrations: {
  appliedIds: [
    1548957970627, 1550601598648,
    1555786194328, 1561751833510,
    1567699552727, 1582384163573,
    1597756566448, 1608652596043,
    1608652596044, 1612625548236,
    1614782639336, 1615745967948,
    1616167010796, 1618975177358,
    1632571489012, 1679728867040,
    1681115033845, 1682974838138,
    1685007876842, 1686139660866,
    1688749527273, 1688841238000,
    1691233396000, 1694438752000,
    1697046240000
  ],
  available: [
    '1548957970627_remove-db-version.sql',
    '1550601598648_payees.sql',
    '1555786194328_remove_category_group_unique.sql',
    '1561751833510_indexes.sql',
    '1567699552727_budget.sql',
    '1582384163573_cleared.sql',
    '1597756566448_rules.sql',
    '1608652596043_parent_field.sql',
    '1608652596044_trans_views.sql',
    '1612625548236_optimize.sql',
    '1614782639336_trans_views2.sql',
    '1615745967948_meta.sql',
    '1616167010796_accounts_order.sql',
    '1618975177358_schedules.sql',
    '1632571489012_remove_cache.js',
    '1679728867040_rules_conditions.sql',
    '1681115033845_add_schedule_name.sql',
    '1682974838138_remove_payee_rules.sql',
    '1685007876842_add_category_hidden.sql',
    '1686139660866_remove_account_type.sql',
    '1688749527273_transaction_filters.sql',
    '1688841238000_add_account_type.sql',
    '1691233396000_add_schedule_next_date_tombstone.sql'
  ]
}
Error updating Error: out-of-sync-migrations
    at checkDatabaseValidity (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:40813:31)
    at Module.migrate (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:40821:17)
    at async runMigrations (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:44260:17)
    at async updateVersion (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:44274:17)
    at async loadBudget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:40433:21)
    at async handlers.load-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:40274:27)
    at async handlers.download-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:40244:17)
    at async handlers.api/download-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:32098:34)
TypeError: Cannot read properties of undefined (reading 'timestamp')
    at _fullSync (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:43625:96)
    at /app/node_modules/@actual-app/api/dist/app/bundle.api.js:43537:38
    at onceFn (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:44451:35)
    at initialFullSync (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:43523:36)
    at handlers.sync-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:40259:92)
    at handlers.download-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:40247:55)
    at async handlers.api/download-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:32098:34)
[Exception] TypeError: Cannot read properties of undefined (reading 'timestamp')
    at _fullSync (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:43625:96)
    at /app/node_modules/@actual-app/api/dist/app/bundle.api.js:43537:38
    at onceFn (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:44451:35)
    at initialFullSync (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:43523:36)
    at handlers.sync-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:40259:92)
    at handlers.download-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:40247:55)
    at async handlers.api/download-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:32098:34)
Full error details {
  message: "Cannot read properties of undefined (reading 'timestamp')",
  reason: undefined,
  meta: undefined
}
/app/node_modules/@actual-app/api/dist/app/bundle.api.js:32103
                        throw new Error((0, _shared_errors__WEBPACK_IMPORTED_MODULE_2__.getDownloadError)(result.error));
                              ^

Error: Something went wrong trying to download that file, sorry! Visit https://actualbudget.org/contact/ for support. (reason: undefined)
    at handlers.api/download-budget (/app/node_modules/@actual-app/api/dist/app/bundle.api.js:32103:31)

Node.js v21.4.0

Let me know what other information might be useful.

youngcw / actual_mint_importer Goto Github PK

actual_mint_importer's People

Contributors

Stargazers

Watchers

Forkers

actual_mint_importer's Issues

Importing multiple files

Error: out-of-sync-migrations or _actual_app_crdt__WEBPACK_IMPORTED_MODULE_0__ is undefined

Migrating to Actual Server hosted in pikaPods gives errors

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent