Re: [GNC] Import troubles

2025-02-23 Thread Murugan Mariappan 
can you elaborate what is the error message you are receiving and also generate 
the trace and post it. You can search the archive on how to create trace file





Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
"alois müller" via gnucash-user 
Sent: 23 February 2025 21:11
To: gnucash-user@gnucash.org 
Subject: [GNC] Import troubles

   I have a large CSV-File with transactions.
   My problem is, that about 10% of this transaction will not import
   correct!!
   See these 4 examples:
   "2007-03-28","Billa","","5.1100","-5.1100","Girokonto","Essen"
   "2021-06-14","Spar","Karte: 98","4.00","-4.00","Bargeld","Extras"
   "2007-03-28","Billa","","0.8500","-0.8500","Girokonto","Katzen"
   "2021-06-14","Spar","Karte: 98","6.00","-6.00","Bargeld","Katzen"
   the FIRST will not import!!
   [BZzO5Da6OkOXWi5VFolOEo3elod13b6p42qAuQJAEmt6hEXWASjp3Uk26WDVFA
   vufydKXVVZIEKAFg+NFygLKOni9MDdXR0qOOIfFMEYWlk9p9XFQ62AI
   BUmCoKAABUDUZcAACAqkHDBQAAqBo0XAAAgKpBw
   wUAAKgaNFwAAICq8f8HMyISB+fFYscASUVORK5CYII=]
   Why does the importer NOT take the correct debit account as it does
   with the 3 others??
   I have about 30 000 transactions.
   I can impossibly correct all not working transactions manually.
   Please help
 __

   Your E-Mail. Your Cloud. Your Office. [1]eclipso Mail Europe.

References

   1. 
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.eclipso.at%2F&data=05%7C02%7C%7C25785e88404d419e5c2c08dd546807f3%7C84df9e7fe9f640afb435%7C1%7C0%7C638759527978336358%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=EYyJ1r66y7E0u%2BYPCIiUMkg%2B0Oi0nGcWWLEvBi5QfTo%3D&reserved=0
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C25785e88404d419e5c2c08dd546807f3%7C84df9e7fe9f640afb435%7C1%7C0%7C638759527978355943%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=eVhkGdRIcSXQoYh%2BwpYtopjRgDeEOIjFDoqcHlgTc0o%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] Import troubles

2025-02-23 Thread David Cousens 
Alois,

I set up a dummy data file in GnuCash 5.10 with Asset accounts
"Bargeld" and "Girokonto" and expense accounts "Essen", "Extras, and
"Katzen" then put the data from your post into a CSV file and imported
it without any problems. I assigned the headers

Date, Description, Memo, Amount Negated, Amount, Account, Transfer
Account
  
to the fields in the data in that order.  The Amount Negated and Amount
were applied to those specific columns so that the debits and credit
were made to the correct accounts (credits to the asset accounts and
debits to the expense accounts) assuming I have translated the German
account names correctly.

With that setup these imported correctly with no problems.

There is a step in the import process where you will have to match the
account names to the internal account names the first time you do an
import even if the names in the CSV Account and Transfer Account fields
are exactly the same as the account names you have used internally in
GnuCash.  Once that assignment has been made it will be remembered in
subsequent imports.

Hope this helps. 

David Cousens

On Mon, 2025-02-24 at 01:11 +0100, "alois müller" via gnucash-user
wrote:
>    I have a large CSV-File with transactions.
>    My problem is, that about 10% of this transaction will not import
>    correct!!
>    See these 4 examples:
>    "2007-03-28","Billa","","5.1100","-5.1100","Girokonto","Essen"
>    "2021-06-14","Spar","Karte: 98","4.00","-4.00","Bargeld","Extras"
>    "2007-03-28","Billa","","0.8500","-0.8500","Girokonto","Katzen"
>    "2021-06-14","Spar","Karte: 98","6.00","-6.00","Bargeld","Katzen"
>    the FIRST will not import!!
>   
> [BZzO5Da6OkOXWi5VFolOEo3elod13b6p42qAuQJAEmt6hEXWASjp3Uk26WDV
> FA
>   
> vufydKXVVZIEKAFg+NFygLKOni9MDdXR0qOOIfFMEYWlk9p9XFQ62
> AI
>   
> BUmCoKAABUDUZcAACAqkHDBQAAqBo0XAAAgKp
> Bw
>    wUAAKgaNFwAAICq8f8HMyISB+fFYscASUVORK5CYII=]
>    Why does the importer NOT take the correct debit account as it
> does
>    with the 3 others??
>    I have about 30 000 transactions.
>    I can impossibly correct all not working transactions manually.
>    Please help
> 
> __
> 
>    Your E-Mail. Your Cloud. Your Office. [1]eclipso Mail Europe.
> 
> References
> 
>    1. https://www.eclipso.at/
> ___
> 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.

[GNC] Import troubles

2025-02-23 Thread alois müller 
   I have a large CSV-File with transactions.
   My problem is, that about 10% of this transaction will not import
   correct!!
   See these 4 examples:
   "2007-03-28","Billa","","5.1100","-5.1100","Girokonto","Essen"
   "2021-06-14","Spar","Karte: 98","4.00","-4.00","Bargeld","Extras"
   "2007-03-28","Billa","","0.8500","-0.8500","Girokonto","Katzen"
   "2021-06-14","Spar","Karte: 98","6.00","-6.00","Bargeld","Katzen"
   the FIRST will not import!!
   [BZzO5Da6OkOXWi5VFolOEo3elod13b6p42qAuQJAEmt6hEXWASjp3Uk26WDVFA
   vufydKXVVZIEKAFg+NFygLKOni9MDdXR0qOOIfFMEYWlk9p9XFQ62AI
   BUmCoKAABUDUZcAACAqkHDBQAAqBo0XAAAgKpBw
   wUAAKgaNFwAAICq8f8HMyISB+fFYscASUVORK5CYII=]
   Why does the importer NOT take the correct debit account as it does
   with the 3 others??
   I have about 30 000 transactions.
   I can impossibly correct all not working transactions manually.
   Please help
 __

   Your E-Mail. Your Cloud. Your Office. [1]eclipso Mail Europe.

References

   1. https://www.eclipso.at/
___
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] Printing personal checks

2025-02-23 Thread Tommy Trussell 
On Thu, Feb 20, 2025 at 3:26 PM  wrote:

> I used to be able to print checks using gnucash.  I have a HP Lazerjet
> 1012, and I would put check in the center print input area. Some of the
> "chk" files would create check going in the correct way, the short part
> of the check going first.  But it would be on the left and not in the
> center.  And I could never modify a "chk" file to correctly do it.  Does
> anybody have a "chk" file that will do this?
>

It has been many years since I printed checks, but the ones I used
successfully back then were the kind that print one or three checks onto a
standard letter-size sheet of paper. I had chosen the kind with a single
check at the bottom and the top two thirds were "stubs." The paper fed into
my printer just like any other letter-size paper stock.

I found the whole process cumbersome for the low quantity of checks I
write, so when I changed banks I shredded the remaining check stock. I
still have the approximately 500 window envelopes remaining, however!

For years I have used an inkjet printer to ENDORSE checks received, and a
few weeks ago the printer suddenly quit functioning. I have been
disappointed that the new "ink tank" printer I purchased cannot reliably
handle a check for endorsement, despite its ability to print onto a
(similarly sized) envelope. I found that the checks would feed straight at
first and then slip sideways and blob excessive amounts of ink onto the
check in addition to the badly skewed text.

I finally found I could put a check in an envelope with a rectangular hole
cut for the check endorsement, and that seems to be working.

Maybe you can find a way to hold each check in position as it feeds through
the printer. I do recall seeing details somewhere describing how to get
GnuCash to print text exactly where you want (which unfortunately seems to
vary somewhat from printer to printer). I recall printing numerous test
pages after changing parameters, then holding the printed plain sheet up to
a strong light to see exactly how its text aligns with the check stock.



> -
> 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.