+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Facility CMIS - Import email addresses in Technical; Hi, I apologies if this has been covered but I cannot find any reference to it. We are moving from ...
  1. #1
    halladam's Avatar
    Join Date
    Apr 2008
    Thank Post
    Thanked 0 Times in 0 Posts
    Rep Power

    Facility CMIS - Import email addresses


    I apologies if this has been covered but I cannot find any reference to it.

    We are moving from one parent contact system to another. The new system will read data directly from CMIS and so I want to import the email addresses of parents into CMIS from a CSV.

    Is this possible? If so how do you import the details ensuring the correct email address imports to the correct contact. Is there a quick way to do it or do I have to tell the office staff its a manual job.

    Any help appreciated...

  2. #2

    Join Date
    May 2009
    Thank Post
    Thanked 889 Times in 667 Posts
    Rep Power
    Quote Originally Posted by halladam View Post
    Any help appreciated...
    There is a data transfer thing which might help (options | Data Transfer), there is some documentation kicking about which support should be able to provide you with.

    You could nip in the back end and do it via SQL, but there will be outraged gasps of horror at the mention of that and not without some justification.

  3. #3

    Join Date
    Jun 2007
    Wakefield, West Yorkshire
    Thank Post
    Thanked 134 Times in 104 Posts
    Rep Power
    If you can get the contact ID from CMIS into a spreadsheet with the email address in the relevant cell next to it, just use concat in excel to build yourself a query. Then copy that down to every row and dump it into SQL.

  4. #4
    tli is offline

    Join Date
    Mar 2010
    Thank Post
    Thanked 4 Times in 4 Posts
    Rep Power
    The CMIS data transfer routine will do this and also avoid possible disasters if the SQL were to go wrong.

    It's fiddy but relatively straightforward as long as your have the student id in the spreadsheet for the routine to use for matching. You will need to make sure that the id is set as a text field in Excel if your ids having leading zeros.

    If you need the manual, there should be links in previous threads.

+ Post New Thread

Similar Threads

  1. [SIMS] Importing Email Addresses into Sims.NET
    By Geoff in forum MIS Systems
    Replies: 49
    Last Post: 27th September 2012, 03:07 PM
  2. [SIMS] Bulk import UDFs and Email address
    By matt40k in forum MIS Systems
    Replies: 2
    Last Post: 1st August 2012, 10:57 AM
  3. [SIMS] Importing Email Addresses into SIMS
    By boffinson in forum MIS Systems
    Replies: 24
    Last Post: 29th April 2012, 03:48 PM
  4. [SIMS] Bulk import staff email address
    By matt40k in forum MIS Systems
    Replies: 16
    Last Post: 31st October 2010, 11:59 PM
  5. Import Users Into RM Maths From Serco Facility CMIS
    By DreddMetal in forum Educational Software
    Replies: 0
    Last Post: 26th November 2008, 03:37 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts