+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Batch Import xml Spreadsheets in Technical; Hi guys, I've recently figured out why the batch import sometimes omits results for some students. It's because there are ...
  1. #1

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Batch Import xml Spreadsheets

    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

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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.

  3. #3

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    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!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Batch Import Formatted Excel Marksheets into SIMS?
    By tben2505 in forum MIS Systems
    Replies: 10
    Last Post: 15th November 2011, 02:31 PM
  2. [SIMS] XML spreadsheet from SIMS.net crashing??
    By ljlbray in forum MIS Systems
    Replies: 2
    Last Post: 21st September 2011, 06:46 AM
  3. Importing live SIMS data as XML to Google spreadsheet
    By CyberNerd in forum Office Software
    Replies: 4
    Last Post: 4th March 2011, 09:39 AM
  4. [SIMS] Printing XML Files in Batch
    By mikeruddell2 in forum MIS Systems
    Replies: 11
    Last Post: 11th November 2010, 11:34 AM
  5. ISA 2004 Proxy Block List XML - Importable...
    By rpycroft in forum Windows
    Replies: 3
    Last Post: 8th December 2007, 11:55 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •