|
| |
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.
Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
|
|
| Author |
 Topic  |
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Aug 27 2019 : 02:44:39
|
I have found that the same email address has more than one automated task with the same message subject.
I went to mlk_task to see and do whatever possible to remove duplications, but cannt do anything with my huge volume, as i have about 300k recordes and over 4GB file size [mlk_task].
see this query it seems to work but stuck after running the first select query.
I know it is better to ask SQL admin rather, but i want to ask if there is any possible smart way to remove Duplicated entries, or prevent mlk from passing such entries.
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
xequte
7504 Posts |
Posted - Aug 27 2019 : 16:19:51
|
Hi Salah
MLK prevents duplication of messages that it generates itself, through rules, not limitations on the MLK_TASK table. E.g. recognizing that a reminder has been sent to the user, so another does not need to be sent until next year.
It does not block you from sending the same message to a user twice, because:
- There are plenty of situations where a duplicate message is sent on a regular schedule (status messages, for instance). And if you don't want duplication there are many options in MLK to prevent it (e.g. the option to skip sending to anyone who has been emailed in the last x days)
- True duplication prevention would mean checking the entire message content. Blob fields cannot be indexed so it would be a slow process
So, there is certainly no locks on the table itself (Unique index locks) to prevent duplication, when you fill it outside of MLK.
My SQL skills are not great, but I do not see how second query would work.
Can you do something like:
DELETE
FROM MLK_TASK
WHERE Index NOT IN
(
SELECT MAX(Index)
FROM MLK_TASK
GROUP BY Email,TaskName,Subject)
Of course, make sure you test this on only a copy.
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
 |
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Aug 28 2019 : 05:20:37
|
Please add an option ro prevent duplication according to the subject text, it will be very helpfull for such case.
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
|
JordanWebmaster
Jordan
54 Posts |
Posted - Aug 28 2019 : 05:27:11
|
sometimes i need to change an automated message body which is already scheduled for many tasks. but there is no way to do such thing.
Please ad a way to change the message "Blob field" depending on Subject field, as it is rationally that same subjects have the same body.
Salah
Jordan Webmaster Co.Ltd.
www.webmaster.com.jo
info@webmaster.com.jo |
|
|
|
xequte
7504 Posts |
Posted - Aug 28 2019 : 16:04:49
|
Hi Salah
I think in many cases messages with the same same subject would NOT have the same body. On my system I always personalize the messages (e.g. insert the recipient's name).
Are you suggesting that if we match Email + Subject we should skip the new message? We could add that as an option.
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
|
|
|
JordanWebmaster
Jordan
54 Posts |
|
|
xequte
7504 Posts |
|
| |
Topic |
|
|
|
| |
Search
Duplicated entries by mistake in mlk_task
