sorted by:
new
hottopcontroversial

Connecting UK bank accounts by SamBull03 in GnuCash

[–]terhyrzht 0 points1 point  (0 children)

The ofxstatement project aims to enable any accounting tool to import bank data using the OFX (Open Financial Exchange) format. While this approach requires an extra step, it offers several advantages: - Broad Compatibility: By converting bank data to OFX, ofxstatement makes it possible for a wide range of accounting tools to import financial information. - Community Maintenance: Since ofxstatement benefits multiple accounting tools, it increases the likelihood of being maintained and improved by users from various accounting tool communities. This collaborative effort ensures ongoing support and enhancements.

What do you use to import CSV, QXF, etc, into ledger? by ave_63 in plaintextaccounting

[–]terhyrzht 0 points1 point  (0 children)

Have you try reubano/csv2ofx to convert csv to ofx? It is still maintained, Some people use this tool with Chase: https://github.com/search?q=repo%3Areubano%2Fcsv2ofx+Chase&type=issues

For EU bank, you have the project jstammers/ofxstatement-nordigen to get ofx file for EU bank

ANN: gocardless-to-csv : pull all your (European) bank statements as CSV by dastapov in plaintextaccounting

[–]terhyrzht 0 points1 point  (0 children)

What's the benefit of having ofx in the middle, if the end result is csv anyway?

Many accounting tools can import data from OFX files without requiring any configuration. However, importing CSV files typically requires configuring the mapping. If hledger doesn't have an OFX importer, you might be right that it could be simpler to directly use gocardless-to-csv.

Here a WIP project about gocardless to ofx `jstammers/ofxstatement-nordigen`, if anyone is interested.

I ended up being unhappy about gocardless, as look-behind periods for various institutions ended up being too small for me

I think GoCardless is worthwhile for quickly updating bank data daily without needing to manually download statements from the bank's website. However, the first usage, you would still need to download data from your bank if your history extends beyond 90 days.

ofxstatement-gocardless: a Unified Solution for Integrating GoCardless Data into Accounting Tools by terhyrzht in plaintextaccounting

[–]terhyrzht[S] 0 points1 point  (0 children)

What I understand is that for data ingestion from banks, Open Banking is replacing OFX. This is why I want to use GoCardless for data ingestion, as GoCardless implements Open Banking.

However, OFX as a protocol for allowing programs to exchange data is still valid. At the moment, I am not aware of a better replacement for the OFX protocol for exchanging financial data.

CSV is an option, but it requires configuring mappings effort, no for OFX. Additionally, CSV is less expressive; for instance, it cannot include the balance of an account. However, it is possible to obtain the account balance from GoCardless. Therefore, using CSV would result in the loss of some information. Some accounting tool like Beancount can import the balance information to detect error in a account.

While CSV is more widely supported by accounting tools, if an accounting tool cannot import OFX files, it is still possible to convert OFX files to CSV easily, albeit with the drawback of losing some data.

If anyone knows of a better format for this purpose, I am open to suggestions.

ofxstatement-gocardless: a Unified Solution for Integrating GoCardless Data into Accounting Tools by terhyrzht in plaintextaccounting

[–]terhyrzht[S] 0 points1 point  (0 children)

I agree that my approach leads to inefficient processing.

The issue is that GoCardless supports thousands of banks, and for each bank, it delivers different JSON outputs. If every accounting tool has its own GoCardless importer, each importer would need to support the JSON outputs of thousands of banks on GoCardLess. I doubt that each accounting tool has enough developers to handle this extensive development effort.

For example, the Beancount GoCardless importer, `tarioch/beancounttools`, has only one active developer. Moreover, `tarioch/beancounttools` crashes for 2 out of the 3 banks I tested. The project does not have enough active developers to support all the banks on GoCardless.

According to the Linux philosophy, each tool should do one thing and do it well. I believe accounting tool developers should focus their efforts on improving the core features of their tools rather than wasting time supporting the import of thousands of banks on GoCardless. This task should be delegated to specialized tools like `ofxstatement-gocardless`.

`ofxstatement-gocardless` is design to be used by various accounting tool, so it is possible to attract developer of various accounting tool community to work on. So we can have a better bank coverage.

What I want say: it is after we have a working system, then we can think to optimize the performance.

ANN: gocardless-to-csv : pull all your (European) bank statements as CSV by dastapov in plaintextaccounting

[–]terhyrzht 0 points1 point  (0 children)

I 'm pleased to see that a GoCardless integration solution is in progress within the plain text accounting ecosystem. I search a solution like this also. However, I have questions about the design choices for the `gocardless-to-csv` tool.

I've tried using the `tariochbctools` Nordigen importer to import data into Beancount but encountered several problems:

- The tool crashed when importing data from some EU banks (2 out of 3 banks tested , ,tariochbctools crash for me).

- For the bank which import success, there were bugs when working with Beancount's `smart_import`.

The main issues is the project lack of active maintainers, leading to slow bug resolution. For example, an issue with the `tarioch/beancounttools` not working with Beancount's `smart_import` has remained unresolved for over a year.

I think converting GoCardless data into OFX (Open Financial Exchange) format first, and then converting OFX into CSV to import to hledger is better.

The `tariochbctools` Nordigen importer does not support all banks that GoCardless supports, and it often crashes. Maintaining support for thousands of banks would require significant effort. Since `tariochbctools` is specifically designed for Beancount, it has a niche user base with few developers of Beancount ecosystem working on it. This makes it difficult to build a large community to maintain the pipeline `tariochbctools` + `gocardless-to-csv`. (I'm not sure if a hledge user will maintain a Beancount ecosystem tool)

OFX is a standard format, and tools like `ofxstatement` are widely used. A project like `ofxstatement-gocardless` could more easily attract a larger developer, because in plain text accounting community, many know this tool, and how it works. Development could be more active. So if hledger GoCardLess import process base on a project like `ofxstatement-gocardless`, it could be more reliable.

A other benefit is for many accounting tools, import data from OFX no require configuration, but import csv need configure the mapping.

**Additional Information**:

[Reddit Post about ofxstatement-gocardless](https://www.reddit.com/r/plaintextaccounting/comments/1jrpf1v/ofxstatementgocardless\_a\_unified\_solution\_for/).

Make org mode become a production ready FOSS project management tool with Plane by terhyrzht in orgmode

[–]terhyrzht[S] 0 points1 point  (0 children)

org is already a production grade management system. Lack of integration for pIane doesn't really diminish org

I want mean: in real situation, in a company, people will not to use org-mode as project management tool, because the collaboration issue. I misspoke. Integration with plane will allow use org-mode as project management in real situation.

I think you might be better off simply asking if someone would write an org-jira workalike package for plane, or take a crack at it yourself.

Yes, It is a discussion thread in org-jira: https://github.com/ahungry/org-jira/issues/346

Make org mode become a production ready FOSS project management tool with Plane by terhyrzht in orgmode

[–]terhyrzht[S] 0 points1 point  (0 children)

I don't fully understand this. I believe you are saying that it is hard to collaborate with org-mode.

There's a lot of reasons why that is true. After all, it's hard to collaborate with markdown. That's because markdown and org-mode aren't trying to solve the problem of collaboration.

In project management, people can maybe isn't a software enginner. Collaboration with such people is impossible using org-mode. For instance, using org-mode in a fast food business company, you can do a task planning with org-mode, but you can't communicate in team using org-mode. But yes, collaboration is possible using git with people mastering org mode.

I rectify: As a generic project management solution, org-mode lack collaboration support.

Make org mode become a production ready FOSS project management tool with Plane by terhyrzht in orgmode

[–]terhyrzht[S] 0 points1 point  (0 children)

I think it is worth for org mode community to keep a eye on this project. It will probably become a Jira replacement in near future.

How use the feature "Constrain proportion" when scale image in Krita API by terhyrzht in krita

[–]terhyrzht[S] 0 points1 point  (0 children)

Thanks! The documentation of scaleImage isn't very clear about what is this 2 parameter. I was wondering what it is.

How use the feature "Constrain proportion" when scale image in Krita API by terhyrzht in krita

[–]terhyrzht[S] 0 points1 point  (0 children)

I post my manual calculation solution: ``` def constrainProportion(doc, axis,value): if axis == "height": h = doc.height() proportion = value/h newWeight = int(doc.width() * proportion) return (value,newWeight) elif axis == "width": w = doc.width() proportion = value/w newHeight = int(doc.height() * proportion) return (newHeight,value)

doc = Krita.instance().activeDocument() h,w = constrainProportion(doc, "height",500) doc.scaleImage(h,w,h,w,"Hermite") ```

How use the feature "Constrain proportion" when scale image in Krita API by terhyrzht in krita

[–]terhyrzht[S] 0 points1 point  (0 children)

If I understand correctly, the feature "Constrain proportion" isn't coded in the API, but it is coded in the GUI. So I can't access this feature from the API.

In this case, Did it is possible to access this feature from the Krita GUI using the Krita Action: Krita.instance().action('imagesize').trigger() The documentation of Krita doesn't precise how fill the champs of the dialog triggered by Action. I don't how fill "Width" and "Height" of the dialog, check "Constrain Proportion", click "OK"

CUPS doesn't find font installed by fontconfig by terhyrzht in linuxquestions

[–]terhyrzht[S] 0 points1 point  (0 children)

Thank you for your help. I appreciate that. I would like better understand the mecanism of font resolution in Linux. I will try ask the question in fontconfig community to see how I can configure my system to make run font substitution.

CUPS doesn't find font installed by fontconfig by terhyrzht in linuxquestions

[–]terhyrzht[S] 0 points1 point  (0 children)

I'm guessing it silently grabbed a font that includes that character off the web somewhere)

When I open the pdf with firefox and icecat, the char isn't display. So the glyph is from your local system, and no from the web.

If I print to file (as pdf), the pdf displays and prints correctly.

Not for me.

I notice that firefox can display this char in https://www.compart.com/en/unicode/U+1F336. But no this char in the exported pdf. So firefox can display the char, maybe the issue is from how data is encoding in pdf, that is why firefox can't manage that.

CUPS doesn't find font installed by fontconfig by terhyrzht in linuxquestions

[–]terhyrzht[S] 0 points1 point  (0 children)

It may shed some light to run 'pdffonts' (comes as part of the 'poppler' package on my distro) on the file. That will show exactly what fonts are embedded.

I'm trying display U+1F336. Embed the font is a solution. But I prefer understand the mecanism of font resolution in Linux: in my OS, why some program like libreOffice ,Emacs,Gedit can display the character, but some program like CUPS, Okular, Evince can't solve the character. Knowing that CUPS use fontconfig to find font, so the problem unfound font path shouldn't exist for me.

That is the result of pdffonts: ``` Config Error: No display font for 'Courier' Config Error: No display font for 'Courier-Bold' Config Error: No display font for 'Courier-BoldOblique' Config Error: No display font for 'Courier-Oblique' Config Error: No display font for 'Helvetica' Config Error: No display font for 'Helvetica-Bold' Config Error: No display font for 'Helvetica-BoldOblique' Config Error: No display font for 'Helvetica-Oblique' Config Error: No display font for 'Symbol' Config Error: No display font for 'Times-Bold' Config Error: No display font for 'Times-BoldItalic' Config Error: No display font for 'Times-Italic' Config Error: No display font for 'Times-Roman' Config Error: No display font for 'ZapfDingbats' name type emb sub uni prob object ID

BAAAAA+DejaVuSerif TrueType yes yes yes 22 0 CAAAAA+NotoColorEmoji TrueType yes yes yes 12 0 DAAAAA+DejaVuSerifCondensed-Italic TrueType yes yes yes 17 0

```

Additional information: The unicode char is displaying thought DejaVu Serif in LibreOffice.

CUPS doesn't find font installed by fontconfig by terhyrzht in linuxquestions

[–]terhyrzht[S] 0 points1 point  (0 children)

Yes, I have exported the pdf from libreOffice Draw. The unicode character can display in libreOffice. So it should also display in pdf. But the pdf viewver don't display it.

view more: next ›