Subscribe Bookmark
Richard_Zink

Staff

Joined:

May 27, 2014

Using JMP to respond to workshop submissions en masse

Greetings, everyone. Sorry for the extra-long blogging hiatus. I have recently been wandering the desert in a self-imposed social media exile (well, mostly) due to some other writing responsibilities. If you’ve been upset over the lack of posts on JMP Clinical or statistics, let me just say that my absence isn’t because of you… it’s all me.

As you all know, JMP has many wonderful features for visualizing your data. However, today I am going to talk about a recent application of JMP Scripting Language (JSL) that helped me write and send emails en masse using the JSL Mail function.

To give a bit of background, I am part of a conference steering committee. Part of our responsibilities involve responding to participants as to whether or not their proposal was accepted for the upcoming workshop. Naturally, this could involve some tedious effort in writing and submitting email, especially if the goal is to customize the email message in such a way as to be most informative for each organizer. Faced with this challenge, I wrote a JSL script to respond to individuals whose proposals were accepted. An artificial example based on dystopian literature is shown in Figure 1. You may need to click on the image to read it.

Figure 1. Artificial Example for the Science is Awesome Workshop

Faced with a rather well-defined structure, the JSL script cycles through each line in the data table to build and customize email text, attach a PDF file of important timelines and send the message (Figure 2). The Mail function is placed within a Try so that if the message fails to send for any reason (such as an incorrectly defined email address), a note is written to the JMP log. You may notice the j-indexed loop towards the bottom. Currently, Mail supports sending to a single recipient, so it is necessary to loop through the number of organizers (up to two in this case). This is the reason for including all organizers in the body of the email. However, if a proposal had only a single organizer, the below script would work (as it does for entry #2).

Figure 2. Script to Respond Positively for the Science is Awesome Workshop

Here are examples of the final messages that are generated and sent by the JSL script:

Hello, Organizers. Thank you for taking the time to submit a session proposal for the Science is Awesome Workshop. We are pleased to inform you that your proposal, 321723: CHICKIENOB NUBBINS: PRACTICAL PROBLEMS WITH GENETIC ENGINEERING, was selected for this year’s workshop.  If needed, please work with the other organizers to identify speakers for the session. Organizers in this session include Crake Smith, HelthWyzer (Crake.Smith@HelthWyzer.wow) and Jimmy Thickney, OrganInc (Jimmy.Thickney@OrganInc.wow). Please select a chair from among the organizers, keeping to the attached rules for Workshop participation. Rules for participation and important timelines are attached. We thank you for your interest in participating in the Science is Awesome Workshop! Sincerely, The Steering Committee

Hello, Organizers. Thank you for taking the time to submit a session proposal for the Science is Awesome Workshop. We are pleased to inform you that your proposal, 231234: THE IMPORTANCE OF VACCINATION PROGRAMS TO HALT THE SPREAD OF DISEASE, was selected for this year’s workshop.  If needed, please work with the other organizers to identify speakers for the session. Organizers in this session include Perdita Verney, University of Windsor (Perdita.Verney@uw.edu.wow). Session chair is currently Adrian Shelley, Earl of Windsor (Adrian@windsor.wow).  Please notify the chair of proposal approval. Rules for participation and important timelines are attached. We thank you for your interest in participating in the Science is Awesome Workshop! Sincerely, The Steering Committee

Hello, Organizers. Thank you for taking the time to submit a session proposal for the Science is Awesome Workshop. We are pleased to inform you that your proposal, 655321: USING THE LUDOVICO TECHNIQUE TO LOWER THE INCIDENCE OF VIOLENT CRIME, was selected for this year’s workshop.  If needed, please work with the other organizers to identify speakers for the session. Organizers in this session include Miles Branom, Ludovico Inc. (Branom@ludovico.wow) and William Brodsky, Ludovico Inc. (Brodsky@ludovico.wow). Session chair is currently Alex DeLarge, Droog Partners (Alex@droogpartners.wow).  Please notify the chair of proposal approval. Rules for participation and important timelines are attached. We thank you for your interest in participating in the Science is Awesome Workshop! Sincerely, The Steering Committee

Unfortunately, due to computer viruses of days past, email programs have gotten a bit protective when other programs try to gain access to send an email (Figure 3). In these instances, you can give JMP access for up to 10 minutes, though this still requires approving each email as it is sent. While some may find this button-pushing step tedious, I found it much preferable to writing and tailoring 30+ emails.

Figure 3. Warning from Microsoft Outlook

As a final note, please be aware that the bitness (32- or 64-bit) of JMP currently has to match that of the email software. Please see the note here as to when this issue may be addressed.