[SOLVED] How use Scheduled email task?

[R.IN.G.O Lavoro Over 40]

Settings:


Log:

'fschett@libero.it' is not an email address 'francoschettino@fastwebnet.it' is not an email address 'f.schett@gmail.com' is not an email address 'f.schettino@tiscali.it' is not an email address updates 4 records email listid = 95 SELECT SQL_CALC_FOUND_ROWS `fabrik_nominativi`.`Visualizza_Stato_Simpatizzante_Socio` AS `fabrik_nominativi___Visualizza_Stato_Simpatizzante_Socio`, `fabrik_nominativi`.`Visualizza_Stato_Simpatizzante_Socio` AS `fabrik_nominativi___Visualizza_Stato_Simpatizzante_Socio_raw`, `fabrik_nominativi`.`Stato_Simpatizzante_Socio` AS `fabrik_nominativi___Stato_Simpatizzante_Socio_raw`, `fabrik_stati_utenti_registrati`.`Avviso_visualizzato` AS `fabrik_nominativi___Stato_Simpatizzante_Socio`, `fabrik_nominativi`.`Modalita_operativa__1_Iscrizione__2_Modif_dati` AS `fabrik_nominativi___Modalita_operativa__1_Iscrizione__2_Modif_dati........​

.............​

"not an email address"???

If I use condition

return {fabrik_nominativi___Stato_Simpatizzante_Socio_row} == '2';​

or

return {fabrik_nominativi___Stato_Simpatizzante_Socio} == '2';​

or

return '{fabrik_nominativi___Stato_Simpatizzante_Socio}' == '2';​

the log is

updates 0 records email listid = 95 SELECT SQL_CALC_FOUND_ROWS `fabrik_nominativi`.`Visualizza_Stato_Simpatizzante_Socio` AS `fabrik_nominativi___Visualizza_Stato_Simpatizzante_Socio`, `fabrik_nominativi`.`Visualizza_Stato_Simpatizzante_Socio` AS `fabrik_nominativi___Visualizza_Stato_Simpatizzante_Socio_raw`, `fabrik_nominativi`.`Stato_Simpatizzante_Socio` AS `fabrik_nominativi___Stato_Simpatizzante_Socio_raw`, ........​

.............​

I don't have 'Require filtering' into list settings to 'Yes' and


I don't understand my errors.

 

[troester]

no email: use placeholder without ' here

condition:
try
return '{fabrik_nominativi___Stato_Simpatizzante_Socio_raw}' == '2';
(not _row)

 

[R.IN.G.O Lavoro Over 40]

I made changes you wrote (I am sorry for _row instead of _raw ).

Now the log by email is

updates 3 records email listid = 95 SELECT SQL_CALC_FOUND_ROWS `fabrik_nominativi`.`Visualizza_Stato_Simpatizzante_Socio` AS `fabrik_nominativi___Visualizza_Stato_Simpatizzante_Socio`, `fabrik_nominativi`.`Visualizza_Stato_Simpatizzante_Socio` AS `fabrik_nominativi___Visualizza_Stato_Simpatizzante_Socio_raw`, `fabrik_nominativi`.`Stato_Simpatizzante_Socio` AS ...

Ok, 3 email is right, but no email is sent.

 

[cheesegrits]

Did you remove the quotes from around the placeholder in the address field?

-- hugh

 

[R.IN.G.O Lavoro Over 40]

Hi Hugh.

Yes, I removed it.
As you see, in log email there isn't "is not an email address" but "updates 3 records email listid".

Franco

 

[cheesegrits]

Yup, that's just the generic count of items the plugin processed. And the fact that it didn't log any errors on sending indicates it thinks it sent the 3 mails. It passed them off to J! mail API helper, and got a success response.

I've added a line of logging in the plugin, just to confirm this:

https://github.com/Fabrik/fabrik/commit/da137337f7b7b7050e1d55ff60ef02f432a57eaf

So update, run it again, and see what addresses it thinks it is sending to.

-- hugh

 

[R.IN.G.O Lavoro Over 40]

I am very very sorry, hugh : I discovered that after changes suggested by troester, email where sent but were considered Spam .

It is hard to say. Please consider my honesty.

Please, say again

You are forgiven.

​

-- hugh

Franco