+ Post New Thread
Page 4 of 4 FirstFirst 1234
Results 46 to 54 of 54
SIMS Bulk Import Thread, SIMS Bulk Import in Projects:; Now doing the same thing for staff in relation to AlfieCloud, got a CSV containing Surname, Forename, Email, but nothing ...
  1. #46

    Ephelyon's Avatar
    Join Date
    Aug 2008
    Location
    Cheshire, England
    Posts
    1,701
    Thank Post
    297
    Thanked 326 Times in 199 Posts
    Rep Power
    143
    Now doing the same thing for staff in relation to AlfieCloud, got a CSV containing Surname, Forename, Email, but nothing comes up in any of the drop-down boxes to match the fields to. Using the stable version for now.

  2. #47

    Join Date
    Mar 2013
    Posts
    168
    Thank Post
    42
    Thanked 6 Times in 5 Posts
    Rep Power
    23
    Thanks for that. Wished I saw this a few days ago though as it would have saved me some work

  3. #48

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,428
    Thank Post
    368
    Thanked 643 Times in 525 Posts
    Rep Power
    159
    @Ephelyon old version work ok?

  4. #49

    Ephelyon's Avatar
    Join Date
    Aug 2008
    Location
    Cheshire, England
    Posts
    1,701
    Thank Post
    297
    Thanked 326 Times in 199 Posts
    Rep Power
    143
    This is 1.7.21.0 that I'm using.

  5. #50

    Ephelyon's Avatar
    Join Date
    Aug 2008
    Location
    Cheshire, England
    Posts
    1,701
    Thank Post
    297
    Thanked 326 Times in 199 Posts
    Rep Power
    143
    Right, problem with the CSV file originally (not all fields filled in). Exported properly now, down to 40-odd people in the right format, can select the right fields to match, but then it gets about halfway through finding people and always crashes out. Tried both stable and preview versions about 20 times each.

  6. #51

    Ephelyon's Avatar
    Join Date
    Aug 2008
    Location
    Cheshire, England
    Posts
    1,701
    Thank Post
    297
    Thanked 326 Times in 199 Posts
    Rep Power
    143
    Now I'm finding the stable version will run on the terminal server and will import, but then none of these imported e-mail addresses are actually showing up in the SIMS staff records...

  7. #52

    Ephelyon's Avatar
    Join Date
    Aug 2008
    Location
    Cheshire, England
    Posts
    1,701
    Thank Post
    297
    Thanked 326 Times in 199 Posts
    Rep Power
    143
    Got it to the stage where it'll import (type initialiser error with the previous SIMS user), but if they've already got an e-mail address it won't overwrite Main and Primary.

    (Sorry for all the posts...)

  8. #53

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,428
    Thank Post
    368
    Thanked 643 Times in 525 Posts
    Rep Power
    159
    Sounds like you need to set the email location - home\work\other.

    the issue with the crashing is it's waiting on the sims api/business objects to return the data, in that version i think it was only one thread so it appears to crash, I'd recommend importing a year group at a time and being very patience, SIMS isn't known for its speed!!

  9. #54

    Ephelyon's Avatar
    Join Date
    Aug 2008
    Location
    Cheshire, England
    Posts
    1,701
    Thank Post
    297
    Thanked 326 Times in 199 Posts
    Rep Power
    143
    I had it set to Work, Overwrite Main, Overwrite Primary.

    In the end I set it to Work, Overwrite Main, No Primary and then went through them all setting the Primary value. We're alright now.

    Thanks for the assistance

SHARE:
+ Post New Thread
Page 4 of 4 FirstFirst 1234

Similar Threads

  1. [SIMS] Bulk import staff photos
    By MicrodigitUK in forum MIS Systems
    Replies: 3
    Last Post: 28th November 2010, 06:21 AM
  2. [SIMS] Bulk import staff email address
    By matt40k in forum MIS Systems
    Replies: 16
    Last Post: 31st October 2010, 10:59 PM
  3. [SIMS] Sims - CTF Import Queries
    By cgilmour in forum MIS Systems
    Replies: 13
    Last Post: 9th September 2010, 03:36 PM
  4. Bulk Import Contacts into Exchange 2003
    By TheFopp in forum Windows
    Replies: 4
    Last Post: 6th May 2010, 07:01 PM
  5. Sims CTF Import - Aspect not Found
    By mmuk08 in forum MIS Systems
    Replies: 1
    Last Post: 16th September 2008, 09:53 AM

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
  •