Importing data from a “Formatted” spreadsheet will import back into the original aspects and result sets that were contained when the data was previously exported. Importing data from an “Un-formatted” spreadsheet will require user input to map the columns of the spreadsheet to the aspects and result sets in SIMS. If the spreadsheets are exported…
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…
Individual reports that previously worked in Office 2003 will not run correctly in Office 2010. There is a work around for this: File Options Trust Centre Trust Centre Settings Macro Settings Check to make sure “Enable all Macros” is selected File Options Trust Centre Trust Centre Settings Privacy Options Under Document specific settings make sure…
To format the date in the report as required after export to excel, please follow the below mentioned steps: Select the column with the dates in the Excel spreadsheet. Select Data tab on the menu bar and click the button that says ‘Text to Columns’. A wizard will now appear. Select ‘Delimited’ in Step 1 click ‘Next’,…
Before setting the password it is important to remember that if you lose or forget the password, it cannot be recovered. Also remember that passwords are case sensitive. Click the File Button , click Save As, and on the bottom of the Save As dialog, click Tools. On the Tools menu, click General Options. Under File…
The inbuilt Attendance and Lesson Monitor reports are designed to output to a web browser such as Internet Explorer. It is possible to export the data from the web browser to Microsoft Excel. After running your report it will open a new window and you will see your information. If you right click on the…
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…
When report is run the date of birth will show i.e 21st January 2001 would like the format to be 21/01/01. To format the date in the report as required after export to excel, please follow the below mentioned steps: 1. Select the ‘DOB’ column in the Excel report output. 2. Go to Menu Data…
When saving reports from Sims .net the edit options such as Data sort are greyed out – this is in Excel 2010. If the header bar, besides giving the file name, also says Group:- 1. Right click on the ‘Sheet 1’ tab at the bottom 2. Choose Ungroup KB6568 Reviewed 29/04/2015
Can i set a password on a spreadsheet?