mirror of
https://github.com/actualbudget/actual.git
synced 2026-03-22 12:30:06 -05:00
[Feature] Add API support for importing transactions from a file #420
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#420
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @j-f1 on GitHub (Jun 1, 2023).
Verified feature request does not already exist?
💻
Pitch: what problem are you trying to solve?
Currently, an OFX or CSV file can only be imported from the UI. Imports via the API can happen by manually parsing a CSV file and then inserting its transactions, but you lose the benefits of our import logic (including OFX parsing).
Describe your ideal solution to this problem
Add a new method to the API that allows passing in a file path which will be parsed and imported. It should follow the flow of the web app (which persists per-account import settings in the
prefsfield) while still allowing manual customization at the call site.This change would require a refactor since a portion of the import logic is currently in the
<ImportTransactions>component. Most important is the field mapping and date parsing for CSVs, but there are some other pieces of logic that should be moved intoloot-core.I’m not sure whether it would be best to have the method add transactions into the account in one step, return the transactions without adding them, or add the transactions and then return them in case the script wants to filter the imported transactions.
Teaching and learning
No response
@github-actions[bot] commented on GitHub (Jun 1, 2023):
✨ Thanks for sharing your idea! ✨
This repository is now using lodash style issue management for enhancements. This means enhancement issues will now be closed instead of leaving them open. This doesn’t mean we don’t accept feature requests, though! We will consider implementing ones that receive many upvotes, and we welcome contributions for any feature requests marked as needing votes (just post a comment first so we can help you make a successful contribution).
The enhancement backlog can be found here: https://github.com/actualbudget/actual/issues?q=label%3A%22needs+votes%22+sort%3Areactions-%2B1-desc+
Don’t forget to upvote the top comment with 👍!
@mcalligator commented on GitHub (Apr 20, 2025):
This looks like it would be a handy feature. I would add that it requires a data validation step to check that the file being imported complies with the specification set in the
prefsfield for the account (with sensible defaults in place when none has been explicitly defined by the user). The amount of detail in any error response is up for discussion - an MVP could be to fail-on-first-error, indicating what and where the error is. A later enhancement could return a structure containing all the errors, to reduce the burden on the user to find and fix all of them.As to whether the transactions should be imported in a single step, merely returned, or both, this should be determined by an API parameter.
@willgryan commented on GitHub (Dec 2, 2025):
This would be useful indeed! Alternatively, I was going to programmatically add transactions using the API w/ the same OFX parsing code using by the file import in the web UI.