Re: [GNC] get quotes via gnucash-cli for unknown quote source

[Jascha K via gnucash-user]

> On Aug 24, 2023, at 05:59, john via gnucash-user gnucash-user@gnucash.org 
> wrote:
> 
> > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user 
> > gnucash-user@gnucash.org wrote:
> > 
> > Hi,
> > 
> > I've been trying to get quotes via gnucash-cli with the following command:
> > 
> > gnucash-cli --quotes get mysql://
> > 
> > However, I get the following message when executing the command and no 
> > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with 
> > no commodities.'
> > 
> > All of my quote sources are of type 'Unknown' (tradegate, fondsweb).
> > 
> > When I get the quotes via 'Get Quotes' in the Price Database, the quotes 
> > are fetched normally, so it seems to be a problem with the CLI.
> > 
> > After some investigation, I found out 2 things:
> > 
> > 1. When switching the quote source for a security to a source that is not 
> > Unknown, the CLI is able to fetch that security's quote.
> > 
> > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add the 
> > tradegate and fondsweb sources to the 'single_quote_sources' variable (thus 
> > making them known sources), the CLI is able to fetch all quotes, no more 
> > errors.
> > 
> > This leads me to believe that the CLI fetching ignores securities where the 
> > quote source is Unknown, whereas the GUI fetches the quotes regardless of 
> > the quote source. I was not able to pin down this behavior in the source, 
> > but maybe somebody can clarify whether this is the desired behavior for the 
> > CLI.
> > 
> > Tested with most recent stable branch and Flatpak version 5.3, F::Q 
> > versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
> 
> 
> Not desired behavior but not surprising either: In order to know about the 
> unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q and 
> it doesn't do that. Shouldn't be too hard to fix, but please file a bug so 
> that the problem doesn't get lost in mailing list entropy.
> 
> Regards,
> John Ralls

Thanks for the explanation. The bug is filed: 
https://bugs.gnucash.org/show_bug.cgi?id=799066.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] CSV Import

[Murugan Muruganandam]

hi Jack

can you be more specific on what help you are looking for.  there are quite a 
few knowlede base online




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
jackielou wong 
Sent: Thursday, August 24, 2023 12:07 AM
To: john 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] get quotes via gnucash-cli for unknown quote source

Hello there

Can i ask for importing 100 transactions using csv.

On Thu, Aug 24, 2023, 12:00 PM john  wrote:

>
>
> > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > Hi,
> >
> > I've been trying to get quotes via gnucash-cli with the following
> command:
> >
> > gnucash-cli --quotes get mysql://
> >
> > However, I get the following message when executing the command and no
> quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with
> no commodities.'
> >
> > All of my quote sources are of type 'Unknown' (tradegate, fondsweb).
> >
> > When I get the quotes via 'Get Quotes' in the Price Database, the quotes
> are fetched normally, so it seems to be a problem with the CLI.
> >
> > After some investigation, I found out 2 things:
> >
> > 1. When switching the quote source for a security to a source that is
> not Unknown, the CLI is able to fetch that security's quote.
> >
> > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add the
> tradegate and fondsweb sources to the 'single_quote_sources' variable (thus
> making them known sources), the CLI is able to fetch all quotes, no more
> errors.
> >
> > This leads me to believe that the CLI fetching ignores securities where
> the quote source is Unknown, whereas the GUI fetches the quotes regardless
> of the quote source. I was not able to pin down this behavior in the
> source, but maybe somebody can clarify whether this is the desired behavior
> for the CLI.
> >
> > Tested with most recent stable branch and Flatpak version 5.3, F::Q
> versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
>
> Not desired behavior but not surprising either: In order to know about the
> unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q
> and it doesn't do that. Shouldn't be too hard to fix, but please file a bug
> so that the problem doesn't get lost in mailing list entropy.
>
> Regards,
> John Ralls
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[jackielou wong]

Hello
i tried to import and csv file.
Can you help me to transfer all of this into proper account; Here is my
sample

On Thu, Aug 24, 2023 at 9:36 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> hi Jack
>
> can you be more specific on what help you are looking for.  there are
> quite a few knowlede base online
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of jackielou wong <
> jcklcalim...@gmail.com>
> *Sent:* Thursday, August 24, 2023 12:07 AM
> *To:* john 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] get quotes via gnucash-cli for unknown quote source
>
> Hello there
>
> Can i ask for importing 100 transactions using csv.
>
> On Thu, Aug 24, 2023, 12:00 PM john  wrote:
>
> >
> >
> > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> > >
> > > Hi,
> > >
> > > I've been trying to get quotes via gnucash-cli with the following
> > command:
> > >
> > > gnucash-cli --quotes get mysql://
> > >
> > > However, I get the following message when executing the command and no
> > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with
> > no commodities.'
> > >
> > > All of my quote sources are of type 'Unknown' (tradegate, fondsweb).
> > >
> > > When I get the quotes via 'Get Quotes' in the Price Database, the
> quotes
> > are fetched normally, so it seems to be a problem with the CLI.
> > >
> > > After some investigation, I found out 2 things:
> > >
> > > 1. When switching the quote source for a security to a source that is
> > not Unknown, the CLI is able to fetch that security's quote.
> > >
> > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add the
> > tradegate and fondsweb sources to the 'single_quote_sources' variable
> (thus
> > making them known sources), the CLI is able to fetch all quotes, no more
> > errors.
> > >
> > > This leads me to believe that the CLI fetching ignores securities where
> > the quote source is Unknown, whereas the GUI fetches the quotes
> regardless
> > of the quote source. I was not able to pin down this behavior in the
> > source, but maybe somebody can clarify whether this is the desired
> behavior
> > for the CLI.
> > >
> > > Tested with most recent stable branch and Flatpak version 5.3, F::Q
> > versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
> >
> > Not desired behavior but not surprising either: In order to know about
> the
> > unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q
> > and it doesn't do that. Shouldn't be too hard to fix, but please file a
> bug
> > so that the problem doesn't get lost in mailing list entropy.
> >
> > Regards,
> > John Ralls
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
Id,Date,Desc,transfer,Amount
1,06/27/2020,Deposit bofa,,3
2,06/30/2020, LLC : QUICKBOOKS ID: ,,1881.34
3,06/30/2020,LLC : QUICKBOOKS ID: 1722616653CO: ,,18000
4,06/30/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,0.82
5,07/21/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 7764315,,-0.56
6,07/21/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 7764314,,-0.94
7,07/28/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8116937,,0.56
8,07/28/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8116938,,0.94
9,07/28/2020, LLC : QUICKBOOKS ID: 1722616653CO:  LLC Entry Class Code: PPD ACH : 8223375,,2000.65
10,07/28/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8116939  (),Expenses:salary,-2002.4
11,07/30/2020, LLC : QUICKBOOKS ID: 1722616653CO:  LLC Entry Class Code: PPD ACH : 3946318,,2000.66
12,07/30/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 3220527 (),Expenses:salary,-2002.41
13,07/31/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,12.58
14,08/13/2020, LLC : QUICKBOOKS ID: 1722616653CO:  LLC Entry Class Code: PPD ACH : 9675915,,2000.66
15,08/13/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH 

[GNC] Issues with gnucash files

[Mahon Finbar via gnucash-user]

This is an update of sorts of a long series of messages here since I had 
an issue with saving my transactions at the end of July.


I was unable to copy and send GNU files to the kind people who tried to 
help me. I have no idea why, copy and paste after changing to the file 
type required just did not work.


There were many messages concerning why I seemed to have more than one 
set of GNU files with  different user names, and at different times.


I have now downloaded all the files containing "GNU" for the period of 
July 2023.


There is bewildering list with an equally bewildering number of names, 
suffixes, etc., such as -


16  files of type  - gnucash.trace.YXDV81.log each one duplicated and 
where only the alphanumeric is different


A large number of 'shortcuts' and many files which I think are backups 
with several date strings in the same file.


I have not been able to decipher these nor files with .msf or .gcm or 
.dmp or GnuCash_is1 !!


Maybe I have made numerous errors, and unwittingly put files in 
different places or formats, but. I am a longtime user of GNU, most 
of the current longer files start with GNU FEB 12 2019.gnucash.


Finally, all the files I have now are in Documents 
(C:\users\administrato) with various sub-addresses. That seems to have 
sorted the issue with one of the issues raised in a message -


"Be sure you aren't confusing the two users on your system! (one is 
"Barry Mahon" and the other is "administrato""



Any help at this stage would be welcome. I have a tax declaration to do 
by mid November.


I would be willing to start all over again and re-enter the 2022 
transactions, the tax year concerned, and create a new 2023 set of 
transactions to continue.


Finbar


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Issues with gnucash files

[Mahon Finbar via gnucash-user]

Thank you and happy to see that someone else is confused by filenames 
and suffixes


A screen grab from CaptureWiz of a screen from part of my 'July' GNU search.

My issue was that towards the end of July I had a strange message which 
said I had no rights to save the current transactions to the file I was 
apparently trying to save to. I had no idea were the 'errant' file came 
from.


I put up a text of the message and then went through a series of 
messages about what was happening, with increasing confusion.


All I want to do is find, if possible, the original 'good' file I was 
working on and continue. I would be quite happy to try on the dates in 
the last few days of July, but where to start?


Can anyone identify a likely candidate? For example in the screengrab 
there are a series of files with 496kb on the same time and date on 30 
July, but I am not sure how to start a GNU session to access the 'right' 
file?


Finbar

On 24/08/2023 18:28, Maf. King wrote:

Barry,

thanks for the update.

The *.log and *.gcm files are not your data.  no idea what *.msf and *.dmp
would be (maybe a crash dump?).Your main data file will most likely be a
*,gnucash file.

As to backups and datestamps etc see the attached image.

mafs-new-accs.xac is my data file (.xac is the very old suffix, it still works
and ,gnucash is equivalent.  I'm just old-school)

ignore the .logs

you can see the datestamps are MMDDhhmmss which should help you decipher
your list.

the first backup in my image is 20230824120845.   So it was made today
(2023-08-24 at 12:08:45) . as you can see, that time matches the "create
time/date" for the base file.

hope that helps you with the deciphering, if you can't get us a screenshot.

Just try to find the *.gnucash file with the most recent date stamp in the name,
move it into a new folder, call it something sensible and open it.  see what
transactions GC says is there.  Add a test txn in and try to save it.

Good luck
Maf.




On Thursday, 24 August 2023 16:14:26 BST Mahon Finbar via gnucash-user wrote:

This is an update of sorts of a long series of messages here since I had
an issue with saving my transactions at the end of July.

I was unable to copy and send GNU files to the kind people who tried to
help me. I have no idea why, copy and paste after changing to the file
type required just did not work.

There were many messages concerning why I seemed to have more than one
set of GNU files with  different user names, and at different times.

I have now downloaded all the files containing "GNU" for the period of
July 2023.

There is bewildering list with an equally bewildering number of names,
suffixes, etc., such as -

16  files of type  - gnucash.trace.YXDV81.log each one duplicated and
where only the alphanumeric is different

A large number of 'shortcuts' and many files which I think are backups
with several date strings in the same file.

I have not been able to decipher these nor files with .msf or .gcm or
.dmp or GnuCash_is1 !!

Maybe I have made numerous errors, and unwittingly put files in
different places or formats, but. I am a longtime user of GNU, most
of the current longer files start with GNU FEB 12 2019.gnucash.

Finally, all the files I have now are in Documents
(C:\users\administrato) with various sub-addresses. That seems to have
sorted the issue with one of the issues raised in a message -

"Be sure you aren't confusing the two users on your system! (one is
"Barry Mahon" and the other is "administrato""


Any help at this stage would be welcome. I have a tax declaration to do
by mid November.

I would be willing to start all over again and re-enter the 2022
transactions, the tax year concerned, and create a new 2023 set of
transactions to continue.

Finbar





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Issues with gnucash files

[R Losey]

On Thu, Aug 24, 2023 at 10:15 AM Mahon Finbar via gnucash-user <
gnucash-user@gnucash.org> wrote:

> This is an update of sorts of a long series of messages here since I had
> an issue with saving my transactions at the end of July.
>
> I was unable to copy and send GNU files to the kind people who tried to
> help me. I have no idea why, copy and paste after changing to the file
> type required just did not work.
>
> There were many messages concerning why I seemed to have more than one
> set of GNU files with  different user names, and at different times.
>
> I have now downloaded all the files containing "GNU" for the period of
> July 2023.
>
> There is bewildering list with an equally bewildering number of names,
> suffixes, etc., such as -
>
> 16  files of type  - gnucash.trace.YXDV81.log each one duplicated and
> where only the alphanumeric is different
>
> A large number of 'shortcuts' and many files which I think are backups
> with several date strings in the same file.
>
> I have not been able to decipher these nor files with .msf or .gcm or
> .dmp or GnuCash_is1 !!
>
> Maybe I have made numerous errors, and unwittingly put files in
> different places or formats, but. I am a longtime user of GNU, most
> of the current longer files start with GNU FEB 12 2019.gnucash.
>
> Finally, all the files I have now are in Documents
> (C:\users\administrato) with various sub-addresses. That seems to have
> sorted the issue with one of the issues raised in a message -
>
> "Be sure you aren't confusing the two users on your system! (one is
> "Barry Mahon" and the other is "administrato""
>
>
> Any help at this stage would be welcome. I have a tax declaration to do
> by mid November.
>
> I would be willing to start all over again and re-enter the 2022
> transactions, the tax year concerned, and create a new 2023 set of
> transactions to continue.
>
> Finbar
>

I'm glad all of the files are under one user now... make sure that you
access them with the same user, or (if you are an advanced user, set the
permissions accordingly).

The file that holds the GnuCash data has an extension of ".gnucash" - you
can ignore the other files for the time being.

Your main file should be "what-you-called-it.gnucash" (for example,
"Finbar.gnucash"). If you don't have one of those files, you have
trouble... all the similar-looking files are backup files with the numbers
being year-month-day-hour-minute-second (using the sample name above,
"Finbar.20230822072234.gnucash").

If your main file is missing, can you restore it from a backup? If so,
restore it, and then start GnuCash and use the File->Open to open that
restored file... you should enter any data you have missing and use this
file as your file henceforth.

If you cannot restore your main file, you will need to pick a backup file,
and start with it. I don't know which would be the best backup file, as I
seem to recall that you have been doing edits on various files. You will
have to decide which is best... possibly, the one with the latest
"Modified" date.  Also, I'm not sure how to open a backup file, because (on
my iMac), the File->Open option does not let me see backup files. You may
need to create a copy of the backup file and call it your main file. You
should then start GnuCash and use File->Open to open that file.

You'll need to correct anything that is wrong and then go forward. Because
of all the confusion, after you are SURE you have a good main file again,
you might want to clear out the old backup files and start fresh. You
control how long to keep backup files in the "General" tab of the
preferences.

As a safety precaution, I would certainly backup the files that you have.

I created a folder just for my GnuCash data files (separate from the
install folder). All it contains are .gnucash files and .log files (and, of
course, the LCK file when I'm running GnuCash). I like this because all it
contains are the data files... this may be worth considering for you. Once
you have your file fixed up, you can use the File->Save As to put your data
file in its own place.

I never click on a file to open it; I always open GnuCash application... it
seems to always open the last file that was being worked on.

Best wishes to you... I hope this helped.

_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Issues with gnucash files

[Mahon Finbar via gnucash-user]

Thanks for the details, OK, here goes.

I opened this file in Gnu -

No 'log' It had a 'save' icon and when I try to save it I get this -

That is the problem. There is plenty of space.

Finbar

On 24/08/2023 18:28, Maf. King wrote:

Barry,

thanks for the update.

The *.log and *.gcm files are not your data.  no idea what *.msf and *.dmp
would be (maybe a crash dump?).Your main data file will most likely be a
*,gnucash file.

As to backups and datestamps etc see the attached image.

mafs-new-accs.xac is my data file (.xac is the very old suffix, it still works
and ,gnucash is equivalent.  I'm just old-school)

ignore the .logs

you can see the datestamps are MMDDhhmmss which should help you decipher
your list.

the first backup in my image is 20230824120845.   So it was made today
(2023-08-24 at 12:08:45) . as you can see, that time matches the "create
time/date" for the base file.

hope that helps you with the deciphering, if you can't get us a screenshot.

Just try to find the *.gnucash file with the most recent date stamp in the name,
move it into a new folder, call it something sensible and open it.  see what
transactions GC says is there.  Add a test txn in and try to save it.

Good luck
Maf.




On Thursday, 24 August 2023 16:14:26 BST Mahon Finbar via gnucash-user wrote:

This is an update of sorts of a long series of messages here since I had
an issue with saving my transactions at the end of July.

I was unable to copy and send GNU files to the kind people who tried to
help me. I have no idea why, copy and paste after changing to the file
type required just did not work.

There were many messages concerning why I seemed to have more than one
set of GNU files with  different user names, and at different times.

I have now downloaded all the files containing "GNU" for the period of
July 2023.

There is bewildering list with an equally bewildering number of names,
suffixes, etc., such as -

16  files of type  - gnucash.trace.YXDV81.log each one duplicated and
where only the alphanumeric is different

A large number of 'shortcuts' and many files which I think are backups
with several date strings in the same file.

I have not been able to decipher these nor files with .msf or .gcm or
.dmp or GnuCash_is1 !!

Maybe I have made numerous errors, and unwittingly put files in
different places or formats, but. I am a longtime user of GNU, most
of the current longer files start with GNU FEB 12 2019.gnucash.

Finally, all the files I have now are in Documents
(C:\users\administrato) with various sub-addresses. That seems to have
sorted the issue with one of the issues raised in a message -

"Be sure you aren't confusing the two users on your system! (one is
"Barry Mahon" and the other is "administrato""


Any help at this stage would be welcome. I have a tax declaration to do
by mid November.

I would be willing to start all over again and re-enter the 2022
transactions, the tax year concerned, and create a new 2023 set of
transactions to continue.

Finbar





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Issues with gnucash files

[David Carlson]

Your last message was truncated before the salient part, but I suspect that
you do not have rights for GnuCash to save files in administrato user space.

You need to unscramble which username is your 'standard' username and put
all your user files including other types from other applications such as
spreadsheets, pdfs, text files, etc. in that userspace Documents folder or
some subfolder.  I am not sure how much trouble it will be to do that, but
you probably need to have administrator rights to accomplish that.  Then
you can make sure that your 'standard' user has read/write rights for all
those files so you no longer need administrator rights.  I am not a Windows
guru so I may have overlooked some details to warn you about.  Good luck.



On Thu, Aug 24, 2023 at 12:47 PM Mahon Finbar via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Thanks for the details, OK, here goes.
>
> I opened this file in Gnu -
>
> No 'log' It had a 'save' icon and when I try to save it I get this -
>
> That is the problem. There is plenty of space.
>
> Finbar
>
> On 24/08/2023 18:28, Maf. King wrote:
> > Barry,
> >
> > thanks for the update.
> >
> > The *.log and *.gcm files are not your data.  no idea what *.msf and
> *.dmp
> > would be (maybe a crash dump?).Your main data file will most likely
> be a
> > *,gnucash file.
> >
> > As to backups and datestamps etc see the attached image.
> >
> > mafs-new-accs.xac is my data file (.xac is the very old suffix, it still
> works
> > and ,gnucash is equivalent.  I'm just old-school)
> >
> > ignore the .logs
> >
> > you can see the datestamps are MMDDhhmmss which should help you
> decipher
> > your list.
> >
> > the first backup in my image is 20230824120845.   So it was made today
> > (2023-08-24 at 12:08:45) . as you can see, that time matches the
> "create
> > time/date" for the base file.
> >
> > hope that helps you with the deciphering, if you can't get us a
> screenshot.
> >
> > Just try to find the *.gnucash file with the most recent date stamp in
> the name,
> > move it into a new folder, call it something sensible and open it.  see
> what
> > transactions GC says is there.  Add a test txn in and try to save it.
> >
> > Good luck
> > Maf.
> >
> >
> >
> >
> > On Thursday, 24 August 2023 16:14:26 BST Mahon Finbar via gnucash-user
> wrote:
> >> This is an update of sorts of a long series of messages here since I had
> >> an issue with saving my transactions at the end of July.
> >>
> >> I was unable to copy and send GNU files to the kind people who tried to
> >> help me. I have no idea why, copy and paste after changing to the file
> >> type required just did not work.
> >>
> >> There were many messages concerning why I seemed to have more than one
> >> set of GNU files with  different user names, and at different times.
> >>
> >> I have now downloaded all the files containing "GNU" for the period of
> >> July 2023.
> >>
> >> There is bewildering list with an equally bewildering number of names,
> >> suffixes, etc., such as -
> >>
> >> 16  files of type  - gnucash.trace.YXDV81.log each one duplicated and
> >> where only the alphanumeric is different
> >>
> >> A large number of 'shortcuts' and many files which I think are backups
> >> with several date strings in the same file.
> >>
> >> I have not been able to decipher these nor files with .msf or .gcm or
> >> .dmp or GnuCash_is1 !!
> >>
> >> Maybe I have made numerous errors, and unwittingly put files in
> >> different places or formats, but. I am a longtime user of GNU, most
> >> of the current longer files start with GNU FEB 12 2019.gnucash.
> >>
> >> Finally, all the files I have now are in Documents
> >> (C:\users\administrato) with various sub-addresses. That seems to have
> >> sorted the issue with one of the issues raised in a message -
> >>
> >> "Be sure you aren't confusing the two users on your system! (one is
> >> "Barry Mahon" and the other is "administrato""
> >>
> >>
> >> Any help at this stage would be welcome. I have a tax declaration to do
> >> by mid November.
> >>
> >> I would be willing to start all over again and re-enter the 2022
> >> transactions, the tax year concerned, and create a new 2023 set of
> >> transactions to continue.
> >>
> >> Finbar
> >>
> >>
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[David Cousens]

Jackielou,

The file looks ok.  You will need to have created the accounts in the transfer
column before importing. You may have to experiment with the header to apply to
the amount column. Assuming you are importing the transactions into an account
of type Asset, e.g. a bank account then normally assigning the deposit header to
the column with the Amounts should import OK. Try a small sample first and if it
doesn't import with debit transactions for the +ve amounts in the Amount column
of your import file switch the header assigned to Withdrawal. For the other
columns assigning the header that matches the column name  should be ok. Make
sure the date format is "mm-dd-yyy" in the CSV setup dialogue. Unfortunately
with CSV importing it takes a bit of fiddling but once you have a correct setup
for importing for a given source you can save the setup and recall it next time
you have to import from the same source


You will need to either specify transfer accounts for all the entries and the
accounts will have to have been created prior to the import or you will need to
assign them at the import matcher dialogue of the import procedure. You can
create new accounts from the account tab while in the import matcher dialogue
(while keeping it open) if they do not exist and then assign them to the
transactions in the import matcher dialogue. In most cases these appear to be
transfers to the account you are importing into from another asset account most
likely a main bank account to cover salary expenses.

If this doesn't work for you can you post some screenshots of the import
matching process for the above file.

David Cousens


On Thu, 2023-08-24 at 22:06 +0800, jackielou wong wrote:
> Hello
> i tried to import and csv file.
> Can you help me to transfer all of this into proper account; Here is my
> sample
> 
> On Thu, Aug 24, 2023 at 9:36 PM Murugan Muruganandam <
> m.muruganan...@hotmail.com> wrote:
> 
> > hi Jack
> > 
> > can you be more specific on what help you are looking for.  there are
> > quite a few knowlede base online
> > 
> > 
> > 
> > Saludos Cordiales
> > 
> > 
> > Murugan
> > --
> > *From:* gnucash-user  > hotmail@gnucash.org> on behalf of jackielou wong <
> > jcklcalim...@gmail.com>
> > *Sent:* Thursday, August 24, 2023 12:07 AM
> > *To:* john 
> > *Cc:* gnucash-user@gnucash.org 
> > *Subject:* Re: [GNC] get quotes via gnucash-cli for unknown quote source
> > 
> > Hello there
> > 
> > Can i ask for importing 100 transactions using csv.
> > 
> > On Thu, Aug 24, 2023, 12:00 PM john  wrote:
> > 
> > > 
> > > 
> > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
> > > gnucash-user@gnucash.org> wrote:
> > > > 
> > > > Hi,
> > > > 
> > > > I've been trying to get quotes via gnucash-cli with the following
> > > command:
> > > > 
> > > > gnucash-cli --quotes get mysql://
> > > > 
> > > > However, I get the following message when executing the command and no
> > > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with
> > > no commodities.'
> > > > 
> > > > All of my quote sources are of type 'Unknown' (tradegate, fondsweb).
> > > > 
> > > > When I get the quotes via 'Get Quotes' in the Price Database, the
> > quotes
> > > are fetched normally, so it seems to be a problem with the CLI.
> > > > 
> > > > After some investigation, I found out 2 things:
> > > > 
> > > > 1. When switching the quote source for a security to a source that is
> > > not Unknown, the CLI is able to fetch that security's quote.
> > > > 
> > > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add the
> > > tradegate and fondsweb sources to the 'single_quote_sources' variable
> > (thus
> > > making them known sources), the CLI is able to fetch all quotes, no more
> > > errors.
> > > > 
> > > > This leads me to believe that the CLI fetching ignores securities where
> > > the quote source is Unknown, whereas the GUI fetches the quotes
> > regardless
> > > of the quote source. I was not able to pin down this behavior in the
> > > source, but maybe somebody can clarify whether this is the desired
> > behavior
> > > for the CLI.
> > > > 
> > > > Tested with most recent stable branch and Flatpak version 5.3, F::Q
> > > versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
> > > 
> > > Not desired behavior but not surprising either: In order to know about
> > the
> > > unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q
> > > and it doesn't do that. Shouldn't be too hard to fix, but please file a
> > bug
> > > so that the problem doesn't get lost in mailing list entropy.
> > > 
> > > Regards,
> > > John Ralls
> > > 
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by usin

Re: [GNC] CSV Import

[jackielou wong]

The file that i give to you what is the proper transfer fir "deposit, " its
under checking account. Can u send it bank sample

On Fri, Aug 25, 2023, 5:06 AM David Cousens 
wrote:

> Jackielou,
>
> The file looks ok.  You will need to have created the accounts in the
> transfer
> column before importing. You may have to experiment with the header to
> apply to
> the amount column. Assuming you are importing the transactions into an
> account
> of type Asset, e.g. a bank account then normally assigning the deposit
> header to
> the column with the Amounts should import OK. Try a small sample first and
> if it
> doesn't import with debit transactions for the +ve amounts in the Amount
> column
> of your import file switch the header assigned to Withdrawal. For the other
> columns assigning the header that matches the column name  should be ok.
> Make
> sure the date format is "mm-dd-yyy" in the CSV setup dialogue.
> Unfortunately
> with CSV importing it takes a bit of fiddling but once you have a correct
> setup
> for importing for a given source you can save the setup and recall it next
> time
> you have to import from the same source
>
>
> You will need to either specify transfer accounts for all the entries and
> the
> accounts will have to have been created prior to the import or you will
> need to
> assign them at the import matcher dialogue of the import procedure. You can
> create new accounts from the account tab while in the import matcher
> dialogue
> (while keeping it open) if they do not exist and then assign them to the
> transactions in the import matcher dialogue. In most cases these appear to
> be
> transfers to the account you are importing into from another asset account
> most
> likely a main bank account to cover salary expenses.
>
> If this doesn't work for you can you post some screenshots of the import
> matching process for the above file.
>
> David Cousens
>
>
> On Thu, 2023-08-24 at 22:06 +0800, jackielou wong wrote:
> > Hello
> > i tried to import and csv file.
> > Can you help me to transfer all of this into proper account; Here is my
> > sample
> >
> > On Thu, Aug 24, 2023 at 9:36 PM Murugan Muruganandam <
> > m.muruganan...@hotmail.com> wrote:
> >
> > > hi Jack
> > >
> > > can you be more specific on what help you are looking for.  there are
> > > quite a few knowlede base online
> > >
> > >
> > >
> > > Saludos Cordiales
> > >
> > >
> > > Murugan
> > > --
> > > *From:* gnucash-user  > > hotmail@gnucash.org> on behalf of jackielou wong <
> > > jcklcalim...@gmail.com>
> > > *Sent:* Thursday, August 24, 2023 12:07 AM
> > > *To:* john 
> > > *Cc:* gnucash-user@gnucash.org 
> > > *Subject:* Re: [GNC] get quotes via gnucash-cli for unknown quote
> source
> > >
> > > Hello there
> > >
> > > Can i ask for importing 100 transactions using csv.
> > >
> > > On Thu, Aug 24, 2023, 12:00 PM john  wrote:
> > >
> > > >
> > > >
> > > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
> > > > gnucash-user@gnucash.org> wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > I've been trying to get quotes via gnucash-cli with the following
> > > > command:
> > > > >
> > > > > gnucash-cli --quotes get mysql://
> > > > >
> > > > > However, I get the following message when executing the command
> and no
> > > > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called
> with
> > > > no commodities.'
> > > > >
> > > > > All of my quote sources are of type 'Unknown' (tradegate,
> fondsweb).
> > > > >
> > > > > When I get the quotes via 'Get Quotes' in the Price Database, the
> > > quotes
> > > > are fetched normally, so it seems to be a problem with the CLI.
> > > > >
> > > > > After some investigation, I found out 2 things:
> > > > >
> > > > > 1. When switching the quote source for a security to a source that
> is
> > > > not Unknown, the CLI is able to fetch that security's quote.
> > > > >
> > > > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add
> the
> > > > tradegate and fondsweb sources to the 'single_quote_sources' variable
> > > (thus
> > > > making them known sources), the CLI is able to fetch all quotes, no
> more
> > > > errors.
> > > > >
> > > > > This leads me to believe that the CLI fetching ignores securities
> where
> > > > the quote source is Unknown, whereas the GUI fetches the quotes
> > > regardless
> > > > of the quote source. I was not able to pin down this behavior in the
> > > > source, but maybe somebody can clarify whether this is the desired
> > > behavior
> > > > for the CLI.
> > > > >
> > > > > Tested with most recent stable branch and Flatpak version 5.3, F::Q
> > > > versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
> > > >
> > > > Not desired behavior but not surprising either: In order to know
> about
> > > the
> > > > unknown quote source gnucash-cli -Q get needs to retrieve them from
> F::Q
> > > > and it doesn't do that. Shouldn't be too hard to fix, but please
> file a
> > > bug
> > > > so that the problem d

Re: [GNC] CSV Import

[jackielou wong]

I have 500 transactions under checking account for importing files... how
can i put this all in linked accounts...

Everytime i do that they fall to imbalance usd.. can you help to fix it. So
i can do it in faster way.

Thank you



On Fri, Aug 25, 2023, 5:08 AM jackielou wong  wrote:

> The file that i give to you what is the proper transfer fir "deposit, "
> its under checking account. Can u send it bank sample
>
> On Fri, Aug 25, 2023, 5:06 AM David Cousens 
> wrote:
>
>> Jackielou,
>>
>> The file looks ok.  You will need to have created the accounts in the
>> transfer
>> column before importing. You may have to experiment with the header to
>> apply to
>> the amount column. Assuming you are importing the transactions into an
>> account
>> of type Asset, e.g. a bank account then normally assigning the deposit
>> header to
>> the column with the Amounts should import OK. Try a small sample first
>> and if it
>> doesn't import with debit transactions for the +ve amounts in the Amount
>> column
>> of your import file switch the header assigned to Withdrawal. For the
>> other
>> columns assigning the header that matches the column name  should be ok.
>> Make
>> sure the date format is "mm-dd-yyy" in the CSV setup dialogue.
>> Unfortunately
>> with CSV importing it takes a bit of fiddling but once you have a correct
>> setup
>> for importing for a given source you can save the setup and recall it
>> next time
>> you have to import from the same source
>>
>>
>> You will need to either specify transfer accounts for all the entries and
>> the
>> accounts will have to have been created prior to the import or you will
>> need to
>> assign them at the import matcher dialogue of the import procedure. You
>> can
>> create new accounts from the account tab while in the import matcher
>> dialogue
>> (while keeping it open) if they do not exist and then assign them to the
>> transactions in the import matcher dialogue. In most cases these appear
>> to be
>> transfers to the account you are importing into from another asset
>> account most
>> likely a main bank account to cover salary expenses.
>>
>> If this doesn't work for you can you post some screenshots of the import
>> matching process for the above file.
>>
>> David Cousens
>>
>>
>> On Thu, 2023-08-24 at 22:06 +0800, jackielou wong wrote:
>> > Hello
>> > i tried to import and csv file.
>> > Can you help me to transfer all of this into proper account; Here is my
>> > sample
>> >
>> > On Thu, Aug 24, 2023 at 9:36 PM Murugan Muruganandam <
>> > m.muruganan...@hotmail.com> wrote:
>> >
>> > > hi Jack
>> > >
>> > > can you be more specific on what help you are looking for.  there are
>> > > quite a few knowlede base online
>> > >
>> > >
>> > >
>> > > Saludos Cordiales
>> > >
>> > >
>> > > Murugan
>> > > --
>> > > *From:* gnucash-user > > > hotmail@gnucash.org> on behalf of jackielou wong <
>> > > jcklcalim...@gmail.com>
>> > > *Sent:* Thursday, August 24, 2023 12:07 AM
>> > > *To:* john 
>> > > *Cc:* gnucash-user@gnucash.org 
>> > > *Subject:* Re: [GNC] get quotes via gnucash-cli for unknown quote
>> source
>> > >
>> > > Hello there
>> > >
>> > > Can i ask for importing 100 transactions using csv.
>> > >
>> > > On Thu, Aug 24, 2023, 12:00 PM john  wrote:
>> > >
>> > > >
>> > > >
>> > > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
>> > > > gnucash-user@gnucash.org> wrote:
>> > > > >
>> > > > > Hi,
>> > > > >
>> > > > > I've been trying to get quotes via gnucash-cli with the following
>> > > > command:
>> > > > >
>> > > > > gnucash-cli --quotes get mysql://
>> > > > >
>> > > > > However, I get the following message when executing the command
>> and no
>> > > > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch
>> called with
>> > > > no commodities.'
>> > > > >
>> > > > > All of my quote sources are of type 'Unknown' (tradegate,
>> fondsweb).
>> > > > >
>> > > > > When I get the quotes via 'Get Quotes' in the Price Database, the
>> > > quotes
>> > > > are fetched normally, so it seems to be a problem with the CLI.
>> > > > >
>> > > > > After some investigation, I found out 2 things:
>> > > > >
>> > > > > 1. When switching the quote source for a security to a source
>> that is
>> > > > not Unknown, the CLI is able to fetch that security's quote.
>> > > > >
>> > > > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add
>> the
>> > > > tradegate and fondsweb sources to the 'single_quote_sources'
>> variable
>> > > (thus
>> > > > making them known sources), the CLI is able to fetch all quotes, no
>> more
>> > > > errors.
>> > > > >
>> > > > > This leads me to believe that the CLI fetching ignores securities
>> where
>> > > > the quote source is Unknown, whereas the GUI fetches the quotes
>> > > regardless
>> > > > of the quote source. I was not able to pin down this behavior in the
>> > > > source, but maybe somebody can clarify whether this is the desired
>> > > behavior
>> > > > for the CLI.
>> > > > >

Re: [GNC] CSV Import

[Stan Brown (using GC 4.14)]

On 2023-08-24 14:15, jackielou wong wrote:
> I have 500 transactions under checking account for importing files... how
> can i put this all in linked accounts...
> 
> Everytime i do that they fall to imbalance usd.. can you help to fix it. So

Jackielou,

This suggestion may seem inefficient, but I think you might get the job
done faster by just entering the 500 transactions manually, which I
imagine you know how to do.

I've never done an import myself, but as I understand it you have to
teach GnuCash to recognize transactions the way you want. That takes
time, which you could be using to enter transactions right into GC, a
process I assume you are comfortable with. And 500 is really not many.

That's what I did in early 2018 when I converted my 2011-2017 data to
GC. It was over 15,000 transactions, but once I got going it went very
quickly. Sure, I had to deal with each transaction individually, but I
would have had to check each one anyway if I had tried an import. And
along the way, I noticed inconsistencies in how I had treated similar
events, and fixed them. For me, at least, the process was less painful
than spending a lot of time learning and tinkering with a batch import
process that I would probably never need to use again.

If you still want to pursue importing, I think it would be helpful if
you could be a lot more specific about what process you are following,
what results you see in GC, and what error message you get (if any).
Maybe import _one_ transaction, and provide that information?

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com/
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[Stephen M. Butler]

I have used the CSV importer several times to great advantage.  At a 
minimum you need the following columns:


1.  Date -- be sure that you set the importer to the date format you 
used.  I use MM/DD/.

2.  Description -- What you want in the transaction description.
3.  Account Code -- Something that will uniquely identify the "other 
account".  I tend to use 3-4 character (sometime just 2) codes easy for 
me to remember.  These will get mapped (by you) to the real GnC account 
during the import process.
4.  Amount -- I sometimes have to specify that this is a negative amount 
(even though the file has positive values).


During the import you will have to specify the base account.  This will 
be the checking account.  This is a field on the import screen -- not in 
your file.
At some point you will map the above fields to tell the imported which 
one is the date, which one is the Other Account, which one is the 
description and which one is the amount (or negative amount).


Test this out in a test environment first.

Save all your mapping to a file name so you can pull it back up for real 
(or for future use).  It is there on the setup screen.


At some point you will have the setup all done and will go NEXT.  At 
this point it will list all the codes you used and ask you to map those 
to the real accounts (I presume expenses).


Good luck.

On 8/24/23 15:00, Stan Brown (using GC 4.14) wrote:

On 2023-08-24 14:15, jackielou wong wrote:

I have 500 transactions under checking account for importing files... how
can i put this all in linked accounts...

Everytime i do that they fall to imbalance usd.. can you help to fix it. So

Jackielou,

This suggestion may seem inefficient, but I think you might get the job
done faster by just entering the 500 transactions manually, which I
imagine you know how to do.

I've never done an import myself, but as I understand it you have to
teach GnuCash to recognize transactions the way you want. That takes
time, which you could be using to enter transactions right into GC, a
process I assume you are comfortable with. And 500 is really not many.

That's what I did in early 2018 when I converted my 2011-2017 data to
GC. It was over 15,000 transactions, but once I got going it went very
quickly. Sure, I had to deal with each transaction individually, but I
would have had to check each one anyway if I had tried an import. And
along the way, I noticed inconsistencies in how I had treated similar
events, and fixed them. For me, at least, the process was less painful
than spending a lot of time learning and tinkering with a batch import
process that I would probably never need to use again.

If you still want to pursue importing, I think it would be helpful if
you could be a lot more specific about what process you are following,
what results you see in GC, and what error message you get (if any).
Maybe import _one_ transaction, and provide that information?

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com/



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[jackielou wong]

You mean ill do it manual for 100s transaction. Is that correct? How can i
transfer in fastest way

On Fri, Aug 25, 2023, 7:01 AM Stephen M. Butler  wrote:

> I have used the CSV importer several times to great advantage.  At a
> minimum you need the following columns:
>
> 1.  Date -- be sure that you set the importer to the date format you
> used.  I use MM/DD/.
> 2.  Description -- What you want in the transaction description.
> 3.  Account Code -- Something that will uniquely identify the "other
> account".  I tend to use 3-4 character (sometime just 2) codes easy for
> me to remember.  These will get mapped (by you) to the real GnC account
> during the import process.
> 4.  Amount -- I sometimes have to specify that this is a negative amount
> (even though the file has positive values).
>
> During the import you will have to specify the base account.  This will
> be the checking account.  This is a field on the import screen -- not in
> your file.
> At some point you will map the above fields to tell the imported which
> one is the date, which one is the Other Account, which one is the
> description and which one is the amount (or negative amount).
>
> Test this out in a test environment first.
>
> Save all your mapping to a file name so you can pull it back up for real
> (or for future use).  It is there on the setup screen.
>
> At some point you will have the setup all done and will go NEXT.  At
> this point it will list all the codes you used and ask you to map those
> to the real accounts (I presume expenses).
>
> Good luck.
>
> On 8/24/23 15:00, Stan Brown (using GC 4.14) wrote:
> > On 2023-08-24 14:15, jackielou wong wrote:
> >> I have 500 transactions under checking account for importing files...
> how
> >> can i put this all in linked accounts...
> >>
> >> Everytime i do that they fall to imbalance usd.. can you help to fix
> it. So
> > Jackielou,
> >
> > This suggestion may seem inefficient, but I think you might get the job
> > done faster by just entering the 500 transactions manually, which I
> > imagine you know how to do.
> >
> > I've never done an import myself, but as I understand it you have to
> > teach GnuCash to recognize transactions the way you want. That takes
> > time, which you could be using to enter transactions right into GC, a
> > process I assume you are comfortable with. And 500 is really not many.
> >
> > That's what I did in early 2018 when I converted my 2011-2017 data to
> > GC. It was over 15,000 transactions, but once I got going it went very
> > quickly. Sure, I had to deal with each transaction individually, but I
> > would have had to check each one anyway if I had tried an import. And
> > along the way, I noticed inconsistencies in how I had treated similar
> > events, and fixed them. For me, at least, the process was less painful
> > than spending a lot of time learning and tinkering with a batch import
> > process that I would probably never need to use again.
> >
> > If you still want to pursue importing, I think it would be helpful if
> > you could be a lot more specific about what process you are following,
> > what results you see in GC, and what error message you get (if any).
> > Maybe import _one_ transaction, and provide that information?
> >
> > Stan Brown
> > Tehachapi, CA, USA
> > https://BrownMath.com/
> >
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[Stephen M. Butler]

I presume that you will not have 100s of expense accounts.  You would 
have to do the mapping once per code word.  Just once.


On 8/24/23 16:21, jackielou wong wrote:
You mean ill do it manual for 100s transaction. Is that correct? How 
can i transfer in fastest way


On Fri, Aug 25, 2023, 7:01 AM Stephen M. Butler  wrote:

I have used the CSV importer several times to great advantage.  At a
minimum you need the following columns:

1.  Date -- be sure that you set the importer to the date format you
used.  I use MM/DD/.
2.  Description -- What you want in the transaction description.
3.  Account Code -- Something that will uniquely identify the "other
account".  I tend to use 3-4 character (sometime just 2) codes
easy for
me to remember.  These will get mapped (by you) to the real GnC
account
during the import process.
4.  Amount -- I sometimes have to specify that this is a negative
amount
(even though the file has positive values).

During the import you will have to specify the base account. This
will
be the checking account.  This is a field on the import screen --
not in
your file.
At some point you will map the above fields to tell the imported
which
one is the date, which one is the Other Account, which one is the
description and which one is the amount (or negative amount).

Test this out in a test environment first.

Save all your mapping to a file name so you can pull it back up
for real
(or for future use).  It is there on the setup screen.

At some point you will have the setup all done and will go NEXT.  At
this point it will list all the codes you used and ask you to map
those
to the real accounts (I presume expenses).

Good luck.

On 8/24/23 15:00, Stan Brown (using GC 4.14) wrote:
> On 2023-08-24 14:15, jackielou wong wrote:
>> I have 500 transactions under checking account for importing
files... how
>> can i put this all in linked accounts...
>>
>> Everytime i do that they fall to imbalance usd.. can you help
to fix it. So
> Jackielou,
>
> This suggestion may seem inefficient, but I think you might get
the job
> done faster by just entering the 500 transactions manually, which I
> imagine you know how to do.
>
> I've never done an import myself, but as I understand it you have to
> teach GnuCash to recognize transactions the way you want. That takes
> time, which you could be using to enter transactions right into
GC, a
> process I assume you are comfortable with. And 500 is really not
many.
>
> That's what I did in early 2018 when I converted my 2011-2017
data to
> GC. It was over 15,000 transactions, but once I got going it
went very
> quickly. Sure, I had to deal with each transaction individually,
but I
> would have had to check each one anyway if I had tried an
import. And
> along the way, I noticed inconsistencies in how I had treated
similar
> events, and fixed them. For me, at least, the process was less
painful
> than spending a lot of time learning and tinkering with a batch
import
> process that I would probably never need to use again.
>
> If you still want to pursue importing, I think it would be
helpful if
> you could be a lot more specific about what process you are
following,
> what results you see in GC, and what error message you get (if any).
> Maybe import _one_ transaction, and provide that information?
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com/ 
>

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.