+ Post New Thread
Page 3 of 3 FirstFirst 123
Results 31 to 36 of 36
MIS Systems Thread, Is this correct? in Technical; I would expect to have a set of 'views' that a supplier could use to give you your data and ...
  1. #31

    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
    I would expect to have a set of 'views' that a supplier could use to give you your data and / or use it as the basic level of migration to a new supplier, i.e spreadsheets.
    Providing this for all historic data should be a small step away too.
    It's only what the front interface should be requesting as collating anyway.
    If you can provide hosting and cheap read only access - great.
    The problem lies in what you define as "cheap".
    You could use a formula similar to a rack space like entity: data x seconds held + plus bandwidth access ... Maybe?

  2. #32


    Join Date
    May 2009
    Posts
    2,916
    Thank Post
    259
    Thanked 771 Times in 586 Posts
    Rep Power
    270
    Quote Originally Posted by scholarpack View Post
    Disclaimer: we're an MIS supplier. OK, so out of interest, how would you guys envisage the switching process works? Should you be allowed to keep historical data free of charge?
    Our data should be made available to us in a format that is reasonable. I'd say to be reasonable, the cost of accessing the data should be low - no 'bespoke' systems or software required to get at the files provided and only fairly low grade development skills (college grade relational database stuff) required to make some sense of it. So that might mean a bunch of XML or just straight CSV table dumps or (generously) ISO standard SQL which will create and populate a coherent schema.

  3. #33

    Join Date
    Oct 2013
    Location
    Derby
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi

    I’m new to the business so most advice gratefully received. I ’ll try and refrain from the sales pitch from now on…..if I stray back just let me know.

    The last post is spot on – we would not ask anyone to delete the SQL database with the school’s data in it. This data can be readily accessed with a variety of tools. We charge for the use of our software.

    Steve

  4. #34

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    621
    Thank Post
    95
    Thanked 129 Times in 100 Posts
    Rep Power
    66
    ^ What Steve said. It's not profiteering in my mind, they're a business, they work by generating a profit. I'm not saying I wholly agree with charging for one machine somewhere to sit with Facility on it for access to the data, but as several people have stated, including Steve, to be fair, bang a reporting tool on (SSRS with Report builder, Access, Excel, etc). And a good DBA wouldn't take a couple of weeks, a poor DBA would take a couple of weeks, a good one would take a couple of hours. It depends what you're trying to get at too. The only thing that's slightly complicated is the way assessments are stored in nsturesults in terms of the way the resutls data is formatted, but that's not unpickable you just have to get your head around it. If you're wanting assessment data that would take a day or two, if you're after everything else which is basic, you're looking at a few hours.
    SQL express is free and if you use 2008 R2 with advanced services, it comes with SSRS (SQL Server Reporting Tools). On which if you want a GUI you can bolt on Report Builder 3. Also free.
    I'd look at paying a DBA for a week to install that, set up report builder on a couple of clients, or use the web based version to view. Make sure before you do you have a clear spec of what you want the reports to look like and what data you want to get out. That will maximise the time the DBA has to actually create the reports rather than try to organise you. Ensure SLT are aware that the reports they request at this stage will be fixed and can't be changed afterwards to set their expectations, and then everything's covered.

  5. #35

    Join Date
    Jul 2006
    Location
    London
    Posts
    1,254
    Thank Post
    111
    Thanked 242 Times in 193 Posts
    Blog Entries
    1
    Rep Power
    74
    You should be allowed to keep single user access to all the data reporting and analysis.

    From what I understand ACS are taking a hard line on the pre-existing contract terms where serco may have been more inclined to look the other way. I suppose that unpicking the mess that they bought has to be funded some how.

  6. #36

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    169
    Thank Post
    54
    Thanked 19 Times in 18 Posts
    Rep Power
    22
    Quote Originally Posted by box_l View Post
    Thanks for the replies.
    @jcs808
    Was there a cost associated with that access?
    And who told you this?

    BoX
    Our "Local Council IT provider" are undertaking the migration. There may well be an itemised cost for keeping a single connection to the Facility CMIS database which is part of the overall licencing/migration service that we are buying in to but I'm not privy to the financing particulars.

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

Similar Threads

  1. PaperCut Code - is this correct?
    By Mr.Ben in forum Coding
    Replies: 8
    Last Post: 26th March 2013, 06:57 PM
  2. Vmware , is this correct ?
    By 2097 in forum Thin Client and Virtual Machines
    Replies: 27
    Last Post: 19th June 2012, 04:19 PM
  3. Is this correct?
    By MattDLEA in forum Licensing Questions
    Replies: 8
    Last Post: 9th December 2011, 02:42 PM
  4. Migrating files to new server using DFS - is this correct?
    By iSteve in forum Windows Server 2008
    Replies: 2
    Last Post: 12th July 2011, 12:42 PM
  5. Is This A Network Problem ?
    By Pear in forum Windows
    Replies: 21
    Last Post: 12th December 2005, 03:01 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
  •