+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Migrate WCBS PASS to iSAM (Not the finance bit) in Technical; Hi there, I have been tasked with leading the migration of our PASS MIS over to iSAMs and only having ...
  1. #1
    bodminman's Avatar
    Join Date
    Apr 2007
    Location
    Sunny Suffolk
    Posts
    1,153
    Thank Post
    724
    Thanked 224 Times in 116 Posts
    Rep Power
    84

    Migrate WCBS PASS to iSAM (Not the finance bit)

    Hi there,

    I have been tasked with leading the migration of our PASS MIS over to iSAMs and only having very little knowledge of PASS and no knowledge of iSAMs, this is starting to stress me out a little.

    Has anyone elso do this move and if so can you please share how you managed to export 'all' your data from PASS etc etc.

    Thanks

  2. #2

    AngryTechnician's Avatar
    Join Date
    Oct 2008
    Posts
    3,730
    Thank Post
    698
    Thanked 1,210 Times in 761 Posts
    Rep Power
    394
    PASS is fairly easy to get data out of as the database structure isn't terribly complicated (though a bit messy), but I suspect there will be a lot of schema differences between the two. I would have thought you would need to liaise with someone at iSAMs, is there a reason they are not handling the migration for you?

  3. #3
    Netman's Avatar
    Join Date
    Jul 2005
    Location
    56.343515, -2.804118
    Posts
    911
    Thank Post
    367
    Thanked 190 Times in 143 Posts
    Rep Power
    54
    Did this very job back in 2009 - it wasn't too painful so don't worry too much! iSAMS are very helpful during the process. I might be able to remember what I did if you want to PM me!!
    In short, it was connect excel to PASS via ODBC and pull the relevant data out (finding the right tables was a pain IIRC), then clean up the data a bit and then submit it all to iSAMS, who did the import.

  4. #4
    bodminman's Avatar
    Join Date
    Apr 2007
    Location
    Sunny Suffolk
    Posts
    1,153
    Thank Post
    724
    Thanked 224 Times in 116 Posts
    Rep Power
    84
    Quote Originally Posted by AngryTechnician View Post
    PASS is fairly easy to get data out of as the database structure isn't terribly complicated (though a bit messy), but I suspect there will be a lot of schema differences between the two. I would have thought you would need to liaise with someone at iSAMs, is there a reason they are not handling the migration for you?
    They have just sent me a load of xls docs that contain the iSAMs field headings and they have asked me to look at the docs, complete various bits of info and then match there field names against those in use in PASS.

  5. #5
    GNewnham's Avatar
    Join Date
    Dec 2008
    Location
    Bath
    Posts
    65
    Thank Post
    9
    Thanked 9 Times in 7 Posts
    Rep Power
    22
    Hi

    I did this exercise 2 years ago - mostly used the export to excel function in Pass to get all the names, addresses etc. The biggest problem is the quality of your data in Pass and whether it is set up with joint parent records or single ones. Ours was single and I had to separate parents into 2 records for the iSAMS import ie Mum and Dad with the correct phone nos etc - this was a bit tricky. Our data was not great as we had mums phone numbers in the fax no field etc. Also the file for depicting the siblings was hard to create from Pass and required quite a lot of manual manipulation.

    Also, you need to decide how much info you are going to bring over iro past pupils - ie all, only last year's leavers, last 5 year's leavers etc

    Am happy to chat on the phone or communicate by email if I can help.

    PM me and I will give you my details.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 22nd May 2012, 11:43 PM
  2. Replies: 6
    Last Post: 30th September 2010, 03:17 PM
  3. Replies: 3
    Last Post: 12th February 2010, 02:42 PM
  4. Changing MIS to possibly WCBS PASS or Hebron
    By trekmad in forum MIS Systems
    Replies: 10
    Last Post: 23rd March 2009, 03:46 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
  •