The 'View custom reports' tool allows the user to view and download any created custom report. The tool is available for “Browser” users (user level 1) and higher.
The tool opens with a list of all currently available report results in alphabetical order along with its creation timestamp and number of data rows.
A the front of the row is a radio button to select the (one) report to view and at the end a checkbox to include the report in the 'delete' action.
When “View report” is clicked the report results are retrieved from the database and converted to a table format. For very large reports the results are truncated at 5000 rows to prevent overloading the browser and prevent long upload times. A message is included at the bottom should the view have been truncated.
The link following the report allows the user to download the full results in CSV (comma-separated-values) format. The default separator is a comma. This downloaded csv file will not be truncated and uses the report name with the extension “.csv” as filename.
Download using URL
Created reports can be downloaded using the link at the top of the report view, but also using a web-address. By pointing the browser to this URL the report can be fetched directly from the server:
The csv download files are by default created using Unix newlines. To retrieve the csv file using the Dos carriage-return/newline append
&type=dos to the url.
The report name in the URL is not case sensitive and any extension provided will be ignored. If spaces are used in the report name, make sure those are substituted with
To retrieve 'dated' report results, include the desired date in the report name as is shown in the reports overview. However, if the date part of the name is omitted, and the report name without the date suffix does not exist, the LATEST of the dated reports of that name is returned. The filename will include the selected date suffix.
-- fetch the 'Domains' report https://genesis.netyce.org/report/Domains -- same thing https://genesis.netyce.org/report/domains.csv -- a dated report requested in Dos format https://genesis.netyce.org/report/Action_logs_by_date-20191226&type=dos -- will return the latest dated result report of 'Action_logs_by_date' (in dos) https://genesis.netyce.org/report/Action_logs_by_date&type=dos -- spaces must be replaced https://genesis.netyce.org/report/Report%20with%20Spaces
Download using API
Generated reports can also be retrieved using the NetYCE XCH API. Two API calls are available:
run_report. Both retrieve the requested report name in XML format but where the first retrieves an earlier retrieved report, the latte will first generate it before returning its results.
Details on these API calls can be found in YCE Exchange gateway and API