Re: Can I automate any of this?

[Mark Lawrence]

On 31/01/18 16:05, Alan Whiteman wrote:
Probably the best way to automate any complex task is through Linux and 
Bash scripts. I was able to successfully do this (with much help from 
https://stackoverflow.):




A bit tricky if the OP is on Windows.  Of course I'd consider Python and 
make the solution cross platform, not that my signature makes me biased 
in any way :)


--
My fellow Pythonistas, ask not what our language can do for you, ask
what you can do for our language.

Mark Lawrence

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

Starter question

[Barry Mahon]

Hi,

I am an experienced user of Quicken, moving to gnucash because of the 
subscription change in Quicken.


I have perused the various help indexes and looked at various vids about 
starting basics.


I thought I followed the right procedures to get a file started. I did 
the actions>new account, created an account name, a bank chequing 
account, entered an opening balance, name the account.


Now, what I have under accounts is -

What am I doing wrong?


___
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: Finance::Quote for EE Savings Bonds

[farleykj]

USBonds.pm   
Here's the Perl code. It was my first Perl program, so it's likely not going
to win any awards and such, but it works for me for my old EE bonds.



-
Ken Farley
--
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: Finance::Quote for EE Savings Bonds

[Ken Farley]

Yes, I was able to get my code to work again. I don't think EE bonds
have CUSIPs despite what others have told me. This kind of makes the
treasurydirect API a mystery. Unless there are options and other info
that can be fed to the site to get EE info.
My Perl stuff uses the savings bond calculator to calculate the
values, then extracts them from the (hidden) tables that are created.
I'm not able to access the code file right now, but I could send it
later, or post it here if that is okay...

On Wed, Jan 31, 2018 at 2:49 PM, Robin Chattopadhyay
 wrote:
> Ken-
>
> Were you able to get quotes for EE Savings bonds? I can't figure out how to
> determine the CUSIP for these.
>
> (I figured out how to find CUSIPs at treasurydirect.gov but it doesn't seem
> to have savings bond CUSIPs.)
>
> Robin
>
> On Sun, Jan 28, 2018 at 2:46 PM, farleykj  wrote:
>>
>> So, after trying different methods of communicating with the
>> treasurydirect
>> site, I finally bit the bullet and updated my Perl modules (via a cpan
>> "upgrade" command) and the problem has been fixed. Don't know which module
>> was mucked up or how it got that way, but things are working fine, now. I
>> noticed when I checked on the versions of things (using the cpan "r"
>> command) that a lot of modules were pretty old. Perhaps they just "aged
>> out"
>> of usefulness? I don't know.
>> A beneficial side effect of this is that after digging deep into my Perl
>> code to get quotes for E/EE/I bonds, it's a lot cleaner and perhaps a bit
>> easier to read. Well, as easy as Perl gets, I suppose.
>>
>>
>>
>> -
>> Ken Farley
>> --
>> 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.

Finance::Quote for EE Savings Bonds

[Robin Chattopadhyay]

Ken-

Were you able to get quotes for EE Savings bonds? I can't figure out how to
determine the CUSIP for these.

(I figured out how to find CUSIPs at treasurydirect.gov but it doesn't seem
to have savings bond CUSIPs.)

Robin

On Sun, Jan 28, 2018 at 2:46 PM, farleykj  wrote:

> So, after trying different methods of communicating with the treasurydirect
> site, I finally bit the bullet and updated my Perl modules (via a cpan
> "upgrade" command) and the problem has been fixed. Don't know which module
> was mucked up or how it got that way, but things are working fine, now. I
> noticed when I checked on the versions of things (using the cpan "r"
> command) that a lot of modules were pretty old. Perhaps they just "aged
> out"
> of usefulness? I don't know.
> A beneficial side effect of this is that after digging deep into my Perl
> code to get quotes for E/EE/I bonds, it's a lot cleaner and perhaps a bit
> easier to read. Well, as easy as Perl gets, I suppose.
>
>
>
> -
> Ken Farley
> --
> 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: Please remove me from the mailing list

[GWB]

It also appears an "unsubscribe" button would not work with mailman
(or most mail lists), because most of them send in text only, and few
allow html or scripts (for good reason).  So forget about the
MailChimp type of button.  It would also have no effect on nabble,
etc.

Gordon

On Tue, Jan 30, 2018 at 9:55 PM, Adrien Monteleone
 wrote:
> This is just getting silly.
>
> Scott,
>
> We can’t remove you.
>
> Read the footer of this e-mail and follow the instructions.
>
> Regards,
> Adrien
>
>> On Jan 30, 2018, at 9:48 PM, Scott Stevens  wrote:
>>
>> Please remove my me as well.
>>
>> Thank you to the community for all I've learned from this group!
>>
>> On Jan 25, 2018 6:30 PM, "Megagrumpy"  wrote:
>>
>>> Tried to do it myself but going around in circles!
>>>
>>>
>>>
>>>
>>>
>>> --
>>> 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
>> 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.
___
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: Can I automate any of this?

[psmlon...@gmail.com]

A workaround might be in printing the invoices via "Print To File" facility
which should offer PDF as an output.
---
The ORIG & OBITER ICO is now LIVE!
Buy tokens at www.LegalMachinery.com

2018-01-31 16:11 GMT+00:00 Adrien Monteleone :

> I’m not sure about auto-raising invoices and saving to pdf from within
> GnuCash, but certainly, you could do that automated outside of GnuCash.
>
> I would think with a Calc sheet or Base file to handle who gets what
> discounts as well as holding the customer info, you could use a macro or
> script to generate the invoices and export them to PDF. The macro/script
> could then fill-in the pdf filename and location into the Calc sheet/Base
> table that is then used to generate the e-mails with proper attachments.
> The generated invoice data should also be saved to a csv file, you can
> import them from the csv file into GnuCash for your records. You can have
> one csv per batch if you like, no need for one per invoice. (note, there is
> a favored data order format for importing csv invoices - check the list
> archives and wiki)
>
> Just be careful about sending out batches of e-mails. Most ISPs as an
> anti-spam measure have an hourly and daily limit. I suspect sending 80 all
> at once would trigger it for the hourly limit. (of course spammers get
> around this)
>
> You can manually hit ‘send’ in small batches, or use a mailing service or
> software that sends them over a short period of time for you. I suppose if
> you’re scripting all of this anyway, the script could put in a 60 second or
> so pause in between each one.
>
> You could probably reduce this work to a minute or so of clicking.
>
> Regards,
> Adrien
>
> > On Jan 31, 2018, at 1:59 AM, bob_summers  wrote:
> >
> > Hi, I've been using GnuCash for a few years in my business, a language
> > academy, and it does everything I need it to, which is; generate
> invoices,
> > track their payment, and send a few reports every tax quarter.  I send
> > around 80 invoices on the first of the month, generally all for the same
> > amount (some get family discounts).
> >
> > My current workflow is:
> > 1. Raise 80 invoices,
> > 2. Generate easy-invoice reports for each,
> > 3. Save these reports to .pdf
> > 4. Mail out the reports (Thunderbird).
> >
> > All of this is done one by one, takes a few hours, and is prone to
> errors.
> > If anyone has an idea how to automate any of the steps, especially the
> last
> > three, I'd love to hear about it.
> >
> > Cheers!
> >
> >
> >
> > --
> > 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.
___
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: Print button and character set options

[psmlon...@gmail.com]

These character issues often relate to incompatibilities between Unicode,
UTF8 and perhaps also national character sets other than ASCII. The
settings might be found in the OS's Control Panel.
---
The ORIG & OBITER ICO is now LIVE!
Buy tokens at www.LegalMachinery.com

2018-01-31 16:43 GMT+00:00 David Carlson :

> Michael,
>
> Please Reply All so the user list is included.  Other users may be
> enlightened or have information to add.
>
> If you are getting strange characters there is an issue with either your OS
> environment settings or sometimes other settings.  You can get more
> specific answers if you tell us what OS you are running GnuCash under and
> which release of GnuCash you have installed.  If the issue is in a certain
> report or it's settings that info would be helpful too.
>
> David C
>
>
>
> On Wed, Jan 31, 2018 at 9:57 AM, michael lindenmeyer 
> wrote:
>
> > Thanks,  David. I found the print button under reports, but the data I
> > wish to print is in a wrong character set, mostly weird symbols. I am
> sure
> > there is a way to select the ASCII English character set for windows, but
> > cannot find reference to it in the manual and only online comments for it
> > for the MAC.
> >
> > PS: I accidentally submitted my first request from my wife, Janice'
> userid.
> >
> > Thanks for your guidance.
> >
> > Mike
> >
> > 180131.0955
> >
> >
> > On 18/01/31 08:01, David Carlson wrote:
> >
> >> Janice,
> >>
> >> Try selecting Reports > Account and see if that is to your liking.
> There
> >> are several other reports that may better fit your needs.
> >>
> >> David C
> >>
> >> On Tue, Jan 30, 2018 at 6:57 PM, janice lindenmeyer <
> >> jmlq...@sbcglobal.net > wrote:
> >>
> >> I am very new to gnucash and want to print my ledger, but cannot
> >> see a print button in the menu bar. How do I print the ledger?
> >>
> >> --
> >>
> >>
> >
> ___
> 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: Can I automate any of this?

[Adrien Monteleone]

I’m not sure about auto-raising invoices and saving to pdf from within GnuCash, 
but certainly, you could do that automated outside of GnuCash.

I would think with a Calc sheet or Base file to handle who gets what discounts 
as well as holding the customer info, you could use a macro or script to 
generate the invoices and export them to PDF. The macro/script could then 
fill-in the pdf filename and location into the Calc sheet/Base table that is 
then used to generate the e-mails with proper attachments. The generated 
invoice data should also be saved to a csv file, you can import them from the 
csv file into GnuCash for your records. You can have one csv per batch if you 
like, no need for one per invoice. (note, there is a favored data order format 
for importing csv invoices - check the list archives and wiki)

Just be careful about sending out batches of e-mails. Most ISPs as an anti-spam 
measure have an hourly and daily limit. I suspect sending 80 all at once would 
trigger it for the hourly limit. (of course spammers get around this)

You can manually hit ‘send’ in small batches, or use a mailing service or 
software that sends them over a short period of time for you. I suppose if 
you’re scripting all of this anyway, the script could put in a 60 second or so 
pause in between each one.

You could probably reduce this work to a minute or so of clicking.

Regards,
Adrien

> On Jan 31, 2018, at 1:59 AM, bob_summers  wrote:
> 
> Hi, I've been using GnuCash for a few years in my business, a language
> academy, and it does everything I need it to, which is; generate invoices,
> track their payment, and send a few reports every tax quarter.  I send
> around 80 invoices on the first of the month, generally all for the same
> amount (some get family discounts).
> 
> My current workflow is:
> 1. Raise 80 invoices, 
> 2. Generate easy-invoice reports for each,
> 3. Save these reports to .pdf
> 4. Mail out the reports (Thunderbird).
> 
> All of this is done one by one, takes a few hours, and is prone to errors. 
> If anyone has an idea how to automate any of the steps, especially the last
> three, I'd love to hear about it.
> 
> Cheers!
> 
> 
> 
> --
> 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: invoice+bill for same bank transaction for business

[Christopher Lam]

Hi Paul

We have similar in Australia called 'Recipient Created Tax Invoices' see 
https://www.ato.gov.au/Business/GST/Issuing-tax-invoices/


I solve this by NOT using the Gnucash business features at all. The 
agency takes care of all customer payment chasing, refunds, calculating 
taxes etc, and sends a single bank remittance. Therefore the business 
accrual issues are invisible to me. I do cash accounting.


See last section on 
https://wiki.gnucash.org/wiki/Alternate_Australian_GST_setup for my 
solution. Each monthly transaction describes gross income, GST on sales, 
agency portion, GST paid to agency, and remittance to bank. I record the 
values manually in every bank remittance as a multisplit transaction 
involving 5 accounts, and report subtotals quarterly to tax authorities.


HTH


On 31/01/18 03:23, Paul de Vries wrote:

clients that are handled by an agency need both an invoice for the service 
rendered and a bill for the agency's commission. the agency balances the 
invoice and their bill into a single bank transaction.

for dutch tax I must specify revenue, tax due, tax payed separately, so I 
cannot handle this by something like a credit note.
  
if I replace the bank transaction by 2 transactons for invoice and bill it would be solved. but I import bank transactions and repeat this the next period to make sure that after mistakes in editing no bank transactions are lost, so this is not a good solution for me.



it could be done this way:

example: invoice=100 bill=10
- bank  90+ as imported
- bank  90- new entry that balances the imported bank transaction to nil
- bank 100+ for invoice
- bank  10- for bill

is there a 'right way' or better solution for this situation?

thanks
-paul.





___
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: Reconcile problem

[Colin Law]

On 30 January 2018 at 22:22, oldpopsie  wrote:

> I used to be able to changetheending balance when I set up a reconcile for
> a
> month. All ofa sudden, i have a new version/build of Gnucash and it won'
> t let me change the ending balance i am trying to reconcile to. Instead, it
> insists on entering the exact register balance for the reconcile date. This
> produces an unreconciled amount when I have accounted for everything that
> has cleared the bank, as it does not allow for outstanding items (uncleared
> checks). Is this a setting problem? If so, what do I change? If not, how do
> I get an accurate reconcile?
>

Which version of gnucash are you using, on what operating system, and how
did you install or build it?

When you say it won't let you change it, what happens if you type into the
appropriate field on the reconcile dialog?

Colin


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

Where is print button?

[janice lindenmeyer]

I am very new to gnucash and want to print my ledger, but cannot see a 
print button in the menu bar. How do I print the ledger?


--
hp/mel --
___
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.

Can I automate any of this?

[bob_summers]

Hi, I've been using GnuCash for a few years in my business, a language
academy, and it does everything I need it to, which is; generate invoices,
track their payment, and send a few reports every tax quarter.  I send
around 80 invoices on the first of the month, generally all for the same
amount (some get family discounts).

My current workflow is:
1. Raise 80 invoices, 
2. Generate easy-invoice reports for each,
3. Save these reports to .pdf
4. Mail out the reports (Thunderbird).

All of this is done one by one, takes a few hours, and is prone to errors. 
If anyone has an idea how to automate any of the steps, especially the last
three, I'd love to hear about it.

Cheers!



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

Exporting customer and vendor data

[Rick Copple]

I checked out the pycash python script for get_customers_from_xml.py as 
a way of exporting in csv format from the XML file. I believe I've 
figured out how to make this work.


It involves going to  to download 
that script. Then, make a copy of your gnucash file. Then rename the 
.gnucash extension to .zip. This is also a good time to rename the whole 
file to something different if you have spaces in your filename.


Then extract the file from it, which will be the XML file. (I couldn't 
get it to go inside to access the file, though there may be a way for it 
to do it.) I also added the .xml onto the file as an extension, though I 
don't know if that is necessary or not.


Then I was able to run the script for extracting customers by going into 
terminal to the location of your xml file and typing in:  python 
 
 c > . So in my case, I had 
"python ~/home/rick/MyScripts/get_customers_from_xml.py CCS.xml c > 
CCSCust.csv"


That exported into the output file a list of customers from the XML file 
which can be imported into your GNUCash file using the "File," "Import," 
"Customers and Vendors". Select the file at the top, select "Customers" 
as your import type, and select "Commas with quotes" as the input format.


The only thing is it exports all your customers, active and inactive, 
and imports them all as active.


As it says on the site, the export of vendors doesn't work yet. I 
figured out why and fixed it by adding two lines of code to it. I'll 
explain further on that point if there is interest in doing so. But I 
was able to export from the old xml file and import both customers and 
vendors into a new file using this procedure.


Hope this is of help to someone.

--
Rick Copple

___
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: Subaccounts [WAS Re: Future allocated money vs Budgets]

[David T. via gnucash-user]

Matt, 
I have to admit that I misread the tally; I did not see that the first $500 
(AllocatedCash) was balancing the others. My apologies. 
I'll let you and Adrien work this out, since I don't have a lot of background 
in this. 
David

 
 
  On Wed, Jan 31, 2018 at 8:58, Matt Graham wrote: 
  #yiv0595440679 #yiv0595440679 -- _filtered #yiv0595440679 {panose-1:2 4 5 3 5 
4 6 3 2 4;} _filtered #yiv0595440679 {font-family:Calibri;panose-1:2 15 5 2 2 2 
4 3 2 4;}#yiv0595440679 #yiv0595440679 p.yiv0595440679MsoNormal, #yiv0595440679 
li.yiv0595440679MsoNormal, #yiv0595440679 div.yiv0595440679MsoNormal 
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}#yiv0595440679 a:link, 
#yiv0595440679 span.yiv0595440679MsoHyperlink 
{color:blue;text-decoration:underline;}#yiv0595440679 a:visited, #yiv0595440679 
span.yiv0595440679MsoHyperlinkFollowed 
{color:#954F72;text-decoration:underline;}#yiv0595440679 
.yiv0595440679MsoChpDefault {} _filtered #yiv0595440679 {margin:72.0pt 72.0pt 
72.0pt 72.0pt;}#yiv0595440679 div.yiv0595440679WordSection1 {}#yiv0595440679 
Hi Dave! 

  
 
Yep, that is pretty much the conclusion I’ve come to. Not sure what you are 
asking about in “where are you balancing the funds”. The Cr and Dr are balanced 
in the example. Maybe you are asking the location in the hierarchy for the 
accounts? It all goes up to the root account “Assets”. For this idea, I had 
Current Assets, Fixed assets, and Allocated Assets. All the little allocation 
accounts were stored in the Allocated Assets branch.

They were balanced by a single account under current assets called 
“AllocatedCash” (as per the example below). This is the weird one – a negative 
asset account that reflects how much I SHOULDN’T spend out of current assets 
unless I am spending on my allocated causes.

  
 
As per Adrian’s discussions, if you are spending out of the account that you 
have put your sub-account into, then there are less splits and it is far easier 
to understand. Using Adrien’s idea, at WORST you have a couple of transactions 
that are just as complex as every transaction the other way – but this is only 
in the rare event that you spend out of a different account from that which 
your sub-account is in.

  
 
I still haven’t fully wrapped my head around Adrien’s most recent email, so 
that could create some more “Aha!” moments too.

  
 
Thanks and regards,

Matt

  
 
From: David T.
Sent: Wednesday, 31 January 2018 2:31 PM
To: matt_graham2...@hotmail.com;Adrien Monteleone; gnucash-user@gnucash.org
Subject: RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

  
 
Matt, 
 
  
 
I see one huge problem: where are you balancing the funds for the allocated 
accounts? They need balancing, and once you add something to balance them, you 
might as well male them Subaccounts of checking anyway. 
 
  
 
Cheers,
 
David 
 
  
 

On Wed, Jan 31, 2018 at 4:06, Matt Graham
 
 
 
  
 
[Snip]
 

If, rather than a sub-account, I use a separate asset account then there is no 
balancing Cr to an asset to increase the allocation. In your example, you had a 
balancing Cr on the parent when you allocated the money. So, we receive a $1000 
pay check, and want to allocate $500 to the four accounts:
Cr Income: Salary $1000
Dr Asset:Current:Checking $1000
Cr Asset:Current:AllocatedCash $500
Dr. Assets:Allocated:Vacation    $250
Dr. Assets:Allocated:Insurance  $150
Dr. Assets:Allocated:Dining      $ 50
Dr. Assets:Allocated:Coffee  $ 50
 
  
   
___
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.