How to export data to a .csv spreadsheet fileIn many places you can download a data to a .csv file. A csv (comma separated values) file can be read by many spreadsheet programs, including Microsoft Excel.
- In the criteria area, put a check mark in front of the data that you want to see. Do not put a check mark in front of 'Actions'.
- Enter criteria values to limit the data you will see. Depending on the table that you are in, you can limit by Date, TeamID, User, etc.
- Select a Show value that will give you all the data that you are looking for.
- Click Show. Make adjustments as necessary to the criteria and click Show again.
- Click on the Download symbol
Depending on your computer desktop configuration, you will have the option to save the csv file or view the csv file in a spreadsheet application. Note: It may not be possible to simply load this data back up into the database. Some fields may be 'pointers' in the database. At this time (2009) the ability to bulk upload data into the database is restricted to the Administrator. |