Re: [GNC] Import Bills & Invoices: how can I use e.g. \S in the custom regular expression for import?

You might get some insight from the Description section of https://developer.gnome.org/glib/stable/glib-Perl-compatible-regular-expressions.html , in particular the bit about UTF8. Regards, John Ralls > On

Re: [GNC] Import Bills & Invoices: how can I use e.g. \S in the custom regular expression for import?

Hi John, Well, I have to take it all back. Using \S etc.does work in this situation. The problem is only with matching the \xHH values. I still don’t understand why it won’t match with the \xHH values, but I have some clues that I will look into. I also tested the issue of the bug you referred

Re: [GNC] Import Bills & Invoices: how can I use e.g. \S in the custom regular expression for import?

> On Dec 21, 2018, at 11:54 AM, Rob Laan wrote: > > Hi, > > In the function Import Bills & Invoices, there is the option to use a custom > regular expression to match the import file to the GnuCash fields. > In that regular expression, I want to use regex generic character types (e.g. > \S

Re: [GNC] Import Bills & Invoices: how can I use e.g. \S in the custom regular expression for import?

So it adds an ‘\’ escape to ‘\S’ but not to ’S’? — weird. Even if it was a bug or intentional to add an ‘\’, I’d think it would do it to all expressions as I can’t see any helpful purpose to adding it when you’ve already specified it. Did you file a bug report? Regards, Adrien > On Dec 21, 201

Re: [GNC] Import Bills & Invoices: how can I use e.g. \S in the custom regular expression for import?

Yes, I even tried that! But luckily no result; it would have been pretty weird if that had worked ;) > On 21 Dec 2018, at 23:37, Adrien Monteleone > wrote: > > Rob, > > Although it *shouldn’t* work right, did you happen to try just using ’S’ > without the leading ‘\’ and letting GC insert it

Re: [GNC] Import Bills & Invoices: how can I use e.g. \S in the custom regular expression for import?

Rob, Although it *shouldn’t* work right, did you happen to try just using ’S’ without the leading ‘\’ and letting GC insert it? Is the result ‘\S’ as intended? Certainly, that would be a bug, but you might still get the result you want. (at least for that narrow case) Regards, Adrien > On De

Re: [GNC] Import Bills & Invoices: how can I use e.g. \S in the custom regular expression for import?

Hi David, Thanks. Yes, I know about escaping special characters in regex. But I do not want to escape anything. And I don’t want to search for a \. \S is a regular regex content, matching any non white space character (a so called generic character type); but the expression editor changes my \

Re: [GNC] Import Bills & Invoices: how can I use e.g. \S in the custom regular expression for import?

Rob, The "\" in Regex expressions is used as an escape character for the characters that are used as commands in Regex expressions to denote that the character following it is not to be interpreted as a command but to be interpreted literally. Hence if you wish to search for a "\" which is a comm

[GNC] Import Bills & Invoices: how can I use e.g. \S in the custom regular expression for import?

Hi, In the function Import Bills & Invoices, there is the option to use a custom regular expression to match the import file to the GnuCash fields. In that regular expression, I want to use regex generic character types (e.g. \S for non white space characters), and hex codes (\xHH). But when I

Re: [GNC] Import qif does not remember account allocation.

Hi, John Ralls writes: >> On Dec 3, 2018, at 6:06 AM, David wasserman wrote: >> >> Running Ubuntu 18.04. GNC version 2.6.19. >> >> Whereas GNC remembers previous account allocation on my Mastercard. >> Importing from my recently new AMEX credit card, the system doesn't >> remember the accoun

Re: [GNC] Import qif does not remember account allocation.

> On Dec 3, 2018, at 6:06 AM, David wasserman wrote: > > Running Ubuntu 18.04. GNC version 2.6.19. > > Whereas GNC remembers previous account allocation on my Mastercard. > Importing from my recently new AMEX credit card, the system doesn't > remember the account allocation even for exactly t

[GNC] Import qif does not remember account allocation.

Running Ubuntu 18.04. GNC version 2.6.19. Whereas GNC remembers previous account allocation on my Mastercard. Importing from my recently new AMEX credit card, the system doesn't remember the account allocation even for exactly the same transaction multiple times previously booked. How to fix, pl

Re: [GNC] Import CSV Multi-currency

Em seg, 26 de nov de 2018 às 07:44, John Ralls < jra...@ceridwen.fremont.ca.us> escreveu: > > > On Nov 26, 2018, at 11:26 AM, GTI .H wrote: > > Em dom, 25 de nov de 2018 às 21:26, John Ralls < > jra...@ceridwen.fremont.ca.us> escreveu: > >> Meh. The word “split” may not be in your accounting text

Re: [GNC] Import CSV Multi-currency

> On Nov 26, 2018, at 11:26 AM, GTI .H wrote: > > Em dom, 25 de nov de 2018 às 21:26, John Ralls > escreveu: > Meh. The word “split” may not be in your accounting textbook, but the concept > of it is. Every transaction requires an entry in each of at leas

Re: [GNC] Import CSV Multi-currency

Em dom, 25 de nov de 2018 às 21:26, John Ralls < jra...@ceridwen.fremont.ca.us> escreveu: > Meh. The word “split” may not be in your accounting textbook, but the > concept of it is. Every transaction requires an entry in each of at least > two account ledgers (hence “double entry”). GnuCash calls

Re: [GNC] Import CSV Multi-currency

Meh. The word “split” may not be in your accounting textbook, but the concept of it is. Every transaction requires an entry in each of at least two account ledgers (hence “double entry”). GnuCash calls those entries “splits”. You can argue about the name if you want, but the concept is the found

Re: [GNC] Import CSV Multi-currency

I have a foot in both the physicist and accounting camps having spent most of my working life as a professional physicist and then doing accountancy after an enforced early retirement as a result of government cutbacks in science/education. The clearest definition of split is really in the data

Re: [GNC] Import CSV Multi-currency

Op zondag 25 november 2018 23:04:45 CET schreef David Cousens: > Hi Geert,On Sun, 2018-11-25 at 15:47 +0100, Geert Janssens wrote: > > Op zaterdag 24 november 2018 23:47:33 CET schreef David Cousens: > > > The single line format data cannot be imported correctly at all at the > > > moment as Geert

Re: [GNC] Import CSV Multi-currency

I like a good debate and you are a good partner. I consider your information more relevant. you're an accountant, maybe I'm a physicist, I do not feel the need to show credentials. It is clear, you and John confirmed my suspicions, David Cousens's references are from the docs of GnuCash, mine are

Re: [GNC] Import CSV Multi-currency

Hi Geert,On Sun, 2018-11-25 at 15:47 +0100, Geert Janssens wrote: > Op zaterdag 24 november 2018 23:47:33 CET schreef David Cousens: > > The single line format data cannot be imported correctly at all at the > > moment as Geert indicated in his reply. The single line exported data has a > > separat

Re: [GNC] Import CSV Multi-currency

Op zaterdag 24 november 2018 23:47:33 CET schreef David Cousens: > The single line format data cannot be imported correctly at all at the > moment as Geert indicated in his reply. The single line exported data has a > separate column for the base account for the transaction and a separate > column

Re: [GNC] Import CSV Multi-currency

> On Nov 25, 2018, at 12:14 PM, GTI .H wrote: > > Em sáb, 24 de nov de 2018 às 19:47, David Cousens > escreveu: > >> GTI, >> >> David Carlson's description is actually more correct in accounting terms >> and >> the way GnuCash actually works. This is a double entry accounting system >> which

Re: [GNC] Import CSV Multi-currency

On Sun, 2018-11-25 at 00:14 -0300, GTI .H wrote: > Em sáb, 24 de nov de 2018 às 19:47, David Cousens > escreveu: > > > GTI, > > > > David Carlson's description is actually more correct in accounting terms > > and > > the way GnuCash actually works. This is a double entry accounting system > > wh

Re: [GNC] Import CSV Multi-currency

Em sáb, 24 de nov de 2018 às 19:47, David Cousens escreveu: > GTI, > > David Carlson's description is actually more correct in accounting terms > and > the way GnuCash actually works. This is a double entry accounting system > which means that all transactions have at least two splits. > > In the

Re: [GNC] Import CSV Multi-currency

GTI, >No. I have in my register a ton of one-line two-currency transactions even >though the register allow them to be displayed on 4 lines pressing the >split button: 1 Description, 2 involved currencies, 1 in white. > >In my humble understanding, splitted transactions are transactions where

Re: [GNC] Import CSV Multi-currency

Let's go to the laborious enlightenment: Em sáb, 24 de nov de 2018 às 06:59, David Carlson < david.carlson@gmail.com> escreveu: > GTI, > > Whenever there is more than one currency in a transaction GnuCash creates > a split to record the exchange between currencies, so there is a separate > sp

Re: [GNC] Import CSV Multi-currency

GTI, Whenever there is more than one currency in a transaction GnuCash creates a split to record the exchange between currencies, so there is a separate split line for each currency. When a multi-currency transaction is imported, there will be two split lines, not one. That is an artifact of dou

Re: [GNC] Import CSV Multi-currency

Em sex, 23 de nov de 2018 às 05:08, Geert Janssens < geert.gnuc...@kobaltwit.be> escreveu: > I think you're right this is currently not possible. > > In the csv importer rewrite only the csv specific parts have been redone. > However once all the info is gathered from the csv file this info is > p

Re: [GNC] Import CSV Multi-currency

Sorry, there was a mistake here I did not copy the list. Here follows this comment for the list. Em sex, 23 de nov de 2018 às 02:19, GTI .H escreveu: > Em sex, 23 de nov de 2018 às 01:14, David Carlson < > david.carlson@gmail.com> escreveu: > >> GTI, >> >> While I am not addressing the issu

Re: [GNC] Import CSV Multi-currency

Op donderdag 22 november 2018 22:28:56 CET schreef GTI .H: > I did several tests on GnuCash 3.3 on W10 and I can not import without > errors(adding extra split) a simple transaction like this: > > Date;Type;Amount;Value;Account;Category;Description;TX;Reconcile > 10/10/2010;Spent;-10;5;Account(cur

Re: [GNC] Import CSV Multi-currency

GTI, Because I did not see the word currency anywhere except the title, I thought you were only discussing multi-line splits. When there are two or more currencies involved, it is impossible to create a single line transaction . Gnucash requires a split line in the base account's currency and a s

Re: [GNC] Import CSV Multi-currency

GTI, While I am not addressing the issue you stated in your first post, I do expect an import to consider existing multi-split transactions that match the amount and timing of a single line imported transaction in the base account. A very common case would be to match an existing payroll transact

Re: [GNC] Import CSV Multi-currency

Thanks for the answers! Em qui, 22 de nov de 2018 às 19:14, David Cousens escreveu: > GTI , > > Don't know how to do it but perhaps the easiest way to find out is to > export > the record of a similar transaction from Gnucash in the default GnuCash > Export Format and then examine the exported

Re: [GNC] Import CSV Multi-currency

I have not used the new CSV importer, so I am not sure whether this comment actually applies to your case... If the new CSV importer is used similarly to the old CSV importer, there is a step in the process to offer an opportunity to match the new transaction to existing transactions if there are

Re: [GNC] Import CSV Multi-currency

GTI , Don't know how to do it but perhaps the easiest way to find out is to export the record of a similar transaction from Gnucash in the default GnuCash Export Format and then examine the exported structure. You can use the default Export Format for importing GnuCash records. David Cousens

[GNC] Import CSV Multi-currency

I did several tests on GnuCash 3.3 on W10 and I can not import without errors(adding extra split) a simple transaction like this: Date;Type;Amount;Value;Account;Category;Description;TX;Reconcile 10/10/2010;Spent;-10;5;Account(currency1);Account(currency2);Test;0.5;n Where: Amount*TX = Value Conf

[GNC] Import Map Editor in 3.3

I wanted to try the import map editor, to help improve imports of QIF files from my retirement accounts (the main reason I went to the trouble to compile 3.3). I have an XML data file of only 933 KB (yes, kilobytes--only been using GnuCash 2 or 3 years). When I click the menu option to open the e

Re: [GNC] Import Transactions via CSV including transfer accounts

I suppose another approach might be to concatenate the description with the category, separated by a space, and just allow the algorithm, to learn. > On Sep 15, 2018, at 8:27 AM, Justin H Haynes wrote: > > One bank I use allows me to customize a set of Categories. The categories > can have hi

Re: [GNC] Import Transactions via CSV including transfer accounts

One bank I use allows me to customize a set of Categories. The categories can have hierarchy denoted with “/“. There is a facility for static mapping of text found in the description and the categories. I would like to create categories at the bank which will match the accounts in GNUCash. I

Re: [GNC] import map editor

> Bayesian matching tokenizes the description on whitespace. Each time you > assign a transaction whose description contains a particular token the count > on the corresponding token-account pair is incremented (and the token-account > pair is created if it doesn’t already exist). There’s no fi

Re: [GNC] Import transactions

Hi ddemott, I use GnuCash Android since v1.0 and it works fine with GnuCash Desktop. I write all my transactions on Android, export to .qif, import .qif in GnuCash Desktop and add exchange rates (I work with multiple currencies.). That's all I need to do. Soon GnuCash Android will export to CSV

Re: [GNC] Import transactions

On Wed, 30 May 2018 14:35:08 GMT "ddem...@juno.com" wrote: > I'm new to GnuCash and trying to learn and use some of its features. > I downloaded version 3.1 and experiencing some very unexpected > behavior. In particular, I'm trying (unsuccessfully) to export > transactions from GnuCash for Andro

Re: [GNC] Import transactions

On 05/30/2018 09:35 AM, ddem...@juno.com wrote: > I'm new to GnuCash and trying to learn and use some of its features. I > downloaded version 3.1 and experiencing some very unexpected behavior. In > particular, I'm trying (unsuccessfully) to export transactions from GnuCash > for Android and imp

Re: [GNC] Import transactions

Op woensdag 30 mei 2018 18:33:17 CEST schreef ddem...@juno.com: > Geert, Thanks for the quick response and steering me to the Android support > channel. As for the export/import, I think my expectations were probably > misguided. I had hoped the csv import would be the equivalent of a qif > import

Re: [GNC] Import transactions

road of understanding. Dale DeMott -- Original Message -- From: Geert Janssens To: gnucash-user@gnucash.org Cc: "ddem...@juno.com" Subject: Re: [GNC] Import transactions Date: Wed, 30 May 2018 17:01:38 +0200 Hi, Gnucash for Android is a separate project with its own s

Re: [GNC] Import transactions

Hi, Gnucash for Android is a separate project with its own support channels. I can't say much of it as I don't use it. The support channel for gnucash for android can be found here: https://github.com/codinguser/gnucash-android/issues >From what I heard I thought you could simply share your dat

[GNC] Import transactions

I'm new to GnuCash and trying to learn and use some of its features. I downloaded version 3.1 and experiencing some very unexpected behavior. In particular, I'm trying (unsuccessfully) to export transactions from GnuCash for Android and import them into GnuCash. Here's what I experience: GnuCash

Re: [GNC] import map editor

> On May 12, 2018, at 9:46 AM, Eric Theise wrote: > > Thank for answering my questions, Geert. > > On Sat, May 12, 2018 at 6:21 AM Geert Janssens > wrote: > >> Do let us know if the import behaves better after you have removed the bad >> map >> entries. >> > > I only import into each accou

Re: [GNC] import map editor

Thank for answering my questions, Geert. On Sat, May 12, 2018 at 6:21 AM Geert Janssens wrote: > Do let us know if the import behaves better after you have removed the bad > map > entries. > I only import into each account on a monthly basis so it'll take some time to really answer this. For th

Re: [GNC] import map editor

Op vrijdag 11 mei 2018 23:10:34 CEST schreef Eric Theise: > I appreciate Stefan raising this issue. I have the opposite issue; not an > empty editor, but an editor full of "Map Account NOT found" and > "Unspecified" lines. Geert Janssens suggested that my import maps have been > corrupted as the mo

Re: [GNC] import map editor

Op maandag 9 april 2018 09:50:37 CEST schreef Stefan Mueller: > Hallo all, > can anyone explain the purpose of the "import map editor" shown in the > tools menu? > All what I can find related to mapping imports is this: > https://wiki.gnucash.org/wiki/Bayes > http://gnucash.1415818.n4.nabble.com/Fi

Re: [GNC] import map editor

I appreciate Stefan raising this issue. I have the opposite issue; not an empty editor, but an editor full of "Map Account NOT found" and "Unspecified" lines. Geert Janssens suggested that my import maps have been corrupted as the most recent comment in my bug filed at https://bugzilla.gnome.org/sh

[GNC] import map editor

Hallo all, can anyone explain the purpose of the "import map editor" shown in the tools menu? All what I can find related to mapping imports is this: https://wiki.gnucash.org/wiki/Bayes http://gnucash.1415818.n4.nabble.com/Fixing-confused-bayesian -matching-data-td4685819.html but there is nothing

<    1   2   3   4