Uploading Target Data in SIMS

[Dill]

Hi

 

I wondered if anyone can help me. I am looking to update target data in SIMS. I have used Routines>Data In>Assessment>Import from spreadsheet. I then import my CSV file and get stopped on the second screen as i need to 'Identify student name column'.

 

My columns all have titles in Row 1 so I am a little confused as what to do next? Can anyone help

 

Thanks

Dill

[Linfit]

SIMS is fairly stupid so you have to tell it which columns in your csv file contain the data items it needs to make a match: name, UPN, etc. You also have to match up your data columns with the aspect/result set combo you want to import the data to. If you right click in each column which it displays on the second screen, it will give you a menu of things to match up to that column.

[tombry]

make absolutely sure you pick a result set - nothing more frustrating that going through 30 or so columns, only to realize at the end it's worthless because they aren't tied to a result set

[MickH]

Create a marksheet template in SIMS with the relevant aspects and student information columns on it - in same order as your csv if possible, if not (as the student info ones are always at top) then juggle your csv columns around to match marksheet - just makes it easier for copy/paste later. As tombry says, pick the correct result set for the aspects if you're using one else it's coffee and dark room time sorting out the mess lol.

 

1. Attach year group to marksheet.

2. Open said marksheet and export 'formatted'.

3. Open the xml exported file in excel, it'll be protected so in excel from the 'Review' ribbon section select 'unprotect sheet' then unhide column A to get access to the UPN data.

4. Delete ALL the student data that's present from column A to last column and row.

5. Paste contents of csv in to the now empty cell making sure your columns match up - double & triple check this bit!!!!

6. Put a date in across all the white cells in row 1 above the aspect names.

7. Hide column A again (no need to protect sheet) - it won't let you import if you don't.

8. Save file then follow same routine you did with csv for importing. No need to match up columns or anything although you may have to match up students if you haven't used their UPN's, jobs a goodun

 

Sounds long winded but after you've set up some 'import' templates for regular imports it takes a couple of mins each time thereafter and is a lot easier than going through matching up columns etc.....

 

For info, if you unhide the top 4 rows after you've unprotected the xml file you'll find the id tags of the aspects and result set - that's how SIMS knows where to stick the data.

[tben2505]

SIMS is fairly stupid so you have to tell it which columns in your csv file contain the data items it needs to make a match: name, UPN, etc. You also have to match up your data columns with the aspect/result set combo you want to import the data to. If you right click in each column which it displays on the second screen, it will give you a menu of things to match up to that column.

 

SIMS would be fairly stupid if it *didn't* have these validation measures.

[SouthCoastSaint]

I would always use the import routine - it's what it's there for and much quicker than exporting marksheets and reimporting. If you can include UPNs on the sheet you are importing it's even easier.