Symptoms:
When we try to export a report to excel (.xml or .csv), the file is opens using other applications like Dreamweaver or any other HTML editing software, rather in Microsoft Excel or is also open on web browsers like Internet explorer, Firefox, Safari etc.

Resolution:

  • Change the excel export format from the User Preferences in Web TimeSheet,
  • Select Settings from the top menu.
  • Change Report Excel Export Format as required.
  • Click Save.
  • Change the file type association in Windows operating system,

Windows XP:

  • Open My Documents or My Computer from the Start menu.
  • Click on Tools on the menu bar.
  • Click on the Folder Options. A dialog box with tabs will appear.
  • Click on the File Types tab. Let Windows fill the information box.
  • Scroll to the file extension in question (.XML or .CSV).
  • Click the Change button.
  • Select Microsoft Excel from the list and then click on OK.

Windows Vista and Windows 7:

  • Open Default Programs by clicking the Start button and then Control Panel.
  • Select Associate a file type or protocol with a program.
  • Scroll down to XML and select it.
  • Click Change program. Windows will give you the suggested programs.
  • Select Microsoft Office or Microsoft Excel from the list and then click on OK.
  • Scroll to CSV and select it.
  • Click on Change program. Windows will give you the suggested programs.
  • Select Microsoft Office or Microsoft Excel from the list and then click on OK.