Scheduled works

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Scheduled works

MENGUAL Jean-Philippe
Hi,

I created various templates bills, that I wanted to generate each month on 1st. Additionally, to do this, I set scheduled work to do this. I use for this the RecurringInvoices task available in Dolibarr.

But actually, no bill is generated automatically. I have to generate manually each month each bill.

What should I check, where is the problem?

Thanks you very much for your help

Regards



--
signature_jp_2
Logo
                Hypra JEAN-PHILIPPE MENGUAL
DIRECTEUR TECHNIQUE ET QUALITÉ
102, rue des poissonniers, 75018, Paris
Tel : <a href="tel:+33184730661" style="margin-right:10px;">+331 84 73 06 61 Mob : <a href="tel:+33676349337">+336 76 34 93 37
Facebook Hypra Twitter Hypra Linkedin Jean-Philippe


_______________________________________________
Dolibarr-user mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
Reply | Threaded
Open this post in threaded view
|

Re: Scheduled works

Laurent Destailleur (aka Eldy)
Check the note into setup of module Scheduled Job.
You should add a line into cron so dolibarr jobs can be ran. Take a look a log cron.

Le ven. 1 févr. 2019 à 14:12, MENGUAL Jean-Philippe <[hidden email]> a écrit :
Hi,

I created various templates bills, that I wanted to generate each month on 1st. Additionally, to do this, I set scheduled work to do this. I use for this the RecurringInvoices task available in Dolibarr.

But actually, no bill is generated automatically. I have to generate manually each month each bill.

What should I check, where is the problem?

Thanks you very much for your help

Regards



--
Logo
                Hypra JEAN-PHILIPPE MENGUAL
DIRECTEUR TECHNIQUE ET QUALITÉ
102, rue des poissonniers, 75018, Paris
Tel : <a href="tel:+33184730661" style="margin-right:10px" target="_blank">+331 84 73 06 61 Mob : <a href="tel:+33676349337" target="_blank">+336 76 34 93 37
Facebook Hypra Twitter Hypra Linkedin Jean-Philippe

_______________________________________________
Dolibarr-user mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/dolibarr-user


--
------------------------------------------------------------------------------------
Google+: https://plus.google.com/+LaurentDestailleur-Open-Source-Expert/
Facebook: https://www.facebook.com/Destailleur.Laurent
------------------------------------------------------------------------------------
* Dolibarr (Project leader): https://www.dolibarr.org (make a donation for Dolibarr project via Paypal: [hidden email])
* AWStats (Author) : http://awstats.sourceforge.net (make a donation for AWStats project via Paypal: [hidden email])
* AWBot (Author) : http://awbot.sourceforge.net
* CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net



_______________________________________________
Dolibarr-user mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
Reply | Threaded
Open this post in threaded view
|

Re: Scheduled works

MENGUAL Jean-Philippe
Hi,

Ok after some searches about key, I found a beginning of solution. But
now when I run the command I get:
Error: Error You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ORDER BY t.rowid DESC' at line 1

I use mysql 5.5.62.

Thanks for your help

Regards


Logo Hypra JEAN-PHILIPPE MENGUAL
DIRECTEUR TECHNIQUE ET QUALITÉ
102, rue des poissonniers, 75018, Paris
Tel : +331 84 73 06 61 <tel:+33184730661> Mob : +336 76 34 93 37
<tel:+33676349337>
[hidden email] <mailto:[hidden email]>
www.hypra.fr <http://www.hypra.fr/>
Facebook Hypra <https://www.facebook.com/hyprasoftware/> Twitter Hypra
<https://twitter.com/Hypra_> Linkedin Jean-Philippe
<https://fr.linkedin.com/in/jean-philippe-mengual-800133135>



Le 01/02/2019 à 19:32, Laurent Destailleur (aka Eldy) a écrit :

> Check the note into setup of module Scheduled Job.
> You should add a line into cron so dolibarr jobs can be ran. Take a look
> a log cron.
>
> Le ven. 1 févr. 2019 à 14:12, MENGUAL Jean-Philippe
> <[hidden email] <mailto:[hidden email]>> a écrit :
>
>     Hi,
>
>     I created various templates bills, that I wanted to generate each
>     month on 1st. Additionally, to do this, I set scheduled work to do
>     this. I use for this the RecurringInvoices task available in Dolibarr.
>
>     But actually, no bill is generated automatically. I have to generate
>     manually each month each bill.
>
>     What should I check, where is the problem?
>
>     Thanks you very much for your help
>
>     Regards
>
>
>
>     --
>     Logo Hypra JEAN-PHILIPPE MENGUAL
>     DIRECTEUR TECHNIQUE ET QUALITÉ
>     102, rue des poissonniers, 75018, Paris
>     Tel : +331 84 73 06 61 <tel:+33184730661> Mob : +336 76 34 93 37
>     <tel:+33676349337>
>     [hidden email] <mailto:[hidden email]>
>     www.hypra.fr <http://www.hypra.fr/>
>     Facebook Hypra <https://www.facebook.com/hyprasoftware/> Twitter
>     Hypra <https://twitter.com/Hypra_> Linkedin Jean-Philippe
>     <https://fr.linkedin.com/in/jean-philippe-mengual-800133135>
>
>
>     _______________________________________________
>     Dolibarr-user mailing list
>     [hidden email] <mailto:[hidden email]>
>     https://lists.nongnu.org/mailman/listinfo/dolibarr-user
>
>
>
> --
> EMail: [hidden email] <mailto:[hidden email]>
> Web: http://www.destailleur.fr
> ------------------------------------------------------------------------------------
> Google+: https://plus.google.com/+LaurentDestailleur-Open-Source-Expert/
> Facebook: https://www.facebook.com/Destailleur.Laurent
> Twitter: http://www.twitter.com/eldy10
> ------------------------------------------------------------------------------------
> * Dolibarr (Project leader): https://www.dolibarr.org (make a donation
> for Dolibarr project via Paypal: [hidden email]
> <mailto:[hidden email]>)
> * AWStats (Author) : http://awstats.sourceforge.net (make a donation for
> AWStats project via Paypal: [hidden email]
> <mailto:[hidden email]>)
> * AWBot (Author) : http://awbot.sourceforge.net
> * CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
>
>
>
> _______________________________________________
> Dolibarr-user mailing list
> [hidden email]
> https://lists.nongnu.org/mailman/listinfo/dolibarr-user
>

_______________________________________________
Dolibarr-user mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
Reply | Threaded
Open this post in threaded view
|

Re: Scheduled works

MENGUAL Jean-Philippe
In reply to this post by Laurent Destailleur (aka Eldy)
Hi,

Ok after some searches about key, I found a beginning of solution. But
now when I run the command I get:
Error: Error You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ORDER BY t.rowid DESC' at line 1

I use mysql 5.5.62.

Thanks for your help

Regards


Logo Hypra JEAN-PHILIPPE MENGUAL
DIRECTEUR TECHNIQUE ET QUALITÉ
102, rue des poissonniers, 75018, Paris
Tel : +331 84 73 06 61 <tel:+33184730661> Mob : +336 76 34 93 37
<tel:+33676349337>
[hidden email] <mailto:[hidden email]>
www.hypra.fr <http://www.hypra.fr/>
Facebook Hypra <https://www.facebook.com/hyprasoftware/> Twitter Hypra
<https://twitter.com/Hypra_> Linkedin Jean-Philippe
<https://fr.linkedin.com/in/jean-philippe-mengual-800133135>



Le 01/02/2019 à 19:32, Laurent Destailleur (aka Eldy) a écrit :

> Check the note into setup of module Scheduled Job.
> You should add a line into cron so dolibarr jobs can be ran. Take a
> look a log cron.
>
> Le ven. 1 févr. 2019 à 14:12, MENGUAL Jean-Philippe
> <[hidden email] <mailto:[hidden email]>> a écrit :
>
> Hi,
>
> I created various templates bills, that I wanted to generate each
> month on 1st. Additionally, to do this, I set scheduled work to do
> this. I use for this the RecurringInvoices task available in Dolibarr.
>
> But actually, no bill is generated automatically. I have to generate
> manually each month each bill.
>
> What should I check, where is the problem?
>
> Thanks you very much for your help
>
> Regards
>
>
>
> -- Logo Hypra JEAN-PHILIPPE MENGUAL
> DIRECTEUR TECHNIQUE ET QUALITÉ
> 102, rue des poissonniers, 75018, Paris
> Tel : +331 84 73 06 61 <tel:+33184730661> Mob : +336 76 34 93 37
> <tel:+33676349337>
> [hidden email] <mailto:[hidden email]>
> www.hypra.fr <http://www.hypra.fr/>
> Facebook Hypra <https://www.facebook.com/hyprasoftware/> Twitter
> Hypra <https://twitter.com/Hypra_> Linkedin Jean-Philippe
> <https://fr.linkedin.com/in/jean-philippe-mengual-800133135>
>
>
> _______________________________________________
> Dolibarr-user mailing list
> [hidden email] <mailto:[hidden email]>
> https://lists.nongnu.org/mailman/listinfo/dolibarr-user
>
>
>
> -- EMail: [hidden email] <mailto:[hidden email]>
> Web: http://www.destailleur.fr
> ------------------------------------------------------------------------------------
> Google+: https://plus.google.com/+LaurentDestailleur-Open-Source-Expert/
> Facebook: https://www.facebook.com/Destailleur.Laurent
> Twitter: http://www.twitter.com/eldy10
> ------------------------------------------------------------------------------------
> * Dolibarr (Project leader): https://www.dolibarr.org (make a donation
> for Dolibarr project via Paypal: [hidden email]
> <mailto:[hidden email]>)
> * AWStats (Author) : http://awstats.sourceforge.net (make a donation
> for AWStats project via Paypal: [hidden email]
> <mailto:[hidden email]>)
> * AWBot (Author) : http://awbot.sourceforge.net
> * CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
>
>
>
> _______________________________________________
> Dolibarr-user mailing list
> [hidden email]
> https://lists.nongnu.org/mailman/listinfo/dolibarr-user
>

_______________________________________________
Dolibarr-user mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/dolibarr-user