Edjet Support

Edjet LMS Server 6.3

Export your data to CSV (Excel, Calc or other spreadsheet)

You can export your data from Edjet LMS to CSV file and then import the data into your spreadsheet like Microsoft Excel, LibreOffice Calc, or any other and create basically any advanced custom reports.

The main advantage of this approach, apart total freedom to create any report you need, is an option to combine data from multiple tables into one report.

To export your data in bulk to CSV file:

1. Navigate to any page with data table.
   Note: Now only selected components do support export.
2. Click Columns and enable columns you want to export.
3. Select rows you want to export using checkbox.
4. Click Export in the toolbar.
5. You can change mapping of exported data using Advanced export settings.
6. Click Export in the toolbar.
7. To confirm the data export click OK in the dialog.
8. You can review the Export results log.
9. To download the CSV file to your device click Download in the toolbar.

Import the CSV file into your spreadsheet software

Use import dialog in your spreadsheet software and set the import properties according to CSV file format:

• Encoding: UTF-8, LF
• Separator: , (colon)
• Text delimiter: none

For mode details follow your spreadsheet software manufacturer's instructions.

Troubleshooting export to CSV

If you have many rows to export (several thousands), select data in smaller ranges (up to 1000 rows) using the filter.