date:20241018

Re: [GNC] Font size

2024-10-18 Thread Stan Brown (using GC 4.14)

On 2024-10-18 10:22, Joanna Walters via gnucash-user wrote:
> Hi,1st, I get an email digest so I couldn't figure how to reply to 1 email 
> only..

The same way as with any other email -- delete everything you _don't_
want to reply to. (Many mail programs offer a nice shortcut: highlight
the part you want to reply to with your mouse, before you click the
Reply button.) That seems pretty basic, so maybe I'm not understanding
your question.

If you meant "how to reply to just one person", please don't. Always
include the list in your reply. Someone else may have the same issue and
benefit from a public thread. Or someone else may have a solution, which
you would miss by a one-to-one reply.

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.

[GNC] duplicate transactions exported

2024-10-18 Thread Brook Milligan via gnucash-user

I am looking at the transactions exported from a GC (v5.0 Mac) book.  It seems 
that there are a number of duplicate records in the exported file.  Why would 
that be?

Cheers,
Brook

___
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] duplicate transactions exported

2024-10-18 Thread Brook Milligan via gnucash-user

OK, upgrading to GC v5.9.1 fixes the problem.  Opening the same *.gnucash file 
and exporting yields only one line per split, as expected.

Apparently, this is not a known issue for earlier versions, but there may still 
be problems.

Cheers,
Brook

> On Oct 18, 2024, at 3:39 PM, Brook Milligan via gnucash-user 
>  wrote:
> 
> See below.
> 
>> On Oct 18, 2024, at 2:54 PM, Mark at Lorimark  
>> wrote:
>> 
>> really odd!
> 
> Yes, that’s why I’m asking.
> 
>> Here's what I'd suggest;
>> 
>> 1. go in to your register 'assets:bank'
>> 2. edit only 1 row
>> 3. change the 'dollars' to some other number
>> 4. re-export your data
> 
> No change.  There are still the same duplicate records after doing this.
> 
>> My expectation; two of those lines would change (one line for each
>> side/split)
> 
> Yes, my expectation too.
> 
>> The export file looks totally wrong.  It is showing the same transaction
>> ID for each and every line, and that's just totally wrong.  I'd like to
>> look at your file directly, if you're interested.  I'm very curious!
> 
> In this case there actually are 4 splits, so my expectation is that there 
> should be 4 lines with the same transaction ID.  The problem is that each of 
> the 4 distinct lines is replicated a total of 3 times.
> 
> As a check, I created a new book and imported the unique set of transactions 
> from the first (i.e., the exported file sorted with “sort -u”) and 
> re-exported the transactions.  That set still had the duplicates.  Thus, 
> there must be something about the export process that is creating duplicates.
> 
> Is this a known issue?
> 
> Cheers,
> Brook
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7Cbrook%40biology.nmsu.edu%7C7aa08b7e4a17457a67fd08dcefbd625c%7Ca3ec87a89fb84158ba8ff11bace1ebaa%7C1%7C0%7C638648843897539120%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=itfM9uJBzp%2BR3h9HvfdVlBx90cB6Gt%2FxcP%2B0v30GV0M%3D&reserved=0
> -
> 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] Font size

2024-10-18 Thread Phyllis Bruce

Thanks Ken, et. all.  I managed to mess it up.  I cannot access c:\ in the
file explorer.  I created the file exactly as above, including the *
{font:...;}  and filed it on my desktop.
I decided to open it to verify it was correct and got the message
"gtk-3.0.css already exists.  Open anyway?"  So I did.  I lost the GNU
shortcut from my desktop.
I can open GNU from a history where I found the exact pathway in the
Help-About and was able to get there by clicking on that to get here:
[image: image.png]
Do I just move the file from the desktop to this location?

Thanks in advance for your help.  po



On Fri, Oct 18, 2024 at 4:10 PM Ken Pyzik  wrote:

> OK — For Phyllis and Joanna - Please bear with me.  I do have a
> programming background - so I have to be mindful to not be too technical.
> This is for Windows.  Steps:
>
>
>1.  If you don't have one already, you want to make a small text file
>called:  * gtk-3.0.css*
>2.  In this file, you just need one line of text: * {font: 14px
>verdana, arial, sans-serif;}   (format it just like I have it and
>notice, I am using 14 font and I am using verdana as the main one because
>that is what I like.  Use what ever size and font you want to replace the
>14px verdana).
>3.  Save this file with the one line of text in the following folder
>-  c:\users\x\Appdata\Roaming\Gnucash  (where x is your user
>profile).  If this does not make sense to you - open GnuCash and hit HELP —
>ABOUT.  The folder listed next to GNC_USERCONFIG_DIR is where the file
>needs to be.
>
> Close out of Gnucash, if you have it open, and then re-open it and the new
> font should take hold.   If this does not work - others can chime in where
> I may have made a mistake.  Hope this helps.
>
> Ken
>
>
>
> --
> *From:* gnucash-user 
> on behalf of Phyllis Bruce 
> *Sent:* Friday, October 18, 2024 11:13 AM
> *To:* Joanna Walters 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] Font size
>
> Thanks for your reply, Ken.  I'm with Joanna.  I am not a programmer.
> Anything that says change a register sends shivers up my spine.  I don't
> know what a GTK is. I'm on windows 11 with V5.8
>
> po
>
> On Fri, Oct 18, 2024 at 12:23 PM Joanna Walters via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > Hi,1st, I get an email digest so I couldn't figure how to reply to 1
> email
> > only..
> > 2nd, I also would like to change the default font size for the account
> > list and registers. The links I followed got deep into css files and gtk,
> > but I can't find anything on my hard drive that seems appropriate for the
> > gnu cash registers. I am not a programmer, nor do I want to be. I changed
> > the font size on the reports, but can't find anything the applies to
> > register fonts.I'm using v 5.7 (build 5.7+) on a windows 11 home.
> > Thanks,Joanna
> > Truckee, CA 96162
> > 
> >
> > On Friday, October 18, 2024 at 09:00:43 AM PDT,
> > gnucash-user-requ...@gnucash.org 
> > wrote:
> >
> >  Send gnucash-user mailing list submissions to
> > gnucash-user@gnucash.org
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > or, via email, send a message with subject or body 'help' to
> > gnucash-user-requ...@gnucash.org
> >
> > You can reach the person managing the list at
> > gnucash-user-ow...@gnucash.org
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of gnucash-user digest..."
> >
> >
> > Today's Topics:
> >
> >   1.  Font size (Phyllis Bruce)
> >   2. Re:  Font size (Ken Pyzik)
> >   3. Re:  How do I do a back up of Gnucash? (R Losey)
> >   4. Re:  Automatic capital gains question (Jon Schewe)
> >
> >
> > --
> >
> > Message: 1
> > Date: Thu, 17 Oct 2024 16:31:49 -0500
> > From: Phyllis Bruce 
> > To: gnucash-user@gnucash.org
> > Subject: [GNC] Font size
> > Message-ID:
> > 
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Is there any way I can change the font size used by the registers?  I'm
> > going blind trying to read that extremely small print.  I don't want to
> run
> > a report.
> >
> > Thanks!  po
> >
> >
> > --
> >
> > Message: 2
> > Date: Thu, 17 Oct 2024 22:11:59 +
> > From: Ken Pyzik 
> > To: Phyllis Bruce , "gnucash-user@gnucash.org"
> > 
> > Subject: Re: [GNC] Font size
> > Message-ID:
> > <
> >
> mn0p222mb1299bc8eb99c8034ef8b674bae...@mn0p222mb1299.namp222.prod.outlook.com
> > >
> >
> > Content-Type: text/plain; charset="Windows-1252"
> >
> > Phyllis ? welcome to the club!  This was a question I had many times -
> and
> > thanks to the great group here - I was able to get this fixed.
> >
> > The wiki below explains how to make these adjustments, the prop

Re: [GNC] Font size

2024-10-18 Thread Joanna Walters via gnucash-user

Hi,1st, I get an email digest so I couldn't figure how to reply to 1 email 
only..
2nd, I also would like to change the default font size for the account list and 
registers. The links I followed got deep into css files and gtk, but I can't 
find anything on my hard drive that seems appropriate for the gnu cash 
registers. I am not a programmer, nor do I want to be. I changed the font size 
on the reports, but can't find anything the applies to register fonts.I'm using 
v 5.7 (build 5.7+) on a windows 11 home.
Thanks,    Joanna 
Truckee, CA 96162      

On Friday, October 18, 2024 at 09:00:43 AM PDT, 
gnucash-user-requ...@gnucash.org  wrote:  

 Send gnucash-user mailing list submissions to
    gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
    gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
    gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."

Today's Topics:

  1.  Font size (Phyllis Bruce)
  2. Re:  Font size (Ken Pyzik)
  3. Re:  How do I do a back up of Gnucash? (R Losey)
  4. Re:  Automatic capital gains question (Jon Schewe)

--

Message: 1
Date: Thu, 17 Oct 2024 16:31:49 -0500
From: Phyllis Bruce 
To: gnucash-user@gnucash.org
Subject: [GNC] Font size
Message-ID:

Content-Type: text/plain; charset="UTF-8"

Is there any way I can change the font size used by the registers?  I'm
going blind trying to read that extremely small print.  I don't want to run
a report.

Thanks!  po

--

Message: 2
Date: Thu, 17 Oct 2024 22:11:59 +
From: Ken Pyzik 
To: Phyllis Bruce , "gnucash-user@gnucash.org"

Subject: Re: [GNC] Font size
Message-ID:

Content-Type: text/plain; charset="Windows-1252"

Phyllis ? welcome to the club!  This was a question I had many times - and 
thanks to the great group here - I was able to get this fixed.

The wiki below explains how to make these adjustments, the proper file name, 
and the proper file location for each operating system.

https://wiki.gnucash.org/wiki/FAQ#Customizing_the_Appearance

If this does not help you ? or if you need more detailed instructions, write 
back with your OS and version of GnuCash - and someone here will walk you 
through it.

Hope this helps.

Ken

From: gnucash-user  on 
behalf of Phyllis Bruce 
Sent: Thursday, October 17, 2024 2:31 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Font size

Is there any way I can change the font size used by the registers?  I'm
going blind trying to read that extremely small print.  I don't want to run
a report.

Thanks!  po
___
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.

--

Message: 3
Date: Thu, 17 Oct 2024 19:12:03 -0500
From: R Losey 
To: Dan a1TNC 
Cc: halatch1008 , Gnucash Users

Subject: Re: [GNC] How do I do a back up of Gnucash?
Message-ID:

Content-Type: text/plain; charset="UTF-8"

The GnuCash financial data is kept in a file, and this is one you must back
up. I have mine on my home NAS, so that all computers and OSs can access
it. The file name is "something".gnucash, and this should absolutely be a
file that you backup. To move your file to a new location, copy it to the
new location, open GnuCash and manually open the new location (File->Open).
This will probably be the default, but when it opens correctly, I would
delete the file from the old location just to force it to use the new
location.

I am not going to recommend backup programs - there are a multitude for
Windows, and you can do your own Google search.

Once you have the data file backed up securely, the other things are
probably good to have - these include your preference settings and saved
reports.

The guide (https://gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=guide)
explains the type of files in section 2.5.  Section 2.6.2 talks about
preferences and saved reports, and shows where there are stored in Windows.
Please let me (us) know if this is confusing, and I can tell you where mine
are on Windows - I'm writing this on a Mac. The saved reports are in a
.gnucash folder that is either in Users/ or in "My
Documents".

On Thu, Oct 17, 2024 at 2:32?PM Dan a1TNC  wrote:

> I'm wanting to use GNC in a Windows land where there are different OSs.
> Some are 10 and some 11 etc.  I ,like Heidi, did not find the backup info

Re: [GNC] Font size

2024-10-18 Thread Joanna Walters via gnucash-user

Yeah! I got it. It took a while to find the right folder to put the file in, 
but found it using the hot-link on the "about" pop up in the open gnu cash app.
Also, I think the spaces and separate lines made a difference. Mine looks like 
this now: /* Application wide font setting */* {  font: 20px verdana;arial;}
4 lines: 1 = comment, 2 = only asterisk and wavy bracket, 3 specs for font, 4 = 
closing wavy bracketI copied the format from this sample: 
https://github.com/Gnucash/gnucash/blob/stable/doc/gtk-3.0.css Thanks! Now I 
don't need new readers :)-Joanna___Message: 
8
Date: Fri, 18 Oct 2024 21:10:40 +
From: Ken Pyzik 
To: Phyllis Bruce , Joanna Walters

Cc: "gnucash-user@gnucash.org" 
Subject: Re: [GNC] Font size
Message-ID:

Content-Type: text/plain; charset="utf-8"

OK ? For Phyllis and Joanna - Please bear with me.  I do have a programming 
background - so I have to be mindful to not be too technical.  This is for 
Windows.  Steps:

  1.
 If you don't have one already, you want to make a small text file called:  
gtk-3.0.css
  2.
 In this file, you just need one line of text:    * {font: 14px verdana, arial, 
sans-serif;}  (format it just like I have it and notice, I am using 14 font and 
I am using verdana as the main one because that is what I like.  Use what ever 
size and font you want to replace the 14px verdana).
  3.
 Save this file with the one line of text in the following folder  -  
c:\users\x\Appdata\Roaming\Gnucash  (where x is your user profile).  If 
this does not make sense to you - open GnuCash and hit HELP ? ABOUT.  The 
folder listed next to GNC_USERCONFIG_DIR is where the file needs to be.

Close out of Gnucash, if you have it open, and then re-open it and the new font 
should take hold.  If this does not work - others can chime in where I may have 
made a mistake.  Hope this helps.

Ken

From: gnucash-user  on 
behalf of Phyllis Bruce 
Sent: Friday, October 18, 2024 11:13 AM
To: Joanna Walters 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Font size

Thanks for your reply, Ken.  I'm with Joanna.  I am not a programmer.
Anything that says change a register sends shivers up my spine.  I don't
know what a GTK is. I'm on windows 11 with V5.8

po

On Fri, Oct 18, 2024 at 12:23?PM Joanna Walters via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi,1st, I get an email digest so I couldn't figure how to reply to 1 email
> only..
> 2nd, I also would like to change the default font size for the account
> list and registers. The links I followed got deep into css files and gtk,
> but I can't find anything on my hard drive that seems appropriate for the
> gnu cash registers. I am not a programmer, nor do I want to be. I changed
> the font size on the reports, but can't find anything the applies to
> register fonts.I'm using v 5.7 (build 5.7+) on a windows 11 home.
> Thanks,    Joanna
> Truckee, CA 96162
> 
>
>    On Friday, October 18, 2024 at 09:00:43 AM PDT,
> gnucash-user-requ...@gnucash.org 
> wrote:
>
>  Send gnucash-user mailing list submissions to
>    gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>    https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
>    gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
>    gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>  1.  Font size (Phyllis Bruce)
>  2. Re:  Font size (Ken Pyzik)
>  3. Re:  How do I do a back up of Gnucash? (R Losey)
>  4. Re:  Automatic capital gains question (Jon Schewe)
>
>
> --
>
> Message: 1
> Date: Thu, 17 Oct 2024 16:31:49 -0500
> From: Phyllis Bruce 
> To: gnucash-user@gnucash.org
> Subject: [GNC] Font size
> Message-ID:
>    
> Content-Type: text/plain; charset="UTF-8"
>
> Is there any way I can change the font size used by the registers?  I'm
> going blind trying to read that extremely small print.  I don't want to run
> a report.
>
> Thanks!  po
>
>
> --
>
> Message: 2
> Date: Thu, 17 Oct 2024 22:11:59 +
> From: Ken Pyzik 
> To: Phyllis Bruce , "gnucash-user@gnucash.org"
>    
> Subject: Re: [GNC] Font size
> Message-ID:
>    <
> mn0p222mb1299bc8eb99c8034ef8b674bae...@mn0p222mb1299.namp222.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="Windows-1252"
>
> Phyllis ? welcome to the club!  This was a question I had many times - and
> thanks to the great group here - I was able to get this fixed.
>
> The wiki below explains how to make these adjustments, the proper file
> name, and the proper file location for each operating system.
>
> https://wiki.gnucash.org

Re: [GNC] duplicate transactions exported

2024-10-18 Thread Brook Milligan via gnucash-user

See below.

> On Oct 18, 2024, at 2:54 PM, Mark at Lorimark  
> wrote:
> 
> really odd!

Yes, that’s why I’m asking.

> Here's what I'd suggest;
> 
>  1. go in to your register 'assets:bank'
>  2. edit only 1 row
>  3. change the 'dollars' to some other number
>  4. re-export your data

No change.  There are still the same duplicate records after doing this.

> My expectation; two of those lines would change (one line for each
> side/split)

Yes, my expectation too.

> The export file looks totally wrong.  It is showing the same transaction
> ID for each and every line, and that's just totally wrong.  I'd like to
> look at your file directly, if you're interested.  I'm very curious!

In this case there actually are 4 splits, so my expectation is that there 
should be 4 lines with the same transaction ID.  The problem is that each of 
the 4 distinct lines is replicated a total of 3 times.

As a check, I created a new book and imported the unique set of transactions 
from the first (i.e., the exported file sorted with “sort -u”) and re-exported 
the transactions.  That set still had the duplicates.  Thus, there must be 
something about the export process that is creating duplicates.

Is this a known issue?

Cheers,
Brook

___
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] duplicate transactions exported

2024-10-18 Thread Mark at Lorimark

really odd!

Here's what I'd suggest;

1. go in to your register 'assets:bank'
2. edit only 1 row
3. change the 'dollars' to some other number
4. re-export your data

My expectation; two of those lines would change (one line for each
side/split)

The export file looks totally wrong. It is showing the same transaction
ID for each and every line, and that's just totally wrong. I'd like to
look at your file directly, if you're interested. I'm very curious!

I've attached an excerpt from my 'extract transactions all account'
exercise. They look typically normal.

~mark petryk
~w:http://www.lorimarksolutions.com

On 10/18/24 15:37, Brook Milligan wrote:

Sure, see attached. I have taken all the lines in the exported file that
correspond to the first transaction. There are 4 splits, each of which is
represented in the file by 3 duplicate lines.

Cheers,
Brook

On Oct 18, 2024, at 2:17 PM, Mark at Lorimark
wrote:

That shouldn't be. The 'account' column should change for the split.
Normally, a transaction would have 2-lines (2-splits).

Can you send me an excerpt of those lines?

~mark petryk
~w:https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.lorimarksolutions.com%2F&data=05%7C02%7Cbrook%40biology.nmsu.edu%7C6fabd6dfa1d64daec42108dcefb1e9bd%7Ca3ec87a89fb84158ba8ff11bace1ebaa%7C1%7C0%7C638648794644986841%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=oXEokX5swo8vko0tIhkoOY2uitdNUQCcSMVGvfer6C8%3D&reserved=0

On 10/18/24 15:08, Brook Milligan via gnucash-user wrote:

No, I mean exactly identical lines across the entire set of fields in the
export file. For example, one transaction ID has 12 lines in the original
export file, which correspond to 3 identical copies of each of 4 different
lines. In this case, there are 4 splits in the transaction, so the 4 different
line correspond to each of those splits. I am concerned about the fact that
there are 3 copies of each.

Why should that be?

Cheers,

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7Cbrook%40biology.nmsu.edu%7C6fabd6dfa1d64daec42108dcefb1e9bd%7Ca3ec87a89fb84158ba8ff11bace1ebaa%7C1%7C0%7C638648794645024075%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=ISZmcZ4x86U2PLO0SWuqVAJhBW%2F2IGAn4IuRtwN5WE8%3D&reserved=0
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

"Date","Transaction ID","Number","Description","Notes","Commodity/Currency","Void Reason","Action","Memo","Full Account Name","Account Name","Amount With Sym","Amount Num.","Value With Sym","Value Num.","Reconcile","Reconcile Date","Rate/Price"
"2015-11-14","19ff865131804982824241db11f6708f","","Travel Insurance Policy","","CURRENCY::USD","","","","Liabilities:CC:8520-Chase","8520-Chase","-$25.25","-25.25","-$25.25","-25.25","y","2024-03-05","1."
"2015-11-14","19ff865131804982824241db11f6708f","","Travel Insurance Policy","","CURRENCY::USD","","","","Personal:Home:Misc","Misc","$25.25","25.25","$25.25","25.25","n","","1."
"2015-12-20","4625e15147f2495bbf724c52ee886aee","","Laithwait","","CURRENCY::USD","","","","Liabilities:CC:8520-Chase","8520-Chase","-$97.41","-97.41","-$97.41","-97.41","y","2024-03-09","1."
"2015-12-20","4625e15147f2495bbf724c52ee886aee","","Laithwait","","CURRENCY::USD","","","","Personal:Home:Wine","Wine","$97.41","97.41","$97.41","97.41","n","","1."
"2023-04-17","9b1b1b75fce6463fafe69a38c42804f6","","craigs list smart car ad","","CURRENCY::USD","","","","Liabilities:CC:9951-BOAM","9951-BOAM","-$5.00","-5.00","-$5.00","-5.00","y","2023-05-05","1."
"2023-04-17","9b1b1b75fce6463fafe69a38c42804f6","","craigs list smart car ad","","CURRENCY::USD","","","","Personal:Home:Car","Car","$5.00","5.00","$5.00","5.00","n","","1."

___
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] duplicate transactions exported

2024-10-18 Thread David H

I found that using 5.0 and exporting txns created a 32 Mb file but in 5.9
only 12.8 Mb.  A quick look didn't show any duplicated txns but I'll have a
more thorough look later.

Cheers David H.


On Sat, 19 Oct 2024 at 08:05, Brook Milligan via gnucash-user <
gnucash-user@gnucash.org> wrote:

> OK, upgrading to GC v5.9.1 fixes the problem.  Opening the same *.gnucash
> file and exporting yields only one line per split, as expected.
>
> Apparently, this is not a known issue for earlier versions, but there may
> still be problems.
>
> Cheers,
> Brook
>
> > On Oct 18, 2024, at 3:39 PM, Brook Milligan via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > See below.
> >
> >> On Oct 18, 2024, at 2:54 PM, Mark at Lorimark <
> m...@lorimarksolutions.com> wrote:
> >>
> >> really odd!
> >
> > Yes, that’s why I’m asking.
> >
> >> Here's what I'd suggest;
> >>
> >> 1. go in to your register 'assets:bank'
> >> 2. edit only 1 row
> >> 3. change the 'dollars' to some other number
> >> 4. re-export your data
> >
> > No change.  There are still the same duplicate records after doing this.
> >
> >> My expectation; two of those lines would change (one line for each
> >> side/split)
> >
> > Yes, my expectation too.
> >
> >> The export file looks totally wrong.  It is showing the same transaction
> >> ID for each and every line, and that's just totally wrong.  I'd like to
> >> look at your file directly, if you're interested.  I'm very curious!
> >
> > In this case there actually are 4 splits, so my expectation is that
> there should be 4 lines with the same transaction ID.  The problem is that
> each of the 4 distinct lines is replicated a total of 3 times.
> >
> > As a check, I created a new book and imported the unique set of
> transactions from the first (i.e., the exported file sorted with “sort -u”)
> and re-exported the transactions.  That set still had the duplicates.
> Thus, there must be something about the export process that is creating
> duplicates.
> >
> > Is this a known issue?
> >
> > Cheers,
> > Brook
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> >
> https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7Cbrook%40biology.nmsu.edu%7C7aa08b7e4a17457a67fd08dcefbd625c%7Ca3ec87a89fb84158ba8ff11bace1ebaa%7C1%7C0%7C638648843897539120%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=itfM9uJBzp%2BR3h9HvfdVlBx90cB6Gt%2FxcP%2B0v30GV0M%3D&reserved=0
> > -
> > 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] duplicate transactions exported

2024-10-18 Thread Mark at Lorimark

Further, Brook, your export file has different column headings than mine.

What version of GnuCash are you running?

~mark petryk
~w:http://www.lorimarksolutions.com

On 10/18/24 15:37, Brook Milligan wrote:

Sure, see attached. I have taken all the lines in the exported file that
correspond to the first transaction. There are 4 splits, each of which is
represented in the file by 3 duplicate lines.

Cheers,
Brook

On Oct 18, 2024, at 2:17 PM, Mark at Lorimark
wrote:

That shouldn't be. The 'account' column should change for the split.
Normally, a transaction would have 2-lines (2-splits).

Can you send me an excerpt of those lines?

On 10/18/24 15:08, Brook Milligan via gnucash-user wrote:

Why should that be?

Cheers,

Re: [GNC] duplicate transactions exported

2024-10-18 Thread Brook Milligan via gnucash-user

5.0 on a Mac.

> On Oct 18, 2024, at 2:56 PM, Mark at Lorimark  
> wrote:
> 
> Further, Brook, your export file has different column headings than mine.
> 
> What version of GnuCash are you running?
> 
> ~mark petryk
> ~w:https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.lorimarksolutions.com%2F&data=05%7C02%7Cbrook%40biology.nmsu.edu%7Cb5b90bc7dfb14e9c2ef008dcefb746f0%7Ca3ec87a89fb84158ba8ff11bace1ebaa%7C1%7C0%7C638648817698425654%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C6%7C%7C%7C&sdata=w5tncBAZBn7zKr2IwsdvH3%2FnNsldEX0Nq8b7zvzRSss%3D&reserved=0
> 
> On 10/18/24 15:37, Brook Milligan wrote:
>> Sure, see attached.  I have taken all the lines in the exported file that 
>> correspond to the first transaction.  There are 4 splits, each of which is 
>> represented in the file by 3 duplicate lines.
>> 
>> Cheers,
>> Brook
>> 
>>> On Oct 18, 2024, at 2:17 PM, Mark at Lorimark  
>>> wrote:
>>> 
>>> That shouldn't be.  The 'account' column should change for the split.
>>> Normally, a transaction would have 2-lines (2-splits).
>>> 
>>> Can you send me an excerpt of those lines?
>>> 
>>> ~mark petryk
>>> ~w:https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.lorimarksolutions.com%2F&data=05%7C02%7Cbrook%40biology.nmsu.edu%7Cb5b90bc7dfb14e9c2ef008dcefb746f0%7Ca3ec87a89fb84158ba8ff11bace1ebaa%7C1%7C0%7C638648817698425654%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C6%7C%7C%7C&sdata=w5tncBAZBn7zKr2IwsdvH3%2FnNsldEX0Nq8b7zvzRSss%3D&reserved=0
>>> 
>>> On 10/18/24 15:08, Brook Milligan via gnucash-user wrote:
 No, I mean exactly identical lines across the entire set of fields in the 
 export file.  For example, one transaction ID has 12 lines in the original 
 export file, which correspond to 3 identical copies of each of 4 different 
 lines.  In this case, there are 4 splits in the transaction, so the 4 
 different line correspond to each of those splits.  I am concerned about 
 the fact that there are 3 copies of each.
 
 Why should that be?
 
 Cheers,
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7Cbrook%40biology.nmsu.edu%7Cb5b90bc7dfb14e9c2ef008dcefb746f0%7Ca3ec87a89fb84158ba8ff11bace1ebaa%7C1%7C0%7C638648817698425654%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C6%7C%7C%7C&sdata=Z1fug%2FpqdWitw8tXr6tb3kj0VrpzDV1xzyNhXbUbaAE%3D&reserved=0
>>> -
>>> 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] Font size

2024-10-18 Thread Ken Pyzik

OK — For Phyllis and Joanna - Please bear with me.  I do have a programming 
background - so I have to be mindful to not be too technical.  This is for 
Windows.  Steps:


  1.
 If you don't have one already, you want to make a small text file called:   
gtk-3.0.css
  2.
 In this file, you just need one line of text: * {font: 14px verdana, 
arial, sans-serif;}   (format it just like I have it and notice, I am using 14 
font and I am using verdana as the main one because that is what I like.  Use 
what ever size and font you want to replace the 14px verdana).
  3.
 Save this file with the one line of text in the following folder  -  
c:\users\x\Appdata\Roaming\Gnucash  (where x is your user profile).  If 
this does not make sense to you - open GnuCash and hit HELP — ABOUT.  The 
folder listed next to GNC_USERCONFIG_DIR is where the file needs to be.

Close out of Gnucash, if you have it open, and then re-open it and the new font 
should take hold.   If this does not work - others can chime in where I may 
have made a mistake.  Hope this helps.

Ken




From: gnucash-user  on 
behalf of Phyllis Bruce 
Sent: Friday, October 18, 2024 11:13 AM
To: Joanna Walters 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Font size

Thanks for your reply, Ken.  I'm with Joanna.  I am not a programmer.
Anything that says change a register sends shivers up my spine.  I don't
know what a GTK is. I'm on windows 11 with V5.8

po

On Fri, Oct 18, 2024 at 12:23 PM Joanna Walters via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi,1st, I get an email digest so I couldn't figure how to reply to 1 email
> only..
> 2nd, I also would like to change the default font size for the account
> list and registers. The links I followed got deep into css files and gtk,
> but I can't find anything on my hard drive that seems appropriate for the
> gnu cash registers. I am not a programmer, nor do I want to be. I changed
> the font size on the reports, but can't find anything the applies to
> register fonts.I'm using v 5.7 (build 5.7+) on a windows 11 home.
> Thanks,Joanna
> Truckee, CA 96162
> 
>
> On Friday, October 18, 2024 at 09:00:43 AM PDT,
> gnucash-user-requ...@gnucash.org 
> wrote:
>
>  Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>   1.  Font size (Phyllis Bruce)
>   2. Re:  Font size (Ken Pyzik)
>   3. Re:  How do I do a back up of Gnucash? (R Losey)
>   4. Re:  Automatic capital gains question (Jon Schewe)
>
>
> --
>
> Message: 1
> Date: Thu, 17 Oct 2024 16:31:49 -0500
> From: Phyllis Bruce 
> To: gnucash-user@gnucash.org
> Subject: [GNC] Font size
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
>
> Is there any way I can change the font size used by the registers?  I'm
> going blind trying to read that extremely small print.  I don't want to run
> a report.
>
> Thanks!  po
>
>
> --
>
> Message: 2
> Date: Thu, 17 Oct 2024 22:11:59 +
> From: Ken Pyzik 
> To: Phyllis Bruce , "gnucash-user@gnucash.org"
> 
> Subject: Re: [GNC] Font size
> Message-ID:
> <
> mn0p222mb1299bc8eb99c8034ef8b674bae...@mn0p222mb1299.namp222.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="Windows-1252"
>
> Phyllis ? welcome to the club!  This was a question I had many times - and
> thanks to the great group here - I was able to get this fixed.
>
> The wiki below explains how to make these adjustments, the proper file
> name, and the proper file location for each operating system.
>
> https://wiki.gnucash.org/wiki/FAQ#Customizing_the_Appearance
>
> If this does not help you ? or if you need more detailed instructions,
> write back with your OS and version of GnuCash - and someone here will walk
> you through it.
>
> Hope this helps.
>
> Ken
>
>
>
> 
> From: gnucash-user 
> on behalf of Phyllis Bruce 
> Sent: Thursday, October 17, 2024 2:31 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Font size
>
> Is there any way I can change the font size used by the registers?  I'm
> going blind trying to read that extremely small print.  I don't want to run
> a report.
>
> Thanks!  po
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listin

Re: [GNC] Font size

2024-10-18 Thread Phyllis Bruce

Thanks for your reply, Ken.  I'm with Joanna.  I am not a programmer.
Anything that says change a register sends shivers up my spine.  I don't
know what a GTK is. I'm on windows 11 with V5.8

po

On Fri, Oct 18, 2024 at 12:23 PM Joanna Walters via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi,1st, I get an email digest so I couldn't figure how to reply to 1 email
> only..
> 2nd, I also would like to change the default font size for the account
> list and registers. The links I followed got deep into css files and gtk,
> but I can't find anything on my hard drive that seems appropriate for the
> gnu cash registers. I am not a programmer, nor do I want to be. I changed
> the font size on the reports, but can't find anything the applies to
> register fonts.I'm using v 5.7 (build 5.7+) on a windows 11 home.
> Thanks,Joanna
> Truckee, CA 96162
> 
>
> On Friday, October 18, 2024 at 09:00:43 AM PDT,
> gnucash-user-requ...@gnucash.org 
> wrote:
>
>  Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>   1.  Font size (Phyllis Bruce)
>   2. Re:  Font size (Ken Pyzik)
>   3. Re:  How do I do a back up of Gnucash? (R Losey)
>   4. Re:  Automatic capital gains question (Jon Schewe)
>
>
> --
>
> Message: 1
> Date: Thu, 17 Oct 2024 16:31:49 -0500
> From: Phyllis Bruce 
> To: gnucash-user@gnucash.org
> Subject: [GNC] Font size
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
>
> Is there any way I can change the font size used by the registers?  I'm
> going blind trying to read that extremely small print.  I don't want to run
> a report.
>
> Thanks!  po
>
>
> --
>
> Message: 2
> Date: Thu, 17 Oct 2024 22:11:59 +
> From: Ken Pyzik 
> To: Phyllis Bruce , "gnucash-user@gnucash.org"
> 
> Subject: Re: [GNC] Font size
> Message-ID:
> <
> mn0p222mb1299bc8eb99c8034ef8b674bae...@mn0p222mb1299.namp222.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="Windows-1252"
>
> Phyllis ? welcome to the club!  This was a question I had many times - and
> thanks to the great group here - I was able to get this fixed.
>
> The wiki below explains how to make these adjustments, the proper file
> name, and the proper file location for each operating system.
>
> https://wiki.gnucash.org/wiki/FAQ#Customizing_the_Appearance
>
> If this does not help you ? or if you need more detailed instructions,
> write back with your OS and version of GnuCash - and someone here will walk
> you through it.
>
> Hope this helps.
>
> Ken
>
>
>
> 
> From: gnucash-user 
> on behalf of Phyllis Bruce 
> Sent: Thursday, October 17, 2024 2:31 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Font size
>
> Is there any way I can change the font size used by the registers?  I'm
> going blind trying to read that extremely small print.  I don't want to run
> a report.
>
> Thanks!  po
> ___
> 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.
>
>
> --
>
> Message: 3
> Date: Thu, 17 Oct 2024 19:12:03 -0500
> From: R Losey 
> To: Dan a1TNC 
> Cc: halatch1008 , Gnucash Users
> 
> Subject: Re: [GNC] How do I do a back up of Gnucash?
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
>
> The GnuCash financial data is kept in a file, and this is one you must back
> up. I have mine on my home NAS, so that all computers and OSs can access
> it. The file name is "something".gnucash, and this should absolutely be a
> file that you backup. To move your file to a new location, copy it to the
> new location, open GnuCash and manually open the new location (File->Open).
> This will probably be the default, but when it opens correctly, I would
> delete the file from the old location just to force it to use the new
> location.
>
> I am not going to recommend backup programs - there are a multitude for
> Windows, and you can do your own Google search.
>
> Once you have the data file backed up securely, the other things are
> probably good to have - these include your preference settings and saved
> reports.
>
> The guide (https://gnucash.o

Re: [GNC] duplicate transactions exported

2024-10-18 Thread Joseph St. Denis via gnucash-user

I find that it happens when there is a difference between the dates that I 
entered the transaction and the clear date. Most of the time the transactions 
will only appear once but you have to pick the center column to have the 
program to pick the correct transaction.

All the best

Joseph

Get Outlook for Android

From: gnucash-user  on 
behalf of Brook Milligan via gnucash-user 
Sent: Friday, October 18, 2024 1:42:05 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] duplicate transactions exported

I am looking at the transactions exported from a GC (v5.0 Mac) book.  It seems 
that there are a number of duplicate records in the exported file.  Why would 
that be?

Cheers,
Brook

___
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] duplicate transactions exported

2024-10-18 Thread Brook Milligan via gnucash-user

I’m not sure I understand your answer.

To be more clear, I have exported all the transactions from a book into a CSV 
file.  That file has multiple lines that are exactly the same as each other.  
Somehow, GC is exporting lines into the file that are the same.

Why should this happen?  Does this mean that the schema allows for duplicates 
in the internal record?

Cheers,
Brook

> On Oct 18, 2024, at 11:59 AM, Joseph St. Denis  wrote:
> 
> I find that it happens when there is a difference between the dates that I 
> entered the transaction and the clear date. Most of the time the transactions 
> will only appear once but you have to pick the center column to have the 
> program to pick the correct transaction. 
> 
> All the best 
> 
> Joseph 
> 
> Get Outlook for Android
> From: gnucash-user  on 
> behalf of Brook Milligan via gnucash-user 
> Sent: Friday, October 18, 2024 1:42:05 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] duplicate transactions exported   I am looking at the 
> transactions exported from a GC (v5.0 Mac) book.  It seems that there are a 
> number of duplicate records in the exported file.  Why would that be?
> 
> Cheers,
> Brook
> 
> ___
> 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] duplicate transactions exported

2024-10-18 Thread David H

And are the amounts for each matching transaction the opposite sign - i.e.
1 positive and 1 negative - double entry accounting has at least two splits
for every transaction ?

Cheers David H.

On Sat, 19 Oct 2024 at 04:32, Brook Milligan via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I’m not sure I understand your answer.
>
> To be more clear, I have exported all the transactions from a book into a
> CSV file.  That file has multiple lines that are exactly the same as each
> other.  Somehow, GC is exporting lines into the file that are the same.
>
> Why should this happen?  Does this mean that the schema allows for
> duplicates in the internal record?
>
> Cheers,
> Brook
>
> > On Oct 18, 2024, at 11:59 AM, Joseph St. Denis 
> wrote:
> >
> > I find that it happens when there is a difference between the dates that
> I entered the transaction and the clear date. Most of the time the
> transactions will only appear once but you have to pick the center column
> to have the program to pick the correct transaction.
> >
> > All the best
> >
> > Joseph
> >
> > Get Outlook for Android
> > From: gnucash-user 
> on behalf of Brook Milligan via gnucash-user 
> > Sent: Friday, October 18, 2024 1:42:05 PM
> > To: gnucash-user@gnucash.org 
> > Subject: [GNC] duplicate transactions exported   I am looking at the
> transactions exported from a GC (v5.0 Mac) book.  It seems that there are a
> number of duplicate records in the exported file.  Why would that be?
> >
> > Cheers,
> > Brook
> >
> > ___
> > 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] duplicate transactions exported

2024-10-18 Thread Mark at Lorimark

That shouldn't be.  The 'account' column should change for the split. 
Normally, a transaction would have 2-lines (2-splits).


Can you send me an excerpt of those lines?

~mark petryk
~w:http://www.lorimarksolutions.com

On 10/18/24 15:08, Brook Milligan via gnucash-user wrote:

No, I mean exactly identical lines across the entire set of fields in the 
export file.  For example, one transaction ID has 12 lines in the original 
export file, which correspond to 3 identical copies of each of 4 different 
lines.  In this case, there are 4 splits in the transaction, so the 4 different 
line correspond to each of those splits.  I am concerned about the fact that 
there are 3 copies of each.

Why should that be?

Cheers,

___
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] duplicate transactions exported

2024-10-18 Thread Brook Milligan via gnucash-user

No, I mean exactly identical lines across the entire set of fields in the 
export file.  For example, one transaction ID has 12 lines in the original 
export file, which correspond to 3 identical copies of each of 4 different 
lines.  In this case, there are 4 splits in the transaction, so the 4 different 
line correspond to each of those splits.  I am concerned about the fact that 
there are 3 copies of each.

Why should that be?

Cheers,
Brook

> On Oct 18, 2024, at 2:01 PM, David H  wrote:
> 
> And are the amounts for each matching transaction the opposite sign - i.e. 1 
> positive and 1 negative - double entry accounting has at least two splits for 
> every transaction ? 
> 
> Cheers David H.
> 
> On Sat, 19 Oct 2024 at 04:32, Brook Milligan via gnucash-user 
>  wrote:
> I’m not sure I understand your answer.
> 
> To be more clear, I have exported all the transactions from a book into a CSV 
> file.  That file has multiple lines that are exactly the same as each other.  
> Somehow, GC is exporting lines into the file that are the same.
> 
> Why should this happen?  Does this mean that the schema allows for duplicates 
> in the internal record?
> 
> Cheers,
> Brook
> 
> > On Oct 18, 2024, at 11:59 AM, Joseph St. Denis  wrote:
> > 
> > I find that it happens when there is a difference between the dates that I 
> > entered the transaction and the clear date. Most of the time the 
> > transactions will only appear once but you have to pick the center column 
> > to have the program to pick the correct transaction. 
> > 
> > All the best 
> > 
> > Joseph 
> > 
> > Get Outlook for Android
> > From: gnucash-user  on 
> > behalf of Brook Milligan via gnucash-user 
> > Sent: Friday, October 18, 2024 1:42:05 PM
> > To: gnucash-user@gnucash.org 
> > Subject: [GNC] duplicate transactions exported   I am looking at the 
> > transactions exported from a GC (v5.0 Mac) book.  It seems that there are a 
> > number of duplicate records in the exported file.  Why would that be?
> > 
> > Cheers,
> > Brook
> > 
> > ___
> > 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] duplicate transactions exported

2024-10-18 Thread Mark at Lorimark


Brook,

In your export, for any duplicated line, what is that value in the 
'account name' column for each of those lines?


~mark petryk
~w:http://www.lorimarksolutions.com

On 10/18/24 13:31, Brook Milligan via gnucash-user wrote:

I’m not sure I understand your answer.

To be more clear, I have exported all the transactions from a book into a CSV 
file.  That file has multiple lines that are exactly the same as each other.  
Somehow, GC is exporting lines into the file that are the same.

Why should this happen?  Does this mean that the schema allows for duplicates 
in the internal record?


___
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] duplicate transactions exported

2024-10-18 Thread Brook Milligan via gnucash-user

Sure, see attached.  I have taken all the lines in the exported file that 
correspond to the first transaction.  There are 4 splits, each of which is 
represented in the file by 3 duplicate lines.

Cheers,
Brook

> On Oct 18, 2024, at 2:17 PM, Mark at Lorimark  
> wrote:
> 
> That shouldn't be.  The 'account' column should change for the split.
> Normally, a transaction would have 2-lines (2-splits).
> 
> Can you send me an excerpt of those lines?
> 
> ~mark petryk
> ~w:https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.lorimarksolutions.com%2F&data=05%7C02%7Cbrook%40biology.nmsu.edu%7C6fabd6dfa1d64daec42108dcefb1e9bd%7Ca3ec87a89fb84158ba8ff11bace1ebaa%7C1%7C0%7C638648794644986841%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=oXEokX5swo8vko0tIhkoOY2uitdNUQCcSMVGvfer6C8%3D&reserved=0
> 
> On 10/18/24 15:08, Brook Milligan via gnucash-user wrote:
>> No, I mean exactly identical lines across the entire set of fields in the 
>> export file.  For example, one transaction ID has 12 lines in the original 
>> export file, which correspond to 3 identical copies of each of 4 different 
>> lines.  In this case, there are 4 splits in the transaction, so the 4 
>> different line correspond to each of those splits.  I am concerned about the 
>> fact that there are 3 copies of each.
>> 
>> Why should that be?
>> 
>> Cheers,
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7Cbrook%40biology.nmsu.edu%7C6fabd6dfa1d64daec42108dcefb1e9bd%7Ca3ec87a89fb84158ba8ff11bace1ebaa%7C1%7C0%7C638648794645024075%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=ISZmcZ4x86U2PLO0SWuqVAJhBW%2F2IGAn4IuRtwN5WE8%3D&reserved=0
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


Date,Transaction ID,Number,Description,Notes,Commodity/Currency,Void Reason,Action,Memo,Full Account Name,Account Name,Amount With Sym,Amount Num.,Value With Sym,Value Num.,Reconcile,Reconcile Date,Rate/Price
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Assets:Current assets:Bank","Bank","$200.00","200.00","$200.00","200.00","y",2024-03-18,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Assets:Current assets:Bank","Bank","$200.00","200.00","$200.00","200.00","y",2024-03-18,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Assets:Current assets:Bank","Bank","$200.00","200.00","$200.00","200.00","y",2024-03-18,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Assets:Current assets:Bank","Bank","$500.00","500.00","$500.00","500.00","y",2024-03-18,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Assets:Current assets:Bank","Bank","$500.00","500.00","$500.00","500.00","y",2024-03-18,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Assets:Current assets:Bank","Bank","$500.00","500.00","$500.00","500.00","y",2024-03-18,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Income:Family 1","Family 1","-$500.00","-500.00","-$500.00","-500.00","n",,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Income:Family 1","Family 1","-$500.00","-500.00","-$500.00","-500.00","n",,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Income:Family 1","Family 1","-$500.00","-500.00","-$500.00","-500.00","n",,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Income:Family 2","Family 2","-$200.00","-200.00","-$200.00","-200.00","n",,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Income:Family 2","Family 2","-$200.00","-200.00","-$200.00","-200.00","n",,"1."
2024-03-18,4c2affd2e71f4b86b0582e31554ee21e,"1009","Initial deposit","","CURRENCY::USD","","","","Income:Family 2","Family 2","-$200.00","-200.00","-$200.00","-200.00","n",,"1."


___
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] Font size

[GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] Font size

Re: [GNC] Font size

Re: [GNC] Font size

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] Font size

Re: [GNC] Font size

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

Re: [GNC] duplicate transactions exported

20 matches

Site Navigation

Mail list logo

Footer information