Code Monkey home page Code Monkey logo

bluecoins-to-fireflyiii's People

Contributors

dependabot[bot] avatar dreautall avatar imjuzcy avatar

Stargazers

 avatar  avatar  avatar

Watchers

 avatar

bluecoins-to-fireflyiii's Issues

`packaging` package version conflicts

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.

Bug fixes

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?

Missing column `splittransactionid`

{'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

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.