Plexus Connect - Exporting Your Data

In order to export the content of a table or a form, click the Export button on the top right side of the action bar of the application. Clicking this button opens the export panel, where you have to specify the fields to be exported and the file format of the exported data.

Export process steps:

  • Select fields for export

  • Reorder fields according to your preferences

  • Choose file format

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

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

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

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-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