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

Exporting users from SIMS (older version)

1. Go into SIMS Launcher and run STAR
2. Go to Reports menu, then Pupils sub menu and choose Alphabetical. Window with options will open
3. Click on magnifying glass icon at right next to year section. Window will open with all years listed on left.
4. Select year from list on left, then click choose (so it moves to right)
5. Click Update
6. Click OK. Pupils in selected year are displayed.
7. Hit second button from right (mext to printer button). This looks like a floppy drive with an arrow to the left. This opens a save window.
8. Choose a: from Drives Menu
9. From "Save file as type:" menu, choose "Comma separated files".
10. Give it a filename ending in .csv and click OK
11. To export a different year, close the pupil list and start again from the reports menu

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 September.

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 [-f <format>] <input> <output> [<password>] [<prefix>]
        -f = different format
                0 = <prefix><initial><surname> (e.g. 00jsmith)
                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)
        -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.