Author Topic: Receive free SMS with new database entry  (Read 1071 times)

0 Members and 1 Guest are viewing this topic.

Offline Paul

  • Hero Member
  • *****
  • Posts: 162
Receive free SMS with new database entry
« on: July 25, 2015, 09:18:38 PM »
Last year I started experimenting with csv write and RSS feeds (see previous post on my RSS Hack)

I found it is possible to use a free service such as IFTTT  to connect your RSS feed to a "SMS Chanel".
(https://ifttt.com/recipes/8643-rss-to-sms)

So when your RSS feed is updated, you get an SMS (takes up to 15 minutes for the SMS to come through).

Practical Use Example
Every workday morning you produce an online bulletin for members of your team using csvwrite.
If members of your team make a "RSS to SMS" recipe, they can get notified by SMS when your bulletin it is ready to view.
This would create one SMS per work day ... (not too many SMS's which is good).
The SMS contains a link to your bulletin.

SAMPLE TEMPLATE
My previous code example from 2014 was this

Code: [Select]
<?xml version='1.0' encoding='UTF-8'?>
<rss version='2.0'>
<channel>
<title>Title of your RSS Feed</title>
<description>Description of your RSS feed</description>
<language>en-us</language>

<template>
<item>
<title>[[title_of_RSS_item]]</title>
<link>[[link]]</link>
<description>[[your_RSS_item]]</description>
<pubDate>[[DATE]]</pubDate>
</item>
</template>

</channel>
</rss>

However, IFTTT requires links to be unique. It also requires a unique ID (guid) for each RSS.
You can simply use the the [[ID]] field to achieve that.

So here is the updated sample code to do that.

Code: [Select]
<?xml version='1.0' encoding='UTF-8'?>
<rss version='2.0'>
<channel>
<title>Title of your RSS Feed</title>
<description>Description of your RSS feed</description>
<language>en-us</language>

<template>
<item>
<title>[[title_of_RSS_item]]</title>
<link>[[link]]?v=[[ID]]</link> //added ID to the query string to make it unique
<description>[[your_RSS_item]]</description>
<guid>[[ID]]</guid> //unique ID field
<pubDate>[[DATE]]</pubDate>
</item>
</template>

</channel>
</rss>