+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 21
MIS Systems Thread, Document Management Server in Technical; Does anyone have any experience of the bulk extraction of documents from the Sims Document Management Server. I've found the ...
  1. #1

    Join Date
    Oct 2010
    Posts
    37
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    10

    Document Management Server

    Does anyone have any experience of the bulk extraction of documents from the Sims Document Management Server. I've found the files in a folder called DOCSTORAGE but they appear to be encrypted.

    Thanks in anticipation

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Quote Originally Posted by Anjelica View Post
    Does anyone have any experience of the bulk extraction of documents from the Sims Document Management Server. I've found the files in a folder called DOCSTORAGE but they appear to be encrypted.

    Thanks in anticipation
    They are encrypted, for good reason. Data Protection

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    Quote Originally Posted by Anjelica View Post
    Does anyone have any experience of the bulk extraction of documents from the Sims Document Management Server.
    You can export reports from within SIMS, this creates a SIMS Report file which can be imported into any SIMS .net system. You don't touch the raw data files, if you move servers, you move the WHOLE folder, if you have issues, you can run a report to get the physical file name and the report name, ie a few files didn't copy and you're looking at just restore it off tape for example, but you never manually extract the documents.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Which documents do you want? There's probably another legitimate way to get them.

  5. #5

    Join Date
    Oct 2010
    Posts
    37
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    10
    creese I find myself feeling very offended. Of course I have considered why they are encrypted. As the DPO at school I know better than most.

    matt40k These aren't just Sims files I want. I want them all - Admission Forms, IEPs, letters, reports etc.

    vikpaw Yes, I want them all. We are considering purchasing Document Archiving Software (similar to Document Management Software | Document Archiving Systems and Scanning for Small Business, Financial Services, Paperless Office) so that all the files we create can be stored in one place (encrypted). I have been using the DMS since it was created. I have 65,000 plus files stored there but if I can't get them out it would be silly buying the software. I'm sure everyone knows the limitations of the Sims DMS and it's time we moved on.

    My next thread was going to be to ask if anyone has experience of archiving software but until I know I can use the library I already have I'm not going to move forward.

  6. #6
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,116
    Thank Post
    414
    Thanked 149 Times in 147 Posts
    Blog Entries
    3
    Rep Power
    59
    Groupcall have a way of extracting the SIMS linked documents, so it's possible somehow.

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    I think you will be looking at a hefty Capita fee to extract all the files programmatically, otherwise, you'd have to do it manually. That would be a mammoth task. Perhaps, reports, could be exported if you use the same templates each year, but all the other stuff.... well it's mammoth.

    It might be worth looking at one of those companies that offers scan to SIMS or autolinking to the DMS (capita website, e.g. Cohesion - RecordLink) - they may also do the kind of archiving you want, and as part of the process if they are a licenced SIMS partner, be willing to write a custom program for you to extract the data. Though, they may not even have a great level of access, because i'm pretty sure they just work by sending the files to the SIMS interface and it's blindly added to the DMS as normal rather than any more direct way.

    Just a thought though, as 'we' own the data, are we allowed to request it out of the system. Say for example if we were moving to another MIS, or simply because we wanted it, and they can't charge an astronomical fee for it...?

  8. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Quote Originally Posted by Cache View Post
    Groupcall have a way of extracting the SIMS linked documents, so it's possible somehow.
    That's a good idea. I couldn't see it listed in the Xporter module, but the write-up makes it sound like they can do anything...
    Groupcall Xporter is a software solution that automatically extracts data from almost any database, and delivers it to other systems in a range of formats.

  9. #9

    Join Date
    Oct 2010
    Posts
    37
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    10
    Thanks Cache. I've e-mailed them - we'll see what they say.

  10. #10
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    432
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    30
    @Anjelica, I don't think you should feel offended at the post from @creese. It was well intended and he wasn't to know you're a DPO at your school. To be fair, other people might come looking at this forum if they wanted to crack the encryption on the DMS for reasons less well intended than your own.

    Back on the topic....

    Even using a number of different SIMS based reports I think what you want to do will be very difficult to achieve without heading into SIMS itself and manually trawling all the records since there are so many places you can link a file on a pupil, staff, contact or agents record.

    The only logical way to approach your problem is by decrypting the document server as you suggest in your OP. This isn't something that is going to be done easily, or for cheap. Certainly not given the volume of documents you're looking at.

    As @Cahce suggests:

    Quote Originally Posted by Cache View Post
    Groupcall have a way of extracting the SIMS linked documents, so it's possible somehow.
    Since Groupcall can do a heck of a lot with the SIMS database now, I imagine they probably could do this as they may well have access to the encryption mechanism. However if you are going down the route of decrypting the DocStorage and then it is probably more appropriate to speak to Capita about doing this than Groupcall isn't it?

    If your support is direct with Capita then log a call asking about it, if it is with the LA, log a call asking them to contact Capita on your behalf.

    Quote Originally Posted by vikpaw View Post
    Just a thought though, as 'we' own the data, are we allowed to request it out of the system. Say for example if we were moving to another MIS, or simply because we wanted it, and they can't charge an astronomical fee for it...?
    Like the idea Vik, but you already have access to it... through SIMS.

    Thinking outside the box a little, is it plausible for you to maintain the DMS instead of this additional software, but move it onto separate hardware to increase its performance and allow it to store a greater volume of records in the long term? The DMS does not have to live on the same box as the SIMS Database.
    Last edited by superfletch; 9th July 2011 at 03:28 PM.

  11. #11

    Join Date
    Oct 2010
    Posts
    37
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    10
    The problems with the DMS are many and various. The main complaint has always been that if you create documents from a mail merge you can't then automatically upload them to the student files whereas with document archive software it would recognise the occurence of a particular name, tag etc. My aim is for all files to be archived no matter where they are stored then they can be searched as necessary. It won't matter then when people "forget" to upload or if a document refers to one or more students.

  12. #12

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Quote Originally Posted by Anjelica View Post
    creese I find myself feeling very offended. Of course I have considered why they are encrypted. As the DPO at school I know better than most..
    You are very quick to take 'extreme offence' as indicated by the none was intended.

    I wrote, got called to something urgent, option 1 : Post what I had written and drop a quick smiley in. Option 2: cancel and let you or anyone else possibly corrupt a schools data.... I would have added more by Monday.

    I'll bow out of the thread completely now for fear of further offence.. Bye

  13. #13
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,116
    Thank Post
    414
    Thanked 149 Times in 147 Posts
    Blog Entries
    3
    Rep Power
    59
    I've poked arround in the DMS folder on a test system, word documents and the like (which will include profiles, individual reports and the like) are all just within the DMS filesystem (not encrypted) and presumably called when required, the remained of the stuff is scattered arround. Obviously I haven't a clue on the structure and wouldn't recommend going poking arround and pulling stuff out of the DMS filestructure on a live system unless you know what your up to.

    Just to expand a little more on what I put, @vikpaw has the right area with the Xporter. The Groupcall Xporter is/was used by CLEO for MIDAS and is how they were extracting linked documents to put in place for the Parental Online Reporting (where ever CLEO decide they are now upto with this project), so we have the reports in SIMS which the Xporter runs and pulls out then uploads any new linked documents.

  14. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Have you tried to open any of those docs you found in the DMS folder structure? It's not that easy.

    Having access through SIMS is not satisfactory access. It's filtered and one at a time. It's stored in a bespoke manner for a particular purpose. Exporting it isn't straight forward, I was just wondering if we have a right to easy access rather than having to buy in to a third party product.

  15. #15
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    171
    Thank Post
    38
    Thanked 61 Times in 49 Posts
    Rep Power
    25
    As someone whose pulls out documents from Sims document server programmaticlly, if you're familiar with the business objects it's fairly simple to iterate through everyone and then interate through all their documents and save them to disk. It would take a long time to process, but nothing particularly tricky in the code.

  16. Thanks to rpwillis from:

    Anjelica (11th July 2011)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. A document management system?
    By localzuk in forum General Chat
    Replies: 10
    Last Post: 5th February 2014, 11:05 AM
  2. File Archiving and/or Document Management
    By wesleyw in forum How do you do....it?
    Replies: 1
    Last Post: 22nd April 2010, 10:39 AM
  3. Mac Management Document from Apple
    By kingswood in forum Mac
    Replies: 1
    Last Post: 28th October 2008, 10:10 PM
  4. Replies: 8
    Last Post: 18th July 2008, 02:34 PM
  5. Alfresco for Document Management
    By CyberNerd in forum Educational Software
    Replies: 1
    Last Post: 3rd June 2008, 01:48 PM

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
  •