Export Data By exporting data from a project, you can provide data to another application or user, or archive views and the data store at key points during an analytic workflow. You can export all or part of the project data at any time, including: Project Views All or part of a Table of the data on the canvas as a CSV or Excel file. The internal graph database from the Data Store subpanel: A data mapping created in the Mapping Editor as a JSON file using the Save Schema button. When you Clear data, exit a project or log out of GraphXR, saved data views and the internal database persist, but the graph on the project canvas and any snapshot views are deleted. To avoid losing work, save a view and/or export data when you come to a point in an exploration that you may want to re-visit. Export Project Views To export any view on the canvas: Export the current view as a CSV or Excel archive or .graphxr file from the Export menu at the top right of the project canvas. You can also export a static .png or or SVG screenshot from the Export menu. Export all saved data views in one step from the Data Store subpanel. Export a .graphxrsnapshots view archive from the Snapshots title bar. Export the current view You can export the current view on the canvas as a CSV or Excel flat file archive, or as a Kineviz .graphxr file. Export as a CSV or Excel archive creates in a collection of flat files, one for each category and relationship. A file for a category includes node IDs, properties and their values. A file for a relationship includes the node source and target IDs, and any edge properties and their values. Export as a .graphxr file retains the graph data as well as its 3D layout and perspective whether or not it is saved before export. A view that’s saved before export is named with the Project name, View name, and .graphxr extension. For example: Demo_Crime.graphxr A view that’s not saved before export is named with the_Project_ name, (nth view saved from the project), and .graphxr. For example, Demo (1).graphxr Consider saving a view before exporting it. This provides a descriptive view name to search for when importing the view. For a .graphxr file, when the saved view you exported is loaded to the canvas, and you then re-import the exported file, the view name and original date of creation is preserved. However, when imported into a new view, the original view name and date of creation are not preserved. To export the current view on the project canvas: Optionally, save the view, either as the existing view or a new view. In the Export dropdown menu at the top right of the canvas, choose from: CSV to export a CSV archive with a .zip extension: ProjectName_ViewName.zip Excel to export an Excel archive with an .xlsx extension: ProjectName_ViewName.xlsx .graphxr to export a .graphxr file: ProjectName_ViewName(or number).graphxr. The file name appears in the Downloads tab of your Chrome browser window. Once exported, you can import any of the views to another (or the same) project by drag and drop. Export all saved views in one step The Export All Views option in the Project > Data Store subpanel exports all your saved views in one step. Views are exported one by one as .graphxr files. To export all saved views in one step: Open the Project > Data Store subpanel. In the Utilities section at the top, click Export All Views. For each view, a .graphxr file is exported, labeled with the ProjectName and saved ViewName. Export a Snapshot view archive Snapshots provide a way to save a set of up to 10 views locally. For exploratory analysis, snapshots make it easier to return quickly to specific branching points in an investigation. Snapshot views are saved locally, not to the server. To save the snapshots you’ve created during a project session, you must export them as a .graphxrsnapshots view archive before you exit the project. For a .graphxrsnapshot archive, view metadata is preserved when you re-load the views. by default, the Snapshots feature is hidden. To display it, open the Project > Settings subpanel and Advanced Settings dropdown, and click the Show Snapshot checkbox. To export a snapshot view archive: Optionally, open the Snapshots window to review, annotate, or delete the snapshots created during the project session. Click the Save Snapshots button. You can click the export icon in the Snapshots title bar to export a snapshot archive without opening the window or reviewing its views. Export data from a table For any single category or relationship, you can export some or all of data that’s visible on the canvas as a table of nodes or edges and their property values. You can: Select data and export the results from a basic table. From a basic table, open an Enhanced Table to further select or edit the data before you export it. The exported file receives a default name based on the category or relationship label: Label(YYYY-MM-DD).xlsx or .csv For example, Location(2023-05-02).CSV contains a table of Location nodes exported on 2023-05-02. To export data from a basic table Select data on the canvas using any method, or de-select all data for tables of all the data. Open the Table panel. The Table > Category subpanel is open by default. It shows all the categories present in the current selection on the canvas (or all visible data if no selection has been made). Open the Table > Relationship subpanel to see all the relationships present, and click a relationship bubble to see its table. Select a table to export by clicking its category or relationship bubble: Optionally, enter a table Search term to find and select the table rows you want to export. Scroll to the bottom of the table and click Select All if you want to export only the rows returned by the search (if any). Click Export Excel or Export CSV to export the table of visible or selected data. The exported Excel file shown below includes only the selected table rows. Export the internal graph database The internal graph database is managed from the Data Store subpanel. To export the internal graph database: Open the Project > Data Store subpanel. In the Data Store section, select the Database Name for the instance you want to export (there may only be one default option). At the bottom of the section, click Export Database. The exported file is named DatabaseName__export (number).kuzu. For example, the second time you export the default database, the filename will be default_export(2).kuzu. Export a data mapping A data mapping is a graph schema for a single table that you define in the GraphXR Mapping Editor. A mapping is saved to the server and is available on the Mapping menu in the Query > CSV and Query > SQL subpanels. From there, it can be applied, edited, and saved as a new mapping. A CSV or SQL mapping is available to sharing users of the project and persists in a project until you delete the mapping (or the project). You may need to export a mapping to include it in a different project, or to maintain an archive on your local system. To export a mapping: Open the Query > CSV or Query > SQL subpanel. In the Mapping menu, select the mapping to export. Click Edit to display the Mapping Editor window. Click the Export Schema icon at the top left. The mapping is exported to your local system as a .json file named MappingName.json.