Exporting a SIMS report as a CSV (comma separated) file

There are two ways to create a CSV file from a report, this is usually to import or send the file where it is imported into third party software.

After creating the report, on the ‘Default output’ screen at the end of the report, select the Text option under Presentation, in the Format box selected Comma Separated.

Click the Browse button and find a location that you want to save the file, name the file in the format of test.csv and the screen should look like as below.

Click the Run button at the top of the screen and the file will now be created in the location you have specified.

Alternatively,

Output the report to Excel, click the Run button. After Excel loads, go to File > Save as and choose CSV from the file type list and save to a location of your choice.

 

Reviewed 29/7/20

How useful was this article?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

Similar Posts

Why is it important to know how many users connect to SIMS?

ByVerity.Ridge

Capita recommend that a Windows workstation running Windows 7 is suitable as a server for up to 5 users, due to the load that this puts on the machine. Scomis recommend that SIMS is made available to all teaching staff in a school, as it provides key up to date information for these staff about…

How can I run a Staff Training Report?

ByVerity.Ridge

This can be done one of 2 ways either by Staff or by Training Course By Staff Select Reports | Personnel | Staff Training Enter a Start Date & End Date. In the Selected Staffs panel click the New button and search for and staff you would like to report on Click the Open button….

Producing Attendance Reports – Quick Reference Sheet

ByVerity.Ridge

Producing Attendance Reports  – Attendance and Lesson Monitor. Producing Attendance Reports   Reviewed 29/7/20 How useful was this article? Click on a star to rate it! Submit Rating Average rating / 5. Vote count: No votes so far! Be the first to rate this post.

How do I change the Enrolment Status of a Student?

ByVerity.Ridge

Routines | Student | Change Enrolment Status select student and change the Enrolment Status.   Reviewed: 29/7/20 How useful was this article? Click on a star to rate it! Submit Rating Average rating / 5. Vote count: No votes so far! Be the first to rate this post.

Payroll2FMS – File not showing to import into Payroll2FMS.

Bykaren.brain

UPDATE: Version 1.1.0.42 has been updated to accept Office 2010 (xlsx) spreadsheets, this will require that the computer have Office 2010 installed. Payroll2FMS – File not showing to import into payroll2FMS. The Excel file has been saved in F:public\payroll2fms folder and can be viewed when in file manager but when importing by browsing to that…

How do I export the Certification Broadsheet Report?

ByVerity.Ridge

To export the Certification Broadsheet Report as a CSV file, 1. Select the criteria for the Certification Broadsheet. 2. Do not click on Print as you will not be able to view AND Export the Report. 3. To Export the Report, click on the Export button immediately after selecting the criteria. 4. Save file as…