Exporting data
Txture offers a variety of options to retrieve data from its repository. Depending on your use case one of the following export options might be suitable for you:
- Exporting tables to CSV or Excel
- Retrieving up-to-date lists in CSV format via the API
- Storing images of visual reports (such as the dependency report or a tree report) in either PNG, PDF or SVG format
- Access to the API retrieving any detail about assets in Txture
Exporting lists to CSV or Excel
A very basic, yet ofter powerful way is a simple export of a table you created to a CSV or Excel file. For example you might want to export a list of all virtual servers tracked in Txture to an Excel file.
- In a first step, create a new table report via the "Reports" button in the main navigation.
- Add your assets using the query sidebar on the left with a proper restriction.
- Click on the
Menu
button in the upper right corner to reach the export menu. - Following the exporting documentation for more detailed information.
Retrieving up-to-date lists in CSV format via the API
This option is most useful if you want to further process date from Txture with another tool in an automated fashion. Txture can provide you with a stable URL at which an up-to-date CSV file is always available.
- In order for the CSV file to be available for non-human users (e.g. software) you will need to create an API token in the admin section.
- Starting off similarly as in the last example, you create a table report with a query suitable to your needs.
- Save the view, since it has to be persistently available.
- The
Menu
button in the upper right corner now offers to export this table view via the API. - The resulting dialog offers a view options. You can either select to export assets or links. At the very end of the dialog you are provided with a link that is static. If you use this link without the addition on an API token, it will only be accessible for already logged in users. If you want a URL that can be directly access, select the API token created in step 1 to be included in the URL. Please note that this allows anyone who gains access to the URL to use the API token to access Txture with the roles and permission granted to the API token.
Storing images of visual reports (such as the dependency report or a tree report)
All visual reports can be exported to three different image formats:
- SVG
- PNG
We advise to stick to SVG or PDF for most use-cases since those are vector-based formats and well suited both for on-screen and print reproduction.
- In a visual report (dependency report, tree report, aggregation report, waterfall chart) click on the
Menu
button in the upper right corner and selectExport
- The resulting modal dialog present a preview of the report
- Select a data format to download the report