Plexus Connect - Exporting Your Data

    In order to export the content of a database, click the Export button in the top-right part of the action bar of the application. Clicking this button opens the export panel, where the list of all fields belonging to the current datatree appears. In this list, you have to specify the fields to be exported by clicking the corresponding checkboxes.

    images/download/attachments/13109212/Connect-export1.gif

    In the version 21.2.0, the Select field icon ( ) has been implemented to simplify field selection for export. After clicking the Select field icon, a field for export can also be added by clicking the preferred field in a widget of a form view, respectively, in a column of a grid view (table). The selected fields are automatically marked in the list of fields in the export panel.

    In the next step, the previously selected fields can be rearranged by using drag and drop and the file format of the exported file needs to be selected from the dropdown menu.

    Data in tables or forms can be exported to a variety of file formats:

    • ChemAxon MRV format (.mrv)*

    • MDL SDF file (.sdf)*

    • MDL RDF file (.rdf)*

    • Tab separated text (.txt)*

    • JChem for Excel with structures (.xlsx)*

    • Microsoft Excel with structure images (.xlsx)*

    The actual list of available file formats depends on the type of data in a particular table or form. If the structure field is not part of the selection then only the non-chemical file formats such as Tab separated text (.txt) and Microsoft Excel (.xlsx) are available.

    In the case of a molecule table , the records can be exported to:

    • ChemAxon MRV format (.mrv)*

    • MDL SDF file (.sdf)*

    • Tab separated text (.txt) * where the structures are represented by their SMILES strings

    • JChem for Excel with structures (.xlsx)*

    • Microsoft Excel with structure images (.xlsx)*

    In the case of a reaction table , the records can be exported to:

    • ChemAxon MRV format (.mrv)*

    • MDL RDF file (.rdf)*

    • Tab separated text (.txt) * where the reactions are represented by their SMILES strings

    • JChem for Excel with structures (.xlsx)*

    • Microsoft Excel with structure images (.xlsx)*

    In the case of a query structure table , the records can be exported to:

    • ChemAxon MRV format (.mrv)*

    • MDL SDF file (.sdf)*

    • Tab separated text (.txt) * where the reactions are represented by their SMARTS strings

    • JChem for Excel with structures (.xlsx)*

    • Microsoft Excel with structure images (.xlsx)*

    In the case of Markush libraries , the records can be exported to:

    • ChemAxon MRV format (.mrv)*

    • MDL SDF file (.sdf)*

    • Tab separated text (.txt) * where the reactions are represented by their ChemAxon Extended SMILES strings

    • JChem for Excel with structures (.xlsx)*

    • Microsoft Excel with structure images (.xlsx)*

    Exporting relational data

    With Plexus Connect, you can also export complex relational data into each supported file type. Thanks to Filtering child data capability, Plexus Connect allows to export only relevant child data records that fit to the definition set in the filter.

    Export without child data filtering Export with child data filtering
    images/download/attachments/13109212/Connect-export2.gif images/download/attachments/13109212/Connect-export3.gif
    In the case of a One-to-Many relationship, when exporting child data and child data filtering is turned off, the root entity's record will be repeated for each record in the child entity. Result .sdf after filtering BIO.CELL contains L929 cell with child data filtering OFF Wombat (compound view) compounds (FilterChildOff).sdf In the case of a One-to-Many relationship, when exporting child data and child data filtering is turned on, root entity's record will not be repeated . Only those root entity's record with corresponding filtered child data will be exported. Result .sdf after filtering BIO.CELL contains L929 cell with child data filtering ON Wombat (compound view) compounds (FilterChildOn).sdf
    images/download/attachments/13109212/Connect-export4.gif images/download/attachments/13109212/Connect-export5.gif

    Printing

    Print feature enables you to generate a PDF document which can be paper printed. The printed representation of the information is often more restrictive than exploring your data in a form or grid view. For instance, you can't use scroll bars in a printout. For this reason, all the columns presented in the grid view or table widget are squeezed on the printed page. Page breaks are added between rows, so that better readability is achieved, printing the content over multiple sheets.

    Printing functionality is available under the Print button on the top right side of the action bar.

    There are two printing options offered in the printing dropdown menu:

    • Fit rows to table height option will print out only those child data, which can fit into their table widget.

    • Print all rows option will print out all child data, even though it might overflow widget size.

      Fit rows to table height Print all rows
      images/download/attachments/13109212/print-fit_to_widgets.pdf_-_Adobe_Acrobat_Reader_DC.png images/download/attachments/13109212/print_all_data-print.pdf_-_Adobe_Acrobat_Reader_DC.png