Member SinceOctober 25th, 2016
Last SeenJanuary 30th, 2020
thdillinger does not have any add-ons for sale.
Support November 14th, 2018 @ 9:50 am
The version that was available here for download on Sept 11th.View Comment
Support October 29th, 2018 @ 9:38 am
we still have the issue, that the API key can only be used without restriction.
But Google heavily recommends to restrict the API Key.
It would be enough to restrict to https://XXX.sugaropencloud.eu/*, where XXX is the customer name.
But it seems this does not work and the requests come from another referrer.
Can you please advise?
Thank you, Thomas
Support July 27th, 2018 @ 8:47 pm
would Wednesday 1st August at 3pm or 3:30 pm CET be possible?
I need several people form customer site to join the meeting.
Support August 13th, 2017 @ 6:24 pm
we are still more than 3.5 Million records in select * from off_quick2list_schedule.
Does uninstall solve the issue and clean up the table? Otherwise we have to wait around 10 days.
Thank you, Thomas
Support August 11th, 2017 @ 11:22 am
as an example, my report for a target list would be Contacts in Status Active or Pending and living in Germany or Austria.
I can either use this report and say remove and redo.
Or I use this report with "Append" and only new records will be added, furthermore I use a report with criteria Contact Status is NOT Active / Pending and living NOT in Germany / Austria and use this to remove.
Would you recommend the second option to optimize performance and only have the delta added and removed instead the whole list recalculated?
Thank you, ThomasView Comment
Support August 11th, 2017 @ 10:51 am
Is there another way to cleanup off_quick2list_schedule? Uninstall for example?View Comment
We still have more than 4 Mio records, as it goes in 500 batches only.
Support August 10th, 2017 @ 9:49 pm
we have around 90.000 Contacts in the DB, and the reports for the target lists show between 50.000 and less.
Especially for the large reports, do you advise to use Quick2List with one Report and select Remove and Redo, or restructure the report to have 2 of them? Or doesn't it matter?
What is better from a performance perspective? I assume the report should only deliver ID and no more fields.
Thank you, Thomas
Support August 10th, 2017 @ 11:55 am
But the SQL query would be the same, as we have only one report defining the contacts. How would this work then?
The report always defines the target list, but there are from days to day a few records that were created and are then also part of the report. And there are some, that fall out from the criteria.
The list backlog gets smaller and smaller, just to let you know.View Comment
Support August 10th, 2017 @ 11:24 am
I run the query from the Quick2List user interface, where I can view the SQL of a report.
it currently holds 4.736.679 records, I will monitor the cleanup.
If we re-create the Quick2List settings for a Target List with 50.000 contacts, and we don't have one Q2L entry "Remove and Redo", but 2 entries "Remove" and "Append", will it then work with a delta, or clear and recreate the target list?View Comment
Does it matter if remove/append run in a specific order?
Support August 10th, 2017 @ 10:22 am
I can post a select to check table off_Quick2list_Schedule in the Quick2List settings, where I can select reports too.View Comment
I would like to use that to check the number of records in the queue table.
what is the name and columns of the table?
SELECT * FROM off_Quick2list_Schedule is invalid.
Support August 10th, 2017 @ 10:07 am
Would it make life easier if we have per target list two Quick2list scheduler, one with Append and one with Remove?View Comment
We have about 20 Target lists, some of them being 50.000-90.000 records. If all of them are completely dropped and re-created, it might create trouble. What do you think?
Support August 10th, 2017 @ 9:37 am
We calculate with a few hundred updates to the target lists each day. But anyway the lists are filled with up to 90.000 records. So removing and adding needs to be capable to work with these numbers. Or is there a limitation in the number of records?View Comment
Support August 10th, 2017 @ 9:36 am
We are in the Sugar Cloud. We did not change anything for the lists since 7. August, nothing seems to be added or removed.
Which Scheduler should be set to inactive, Admin-Scheduler or the one for each target list?
Please describe the steps to enable cleanup.
The records are always derived from a report. Of course we can initially fill the target list via report directly.View Comment
But we are too confident to have this working on a long term view at the moment. As currently it seems everything is somehow stuck.
Support August 10th, 2017 @ 9:28 am
Feel free for a screensharing, then you can take a look at the instance yourself to troubleshoot if that makes sense.View Comment
It's strange that there seems to be no activity although the schedulers are running. But other target lists stay untouched as well.
Support August 10th, 2017 @ 9:26 am
It's a cloud instance, how can I find out?View Comment
Support August 10th, 2017 @ 9:18 am
we had "once a day at 15:00" before, it stayed for 3 days and nothing happened.
Even if we try to fill the list by the option "Run Query", nothing happened.
Support August 10th, 2017 @ 8:15 am
thanks for coming back to me. We used v3.7.0 downloaded from here.
I added the screenshots as attachment to my post, but you can see here as well:
The scheduler in the target list administration was changed already, first we had it once a day, currently it's once an hour.
The scheduling jobs run regularily.
We can also have a screensharing? Please contact me at firstname.lastname@example.org
Thank you, Thomas
Support August 9th, 2017 @ 6:08 pm
We found some possible hints in the log:View Comment
Wed Aug 9 18:13:43 2017 [9eb8f538-405b-11e7-a3d9-06b245f0b883][FATAL] runQueryMethod: Array
[__sugar_url] => v10/off_Dynamic_Target_List/aeac85e0-7bb6-11e7-873c-021bf164ce0b/runQuery
[module] => off_Dynamic_Target_List
[record] => aeac85e0-7bb6-11e7-873c-021bf164ce0b
Support August 9th, 2017 @ 6:01 pm
Any update so far? We can of course provide login credentials or further information if needed. BR, ThomasView Comment
Support January 26th, 2017 @ 8:33 pm
Hi Jon,View Comment
thank you, I entered a call for Monday 4:00 pm CET.
thdillinger has not rated any add-ons.
thdillinger has not verified any add-ons.
thdillinger has not created any Wanted Add-ons.