Re: Struggling to get my first importer working (using Red's Importers)

Thanks for the file! I can’t tell whether it was an artifact of how the ofx file you attached got created or whether the original ofx file suffers from this problem, but your ofx file is encoded in UTF-16 even though the header claims it’s UTF-8. ofxparse fails because of this. Running this al

Beanquery - Select expenses tied to a specific asset

Hello everyone, I am using the latest beanquery from PyPI (v0.1.dev0) and I'm pretty new to SQL and beanquery's SQL-like syntax. I am trying to produce a report where I can see all of my expenses for a certain period, something like what my bank statement would show but grouped by my expense ca

Re: Beanquery - Select expenses tied to a specific asset

Hi, I am not sure exactly what you want to achieve, but the following query will give you a sum of all changes to to all accounts (including Assets and Liabilities) over the period of time SELECT account, SUM(position) WHERE date >=2024-09-12 and date <=2024-09-26 This will be all of your inc

Re: Beanquery - Select expenses tied to a specific asset

P.S. changes to Equity will also be shown On Friday, September 20, 2024 at 8:16:13 PM UTC+2 Chary Chary wrote: > Hi, > > I am not sure exactly what you want to achieve, but the following query > will give you a sum of all changes to to all accounts (including Assets and > Liabilities) over the

Re: Beanquery - Select expenses tied to a specific asset

Wow, so simple. That is pretty close to what I need, I'm just wondering if there is a way to filter out only transactions that have a posting with a specific account. For example, take these transactions: 2024-01-01 * "Opening Balances"     Liabilities:Credit  -1000.00 USD     Equity:Opening 

Re: Struggling to get my first importer working (using Red's Importers)

So, I've got my .ofx file and am not worried about the download task anymore. That's the good news. The bad news is now I'm stuck on the import task. bean-extract my.import fidelity_1234_july2024.ofx Results ERROR:root:Importer beancount_reds_importers.importers.fidelity.Importer.identify() ra

Re: Struggling to get my first importer working (using Red's Importers)

This is uncommon, but typically because there was an issue downloading the ofx. Usually because of authentication problems. Have you examined the ofx to see if it's valid? Try this to make it more readable: ``` sed 's/>/>\n/g' xyz.ofx ``` You should see something like this on the top: ```

Re: Struggling to get my first importer working (using Red's Importers)

This is uncommon, but typically because there was an issue downloading the ofx. Usually because of authentication problems. Have you examined the ofx to see if it’s valid? Try this to make it more readable: sed 's/>/>\n/g' xyz.ofx ​ You should see something like this on the top: 0 INFO

Re: Handling reverted transactions in a CVS importer

Glad to hear! If you haven’t seen them already, some of these articles might save you time too. On Thursday, September 19, 2024 at 11:42:36 PM UTC-7 ddv...@gmail.com wrote: > Thanks, that looks like what I need

Re: Struggling to get my first importer working (using Red's Importers)

Thanks, Red. The file itself looks okay after another look. I tried the new line trick, but it didn't change the results. The simple parse threw the same unpacking value error on my ofx while working on the sample ofx. I'm sharing a sanitized version of my ofx (replaced account number, transac