+ Post New Thread
Results 1 to 4 of 4
How do you do....it? Thread, EasyTrace - importing users via CSV in Technical; We have made the switch from SIMS to Bromcom MIS, and I have come unstuck with Easytrace. Obviously, it's not ...
  1. #1

    Join Date
    Apr 2007
    Location
    Huntingdon
    Posts
    16
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Question EasyTrace - importing users via CSV

    We have made the switch from SIMS to Bromcom MIS, and I have come unstuck with Easytrace. Obviously, it's not integrated with BackOffice, and so I was wondering about exporting a CSV from Bromcom to import new customers 'manually' into EasyTrace. Does anyone have any experience of this? I see it's an option, but I don't know what columns I need to include...

    Any thoughts please?

    Thank yoooo!

    Jon

  2. #2
    JohnCondon's Avatar
    Join Date
    Apr 2007
    Location
    Bromcom
    Posts
    283
    Thank Post
    47
    Thanked 64 Times in 41 Posts
    Rep Power
    26
    Good Morning Jon,

    This is something that the helpdesk should certainly be able to assist you with. Even if your query is on the EasyTrace side with which columns to include for that import to work, we have had experience in dealing with these guys before.

    So if you don't get any immediate joy from here (although I expect you will get a significant number of offers to assist, these guys and girls are great that way) then call the Helpdesk on 020 8695 8077 and they will be more than happy to assist.

    Regards
    John

  3. Thanks to JohnCondon from:

    Easytrace (14th June 2011)

  4. #3

    Join Date
    Jun 2011
    Location
    Abingdon Oxfordshire
    Posts
    2
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by JohnCondon View Post
    Good Morning Jon,

    This is something that the helpdesk should certainly be able to assist you with. Even if your query is on the EasyTrace side with which columns to include for that import to work, we have had experience in dealing with these guys before.

    So if you don't get any immediate joy from here (although I expect you will get a significant number of offers to assist, these guys and girls are great that way) then call the Helpdesk on 020 8695 8077 and they will be more than happy to assist.

    Regards
    John
    @JohnCondon

    Thanks for the referal. The helpdesk number is 08450 714 667.

    @saintoctopus: There is a CSV standard template for importing student and/or staff details into Easytrace. The headers follow below.

    Surname | Forename | Title | Admino | RegGroup | YearGroup

    Where the AdminNo represents the unique person number from Bromcom. Obviously for Students Title fields can be left blank. For Staff the recommended standard is 'ST' for YearGroup and 'Staff' for RegGroup. If however you would like to adopt a different standard the software can handle that too, as long as its unique (i.e. not the same as any of the Student reg or year groups).

    Once the csv has been formatted to these standards in excel you can save it as MSDos csv. This ensures any excel formatting is stripped out. You can then go to Easytrace and click on Tools > Import > From CSV Format > Customers and Cards from CSV (Any Custom Format)

    You can then browse to your csv (making sure that it is closed first - If you have it open you will get an error: Access to that file was denied by operating system) and map the fields from your csv to Easytrace. The software will make educated assumptions on fields. But in case you hve mis-spelled a header you can still drag and drop from the left pane to the right, the fields tht don't match. When you click 'OK' the software will do the rest.

    Really hope this helps with your query.

    Regards

    Easytrace Support Team

  5. #4

    Join Date
    Jan 2010
    Posts
    101
    Thank Post
    0
    Thanked 7 Times in 7 Posts
    Rep Power
    11
    also have a look at groupcall exporter - softlink use it with easytrace to import card csn info from a csv from easytrace which is made every night at 00:00 to oliver v5 sql

  6. Thanks to lordasb from:

    Easytrace (15th June 2011)

SHARE:
+ Post New Thread

Similar Threads

  1. MRBS - Import .CSV isn't importing my room bookings
    By princessbucki in forum How do you do....it?
    Replies: 0
    Last Post: 26th August 2010, 11:28 AM
  2. Importing Users
    By itgeek in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 22nd March 2010, 08:35 AM
  3. Importing new users into Active Directory
    By Mr_M_Cox in forum How do you do....it?
    Replies: 16
    Last Post: 4th November 2008, 11:36 AM
  4. CSVDE importing users into groups
    By markman in forum Windows
    Replies: 2
    Last Post: 8th November 2007, 02:46 PM
  5. Recommendations for importing users into Moodle
    By Ric_ in forum Virtual Learning Platforms
    Replies: 6
    Last Post: 9th October 2006, 10:49 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
  •