Q: How can I export table data to CSV or Excel File Format.
A: Most data tables include a CSV button and an Excel button. The exported data will include “All” entries regardless of number selected in the Show entries drop-down list for the table.
CSV - The CSV button exports the data table to the CSV file format. If you intend to import data back into STRATUS, the file will need to be saved as a CSV file.
Excel - The Excel exports the data table to an Excel file. If you intend to import data back into STRATUS, the file will need to be saved as a CSV file.
To Export table data:
1. The CSV and Excel download data table buttons display on many STRATUS pages. Notice that Loaded entries inform you how many rows have loaded out of how many entries will be loaded.
2a. If you click either the CSV or Excel download data table button before all entries have been loaded, the following message will display.
2b. Generate - If the user clicks the Generate button, a partial file will download indicated with (Partial) in the file name.
2c. Cancel - Click Cancel to wait for all data table records to load.
3. The file will either download to your Downloads folder or you will be prompted for the output format.
3a. Open with - To Open with, select Open with radio button with Excel selected regardless of which button was clicked. If the CSV button was clicked in STRATUS, the file will open in the CSV file format. If the Excel button was clicked in STRATUS, the file will open in the Excel file format.
3b. Save File -To save the file, click the Save File radio button. If the CSV button was clicked in STRATUS, the file will save in the CSV file format. If the Excel button was clicked in STRATUS, the file will save in the Excel file format.
Download a CSV File - Click the CSV button. The CSV is downloaded and can be opened.Q: How can I Import CSV table data?
A: Many While many data tables can exported, only a few include an Import CSV button.
Admin > Company > Containers Example:
To export the Containers to CSV:
Assemblies > Dashboard