MIS Systems Thread, deleting incorrectly imported set of grades in Technical; Hi,
I want do delete a set of grades imported into an aspect and a given result set (using Routines ...
21st September 2010, 01:35 PM #1
- Rep Power
deleting incorrectly imported set of grades
I want do delete a set of grades imported into an aspect and a given result set (using Routines Data In ) in error.
I seem to remember there was a way under Tools - Performance - assessment then somehow selecting the results by date (today) or similar etc. but am nervous about going to far into these options.
I only want to delete a subset of imports ( done today) not the whole result set or aspect or perhaps it's just easier to overwrite with the correct results - not sure if they're overwritten or each imported is stored in some timestamped way?.
ANy help appreciated
IDG Tech News
21st September 2010, 02:27 PM #2
I may be wrong here, but if I understand correctly, results are stored against an aspect by date or result set, so if you've imported in to a result set, I'm afraid you've overwritten the previously stored results and won't be able to get them back that easily.
The only way I can think you can get them back is to restore yesterday's backup to a dummy server, export the relevant results, then re-import them in to your actual database; if you have local SIMS support they may be able to do that for you
21st September 2010, 02:47 PM #3
- Rep Power
Thanks for clarifying - I've sorted out now as I've just reimported some data into the same result set overwriting the previous data - I just didn't want to end up with multiple version of the data all over the place.
21st September 2010, 02:51 PM #4
The routine is where you expect it, and works very well. Yes it is scary, but if you know how many results you imported, then you can compare with the number to be deleted, as it warns you. You can be specific about the result date and many other things. Run through the wizard to see the options available, you dont have to click the final delete button if you dont want to.
Tools | Performance | Assessment | System Utilities | Results
Then you can delete them.
If they were imported against a result set, then there is no date stamping visible to us (no history so to speak), possibly something hidden in the SQL tables, but so long as your are using result sets, you can only store one value per Aspect+Resultset combo, so if you defo need data in, you can overwrite it or just reimport other data over the top.
Edit: oops too late
Last edited by vikpaw; 21st September 2010 at 02:59 PM.
By usmn01 in forum EduGeek Joomla 1.5 Package
Last Post: 17th March 2011, 03:46 PM
By wesleyw in forum How do you do....it?
Last Post: 12th July 2010, 10:20 AM
By russdev in forum MIS Systems
Last Post: 13th August 2009, 12:40 PM
By danIT in forum MIS Systems
Last Post: 3rd November 2008, 04:51 PM
By Geoff in forum EduGeek.net Site Problems
Last Post: 31st January 2008, 01:09 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)