+ 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
    Location
    Wolverhampton
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Facility CMIS - Import email addresses

    Hi,

    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
    Posts
    2,916
    Thank Post
    259
    Thanked 771 Times in 586 Posts
    Rep Power
    270
    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
    Location
    Wakefield, West Yorkshire
    Posts
    621
    Thank Post
    95
    Thanked 129 Times in 100 Posts
    Rep Power
    66
    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
    tli is offline

    Join Date
    Mar 2010
    Location
    Birmingham
    Posts
    17
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    9
    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.

SHARE:
+ 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, 02:07 PM
  2. [SIMS] Bulk import UDFs and Email address
    By matt40k in forum MIS Systems
    Replies: 2
    Last Post: 1st August 2012, 09:57 AM
  3. [SIMS] Importing Email Addresses into SIMS
    By boffinson in forum MIS Systems
    Replies: 24
    Last Post: 29th April 2012, 02:48 PM
  4. [SIMS] Bulk import staff email address
    By matt40k in forum MIS Systems
    Replies: 16
    Last Post: 31st October 2010, 10: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, 02: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
  •