Re: Vendor Bill - Invoice Entries

[DaveC49]

Hi,

The facilities you are requesting are likely to require an inventory
management system. At present Gnucash is an accounting package and currently
does not incorporate any features for inventory management. As far as i know
there are no plans to incorporate such features in the near future. To do so
would reuire a developer(s) interested in developing these features.
Similarly while it can handle the accounting specific side of payroll
management it does not handle the calculation of payrolls, deductions, taxes
etc. You may need to took at ERP software if you require these facilities.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

QIF imports

[David Reiser]

> I am aware that QIF is a text file and I can open it in text editor. 
> 
> I have a 235000 lines QIF file created by quicken. Most of the transactions
> are being imported properly but there are thousands failing as well. I have
> no way to identify those failed transactions other than going line by line
> in each account. What shall I "edit in quicken first" to insure a successful
> import?

The answer to your last question is that no one knows authoritatively, not even 
Quicken or Intuit.

The QIF data definition has a number of inconsistencies that were never 
resolved. Intuit undoubtedly made some internal accommodations on import for 
some common unusual export decisions made by powerful, large financial 
institutions. But since that occurred outside of the data stream, the qif 
definition didn’t have to change. And those “unusual decisions” might not have 
even violated the qif spec.

There is no guarantee that you will be able to see whatever is causing the qif 
exporter to create a transaction that trips up gnucash. What happens if you 
somehow have non-printing characters in your transactions? Quicken may have 
ignored them internally, but included them in the export. 

Dates are possible source of problems. Several date formats were permitted by 
qif, but I don’t think you could change format in a single qif file. If you 
imported data from more than one financial institution and there was more than 
one date format used, there’s no guarantee that quicken didn’t store the data 
as it was received and then exported it that way too. Internally, they’d have 
had to have a way to mark date format within a transaction, but that’s easy if 
they felt it was necessary. Since the qif definition doesn’t have a way to 
declare date format per transaction, you might be in trouble that way.

Transfers between accounts have been problematic, but I’ve rarely had to deal 
with them, so I can’t offer advice on those.

Because you have no way of knowing if your problems result from data 
irregularities that don’t bother Quicken, limitations of the Quicken qif 
exporter, or shortcomings in the gnucash import parser, I think you’re better 
off trying to identify the cause in the qif file and fixing it there.  You’d 
have to find all your failing transactions in Quicken in order  to fix them, 
why not search the qif text? 

Are all your problem transactions of one type? Investments? reinvested 
dividends? transfers between accounts? Anything you’ve noticed in common among 
the failing transactions can help you figure out a few substitutions that fix 
hundreds to thousands of problems.

At least open the qif file, find a known good transaction of a similar type to 
ones that fail, and another transaction that fails the trip to gnucash. Copy 
them to a blank file and see if there is anything obviously wrong. It seems 
unlikely that a single problem will account for all your failed import 
transactions, but if you can get it down to a couple hundred, it would be worth 
a bit of investigating.

--
Dave Reiser
dbrei...@icloud.com





___
gnucash-user mailing list
gnucash-user@gnucash.org
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: command line QIF import

[David Carlson]

I am not a developer, but I can point out that the QIF importer works in
several discrete steps where (roughly) it

1. identifies the 'source' account type and name and tries to associate it
to an existing account in the data file.  If there is more than one
'source' account in the QIF file it repeats for each.

2.  It presents it's results to the user for verification and (if
necessary) correction.

3.  Identifies all of the 'destination' accounts or categories and tries to
match them to existing accounts.

4.  It presents it's results to the user for verification and (if
necessary) correction.

5.  It parses each transaction and compares it to existing transactions
between the particular accounts previously identified.

6. It prepares lists of incoming transactions with suggested matches to
existing transactions where found.  These lists allow user editing to
accept or correct suggested matches.  This is where it is more efficient to
import only one account at a time so the 'duplicates' can be found here.

There are many checks during the import to test the text at each step and
prevent possible crashes and gross errors during matching and acceptance.

As an experienced user I would actually prefer that the developers stay out
of this discussion as they are very busy working 'under the hood' right now
toward getting the release 2.8 series into shape.  That release should get
rid of the deprecated software that is now threatening the continued
inclusion of GnuCash in (and compatibility with) upcoming Linux packages.

David C

On Sun, Oct 15, 2017 at 6:05 PM, Adam Jensen  wrote:

> On 10/15/2017 04:49 PM, Nelson wrote:
> > Thank you for your answer David.
> >
> > I am aware that QIF is a text file and I can open it in text editor.
> >
> > I have a 235000 lines QIF file created by quicken. Most of the
> transactions
> > are being imported properly but there are thousands failing as well. I
> have
> > no way to identify those failed transactions other than going line by
> line
> > in each account. What shall I "edit in quicken first" to insure a
> successful
> > import?
>
> Hi. I am very new to the list [1] and *very* new to GnuCash [2].
>
> Strangely, Nelson, I might get what you are asking far more than the
> other respondents seem to. I hope you can endure this problem, at least
> while it is being explored and discussed; rational, pragmatic people are
> vital to technical projects. ...Sometimes volunteer-based communities
> get a little cult-like in their public interface...
>
> So, I am a mature engineer [3] with some experience in
> instrumentation-sourced data wrangling (as part of large data
> organization and analysis systems); maybe I can try to steer the topic
> of file conversion/import towards the "hackers" on the list - and those
> otherwise interested in engaging such a conversation. To that end, could
> some of the software developers and maintainers chime into a technical
> discussion of the data structure issues involved in building a
> translation utility? It might be fruitful if not at least interesting :)
>
> Anyway, a belated Greetings and Salutations to you all :)
>
>
> [1]: Subscribed for about two days.
> [2]: I've only just started the semi-serious exploration, assessment and
> evaulation of the GnuCash software (and its representation of the
> historical bookkeeping/accounting processes and their
> traditional/societal basis) about three days ago - installation and one
> launch of the application on Ubuntu, one chapter of the Guide read and
> the introductory chapter of a financial Accounting book mused at.
> [3]: LinkedIn, Google::hanzer
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: command line QIF import

[Ken Pyzik]

Nelson -- do you really need (want) 20 years of data?  I recently
transferred from Quicken to GnuCash because of the new goofy subscription
model -- and I have about 11 years of data.  Upon doing the import first
with all the data -- it was too complicated to try and get it right -- since
-- I had not categorized all the data in Quicken to begin with.  After
careful reflection and inspection of the source data in Quicken -- I was
able to determine that I really did not need all the data and cut down to 6
years of data. 

Then, once I imported, I was able to delete a couple more years and was able
to get everything in sync and balanced.  It took a few days -- but I think
you can do it.  Additionally, if you get "good" balances on most of the
accounts, search the 'imbalance" account for those transactions that are not
in balance.  At the end of the process - it does work.   Best of luck. 

-Original Message-
From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org]
On Behalf Of Nelson
Sent: Sunday, October 15, 2017 1:50 PM
To: gnucash-user@gnucash.org
Subject: Re: command line QIF import

Thank you for your answer David.

I am aware that QIF is a text file and I can open it in text editor. 

I have a 235000 lines QIF file created by quicken. Most of the transactions
are being imported properly but there are thousands failing as well. I have
no way to identify those failed transactions other than going line by line
in each account. What shall I "edit in quicken first" to insure a successful
import?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: command line QIF import

[Nelson]

Thank you for your answer David.

I am aware that QIF is a text file and I can open it in text editor. 

I have a 235000 lines QIF file created by quicken. Most of the transactions
are being imported properly but there are thousands failing as well. I have
no way to identify those failed transactions other than going line by line
in each account. What shall I "edit in quicken first" to insure a successful
import?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Re: command line QIF import

[Dave Gillam]

I am temporarily away from my email.  If urgent, please contact Joe Miller at 
210-884-1334 or j...@davegillam.com.

Thank You,

David


On Oct 15, 2017, at 3:20 PM, D via gnucash-user  
wrote:

> Nelson,
> 
> I don't see how a command line interface would help.
> 
> Since QIF is a text file format, you could always just go through the source 
> file with a text editor first to get your data in a ship shape state and 
> *then* do the import. Or, use quicken to edit the transactions first.
> 
> David
> 
> On October 15, 2017, at 10:03 PM, David Carlson  
> wrote:
> 
> Not sure about more efficient ways to import via QIF, which, by the way, is
> reasonably efficient when done in small chunks,  but another caveat that
> has not been raised recently is that as the data file grows it takes longer
> to do the frequent file saves.
> 
> In Windows each save for my data file takes the file out of service for
> over a minute with a very fast computer.  In Linux it is still 15 or 20
> seconds.  I have about 10 years' data in my main file.
> 
> David C
> 
> On Sun, Oct 15, 2017 at 12:14 PM, Nelson  wrote:
> 
> Hi everyone,
> 
> I am trying to import about 20 years of Quicken transactions into GnuCash
> going trough a Quicken QIF export. As many people reported, this is a very
> painful process and requires endless manual corrections.
> 
> I was wondering if it would be possible to maybe to do the import from
> command line, and maybe to have more control of the process. Doing it from
> gui, there are no options to modify / adjust the process and all warnings /
> progress messages just disappear from the screen. Also, any entity
> remapping
> is not kept from one test to another and it seems that no useful logs are
> being created.
> 
> I am running this on windows and I've noticed 83 .exe files in GnuCash's
> bin
> directory. Is any of these binaries capable to do an QIF import, maybe with
> more options than the gui does and proper logging?
> 
> TIA.
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
> 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
> 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
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: command line QIF import

[D via gnucash-user]

Nelson,

I don't see how a command line interface would help.

Since QIF is a text file format, you could always just go through the source 
file with a text editor first to get your data in a ship shape state and *then* 
do the import. Or, use quicken to edit the transactions first.

David

On October 15, 2017, at 10:03 PM, David Carlson  
wrote:

Not sure about more efficient ways to import via QIF, which, by the way, is
reasonably efficient when done in small chunks,  but another caveat that
has not been raised recently is that as the data file grows it takes longer
to do the frequent file saves.

In Windows each save for my data file takes the file out of service for
over a minute with a very fast computer.  In Linux it is still 15 or 20
seconds.  I have about 10 years' data in my main file.

David C

On Sun, Oct 15, 2017 at 12:14 PM, Nelson  wrote:

> Hi everyone,
>
> I am trying to import about 20 years of Quicken transactions into GnuCash
> going trough a Quicken QIF export. As many people reported, this is a very
> painful process and requires endless manual corrections.
>
> I was wondering if it would be possible to maybe to do the import from
> command line, and maybe to have more control of the process. Doing it from
> gui, there are no options to modify / adjust the process and all warnings /
> progress messages just disappear from the screen. Also, any entity
> remapping
> is not kept from one test to another and it seems that no useful logs are
> being created.
>
> I am running this on windows and I've noticed 83 .exe files in GnuCash's
> bin
> directory. Is any of these binaries capable to do an QIF import, maybe with
> more options than the gui does and proper logging?
>
> TIA.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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
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: command line QIF import

[David Carlson]

Not sure about more efficient ways to import via QIF, which, by the way, is
reasonably efficient when done in small chunks,  but another caveat that
has not been raised recently is that as the data file grows it takes longer
to do the frequent file saves.

In Windows each save for my data file takes the file out of service for
over a minute with a very fast computer.  In Linux it is still 15 or 20
seconds.  I have about 10 years' data in my main file.

David C

On Sun, Oct 15, 2017 at 12:14 PM, Nelson  wrote:

> Hi everyone,
>
> I am trying to import about 20 years of Quicken transactions into GnuCash
> going trough a Quicken QIF export. As many people reported, this is a very
> painful process and requires endless manual corrections.
>
> I was wondering if it would be possible to maybe to do the import from
> command line, and maybe to have more control of the process. Doing it from
> gui, there are no options to modify / adjust the process and all warnings /
> progress messages just disappear from the screen. Also, any entity
> remapping
> is not kept from one test to another and it seems that no useful logs are
> being created.
>
> I am running this on windows and I've noticed 83 .exe files in GnuCash's
> bin
> directory. Is any of these binaries capable to do an QIF import, maybe with
> more options than the gui does and proper logging?
>
> TIA.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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.

command line QIF import

[Nelson]

Hi everyone,

I am trying to import about 20 years of Quicken transactions into GnuCash
going trough a Quicken QIF export. As many people reported, this is a very
painful process and requires endless manual corrections. 

I was wondering if it would be possible to maybe to do the import from
command line, and maybe to have more control of the process. Doing it from
gui, there are no options to modify / adjust the process and all warnings /
progress messages just disappear from the screen. Also, any entity remapping
is not kept from one test to another and it seems that no useful logs are
being created.

I am running this on windows and I've noticed 83 .exe files in GnuCash's bin
directory. Is any of these binaries capable to do an QIF import, maybe with
more options than the gui does and proper logging?

TIA. 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Scheduled transactions

[prl]

No problem.

Peter

On 7/10/2017 20:33, Alain Dormoy wrote:
As a test I have re-entered the amount for one of my scheduled 
transactions. It appeared with comas and the next month transaction 
was created smoothly.

So thank you.

Alain

Le 07/10/2017 à 01:49, prl a écrit :

On 7/10/2017 05:04, Alain Dormoy wrote:


What should I do? Just replace the dots with comas in the formulas?


That's what I'd try to start with.

Peter




---
L'absence de virus dans ce courrier électronique a été vérifiée par le 
logiciel antivirus Avast.

https://www.avast.com/antivirus




___
gnucash-user mailing list
gnucash-user@gnucash.org
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.