dreautall / bluecoins-to-fireflyiii Goto Github PK
View Code? Open in Web Editor NEWPython script to import a bluecoins database into a Firefly III instance
License: MIT License
Python script to import a bluecoins database into a Firefly III instance
License: MIT License
ERROR: Cannot install -r requirements.txt (line 4) and packaging==21.3 because these package versions have conflicting dependencies.
The conflict is caused by:
The user requested packaging==21.3
black 24.3.0 depends on packaging>=22.0
with the current master branch.
Changing packaging
version to 22.0 does not work too, because it'll then conflict with prospector
:
The conflict is caused by:
The user requested packaging==22.0
black 24.3.0 depends on packaging>=22.0
prospector 1.8.4 depends on packaging<22.0
Reverting commit #7 by changing black
version to 22.12.0 works for installing the requirements.
There were some bugs regarding foreign currency transactions and transaction linking for split transactions, which I have fixed in my fork in the branch fix-bugs
. I have also added the option to use description as the opposing account name. @dreautall should I open a pull request?
{'data': {'api_version': '2.0.13',
'driver': 'pgsql',
'os': 'Linux',
'php_version': '8.3.4',
'version': '6.1.13'}}
Traceback (most recent call last):
File "/home/ubuntu/firefly_iii/bluecoins-to-fireflyiii/./convert.py", line 89, in <module>
total_txs = db.query_transactions_count()
File "/home/ubuntu/firefly_iii/bluecoins-to-fireflyiii/db.py", line 79, in query_transactions_count
res = cur.execute(sql)
sqlite3.OperationalError: no such column: splittransactionid
The fydb
file is from the new Bluecoins after the redesign, version 13.0.153. New database structure, perhaps? The available column names in my fydb
file in the TRANSACTIONSTABLE
table are:
transactionsTableID
itemID
amount
transactionCurrency
conversionRateNew
date
transactionTypeID
categoryID
accountID
notes
status
accountReference
accountPairID
uidPairID
deletedTransaction
newSplitTransactionID
transferGroupID
reminderTransaction
reminderGroupID
reminderFrequency
reminderRepeatEvery
reminderEndingType
reminderStartDate
reminderEndDate
reminderAfterNoOfOccurences
reminderAutomaticLogTransaction
reminderRepeatByDayOfMonth
reminderExcludeWeekend
reminderWeekDayMoveSetting
reminderUnbilled
creditCardInstallment
reminderVersion
dataExtraColumnString1
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.