Need Help on GNUCash - import from quickbooks...

2017-10-09 Thread Vip via gnucash-user 
 Hi,
First of All - congratulations for making such a great product and helping 
users like me. We appreciate your help and hope that GNUCash becomes a 'The 
Best' accounting software.
Need Help! I understand that there's no direct way to import quick books to 
GNUCash and that's ok.
What I am trying to understand from an expert is what are the alternates to 
import data from quickbooks - I mean, can we export data from QB in excel and 
then what do we have to modify on excel so same excel can be used in GNUCash 
import.
My long story short, I need to upload all the QB data to GNUCash so I can 
forget QB forever. And I understand that there's no direct way and I need your 
help to understand indirect way of import.
I do understnad that I can export in excel and then using some tool, I can 
convert into QIF - and I think this job requires lot of work so it's better 
that I export qb data in excel and import in excel - guncash.
I think this is a bit difficult question so I am trying to ask you in a little 
bit different way.
1. Let's assume that I am using QB for my accounting having more than 10 years 
of data.2. Now how  many excel file do I need to upload the data into GNUCash3. 
What are the formats of all those file - meaning what fields do we need to 
bring in.
My plan is to convert all my data in EXCEL / CSV and then just upload the data 
into GNUCash.
Please help me out.
Thanks,
Vip
___
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: importing

2017-10-09 Thread Aaron Laws 
On Sun, Oct 8, 2017 at 9:27 PM, frank raney  wrote:

> Just finished 6 hours correcting all the data i imported and before I
> could save it, the program crashed. All I have is the unchanged imported
> data fileWhen it crashed, the file was lost but there is a log
> file..what it is I don't know.  Guess I have to start all over?
>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 H
> 559.304.1751 C
>

Oh, that's so painful; know that we feel your pain!

If you use a sql backend (sqlite is certainly the easiest to set up), it
saves everything you do as you do it. This means two things: you won't have
the catastrophe that you described, and you can't back out of changes by
closing without saving. Either way, you'll want to take periodic backup
"snapshots" of your books.
___
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: [MAINT] More network maintenance for Saturday

2017-10-09 Thread Derek Atkins 
Hi,

Just want to report that:

1) The card arrived and I performed the maintenance on Saturday
   evening.  It took much longer than expected to get the Ovirt Host to
   persist the new connection.

2) Alas, once I got the new card installed, the problem did not go
   away.  This implies that it was not the issue, so I need to go back
   and continue searching.  :(

My next step is swap out my router with my older one, just to ensure the
router isn't the issue.

-derek

Derek Atkins  writes:

> Hi,
>
> In my ongoing effort to debug my network issues, I need to add a new
> network card to the VM host that runs code.gnucash.org (among other
> VMs).  This will involve some downtime as I install and configure
> the new card in the machine.
>
> The card is due to arrive sometime tomorrow (Saturday, Oct 7).  I expect
> I wont have time to do perform the surgery until the evening (US/EDT).
> I'll post on IRC when I plan to start.
>
> My hope is that the downtime will be under 30 minutes.
>
> -derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: importing

2017-10-09 Thread frank raney 
I thought it did something like that..I usually do save periodically when 
working for long periods,  But I got so involved, I forgot.How do I 
get/install an sql backend.


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/9/2017 6:43:14 AM, Aaron Laws  wrote:
On Sun, Oct 8, 2017 at 9:27 PM, frank raney mailto:frankraney...@gmail.com]> wrote:

Just finished 6 hours correcting all the data i imported and before I could 
save it, the program crashed. All I have is the unchanged imported data 
fileWhen it crashed, the file was lost but there is a log 
file..what it is I don't know.  Guess I have to start all over?


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 [tel:559.297.8577] H
559.304.1751 [tel:559.304.1751] C


Oh, that's so painful; know that we feel your pain!

If you use a sql backend (sqlite is certainly the easiest to set up), it saves 
everything you do as you do it. This means two things: you won't have the 
catastrophe that you described, and you can't back out of changes by closing 
without saving. Either way, you'll want to take periodic backup "snapshots" of 
your books.

---
This email has been checked for viruses by Avast antivirus software.
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.

Re: importing

2017-10-09 Thread Colin Law 
On 9 October 2017 at 16:13, frank raney  wrote:
> I thought it did something like that..I usually do save periodically when 
> working for long periods,  But I got so involved, I forgot.How do I 
> get/install an sql backend.

I thought the default was to auto-save every 5 minutes or something.
Are you absolutely certain that you have lost everything? Are you sure
you are looking at the correct file?

Colin

>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 H
> 559.304.1751 C
> On 10/9/2017 6:43:14 AM, Aaron Laws  wrote:
> On Sun, Oct 8, 2017 at 9:27 PM, frank raney  [mailto:frankraney...@gmail.com]> wrote:
>
> Just finished 6 hours correcting all the data i imported and before I could 
> save it, the program crashed. All I have is the unchanged imported data 
> fileWhen it crashed, the file was lost but there is a log 
> file..what it is I don't know.  Guess I have to start all over?
>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 [tel:559.297.8577] H
> 559.304.1751 [tel:559.304.1751] C
>
>
> Oh, that's so painful; know that we feel your pain!
>
> If you use a sql backend (sqlite is certainly the easiest to set up), it 
> saves everything you do as you do it. This means two things: you won't have 
> the catastrophe that you described, and you can't back out of changes by 
> closing without saving. Either way, you'll want to take periodic backup 
> "snapshots" of your books.
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> 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.
___
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.

MySQL field question

2017-10-09 Thread Joseph Hesse 

Hi,

In the gnucash mysql transactions table there are 2 date fields,

post_date and enter_date

What is the difference between them? When I enter transactions I only 
enter 1 date and I don't enter any time data.


Thank you,

Joe

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

simple find transactions report

2017-10-09 Thread Elmar 

Good afternoon to the list

I seem to be having a brain fart.  I am trying to retrieve all the 
transactions (all dates) with a certain payee in the description field, 
and only those transactions.  Somehow I cannot make the transaction 
report do this - what am I missing?  It should be easy, which tells me 
I'm at fault.


- Elmar


___
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: simple find transactions report

2017-10-09 Thread Geert Janssens 
Start with a search from the account hierarchy page and then open an account 
report on the search results tab.

Regards,
Geert

Elmar  schreef op 9 oktober 2017 20:35:06 GMT+01:00:
>Good afternoon to the list
>
>I seem to be having a brain fart.  I am trying to retrieve all the 
>transactions (all dates) with a certain payee in the description field,
>
>and only those transactions.  Somehow I cannot make the transaction 
>report do this - what am I missing?  It should be easy, which tells me 
>I'm at fault.
>
>- Elmar
>
>
>___
>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.

Sent from my smartphone. Please excuse my brevity.
___
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: simple find transactions report

2017-10-09 Thread David Carlson 
Geert,

Gmail used those ing triple dots to hide your reply in my mail folder.
Lucky for me I suspected as much when there appeared to be no reply .

David C


On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens 
wrote:

> Start with a search from the account hierarchy page and then open an
> account report on the search results tab.
>
> Regards,
> Geert
>
> Elmar  schreef op 9 oktober 2017 20:35:06 GMT+01:00:
> >Good afternoon to the list
> >
> >I seem to be having a brain fart.  I am trying to retrieve all the
> >transactions (all dates) with a certain payee in the description field,
> >
> >and only those transactions.  Somehow I cannot make the transaction
> >report do this - what am I missing?  It should be easy, which tells me
> >I'm at fault.
> >
> >- Elmar
> >
> >
> >___
> >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.
>
> Sent from my smartphone. Please excuse my brevity.
> ___
> 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: simple find transactions report

2017-10-09 Thread Elmar 
Perfect!  Thanks, although I had to translate this to the menu entry 
"edit/find" (not "search")


- elmar

On 10/09/2017 04:16 PM, David Carlson wrote:

Geert,

Gmail used those ing triple dots to hide your reply in my mail 
folder.  Lucky for me I suspected as much when there appeared to be no 
reply .


David C


On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens 
mailto:geert.gnuc...@kobaltwit.be>> wrote:


Start with a search from the account hierarchy page and then open
an account report on the search results tab.

Regards,
Geert

Elmar mailto:etsc...@gmail.com>> schreef op 9
oktober 2017 20:35:06 GMT+01:00:
>Good afternoon to the list
>
>I seem to be having a brain fart.  I am trying to retrieve all the
>transactions (all dates) with a certain payee in the description
field,
>
>and only those transactions.  Somehow I cannot make the transaction
>report do this - what am I missing?  It should be easy, which
tells me
>I'm at fault.
>
>- Elmar
>
>
>___
>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.

Sent from my smartphone. Please excuse my brevity.
___
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: importing

2017-10-09 Thread Buddha Buck 
It's entirely possible that Frank has a "mybooks.gnucash" file that doesn't
have everything, and a bunch of "mybooks.gnucash..gnucash" files
which have (incrementally) more of everything, as well as the "*.log" files
which go along with them, but beign a new user doesn't realize what those
timestamped autosave files are.


On Mon, Oct 9, 2017 at 11:32 AM Colin Law  wrote:

> On 9 October 2017 at 16:13, frank raney  wrote:
> > I thought it did something like that..I usually do save periodically
> when working for long periods,  But I got so involved, I forgot.How do
> I get/install an sql backend.
>
> I thought the default was to auto-save every 5 minutes or something.
> Are you absolutely certain that you have lost everything? Are you sure
> you are looking at the correct file?
>
> Colin
>
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 <(559)%20297-8577> H
> > 559.304.1751 <(559)%20304-1751> C
> > On 10/9/2017 6:43:14 AM, Aaron Laws  wrote:
> > On Sun, Oct 8, 2017 at 9:27 PM, frank raney  [mailto:frankraney...@gmail.com]> wrote:
> >
> > Just finished 6 hours correcting all the data i imported and before I
> could save it, the program crashed. All I have is the unchanged imported
> data fileWhen it crashed, the file was lost but there is a log
> file..what it is I don't know.  Guess I have to start all over?
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 <(559)%20297-8577> [tel:559.297.8577 <(559)%20297-8577>] H
> > 559.304.1751 <(559)%20304-1751> [tel:559.304.1751 <(559)%20304-1751>] C
> >
> >
> > Oh, that's so painful; know that we feel your pain!
> >
> > If you use a sql backend (sqlite is certainly the easiest to set up), it
> saves everything you do as you do it. This means two things: you won't have
> the catastrophe that you described, and you can't back out of changes by
> closing without saving. Either way, you'll want to take periodic backup
> "snapshots" of your books.
> >
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > 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.
> ___
> 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: importing

2017-10-09 Thread Frankie Raney 
Yes, yes, and yes. It was, is the only filewhen it crashed it went
awayI saved it after importing, and looked at it with file
browserit was therethen I went back, run GC and started
editing..when GC crashed, the file went to lala land. Only the log file
was left.

On Oct 9, 2017 8:26 AM, "Colin Law"  wrote:

> On 9 October 2017 at 16:13, frank raney  wrote:
> > I thought it did something like that..I usually do save periodically
> when working for long periods,  But I got so involved, I forgot.How do
> I get/install an sql backend.
>
> I thought the default was to auto-save every 5 minutes or something.
> Are you absolutely certain that you have lost everything? Are you sure
> you are looking at the correct file?
>
> Colin
>
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 H
> > 559.304.1751 C
> > On 10/9/2017 6:43:14 AM, Aaron Laws  wrote:
> > On Sun, Oct 8, 2017 at 9:27 PM, frank raney  [mailto:frankraney...@gmail.com]> wrote:
> >
> > Just finished 6 hours correcting all the data i imported and before I
> could save it, the program crashed. All I have is the unchanged imported
> data fileWhen it crashed, the file was lost but there is a log
> file..what it is I don't know.  Guess I have to start all over?
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 [tel:559.297.8577] H
> > 559.304.1751 [tel:559.304.1751] C
> >
> >
> > Oh, that's so painful; know that we feel your pain!
> >
> > If you use a sql backend (sqlite is certainly the easiest to set up), it
> saves everything you do as you do it. This means two things: you won't have
> the catastrophe that you described, and you can't back out of changes by
> closing without saving. Either way, you'll want to take periodic backup
> "snapshots" of your books.
> >
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > 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.
>
___
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: MySQL field question

2017-10-09 Thread John Ralls 


> On Oct 9, 2017, at 11:11 AM, Joseph Hesse  wrote:
> 
> Hi,
> 
> In the gnucash mysql transactions table there are 2 date fields,
> 
> post_date and enter_date
> 
> What is the difference between them? When I enter transactions I only enter 1 
> date and I don't enter any time data.

“Posted date” is the date that the transaction happened and “entered date” is 
the date and time that you performed the data entry. For example I posted my 
grocery shopping receipts this morning though I’d done the shopping on Friday: 
The posted date is 6 October and the entered date is today at 10:something.

The time on posted date is almost always 10:59:00UTC as that keeps the date the 
same across almost all timezones; the exceptions are the mid-pacific timezones 
of -11, +13 and +14. If anyone is using GnuCash there it uses 10:59 local time 
so that they don’t see dates change when daylight time goes on or off.

Regards,
John Ralls

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

Does Gnucash supports barcode scanner.

2017-10-09 Thread Suresh Saragadam 
I am looking for an accounting and inventory management software solution
for my online retail store, I want to implement Gnucash if it supports
barcode scanner like in pos,

Please do confirm does Gnucash supports barcode scanner.

Regards

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