+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
MIS Systems Thread, CMIS - Importing data into CMIS. Can it be done? in Technical; Yep, it is, the format of the nsturesults table is nasty. Rather then having a different entry for each result ...
  1. #16

    Join Date
    Jan 2008
    Location
    Chesterfield, Derbyshire
    Posts
    194
    Thank Post
    11
    Thanked 35 Times in 25 Posts
    Rep Power
    21
    Yep, it is, the format of the nsturesults table is nasty. Rather then having a different entry for each result it has as many results as it can fit in one entry then moves onto a new entry when it hits the max, all space sperated in the form mapid result mapid result which looks like 50 B 75 7.2 63 B etc. I created a user with read only access to the database for my scripts as im only reading from it (makes sure I cant mess it up). Im just not brave enough to write back to it.

  2. #17

    Join Date
    Oct 2012
    Posts
    7
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Fair enough. Events are, by comparison, relatively straightforward. Each event has one entry in APPAPPEVENT, and data for each field of each event is stored in APPAPPFIELDS. The only odd behaviour is that there's a lot of duplication of data in the two tables, and also that long comments get split into several entries in APPAPPFIELDS. But it's not terrible.

    I can see why you don't want to touch NSTURESULTS!

  3. #18


    Join Date
    May 2009
    Posts
    3,134
    Thank Post
    276
    Thanked 849 Times in 637 Posts
    Rep Power
    334
    Quote Originally Posted by MrGravell View Post
    Why is everyone so paranoid about writing to the database? People at my school are even afraid of reading from the database. Obviously I'd try it on a test server first, and also take a backup when I tried it for real. But really, how hard can it be? Is the database that crazy? It might be...
    Because if you stuff it up, it could cost you a lot of money. You may not notice problems at first. You might not even notice them until an update comes along that expected everything to be 'just so'. Then you have to resort to the company for support and they say ... that'll be £1200 a day please.

    Even reading from the database can cause problems. Badly written SQL can be a game of "cripple Mr Database" and it can be easy to miss on a test server where transactional read consistency isn't in the presence of a consistent low level of writes from multiple sessions. Hell, sometimes the poor SQL will be supplied by the MIS developers!

    My compromise is to read but never write.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Google Earth install via GPO? Can it be done in v6?
    By Ben_Stanton in forum How do you do....it?
    Replies: 19
    Last Post: 10th August 2011, 11:22 AM
  2. [Pics] Musical Score: Can It Be Played?
    By DaveP in forum Jokes/Interweb Things
    Replies: 13
    Last Post: 27th February 2011, 07:21 PM
  3. Linux workstation - Windows Network : Can it be done?
    By Nimon in forum Wireless Networks
    Replies: 4
    Last Post: 28th April 2010, 09:24 AM
  4. Student Webpage with Moodle - can it be done?
    By dgarner in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 9th February 2010, 06:05 PM
  5. Is this quote good? Can it be beaten?
    By danielson81 in forum Budgets and Expenditure
    Replies: 15
    Last Post: 21st August 2008, 05:57 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
  •