Re: Can I automate any of this?

[Alan Whiteman]

Well, Bob Summers' dilemma would be a good place to start.

On 02/01/2018 09:03 AM, Mark Lawrence wrote:

On 01/02/18 14:44, Alan Whiteman wrote:

Indeed... Can't wait to see what you can help us with!


I can write Python if you have a specific job or jobs that need doing. 
My C is good but very rusty, I've never done C++ and I very much doubt 
that CORAL 66 or Monk are of much use :)


I've plenty of spare time as I don't work due to long term ill health.



On 01/31/2018 02:18 PM, Mark Lawrence wrote:

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 :)






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

[Mark Lawrence]

On 01/02/18 14:44, Alan Whiteman wrote:

Indeed... Can't wait to see what you can help us with!


I can write Python if you have a specific job or jobs that need doing. 
My C is good but very rusty, I've never done C++ and I very much doubt 
that CORAL 66 or Monk are of much use :)


I've plenty of spare time as I don't work due to long term ill health.



On 01/31/2018 02:18 PM, Mark Lawrence wrote:

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.

Re: Can I automate any of this?

[Adrien Monteleone]

That’s too cool. I’m going to make some people’s eyes bug out with this.

And I have a use case for it already. Wish I had found that last week, I could 
use it to help a client today.

Thanks!

Regards,
Adrien

> On Feb 1, 2018, at 8:52 AM, Christopher Lam  wrote:
> 
> Hi Bob:
> 
> Try this for an unusual solution...
> 
> https://lists.gnucash.org/pipermail/gnucash-user/2017-February/069016.html
> 
> C
> 
> On 31/01/18 15:59, 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: Can I automate any of this?

[Christopher Lam]

Hi Bob:

Try this for an unusual solution...

https://lists.gnucash.org/pipermail/gnucash-user/2017-February/069016.html

C

On 31/01/18 15:59, 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: Can I automate any of this?

[Alan Whiteman]

Indeed... Can't wait to see what you can help us with!

On 01/31/2018 02:18 PM, Mark Lawrence wrote:

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 :)




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

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

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