[GNC] Importing data from a CSV file

2020-05-08 Thread flywire
lol - Welcome to GnuCash. That's how it is designed. Discussed https://lists.gnucash.org/pipermail/gnucash-user/2020-April/090631.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Importing data from a CSV file

2020-05-08 Thread stephen.m.butler51
Assign that column to Transfer Account. Note that you have to map the values in that column to actual accounts.  Its easier to use shorthand values in the column since you have ti mao them. Subsequent loads remember the mappings already made.  Sent from my Verizon, Samsung Galaxy smartphone

Re: [GNC] Reformat Bank Description to Capitalise Every Word

2020-05-08 Thread Adrien Monteleone
If they are in CSV, you can do this in a spreadsheet app like LibreOffice Calc or Excel. They both have functions for adjusting case. If they are in some other format, then yes, sed would probably be the easiest route. (I suppose you could use it on a CSV too) As for editing the XML directly

[GNC] Importing data from a CSV file

2020-05-08 Thread Geoff Palmer
I've edited my .csv file to include a column of things like "Expenses:Bank Charges" and "Income:Other Income" -- exactly the way they're recorded in GnuCash's account tree, but there doesn't seem to be a way to import these. I can assign this column to "Account" at import, but when I

[GNC] Reformat Bank Description to Capitalise Every Word

2020-05-08 Thread flywire
My bank statements use uppercase text which is harder to read than mixed case. Is it possible to reformat the bank description to capitalise every word? It could happen as part of the import process on any field selected but ideally it would be nice to run on existing transactions without

Re: [GNC] Adding Transactions From Another Program

2020-05-08 Thread Michael or Penny Novack
On 5/8/2020 12:29 PM, John Ralls wrote: GNU BASH, a.k.a. the Bourne Again Shell (because it was originally a Free clean room clone of SysV's Bourne Shell) is the default shell (terminal command processor) on many Linux systems. . It has nothing at all to do with GnuCash and discussing

Re: [GNC] Adding Transactions From Another Program

2020-05-08 Thread John Ralls
GNU BASH, a.k.a. the Bourne Again Shell (because it was originally a Free clean room clone of SysV's Bourne Shell) is the default shell (terminal command processor) on many Linux systems. The manual is at https://www.gnu.org/software/bash/manual/bash.html and you'll find abundant documentation

Re: [GNC] XML vs SQL data integrity question

2020-05-08 Thread GWB
Have you tried sqlite? I don't know how it works on Windows but it might just save it as a file without setting up a salute back end. Maybe try that when you have time. Gordon On Fri, May 8, 2020, 1:27 AM Jeff wrote: > On 5/7/2020 8:28 PM, GWB wrote: > > The idea about the images is a very

Re: [GNC] XML vs SQL data integrity question

2020-05-08 Thread Jeff
On 5/7/2020 8:28 PM, GWB wrote: The idea about the images is a very good one. Invoices, receipts, etc., would do fine in digital format. No question that databases are capable of much greater depth, granularity and ability to search and change. However, in defense of the humble xml text file,