Export log records to CSV
Sometimes you'll need the log data in another way than the FoolLog component can provide. This is where the CSV Export button is created for.
This function will generate a default CSV (text)file where you can set the delimiters and enclosed characters to your preferences. The format complies to the definitions as described on the Wikipedia page CSV (comma-seperated values).
When clicking the CSV Export button a popup window will appear that looks like this:
- Columns separated with
- Here you can set the field seperation character. Default it's a comma but if you need another character you can change it here.
- Columns enclosed with
- This is the character which will be used to enclose your field values. It's highly recommended to use this option because exported fields contain mostly more than one word. This option will keep it 'together' when exporting/importing.
- Columns escaped with
- This character is used to escape special characters used in the export fields. For instance the field: "Isn't exporting great?" will result in "Isn\\'t exporting great?" (assuming you're using the default escape characters).
- Put column names in 1st row
- Most of the import programs require a complete field naming list at the top of your CSV export file. It's default set to "Yes" so that's include by default. Select "No" if you want to leave the column export names out.
- Export 'extra' DB-field
- The FoolLog database table contains an extra information field with data which isn't fully shown in the backend view. Here you can choose to export that field to your CSV file.
- Export filename (readonly)
- This field only shows you the name of the CSV export file as it is used by the FoolLog component.
- Save path (readonly)
- This field shows you the save path used by the FoolLog component. This is the folder/directory where the FoolLogCSVExport.txt file is stored.
Export selection
The selection fields at the left of the popup window give you the abillity to choose what type of logs must be exported.
- Categories to export
- This is where you select what log categories you want to export. You can select multiple categories. Leaving this field empty will export ALL categories.
- Log types to export
- The log types can be selected for export. You can also select multiple log types but leaving this field empty will export ALL log types (if they are linked to the selected categories).
- Site End to export
- Here you can select to export only log records for the front-end or back-end. Leaving this field blank will export records for the front-end AND the back-end.
Leaving one of the fields empty means all types are exported depending on the previous selected field. For instance: when you select Content in the category field this will be the main field for the export query.
When you've also selected options in the log type field this field will be used for the second condition in the query. If no result is found for the Log type field only the export of the category values will be the result. The third query option used is the Site end field which only returns results in the front-end, back-end or both.
So, all that is left to do when you've set you export settings; click the 
button to start the export. After the export is succesfull you can download the CSV by clicking the 
button (the blue part of the button that is). If the Download CSV button is not shown you can try to refresh your webpage using F5 on your keyboard. The button still not visible? Than something has gone wrong with the export, please check folder rights on your website.