Educational ICT Virtualisation Specialist

Twitter LinkedIn E-mail
Precedence Technologies Ltd
Technology House, 36a Union Lane
Cambridge, CB4 1QB, United Kingdom
T: +44 (0)8456 446 800 / +44 (0)1223 359900
F: +44 (0)8456 446 899 / +44 (0)1223 359459
E: enquiries@precedence.co.uk
Users-SIMS

Jump To: Support > KB > NetManager > Users > SIMS

Exporting users from SIMS .net

Initial set up that needs to be done once only

  1. Launch SIMS .net
  2. From the Reports menu, choose Design Report
  3. Click on Create to create a new report
  4. Choose People > Student from the list of items and click Next>>
  5. Click Next>> on Based on Student On "Roll"
  6. On "Select Data Fields", go to Basic details and choose Legal Surname and click the right-hand arrow. Then click Legal Forename and click the right-hand arrow. Legal Surname and Legal Forename should be displayed in the right-hand box. Click Next
  7. On "Define Filter", click New. Select "Registration > Year Group" on the expanding list. Tick "Prompt at Run time". Click OK, then Next
  8. On Sort page, click Next
  9. On effective date, click Next
  10. On "Define presentations", click Text. Then check that "Comma separated" is selected. Tick "Allow these settings to be changed", then click Next.
  11. Click "Save my report" as "Export for network"

Exporting the data

  1. Choose Run Report from the Reports menu
  2. Choose "Export for network" from Report Browse and then click Run
  3. Select year group and make sure other year groups are unticked
  4. Browse to required location (e.g. your home area on the network or a USB pen drive) and enter a filename ending in .csv
  5. Click OK

Creating users

For Precedence to Create Users

  1. Save the exported .csv file to an area accessible by our engineers remotely.
  2. Email support@precedence.co.uk with the subject line <school name> New Intake File Location. In the body of the text, please state the location of your CSV file. DO NOT EMAIL THE .CSV FILE DIRECTLY unless instructed to do so.
  3. The requests will be processed on a "first-come, first-served" basis. Therefore, the sooner the file is made available to us, the higher the priority will be. We will endeavour to create all users by the end of August.

This is a standard service of our support offering. If you need a higher priority service, then a flat fee of 25 (plus VAT) would be payable.

To do it yourself

The CSV files from SIMS will need converting to the correct format with the simsname command. Its syntax is:

Syntax:  simsname [-s] [-f X] [-d X] <input> <output> [<password>] [<prefix>]
        -f = different format
                0 = <prefix><initial><surname> (e.g. 00jsmith) - default
                1 = <prefix><surname>_<initial> (e.g. 00smith_j)
                2 = <prefix><surname><initial> (e.g. 00smithj)
                3 = <prefix><initial of surname><counter> (e.g. 06s01)
                        <counter> is a count of how many times the initial
                        has been used
                4 = <prefix><initial of surname><first name> (e.g. 00sjohn)
                5 = <prefix><first name><initial of surname> (e.g. 00johns)
        -d = how to handle duplicates
                0 = use more letters from first name - default
                1 = add number at end of all but first duplicates
                        (e.g. 00jsmith and 00jsmith2)
                2 = add number at end of all duplicates
                        (e.g. 00jsmith1 and 00jsmith2)
        -s = skip first line (repeat to skip more lines)
        -h = this message

Click here for a transcript of simsname in use

The users can then be created on the NetManager and/or Active Directory.

© Copyright Precedence Technologies 1999-2017
Page last modified on January 05, 2016, at 11:31 AM by sborrill