| Author |
 Topic  |
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Dec 30 2018 : 03:25:09
|
As you see in the attached image, this is an automated message email but as you see images source needs to be fixed before being sent.
The problem here is that I have created many many automated messages to be sent according to subscribtion date for each recepient the fact with which I cannot change many many templates to fix the image source in each one or to do any other modification.
This problem occurred because MLK created the automated message once it has been triggered while it should be LINKED to a message container, so this automated message could be modified any time without worries despite the nomber of automated messages list.
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
xequte
7504 Posts |
Posted - Dec 30 2018 : 13:25:20
|
Hi Salah
They are not linked, because when users change an automated message they would not expect that change to affect all messages waiting to be sent. Their expectation would be that it would only affect future messages.
I think you would be best to delete all the erroneous automated messages and generate them again.
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
 |
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Dec 30 2018 : 13:54:03
|
Thank you, but do you think it will be easy to do such fix?
I can i get i a list of those recipients in order to re send the email again to them?
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
|
xequte
7504 Posts |
Posted - Dec 31 2018 : 13:24:38
|
Hi
To get all the recipient email addresses of a automated messages, select all (Ctrl+A) then copy (Ctrl+C).
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
|
|
|
JordanWebmaster
Jordan
54 Posts |
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Jan 06 2019 : 02:43:27
|
As you see, there is a very larg numbor of tasks and each one has its own scheduled date and time the fact that we couldnt resume all of these tasks to its previously defined date and time.
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
|
xequte
7504 Posts |
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Jan 15 2019 : 08:41:19
|
as you see below, i have {MEMO} feild type which dosnt exported to the text file using this utility, so coudnt import this text file as this emport action will update {MEMO} fields with null values...
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
|
xequte
7504 Posts |
Posted - Jan 15 2019 : 19:32:49
|
Sorry Salah,
I'd forgotten that memo fields are not supported by the DB Utility.
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
|
|
|
JordanWebmaster
Jordan
54 Posts |
|
|
xequte
7504 Posts |
|
|
JordanWebmaster
Jordan
54 Posts |
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Aug 06 2019 : 08:14:57
|
I want to extend the "NextSend" field by 3 or 4 days for all the automated emails... please help me with the best way to such update query.
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
|
xequte
7504 Posts |
Posted - Aug 07 2019 : 03:06:36
|
Hi
Using the Database Utility, you can use SQL to batch update fields as follows:
1. Run Database Utility
2. Click File > Open and browse to mlk_task
3. Click File > New SQL Query
4. Click OK
5. Enter:
UPDATE MLK_TASK SET "NEXTSEND" = '2019-12-20'
6. Click Run SQL
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
|
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Aug 07 2019 : 03:19:25
|
great help.
Can i search the content of MEMO field for a small string ( not the whole field value ) if it exist then replace it with another string and update the field then.?
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
|
xequte
7504 Posts |
Posted - Aug 07 2019 : 22:55:57
|
Yes, you can do something like:
UPDATE MLK_TASK SET "NEXTSEND" = '2019-12-20' WHERE OCCURS('Search Text' IN "Body") > 0
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
|
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Aug 08 2019 : 02:57:56
|
Sorry, ignore "NEXTSEND" ...
this is another Q.
Can I search the content of a MEMO ("Body") field for a small string, if it exists then replace it with another string and update the MEMO field itself then.?
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
|
xequte
7504 Posts |
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Aug 21 2019 : 03:18:33
|
I am trying to run the below SQL Q
but i get error.
please see it and kindly help me update MEMO feilds this way.
UPDATE mlk_task AS tbl1
SET
tbl1.Body = (
SELECT
tbl2.Body
FROM
mlk_task AS tbl2
WHERE
tbl2.Index = 395899
)
WHERE
tbl1.Index = 395912
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
|
xequte
7504 Posts |
Posted - Aug 21 2019 : 15:57:07
|
Hi Salah
You are probably better to ask on an SQL forum, but this code isn't right...
SET
tbl1.Body = ( ... )
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
|
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Aug 25 2019 : 10:16:17
|
I have just make it successfully by the following query.
UPDATE mlk_task
SET mlk_task.Body = mlk_task_source_tbl.SourceBody
from mlk_task, mlk_task_source_tbl
WHERE mlk_task.Subject='انقل موقعك إلينا بنصف السعر' AND mlk_task.Index BETWEEN 600000 AND 650000 ;
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
| |
Topic |
|
Search
automated email should be linked to emailcontainer
