FAQs: Imperial College Analytics (ICA)
Frequently asked questions (FAQs) on ICA for staff
Why does ICA reject my password?
ICA can only support alpha-numeric passwords with basic punctuation. If you are unable to login to ICA, it may be because your password contains one or more unsupported characters. Try changing your password to resolve the issue.
It is possible to meet the criteria for our password security requirements without using unsupported characters.
Missing headers in Internet Explorer 7
Some users have reported that they lose the headers (such as Dashboard) when using the web browser Internet Explorer 7, meaning that they cannot access their reports. This is a caching issue in Internet Explorer and you can solve this problem by following these steps:
- Press the F12 button on your keyboard to display the IE Developer Tools window.
- Select Cache and then Clear browser cache from the menu.
Problems exporting ICA data to Microsoft Excel 2007+
Within ICA you have the option to explort your data to Microsoft Excel 2007, but when exporting to this format the date fields are not recognised as dates. As a result, it is not possible to sort these columns without modifying the data in Excel.
You can export the data to Excel 2003 if you wish to sort using the date field in Excel. This file can then be saved as an *.xlsx file later if required.
Sorting options in Excel
- When sorting, Excel 2007+ only gives the option of A-Z.
- When sorting, Excel 2003 gives the option of oldest to newest.