Hello everybody,
I'm looking for a way to start the csv export via terminal command. Are
there solutions to work around the GUI? Or is it possible to convert all
accounts and bookings directly from a .gnucash file to a .csv file per
terminal?
Thanks in advance
--
Sent from:
Hi all
As subject line all of my save reports have gone since I upgraded from V2 to
V3.
Any help?
Peter
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
See https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html for
details of setting up database backends.
Basically it is just File ->Save As and then select the option you require
provided you have the database systems installed and have the necessary
permissions to create a
I have given up trying to create an account structure and then populating it.
Instead I exported one account with transactions of a limited date range and
imported it into GnuCash. I got further this time. The import created the
accounts from the Quicken account/categories, showed the matches for
That is a fair interpretation, since that's what the wiki says. However, it
would appear that the wiki is in need of some correction.
I'm not sure, but that wiki language may have resulted from a writer's
misunderstanding of the different import vectors, with one writer assuming that
account
I am using a System76 Pop!_OS 18.04 LTS
GnuCash 2.6.19 is available
During initial setup only the XML file format is available.
I have PostgreSQL on my system. Would rather use that or SQLite.
How can I setup using one of those DBs?
Thanks
___
But this is based off transactions and I don’t think the OP wanted
transactional data, just accounts.
Regards,
Adrien
> On Feb 12, 2019, at 3:01 PM, Bucky Carr wrote:
>
>
> Quicken2016 has a .PRN export option that looks like this:
>
>
If you are in a mood to experiment you could try exporting as qif a limited
date range of a month or so from the bank account in Quicken that should
match the account you have already set up in Gnucash both with and without
the account tree. Then try importing both. That might at least get all
Hello,
I just want to apologize, somehow the subject of this thread escaped my
mind maybe because the OP’s post I bit not understandable.
I obviously know what split transactions are and yes, if one account
remains unsplit I would go from there.
Kind regards
Christian Kluge
Am 12.02.2019 um
Quicken2016 has a .PRN export option that looks like this:
"Date","Num","Payee","Category","Memo","Amount","C","Balance"
"6/24/1992",,"VG - 500 Index","[Retire - VG - Rollover
IRA]",,-2.50,"R",-2.50,
"9/24/1992",,"VG - 500 Index","[Retire - VG - Rollover
IRA]",,-2.50,"R",-5.00,
Is that
Nope, the category import also produces nothing.
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
No, Quicken does not have the CSV option. It has the options to export
transactions, account list, category list, memorized payees and security
list. I assumed GnuCash would build an account tree from an account list
based on the following from the Quicken Migration wiki statement "Although
it is
On 2/12/2019 2:49 PM, Christian Kluge wrote:
Sorry, I made the assumption that since talking about "splits" you
already knew about entering "split transactions. Your example below,
showing it as multiple transactions, indicates otherwise. So taking your
example (a $100 expense paid for by $50
Does Quicken offer the option to export just the account tree as a CSV? You can
import an account tree into GnuCash if it is in the proper CSV format. This is
a fixed format, you can’t map the columns so you’ll need to likley modify the
Quicken export to conform before importing.
Regards,
Am 11.02.2019 um 22:15 schrieb Michael or Penny Novack:
> On 2/11/2019 2:40 PM, Christian Kluge wrote:
>> Hi,
>>
>> my general rule of thumb is to always entering from an asset or
>> liability account.
>>
> The proper "general rule" for a (one side) split transaction is to
> enter it from the
You can't. Qif only imports transactions. If you have no transactions
then the importer will do nothing.
-derek
Sent using my mobile device. Please excuse any typos.
On February 12, 2019 1:37:28 PM David Carlson
wrote:
I am not by my Gnucash right now but if I recall, there is a slightly
I am not by my Gnucash right now but if I recall, there is a slightly
different work path to import accounts without transactions.
David Carlson
On Tue, Feb 12, 2019, 12:22 PM dmacklewis I installed Gnucash 3.4.1 on MacOS High Sierra 10.13.6 and created a file
> with one account. I then
I installed Gnucash 3.4.1 on MacOS High Sierra 10.13.6 and created a file
with one account. I then exported a Quicken Deluxe 2019 QIF file containing
just the accounts. The import seems to run but when the page to 'Match QIF
accounts with GnuCash accounts' is displayed, it it empty. None of the
> On Feb 12, 2019, at 11:47 AM, Keith Bellairs wrote:
>
> Thanks, Derek. The issue has been around for years, I guess.
>
> Looking at invoices, for a cash basis user the invoice should get posted to
> payables when received and the payable is reversed to expense on the date
> the payment is
Thanks for the tip(s)! I had forgotten that GC automatically creates a
"Trading" account. After deleting that and the inital price ntry
created by the first transaction, I could delete the security.
On 12.02.19 18:30, Maf. King wrote:
On Tuesday, 12 February 2019 17:27:20 GMT rsbrux via
On Tue, 12 Feb 2019, Adrien Monteleone wrote:
That doesn’t apply if using the Transaction Report. If you were following
the advice to run an Account Report *after* first filtering that
particular register, then I was advising to add to the workflow a step to
remove the filter on that register.
That doesn’t apply if using the Transaction Report.
If you were following the advice to run an Account Report *after* first
filtering that particular register, then I was advising to add to the workflow
a step to remove the filter on that register.
Regards,
Adrien
> On Feb 12, 2019, at 11:36
Thanks, Derek. The issue has been around for years, I guess.
Looking at invoices, for a cash basis user the invoice should get posted to
payables when received and the payable is reversed to expense on the date
the payment is actually made.
For an accrual basis user the expense could be posted
On Tue, 12 Feb 2019, Adrien Monteleone wrote:
Don’t forget to clear the filter after running the report or down the road
you might be wondering why you aren’t seeing a bunch of transactions.
(there is an indicator, but it is easily missed)
Adrien,
I'm not following you; perhaps we're looking
Hi,
Did you uncompress the XML file before trying to open it?
-derek
On Tue, February 12, 2019 12:27 pm, rsbrux wrote:
> @Derek,
> Many thanks for your advice. Believe me, I've tried. Unfortunately, it
> is a mystery to me why any account should still be using this security.
> As mentioned
You might have set the preference to compress the file. Either uncompress it
from your file manager before opening, or unset the preference and perform
another save from within GnuCash.
Regards,
Adrien
> On Feb 12, 2019, at 11:27 AM, rsbrux via gnucash-user
> wrote:
>
> @Derek,
> Many
Don’t forget to clear the filter after running the report or down the road you
might be wondering why you aren’t seeing a bunch of transactions. (there is an
indicator, but it is easily missed)
Regards,
Adrien
> On Feb 12, 2019, at 10:39 AM, Rich Shepard wrote:
>
> On Tue, 12 Feb 2019, David
@Derek,
Many thanks for your advice. Believe me, I've tried. Unfortunately, it
is a mystery to me why any account should still be using this security.
As mentioned below, I have deleted both the initial transaction and the
investment account I created for the security. I don't know why any
On Tue, 12 Feb 2019, Rich Shepard wrote:
Otherwise, use the transaction report and select your account and date
range there.
I like this.
As a follow up suggestion, it would be nice if GnuCash remembers the
directory in which to print the PDF file based on the previous one used.
Now, each
Hello all,
I am unable to set the invoice counter format in GnuCash 3.4 on OSX 10.14
(Mojave) while using the XML backend (I have not tried with SQL). When I reopen
File > Preferences after entering a format and clicking OK, my edits are gone,
and new invoices inherit the default nn
On Tue, 12 Feb 2019, David T. wrote:
You have numerous options. If you’re going the Account Report method,
first filter your account for the date range you want and then trigger the
report.
David,
This is what Geert recommended. Hadn't thought of doing this.
Otherwise, use the transaction
Rich,
You have numerous options. If you’re going the Account Report method, first
filter your account for the date range you want and then trigger the report.
Otherwise, use the transaction report and select your account and date range
there.
Of course, you could use the Tax Options to set
Op dinsdag 12 februari 2019 17:05:41 CET schreef Rich Shepard:
> Running Build ID: 3.4+ (2018-12-30) on Slackware-14.2.
>
> Preparing to send my account 2018 tax information and I've encountered a
> problem: when I print an Account Report as a PDF the options do not allow me
> to specify a date
Sorry, yeah QXF != QFX. QFX/OFX is readable. QXF is not.
-derek
On Tue, February 12, 2019 11:04 am, Dan Black wrote:
> QFX is a download format, designed for import of transactions from your
> bank into a single Quicken account. ... QXF is an encrypted file transfer
> format designed to move
Running Build ID: 3.4+ (2018-12-30) on Slackware-14.2.
Preparing to send my account 2018 tax information and I've encountered a
problem: when I print an Account Report as a PDF the options do not allow me
to specify a date range, only the appearance of the report and which columns
to include.
QFX is a download format, designed for import of transactions from your
bank into a single Quicken account. ... QXF is an encrypted file transfer
format designed to move entire Quicken databases with multiple accounts
from Windows to Mac or visa versa.
On February 12, 2019 10:46:36 AM Derek
Hi,
rsbrux via gnucash-user writes:
> Because of the well-known difficulties associated with assigning the
> correct currency to a security, I need to delete and recreate a
> security. I have deleted the initial transaction I created for this
> security, as well as the investment account I
David Carlson writes:
> I just peeked at Quicken 2019 and they also have a QXF file format which
> does not work for GnuCash either. I did not have time to figure out what
> they do use that format for. For us it is another tree in the forest.
Are you sure? QXF should be readable by the OFX
There is a difference between QXF and QFX formats.
Ken Schneider
> On Feb 12, 2019, at 8:45 AM, David Carlson
> wrote:
>
> I just peeked at Quicken 2019 and they also have a QXF file format which
> does not work for GnuCash either. I did not have time to figure out what
> they do use that
I just peeked at Quicken 2019 and they also have a QXF file format which
does not work for GnuCash either. I did not have time to figure out what
they do use that format for. For us it is another tree in the forest.
David Carlson
On Mon, Feb 11, 2019 at 11:23 PM John Ralls wrote:
>
>
> > On
Do not overlook the possibility that you may be looking in the wrong file
for the fresh data. Usually it is easiest to employ a file manager to look
for data files that have the correct name and recent date stamps.
David Carlson
On Mon, Feb 11, 2019 at 11:20 PM David Cousens
wrote:
> Anatoly
It reachd the list.
> On Feb 11, 2019, at 4:58 PM, Derek Atkins wrote:
>
> humming.b...@posteo.net writes:
>
>> Dear Derek,
>>
>> if this email reaches the list, then TLS is working.
>
> Considering you sent it to me *and* the list, I have no way to confirm.
> My tests seem to imply it is
On Tuesday, 12 February 2019 12:09:22 GMT Finbar Mahon wrote:
> Well, I hope I understood all that.
>
> I did a save as in a new folder called GNU FEB 12 2019, >Saved all the
> open accounts, >closed them, >quit and then reopened GNUcash.
>
> Voila, afaics, a file opened called GNU FEB12
Well, I hope I understood all that.
I did a save as in a new folder called GNU FEB 12 2019, >Saved all the
open accounts, >closed them, >quit and then reopened GNUcash.
Voila, afaics, a file opened called GNU FEB12 2019.gnucash and it
contains the last transactions, so far so good.
Just
Because of the well-known difficulties associated with assigning the
correct currency to a security, I need to delete and recreate a
security. I have deleted the initial transaction I created for this
security, as well as the investment account I created for the
transaction. Nonetheless,
> On 11 Feb 2019, at 18:59, Adrien Monteleone
> wrote:
>
> All context menus for me on a Mac have a ‘lag’ or delay on some or all items
> in the menu. At most this lasts about 2 seconds. In most cases it is only one
> menu entry (consistently a ‘delete’ variant) that doesn’t seem to want to
Hello,
does anyone have suggestions how to trace the fault further?
even if I launch gnucash with "gnucash --log "=debug" --log
"gnc.backend.dbi=debug" --log "qof=debug" --log "gnc=debug", I do not get
anything on STDOUT or STDERR..
Logs are by default written to
47 matches
Mail list logo
