+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 34
MIS Systems Thread, Batch create Aspects in SIMS? in Technical; That looks fine to me...
  1. #16

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,505
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    That looks fine to me

  2. #17

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

    And I've attached the excel file that I'll run - could you just see if that looks OK to you too?
    Attached Files Attached Files

  3. #18

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    Ah, so all imports do have a bizarre ID in them somewhere?
    So what happens if i export mine, and send them to you for import, are they tagged in some way or would you risk a tiny chance it might have the same id as one of yours. That doesn't sound very robust.

  4. #19

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,505
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    Spotted your problem: you're using the gradeset external ID when specifying the details of your original aspect (in B3 on the spreadsheet), it's the aspect's ID that you need, which in this case would be 3391 (you can see it in the XML as "<ExternalId>3391</ExternalId>")

    Correct that, and it should run fine...
    Last edited by LosOjos; 18th May 2011 at 12:54 PM.

  5. #20

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,505
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    Quote Originally Posted by vikpaw View Post
    Ah, so all imports do have a bizarre ID in them somewhere?
    So what happens if i export mine, and send them to you for import, are they tagged in some way or would you risk a tiny chance it might have the same id as one of yours. That doesn't sound very robust.
    Truth is I don't know... that certainly appears to be what would happen, but it does seem like a gaping flaw if it's true... perhaps SIMS also checks the supplier ID that is also in the XML and assigns a new ID if it's from an external supplier?

    This has got me thinking actually, I'm going to do a little playing, we may be able to make this batch aspect system a little more robust if that's the case...

    Just on the off chance, @PhilNeal if you're reading, do you know the specifics?

  6. #21

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by LosOjos View Post
    Spotted your problem: you're using the gradeset external ID when specifying the details of your original aspect (in B3 on the spreadsheet), it's the aspects ID that you need, which in this case would be 3391 (you can see it in the XML as "<ExternalId>3391</ExternalId>")

    Correct that, and it should run fine...
    You sir, are a genius! Thanks!!

  7. #22

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,505
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    Quote Originally Posted by tben2505 View Post
    You sir, are a genius! Thanks!!
    No genius, just spent a long time battling to create an easier life myself along with other members here, glad to be of help though

  8. #23

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    @LosOjos - that's what i think must happen, because it sets supplier ref and other things, so if you keep some extra info in there it should otherwise we'd all be leaving our systems open to massive corruption just by importing some third party aspects.

    was it @Dancer that created that macro / routine? perhaps he'll have more of an idea...

  9. #24

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,505
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    Quote Originally Posted by vikpaw View Post
    @LosOjos - that's what i think must happen, because it sets supplier ref and other things, so if you keep some extra info in there it should otherwise we'd all be leaving our systems open to massive corruption just by importing some third party aspects.

    was it @Dancer that created that macro / routine? perhaps he'll have more of an idea...
    I believe it was yes, his name certainly rang a bell when you said it and it was the same person who created the one for templates (all uploaded to SupportNet quite some time back)

  10. #25
    ajp233's Avatar
    Join Date
    Jun 2009
    Posts
    19
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Back in the day when I worked in Local Authorities we developed an Excel file that allowed schools to enter KS2 raw scores and marks and obtain a set of reports (tabular and graphical). It also automatically identified students who were within 3 marks of the next level (helped the school identify possible remark requests), and finally it generated a SIMS Assessment Manager xml results file for import into their system via a macro.

    To give you a flavour the following VBA code creates a File System object called XMLFS, creates a text file called ResKS22010.xml in S:\SIMS\Marks and then begins to write text into the file

    Set XMLFs = CreateObject("Scripting.FileSystemObject")
    Set XMLFile = XMLFs.CreateTextFile("S:\SIMS\Marks\ResKS22010.XML ", True)

    ' Write opening lines of XML file with results file Tag and Header Line
    XMLFile.WriteLine "<ResultFile>"
    XMLFile.Write "<Header>"
    XMLFile.Write "Key Stage 2 Assessment Results 2010"
    XMLFile.WriteLine "</Header>"

    I'v still got a copy of the Excel file and it is perfectly feasible to adapt it to make bulk generation of aspects not reliant on the existence of 2 additional text files in the same directory as the Excel file.

    Think I might give it a go actually......something to get my teeth into

  11. #26

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,505
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    Quote Originally Posted by ajp233 View Post
    I'v still got a copy of the Excel file and it is perfectly feasible to adapt it to make bulk generation of aspects not reliant on the existence of 2 additional text files in the same directory as the Excel file.

    Think I might give it a go actually......something to get my teeth into
    Let us know how you get on, I think the reasoning behind using a pre-existing aspect as a base is it already specifies the gradeset, aspect type etc.

    There are certainly ways you could do it with a nicer front end, but finding time to do that when this one has worked for me has meant it's always been at the bottom of the list unfortunately!

  12. #27

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Something which allows you to choose a different gradeset for each row would be great, too!

  13. #28

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,505
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    I can see this becoming another little EduGeek project... kind of feels wrong continuing development without @Dancer's blessing though...

  14. #29

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    If you know the gradeset IDs in your system, you would be able to push that into the file where it is currently specified quite easily.

  15. #30

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Well, I couldn't !!

    And there doesn't seem to be a way of easily finding the ID - furthermore, it seems (redundantly) every aspect not only needs the gradeset ID, but also the grades and equivalent values of that gradeset. Which is silly!

SHARE:
+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. MYSql - Script batch create users & dbs
    By peterdoherty in forum How do you do....it?
    Replies: 9
    Last Post: 15th January 2014, 10:06 AM
  2. Replies: 14
    Last Post: 18th March 2012, 09:14 PM
  3. [SIMS] Aspects - assessment Manager
    By rh91uk in forum MIS Systems
    Replies: 13
    Last Post: 22nd July 2010, 06:02 AM
  4. Problem with batch backup or SIMS.net using DBAttach
    By GreenICT in forum MIS Systems
    Replies: 5
    Last Post: 18th August 2009, 08:48 AM
  5. Need SIMS - AD Create Module
    By Grommit in forum MIS Systems
    Replies: 10
    Last Post: 24th June 2009, 10:45 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
  •