— iIT-Services

Archive
Management

Extract key data from your emails, automatically. Integrates directly with any major email provider, tell Mailparser what data to extract and where to send it: mailparser.io/integrations.

Read More

As a teacher, MikeMcKinley1 regularly marks up his PowerPoint presentations and saves the markup to send to his students at the end of the class. Then before the beginning of the next class with a different group of students, he erases/deletes all of his ink markings in a powerpoint file using the “Delete All Comments and Ink in This Presentation” function.

Unfortunately, the “Delete All Comments and Ink in This Presentation” option is gone in Powerpoint 2016 Version 1805. It seems to be replaced by the “Hide Ink” function. But when the “Hide Ink” function is used, the old ink reappears when trying to write on the slide. Going through each slide and laboriously select the ink and delete it is obnoxious.

Therefore, the following Macro has to do the job:

Sub zapInk()
    Dim osld As Slide
    Dim L As Long
    For Each osld In ActivePresentation.Slides
        For L = osld.Shapes.Count To 1 Step -1
            If osld.Shapes(L).Type = 23 Then osld.Shapes(L).Delete
        Next L
    Next osld
End Sub

Copied from: answers.microsoft.com…

Read More

Zapier is an online automation tool that connects your favorite apps, such as Gmail, Slack, Mailchimp, and more. You can connect two or more apps to automate repetitive tasks without coding or relying on developers to build the integration. It’s easy enough that anyone can build their own app workflows with just a few clicks.

For example, maybe you get a lot of email attachments in your Gmail account and you want to save them to Dropbox. Every time you get an attachment, you could open up the email, click the attachment, and then save it to Dropbox. Or you can have Zapier automate this for you, saving you time and effort: zapier.com.

Read More

This is a step-by-step manual to configure a Limesurvey poll to show X questions from a (random) selection of Y question groups.

The proof of concept can be accessed here: https://survey.toolsforresearch.com/index.php/345678. The compliation was borrowed from Tony Partner:
https://www.limesurvey.org/forum/can-i-do-this-with-limesurvey/107889-randomly-select-question-groups#145950

The full manual can be found here: https://toolsforresearch.com/limesurvey-randomly-show-x-out-of-y-question-groups and an excerpt of it is copied below.

1) The slider to choose the number of groups (variable x)

Create a ‘Multiple numerical input’ question with Qcode ‘gcount’. The maximum should match the number of random groups within randomization group (‘y’).

Add a subquestion ‘1’. The variable ‘x’ will be stored in ‘gcount_1’.

2) Random groups

Create the random groups: ‘randGroups1’ in randomization group.

3) Equation in each random group

Every random group should start with a hidden question of the equation type.

The value of the equation is the sum of the RelevanceStatuses for all the other groups in the same Randomization group.

4) Questions within a random question group

The trick is that every (visible) question within each random group must have a relevance equation that checks if the equation of the current random group is less than gcount_1 (the ‘x’ variable). The relevance equation is entered in the general options of each question.

Read More

A simple, free online tool for visually comparing PDF files: https://draftable.com/compare.

Much like diff-pdf, just online.

Read More

A Butterfly chart is a chart where two entities are compared side by side using scales meeting at the center. Due to its shape, the chart resembles a butterfly and hence the name. These charts are sometimes also known as Funnel or Tornado Charts though I find “butterfly” to be a better description as it allows for a greater variation in shape than a funnel or a tornado does: http://www.databison.com/butterfly-chart-excel-chart-with-dual-converging-scales/.

Read More

eCRM – an Ecommerce CRM and marketing campaign automation tool designed for building personal and profitable relationships with your customers at scale: https://www.drip.com.

A good comparison of drip with Mailchimp can be found, for example, here: https://www.marketingautomationinsider.com/mailchimp-vs-drip/.

Read More