Stephen Hoffer

Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • in reply to: Errors: SQL and on Scheduler #1378482
    Stephen Hoffer
    Participant

    THE # 2 Error:
    Any new Import using other URL to import on schedule. for example, using
    http://www.rinkfinder.net/burnsvilleicecenter/events
    and hitting preview will result in this error.
    This happens for any of our other URLs.

    The # 1 Error:
    The error appears to be generated when I go to Imports-> Scheduled Imports–>Edit[ under the scheduled:https://rinkfinder.net/burnsvilleicecenter/events%5D –> Preview

    Stephen Hoffer
    Participant

    Thanks Andras,

    We have many changes, or adds and deletes, on subsites on our multi-site, to events. This means we have to delete all events that have been aggregated, and reimport/aggegate events at least daily.

    This is driven by the various habits of each user on the multisite.

    We need to ensure that the job runs at the most opportune time on a strict schedule. This schedule may have to be modified as the usage grows.

    We cannot rely on a user coming in to trigger the wp-cron or Modern_tribe cron. This is why we are exploring using a OS cron job to trigger actions.

    We are struggling with standardizing this schedule and having successful import.

    We do have a daily schedule and change the time it does not seem to run. Is there some delay before a scheduled import runs?

    We can close the delete issue. Would you like to transfer this reply to a new thread and consider the “delete” issue closed?

    Stephen Hoffer
    Participant

    Yes, that is funny. I Mistyped…I meant to say “is there a function to run an import, for example, we set up an on demand import, then use a cron job to trigger it.”

    We found the way to correctly set code to delete all events.

    But we are
    Now struggling with scheduling very specific times when we want to run the imports.

    Any hints to code would be helpful.

    Stephen Hoffer
    Participant

    OK…we have to run the script including the tribe_get_events() to delete all events and it works. For some reason running it once does not clear all in one run.)

    Is there a tribe function that we can use to run a scheduled import on demand?

    Stephen Hoffer
    Participant

    Thanks Andras,

    We did have a date listed and date range Three Months.

    We are doing tests, but think there have been conflicts around the source URL having events in the Trash or tribe-ignored.

    We are using the tribe_get_events() in a script to delete everything off of our main site on a multisite.

    This appears to work,but only after we run the script multiple times. If we only run it once, it leaves some of the tribe events as Published. This SEEMS to take care of whatever caused the old dates to be loading.

    This does not make sense, but so far it seems to eliminate old events from being aggregated to the main site.

    From a source URL, we have seen loads that correctly import most, except for some duplication. We have 8 line items and end up with 9 [ 1 duplicate].

    This is where we think the trash or tribe-ignored is the issue. We tried to set the site at wp-config,php to bypass trash, but this appears to not affect the tribe-ignored post-types.

    We are running more tests as we speak. I can post updates later today or tomorrow on what worked or didn’t

    Stephen Hoffer
    Participant

    the url of the source website

    http://www.rinkfinder.net

    the url of the feed that you are trying to import

    https://rinkfinder.net/burnsvilleicecenter/events/

    This is the pull of data from burnsville. Every date is old
    2017-09-20
    7:00 AM
    2017-09-20
    Ice for Sale

    2017-10-14
    6:10 PM
    2017-10-14
    Ice For Sale

    2017-10-14
    7:20 PM
    2017-10-14
    Ice For Sale

    2017-10-14
    8:30 PM
    2017-10-14
    Ice For Sale

    2017-10-15
    10:40 AM
    2017-10-15
    Ice For Sale

    2017-10-16
    6:00 PM
    2017-10-16
    Ice For Sale

    2017-10-17
    7:10 PM
    2017-10-17
    Ice For Sale

    2017-10-18
    7:40 PM
    2017-10-18
    Ice For Sale

    Here are the events that actually exist on the URL source:
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    Burnsville Ice Center — — November 20 7:40 pm November 20 7:40 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    Burnsville Ice Center — — November 19 7:10 pm November 19 7:10 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    Burnsville Ice Center — — November 18 6:00 pm November 18 6:00 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    Burnsville Ice Center — — November 17 10:40 am November 17 10:40 am
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    Burnsville Ice Center — — November 16 8:30 pm November 16 8:30 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    Burnsville Ice Center — — November 15 7:20 pm November 15 7:20 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    Burnsville Ice Center — — November 14 6:10 pm November 14 6:10 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    Burnsville Ice Center — — October 18 7:40 pm October 18 7:40 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    — — October 17 7:10 pm October 17 7:10 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    — — October 16 6:00 pm October 16 6:00 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    — — October 15 10:40 am October 15 10:40 am
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    — — October 14 8:30 pm October 14 8:30 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    — — October 14 7:20 pm October 14 7:20 pm
    Select Ice For Sale
    “Ice For Sale” is locked
    Ice For Sale
    Edit | Quick Edit | Hide & Ignore | View
    — — October 14 6:10 pm October 14 6:10 pm
    Select Ice for Sale
    “Ice for Sale” is locked
    Ice for Sale
    Edit | Quick Edit | Trash | View
    ITF Arena Burnsville Ice Center — — September 20 7:00 am September 20 8:00 am

    Stephen Hoffer
    Participant

    I replied via email with information, but do not see the details in my reply post above.
    Did it actually come through? But it is not showing?

    Stephen Hoffer
    Participant

    See in blue below

    Stephen Hoffer
    Participant

    Quick addition:
    We have tried on demand and scheduled.

    When you do a preview…even the preview shows older than today events.

Viewing 9 posts - 1 through 9 (of 9 total)