Timewarp

Discussion in 'Announcements' started by twisted1919, Jan 8, 2018.

Tags:
Thread Status:
Not open for further replies.
  1. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,254
    Likes Received:
    2,382
    Hi guys,

    I am happy to announce that starting with mailwizz 1.5.2 (next release) we added support for sending campaigns in using the timezones specific to each subscriber, so we can now send the campaign at a given time and schedule so that subscribers receive it at their local time.

    For more details about requirements and how this works, see:
    https://kb.mailwizz.com/articles/timewarp/

    Because of implementing this feature, we had to alter the database a bit, in special, we had to add and alter some columns, so please, at upgrade, if you have a larger database, do the upgrade from command line (or let the auto-updater do it for you).

    Screenshot 2018-01-08 14.59.43.png
     
    selcuk akbas, iSimon, Fabyc and 6 others like this.
  2. sendizo

    sendizo Active Member

    Joined:
    Jun 7, 2016
    Messages:
    139
    Likes Received:
    33
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    So beautiful.
     
  3. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,707
    Likes Received:
    677
    S.E:
    2019-11-27 02:17:39
    L.T:
    Regular
    L.C:
    7
    Great stuff!
    Will this work even if temp queue tables are not enabled?
     
  4. gsonline

    gsonline New Member

    Joined:
    Nov 26, 2017
    Messages:
    16
    Likes Received:
    1
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    Will the timewarp also work with lists I manually import? (for example, it can take the IP address from the user once the email is opened for the first time)
     
  5. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,254
    Likes Received:
    2,382
    Yup.

    Yup.
     
    frm.mwz and gsonline like this.
  6. Vpul Shah

    Vpul Shah Active Member Support Staff

    Joined:
    Feb 23, 2015
    Messages:
    752
    Likes Received:
    120
    S.E:
    2019-12-22 13:03:57
    L.T:
    Regular
    L.C:
    1
    Wow :) New features are starting to add
     
    twisted1919 likes this.
  7. Priti

    Priti New Member

    Joined:
    Mar 2, 2017
    Messages:
    22
    Likes Received:
    6
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    Wonderful update.
    @twisted1919 I came across an issue with XML feed campaign, the 'postpone-campaign' feature did not worked when no post was found here is my code.

    [XML_FEED_BEGIN url='feed-url' count='5' days-back='1' no-item-action='postpone-campaign']

    Though it was supposed to not send the campaign when there is no post in contrast the campaign executed with original xml tags template.

    please look into this.

    thanks
     
  8. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,254
    Likes Received:
    2,382
    @Priti - Open a support ticket with the actual xml content you used so i can try it ;)
     
  9. Osjtya

    Osjtya Active Member

    Joined:
    Dec 10, 2015
    Messages:
    272
    Likes Received:
    64
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    3
  10. Priti

    Priti New Member

    Joined:
    Mar 2, 2017
    Messages:
    22
    Likes Received:
    6
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    I suppose i have resolve the issue. I think the problem was in subject line where I had put something like

    [XML_FEED_BEGIN url='XML-FEED-URL' count='1'] [XML_FEED_ITEM_TITLE] [XML_FEED_END]

    without no-item-action='postpone-campaign' and I think that was the issue?

    And I also find the campaign status as 'sending' but sending time date got changed for the next date, is this how it suppose to work?

    is it normal now?

    thanks
     
  11. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,254
    Likes Received:
    2,382
    Yup.
     
  12. AHK

    AHK Active Member

    Joined:
    May 8, 2016
    Messages:
    238
    Likes Received:
    29
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    @twisted1919
    This is really amazing feature.

    so now we can export or segment subscribers based on their location as once @sendizo suggested ?

    Great work !
     
  13. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,707
    Likes Received:
    677
    S.E:
    2019-11-27 02:17:39
    L.T:
    Regular
    L.C:
    7
    You can export geoloc of subs anytime and even combine it with activity, but you might have to go to cli or phpmyadmin, depending on if the feature is available or if you like to avoid slow php queries.
     
  14. Priti

    Priti New Member

    Joined:
    Mar 2, 2017
    Messages:
    22
    Likes Received:
    6
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    Wonderful.

    Does Mailwizz XML/JSON parser also support Google Sheet JSON/XML (as it produce xml feed entry as following rather than item as per WordPress feed).

    <entry>
    <gsx:sl.no.>1</gsx:sl.no.>
    <gsx:title>this is title</gsx:title>
    <gsx:description>this is details</gsx:description>
    <gsx:link>https://google.com</gsx:link>
    <gsx:image>https://google.com</gsx:image>
    <gsx:content>this is content</gsx:content>
    <gsx:pubdate>1/11/2018</gsx:pubdate>
    </entry>

    thanks
     
  15. Priti

    Priti New Member

    Joined:
    Mar 2, 2017
    Messages:
    22
    Likes Received:
    6
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    I assume CampaignXmlFeedParser.php file at this location apps/common/components/utils/ is responsible for this though I tried but its not working could you please guide in this regards.

    parsing google sheet XML/JSON can bring immense possibility also it will help in MW customizing the XML feed metas.

    thanks
     
  16. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,254
    Likes Received:
    2,382
    @Priti - Can you show me an example of such feed?
     
  17. Priti

    Priti New Member

    Joined:
    Mar 2, 2017
    Messages:
    22
    Likes Received:
    6
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    Code:
    <?xml version='1.0' encoding='UTF-8'?>
    <feed xmlns="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:gsx="http://schemas.google.com/spreadsheets/2006/extended">
        <id>https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values</id>
        <updated>2018-01-11T12:43:05.615Z</updated>
        <category scheme="http://schemas.google.com/spreadsheets/2006" term="http://schemas.google.com/spreadsheets/2006#list" />
        <title type="text">Sheet1</title>
        <link rel="alternate" type="application/atom+xml" href="https://docs.google.com/spreadsheets/d/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/pubhtml" />
        <link rel="http://schemas.google.com/g/2005#feed" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values" />
        <link rel="http://schemas.google.com/g/2005#post" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values" />
        <link rel="self" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values" />
        <author>
            <name></name>
            <email></email>
        </author>
        <openSearch:totalResults>1</openSearch:totalResults>
        <openSearch:startIndex>1</openSearch:startIndex>
        <entry>
            <id>https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values/cokwr</id>
            <updated>2018-01-11T12:43:05.615Z</updated>
            <category scheme="http://schemas.google.com/spreadsheets/2006" term="http://schemas.google.com/spreadsheets/2006#list" />
            <title type="text">1</title>
            <content type="text">title: This is title, description: This is description, image: https://google.com, link: https://google.com, pubdate: 1/11/2018</content>
            <link rel="self" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values/cokwr" />
            <gsx:sl.no.>1</gsx:sl.no.>
            <gsx:title>This is title</gsx:title>
            <gsx:description>This is description</gsx:description>
            <gsx:image>https://google.com</gsx:image>
            <gsx:link>https://google.com</gsx:link>
            <gsx:pubdate>1/11/2018</gsx:pubdate>
        </entry>
    </feed>
    go here to check https://goo.gl/32DekZ live feed (minify xml version).
    This is the entire xml code generated from google sheet api xml feed.
     
  18. Priti

    Priti New Member

    Joined:
    Mar 2, 2017
    Messages:
    22
    Likes Received:
    6
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    you can see direct feed here https://goo.gl/32DekZ
    thanks
     
  19. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,254
    Likes Received:
    2,382
    Thank you for the examples, i'll check them in details in the morning and based on them i'll create an implementation ;)
     
  20. Priti

    Priti New Member

    Joined:
    Mar 2, 2017
    Messages:
    22
    Likes Received:
    6
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    many thanks
     
Thread Status:
Not open for further replies.

Share This Page