Running Reports over a Windows 10 Network

[Alan Culpitt via gnucash-user]

I am using GNUCash 2.6.19 on 2x Windows 10 PCs networked together to access
our joint financial information stored on my wife's computer.  We have a
number of saved reports.   If I try to run one of the saved reports it
takes a very long time to run, 10-15 minutes, the first time but then
subsequently if I run another report, it works fine. Any suggestions?

Thanks

Alan Culpitt
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Files don't export as html

[Adrien Monteleone]

CMD/CTRL+A is standard across most operating systems for ’select all’. There 
are many other common keyboard shortcuts. Do a web search for ‘keyboard 
shortcuts for Mac’ and there are several resources with lists and cheat sheets.

Regards,
Adrien

> On Mar 30, 2018, at 7:02 PM, Peter Kiessling  wrote:
> 
> 
> Thanks Ken, 
> Sounds Good. Is there some sort of manual for these tricks?
> Pete
> 
> On Mar 30, 2018, at 4:54 PM, Kenneth Schneider  
> wrote:
> 
> 
> 
> Ken Schneider 
> 
>> On Mar 30, 2018, at 6:54 PM, Peter Kiessling  wrote:
>> 
>> 
>> 
>> Mar 30
>> Great idea Geert.
>> Bottom line - it works. I had not considered it before because I didn’t know 
>> how to select the whole report other than using cursor pull down 
>> highlighting all. Turns out I can click upper left then shift-click lower 
>> right and all gets highlighted.
> 
> 
> You might also try ctrl-a to highlight all after you click in the upper left.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Files don't export as html- text edit instead.

[Adrien Monteleone]

It’s not a Mac problem. It works fine for me on High Sierra, at least. The 
solution is simple enough though should it not work, just manually add the 
.html. (the file itself IS HTML, so this will simply tell the OS to use the 
default app, in this case a browser, to open the file instead of Text Edit) 
Numbers won’t read an HTML file, but LO Calc can import it via ‘Insert Sheet 
From File’ and opening in a browser for display and then copy/paste produces 
the same result. (Numbers can take the copy/paste) But if you’re going to 
copy/paste anyway, you can just skip the export entirely and copy the report 
directly.

Regards,
Adrien

> On Mar 30, 2018, at 6:29 PM, DaveC49  wrote:
> 
> Peter,
> 
> For your info. No problem with report export ( balance sheet) as html in
> Gnucash 2.6.19 running on Linux Mint 18.3, so it may be a specific Mac bug.
> It may also be a change in the html import for the spreadsheet you are
> using, if that has been recently updated. 
> 
> On Linux the .html extension is added to the file name by default and it
> opens directly in my browser. I can also import the report.html file
> directly into LibreOffice (v 6.0.2.1) and it is imported with an appropriate
> set of columns. By default they have the spreadsheet default widths, so the
> report does look compacted but this is easily fixed by dragging the column
> boundaries.
> 
> I know it doesn't help too much knowing it is working on other platforms but
> it may help the developers isolate the problem.
> 
> David Cousens
> 
> 
> 
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Files don't export as html

[Peter Kiessling]

Thanks Ken, 
 Sounds Good. Is there some sort of manual for these tricks?
Pete

On Mar 30, 2018, at 4:54 PM, Kenneth Schneider  wrote:



Ken Schneider 

> On Mar 30, 2018, at 6:54 PM, Peter Kiessling  wrote:
> 
> 
> 
> Mar 30
> Great idea Geert.
> Bottom line - it works. I had not considered it before because I didn’t know 
> how to select the whole report other than using cursor pull down highlighting 
> all. Turns out I can click upper left then shift-click lower right and all 
> gets highlighted.


You might also try ctrl-a to highlight all after you click in the upper left.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Files don't export as html

[Kenneth Schneider]

Ken Schneider 

> On Mar 30, 2018, at 6:54 PM, Peter Kiessling  wrote:
> 
> 
> 
> Mar 30
> Great idea Geert.
> Bottom line - it works. I had not considered it before because I didn’t know 
> how to select the whole report other than using cursor pull down highlighting 
> all. Turns out I can click upper left then shift-click lower right and all 
> gets highlighted.


You might also try ctrl-a to highlight all after you click in the upper left.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Files don't export as html- text edit instead.

[DaveC49]

Peter,

For your info. No problem with report export ( balance sheet) as html in
Gnucash 2.6.19 running on Linux Mint 18.3, so it may be a specific Mac bug.
It may also be a change in the html import for the spreadsheet you are
using, if that has been recently updated. 

On Linux the .html extension is added to the file name by default and it
opens directly in my browser. I can also import the report.html file
directly into LibreOffice (v 6.0.2.1) and it is imported with an appropriate
set of columns. By default they have the spreadsheet default widths, so the
report does look compacted but this is easily fixed by dragging the column
boundaries.

I know it doesn't help too much knowing it is working on other platforms but
it may help the developers isolate the problem.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Files don't export as html

[Peter Kiessling]

Mar 30
Great idea Geert.
Bottom line - it works. I had not considered it before because I didn’t know 
how to select the whole report other than using cursor pull down highlighting 
all. Turns out I can click upper left then shift-click lower right and all gets 
highlighted. Pastes correctly except last 2 lines (totals) which are shifted to 
the left cells instead of bottom right. Not a problem for me though.  I don’t 
use them much.
For fun I used the mac numbers spreadsheet also which in latest version seems 
to require me to tell it that the separators are tabs with this table.
Pete

On Mar 30, 2018, at 9:00 AM, gnucash-user-requ...@gnucash.org wrote:
Op vrijdag 30 maart 2018 07:08:39 CEST schreef Peter Kiessling:

Update;
> I continued using my work around. Then tonight, suddenly again, the .html
> extension began to reappear. I did snoop around a bit and surmise that the
> only thing lacking in the report file was the extension label, which is
> necessary for the browser to see it. Text edit showed a file that seemed to
> have html code even though it was not labelled html or anything. Anyhow now
> working.

Have you tried copying straight from the gnucash report window instead of 
exporting to the browser and then copying ? It should give you the same result 
while saving you an intermediate step.

Geert




--

Subject: Digest Footer

___

gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

--

End of gnucash-user Digest, Vol 180, Issue 67
*

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: files don't export as html. UPDATE.

[Geert Janssens]

Op vrijdag 30 maart 2018 07:08:39 CEST schreef Peter Kiessling:
> Update;
> I continued using my work around. Then tonight, suddenly again, the .html
> extension began to reappear. I did snoop around a bit and surmise that the
> only thing lacking in the report file was the extension label, which is
> necessary for the browser to see it. Text edit showed a file that seemed to
> have html code even though it was not labelled html or anything. Anyhow now
> working.

Have you tried copying straight from the gnucash report window instead of 
exporting to the browser and then copying ? It should give you the same result 
while saving you an intermediate step.

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.