New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Operating System General OS operation information and support

Using Automator


Post Reply New Thread Subscribe

 
Thread Tools
reamoin

 
Member Since: Dec 19, 2012
Location: Vienna
Posts: 2
reamoin is on a distinguished road
Mac Specs: Novice

reamoin is offline
Dear forum,

I've been trying to get Automator to do a series of tasks for me but I'm having some difficulty and I've hit a brick wall. Here is what I would like to do:

I get mails from a website where my students do grammar quizzes and the mails are exactly like this:

The A vs. An Quiz 2 was completed by Ray Stevens:

Final Score: 10/10

Student Comments:

What I currently do manually is input this data in a simple numbers spreadsheet with the following columns:
NAME; QUIZ; DATE; RIGHT ANSWERS; TOTAL QUESTIONS; % (formula)

I then wait til a student has about done about (another) 10 quizzes and then send them a normal bar chart showing the names and results of each test they have do so far.

This is all quite simple, but as the number of students increases, it takes up more and more of my time. I would therefore like to try to automate this task, meaning get Automator to:

Find the respective mails in the Mail programme,
Copy/export/steal/borrow the info that should go into the numbers spreadsheet,
(if possible) Send my students an email with a graph of their results.

Any and all help would be greatly appreciated :-)

Thanks
QUOTE Thanks
Lifeisabeach

 
Lifeisabeach's Avatar
 
Member Since: Sep 30, 2007
Location: Wilmington, NC
Posts: 6,894
Lifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond reputeLifeisabeach has a reputation beyond repute
Mac Specs: iMac i3 (mid-2010) + OS 10.9; TV 3; iPhone 5S; iPad 4

Lifeisabeach is offline
I have a pretty fair grasp of Automator, but this seems beyond what it can do. Perhaps not beyond it, but insidiously complex and highly prone to errors. Here's a rudimentary idea of what I think the workflow would have to do:
  1. Copy contents of email.
  2. Paste into a text editor (i.e. TextEdit).
  3. Find the text " was completed by " (no quotes, with those spaces) and insert a RETURN character to put the name on a new line.
  4. If desired, also strip the first four characters of the first line so that "The A vs..." field now says "A vs ...".
  5. Find the text "Final Score: " and strip that.
  6. Find the "/" character, strip it and insert a RETURN character.
  7. Find the text "Student Comments:" and strip that.

Once done, you should have five lines of text matching what your spreadsheet column entries would be, though not in your preferred order. From here, the question is how to put it in the spreadsheet itself. That's a whole new challenge. I'm not familiar with Numbers and I haven't even used spreadsheet software in a couple decades, but you could probably continue to modify those lines above so that they are "tagged" as belonging to a specific column using XML code, then save it as an XML file and import it to Numbers.

There ultimately "may" be a better solution from this website that sends you these results. They should already have all this data available in a format that Numbers could import directly. Your email is simply a human-readable report of that database's output, similar to what you could set Numbers to generate (I assume). Is there any chance you can have the website start sending you these results in an XML file instead? That would greatly simplify things.

EDIT: Besides Automator, there are other macro tools available that can pull off feats like these. Keyboard Maestro in particular is especially good and more capable than Automator in some ways.


Please verify and include the exact model/year of your Mac and OS X version number (available from "About This Mac", then "More Info" on the Apple menu).
------
Links: Onyx | EasyFind | Apple Hardware Test | How to test your hard drive | The Safe Mac Adware Removal Guide | Uninstall MacKeeper
------
Lifeisabeach - Mac-Forums Member of the Month June 2009, Feb 2012, and March 2013.
QUOTE Thanks

Post Reply New Thread Subscribe


« forgotten password | What icon is this for? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Automator acting goofy qoncept OS X - Apps and Games 1 04-19-2013 07:45 AM
Automator - Help closing apps after Automator launches them p605 OS X - Apps and Games 0 08-26-2011 01:04 PM
Easing (some of) the pain of GPU switching on my mid-2009 Macbook Pro using Automator cwintermeyer Apple Notebooks 3 05-14-2010 01:13 PM
Automator Qualm! biggyk33 OS X - Apps and Games 0 06-26-2007 03:12 PM
Automator and Downloads MacGuy18 OS X - Apps and Games 6 12-07-2006 02:19 PM

All times are GMT -4. The time now is 05:34 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?