[sims] Batch Import xml Spreadsheets

[tben2505]

Hi guys,

 

I've recently figured out why the batch import sometimes omits results for some students.

 

It's because there are a handful of kids who don't have UPNs.

 

I know this might sound odd to most but we're a private school so we don't need them (altough I've ensured all kids now have a UPN to avoid this happening in future).

 

However I currently have dozens of marksheets with results I need to get into SIMS, with loads of kids that (on the exported marksheet) have no UPNs... this makes the automated import miss certain kids.

 

Is there, does anyone know, another way of doing this apart from importing each sheet one by one (which will take a while!)

 

Cheers,

 

Tom

[vikpaw]

Wow that's a big find. I remember losing data even on a single sheet import after manual matching! Still if you've sussed it in your case maybe the only way is do a manual lookup. Export a master sheet with all upns then drop in a lookup formula. Its a hassle but maybe quicker than manual single sheet.

[tben2505]

Wow that's a big find. I remember losing data even on a single sheet import after manual matching! Still if you've sussed it in your case maybe the only way is do a manual lookup. Export a master sheet with all upns then drop in a lookup formula. Its a hassle but maybe quicker than manual single sheet.

 

Cheers mate!