| T O P I C R E V I E W |
| JordanWebmaster |
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 |
| 20 L A T E S T R E P L I E S (Newest First) |
| JordanWebmaster |
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 |
| xequte |
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 |
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 |
Posted - Aug 08 2019 : 06:31:21
Hi
No, there is not a practical way to do that.
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
| JordanWebmaster |
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 |
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 |
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 |
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 |
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 |
| JordanWebmaster |
Posted - Aug 06 2019 : 08:07:11
Can i change only the frequency of stored automated emails without affecting the MEMO fields?.
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
| xequte |
Posted - Jan 16 2019 : 14:27:56
No, I'm afraid not.
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
| JordanWebmaster |
Posted - Jan 16 2019 : 01:16:54
OK, is there anyway to update the memo fields in bulk?
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
| xequte |
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 |
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 |
Posted - Jan 06 2019 : 13:30:10
Hi Salah
The other option then would be to use the Database Utility:
http://www.xequte.com/download/dbsys426.exe
Open mlk_task.dat and import/export to update the database. You should be able to update the import file in Notepad or Excel fairly quickly.
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
| JordanWebmaster |
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 |
| JordanWebmaster |
Posted - Jan 06 2019 : 02:37:26
this is a good way, thanks.
It will be a helpfull way to add a button instead of this shortcut key?
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
| xequte |
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 |
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 |
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
|
Search
