User Name
Password
AppleNova Forums » Programmer's Nook »

Advanced Copy Paste


Register Members List Calendar Search FAQ Posting Guidelines
Advanced Copy Paste
Thread Tools
EmC
Senior Member
 
Join Date: Jun 2004
Location: Columbus, Georgia
 
2020-09-04, 15:07

Thank you in advance for any advice or help. I am a teacher. I am teaching virtually this semester. All of the assignments and grading are done in one platform and the grades for each assignment have to be entered into another platform. I can export the grades for each assignment into excel, but need help automating the pasting. I am looking for a little script or utility or something that will let me copy the grades from a spreadsheet, put my cursor in the first box of my grade book and press go and have it put in the first grade from the list "press enter" then put the next grade in and so on until the end of the list.

I have no idea where to start. HELP!

What Adobe Updater‽ What‽ What‽ WHAT‽
  quote
Brad
Selfish Heathen
 
Join Date: May 2004
Location: Zone of Pain
 
2020-09-06, 17:46

Is your grade book a dedicated app (desktop? mobile?) or just some kind of online app in a web browser? I presume there's no import feature anywhere, is there? If you could find any way to import grades, it might be better to find a way to transform the shape of the other exported spreadsheet into some other format the grade book will import.

Unfortunately, all of my other ideas would require a fair bit of technical programming skill, and they would both assume your grade book tool is in a web app.

For automating web stuff, Selenium WebDriver is a popular tool for programmers and SDET/QA engineers. You write code that teaches it what to look for in a web page and how to interact with it (click, type, etc). At the lower level, most languages like Python have libraries for communicating directly over HTTP, parsing web pages, and posting form contents; requests and Beautiful Soup come to mind. If you're not already a web developer, though, both of these answers are probably way out of scope for you.

Outside of web apps, the tooling for automating clicks and types gets real shaky. With macOS, technically it's possible to use AppleScript to automate UI interactions, but it's a real nightmare finding the appropriate objects and the APIs are super obtuse and nigh-impossible to find good documentation. I know this because I have written two AppleScripts that change a bunch of system settings at night and in the morning, and it was agonizing getting them to work as I wanted.

I've also seen/touched a program that did UI automation for Windows apps many years ago, so I know that's possible too, but I can't remember the name and wouldn't be able to give any good recommendations.

The quality of this board depends on the quality of the posts. The only way to guarantee thoughtful, informative discussion is to write thoughtful, informative posts. AppleNova is not a real-time chat forum. You have time to compose messages and edit them before and after posting.
  quote
Dr. Bobsky
Senior Member
 
Join Date: Feb 2015
Location: UK's most densely packed city. It's not London...
 
2020-09-07, 02:37

It sounds like it would be easier to write the developer of the grade submission application to incorporate an excel import function. It's a handful of lines of code on their side...
  quote
EmC
Senior Member
 
Join Date: Jun 2004
Location: Columbus, Georgia
 
2020-09-10, 21:02

My grade book is web based and the grades would be coming from a column in excel that is the exact number of rows as my grade book. I am just looking to do a row at a time, not a full grade book import.

I took some c+ courses 20 years ago in undergrad, but have not used it since. I did find what I was looking for that runs on Windows. I suppose I will just do my grade importing at my windows computer at work.
Grade Paster for Windows

I have feature requested this with the company many times. It makes no sense not to enable pasting.

What Adobe Updater‽ What‽ What‽ WHAT‽
  quote
Posting Rules Navigation
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Post Reply

Forum Jump
Thread Tools
Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and Paste issue with Numbers Frank777 Genius Bar 1 2016-09-20 01:40
MC: Copy and Paste Bryson GamingNova 49 2014-02-23 20:22
Copy & Paste, actually important? Kraetos General Discussion 32 2008-07-18 10:32
10.4.3 F'ed up copy and paste NeverFade Genius Bar 4 2005-11-08 09:18
Copy-Paste without formatting? atomicbartbeans Genius Bar 2 2005-05-21 10:15


« Previous Thread | Next Thread »

All times are GMT -5. The time now is 17:22.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004 - 2024, AppleNova