Daily Recent Changes Email #4431

tlfillingim · 2021-09-14T14:20:37Z

tlfillingim
Sep 14, 2021

We've recently begun using Wiki.js as a private wiki in our corporate group. One thing we wanted from a wiki is an automated way to let all users know when pages are changed. I saw this was on the roadmap but not implemented yet. So, we wrote our own. Here's a quick & dirty bash script we run daily to email out 24 hours of changes to all users in our group. It isn't fancy, but will work for us until there is a built-in function for this.

Maybe it'll help someone else. If you see any improvements that could be made, let us all know.

#!/usr/bin/bash
#
# This script queries the db and returns the pages changes within the last 24 hours and sends an email.
# This is useful to let the group know what pages were changed recently.
# Created: *********  9/10/21
# Modified: ******* 9/14/21
# Modified: 
# Modified: 


# setup user and db names and the WHERE clause of the queries
user="postgres"
database="wiki"
file=/opt/wiki/body.html
email="[email protected]"
where="WHERE p.\"updatedAt\"::TIMESTAMP AT TIME ZONE 'UTC' AT TIME ZONE 'America/New_York' BETWEEN NOW() - INTERVAL '24 HOURS' AND NOW() ORDER BY p.\"updatedAt\""

# get the names of the users of changes in the last 24 hours, store in 'names' array
query="SELECT u.name FROM \"pages\" p JOIN \"users\" u ON p.\"authorId\"=u.id $where"
while read line
do
   name+=("$line")
done < <(sudo -u postgres -H -- psql -qAtX -d wiki -c "${query}")

# get paths, store in 'path' array
query="SELECT p.path FROM \"pages\" p $where"
while read line
do
    path+=("$line")
done < <(sudo -u postgres -H -- psql -qAtX -d wiki -c "${query}")

# get titles, store in 'title' array
query="SELECT p.title FROM \"pages\" p $where"
while read line
do
    title+=("$line")
done < <(sudo -u postgres -H -- psql -qAtX -d wiki -c "${query}")

# get time of last update, store in 'updatetime' array
query="SELECT \"updatedAt\"::TIMESTAMP(0) AT TIME ZONE 'UTC' AT TIME ZONE 'America/New_York' FROM \"pages\" p $where"
while read line
do
    updatetime+=("$line")
done < <(sudo -u postgres -H -- psql -qAtX -d wiki -c "${query}")


# delete the last body.html file
if test -f "$file"; then
rm $file
fi

# create a new body.html file by running through the items in the arrays and building an HTML table for the email
count=0
{
echo "<html><br/>"
echo "<head><title></title><br/>"
echo "</head><br/>"
echo "<body><br/>"
echo "<h1>Wiki.js Recent Changes</h1>"

for i in "${name[@]}"
do
	echo "<table style=\"font-family:Helvetica\" border=\"1\">"
	echo "<tr><th align="left">Page Title</th>"
	echo "<td>" ${title[$count]} "</td></tr>"
	echo "<tr><th align="left">Updated By</th>" 
	echo "<td>" $i "</td></tr>"
	echo "<tr><th align="left">Update Time</th>" 
	echo "<td>" ${updatetime[$count]} "</td></tr>"
	echo "<tr><th align="left">Page Path</th>" 
	echo "<td><a href=\"https://<your server address & port>/"${path[$count]}"\">"
	echo  ${path[$count]} "</a></td></tr>"
	echo "</table><br>"
	echo "<br/>"
	let count++
done

echo "</body><br/>"
echo "</html><br/>"
} >>$file

echo $count " Items found."

# if there are items to report on, send the email
if [ ${#name[@]} -ge 1 ]; then 
mail \
-a "From: [email protected]" \
-a "MIME-Version: 1.0" \
-a "Content-Type: text/html" \
-s "Wiki.js Recent Changes" \
$email \
<$file
fi

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Daily Recent Changes Email #4431

{{title}}

Replies: 0 comments

Select a reply

Daily Recent Changes Email #4431

tlfillingim Sep 14, 2021

Replies: 0 comments

tlfillingim
Sep 14, 2021