File Menu - Revision history

Kristina: /* Import from Project */

2015-02-17T13:58:02Z

Import from Project

← Older revision		Revision as of 13:58, 17 February 2015
Line 42:		Line 42:

	==Import from Project==		==Import from Project==
			<br>
	<ol>		<ol>
	<li>Select the project to be used as a source of data for import from a dropdown box.<br>		<li>Select the project to be used as a source of data for import from a dropdown box.<br>
	'''NOTE:''' Only those projects that are currently opened in '''ACD/Percepta''' are displayed in this list.		'''NOTE:''' Only those projects that are currently opened in '''ACD/Percepta''' are displayed in this list.
	<br>		<br><br>
	[[Image:import_project_step_1.png]]		[[Image:import_project_step_1.png]]
	</li>		</li>
	<br>		<br>
	<li>Drag all columns of the source project that you wish to be imported to the right-hand side pane.		<li>Drag all columns of the source project that you wish to be imported to the right-hand side pane.
	<br>		<br><br>
	[[Image:import_project_step_2.png]]		[[Image:import_project_step_2.png]]
	</li>		</li>
	<br>		<br>
	<li>Link matching columns between the source and destination projects. If both projects contain columns with identical names, these will be linked automatically. Otherwise, if certain columns contain the same kind of data, but are named differently, you will need to link them manually.		<li>Link matching columns between the source and destination projects. If both projects contain columns with identical names, these will be linked automatically. Otherwise, if certain columns contain the same kind of data, but are named differently, you will need to link them manually.
	<br>		<br><br>
	[[Image:import_project_step_3.png]]		[[Image:import_project_step_3.png]]
	</li>		</li>
	<br>		<br>
	<li>Specify whether the program should simply append the entries from the source project without any checking for possible duplicates, or merge the data from both source and destination projects with matching entries identified either by comparing values stored in a particular column or by molecular structure. In the latter case, a honeycomb diagram is displayed illustrating whether the central molecule would match (denoted by "=" sign) the molecules on the outside under the currently selected settings.		<li>Specify whether the program should simply append the entries from the source project without any checking for possible duplicates, or merge the data from both source and destination projects with matching entries identified either by comparing values stored in a particular column or by molecular structure. In the latter case, a honeycomb diagram is displayed illustrating whether the central molecule would match (denoted by "=" sign) the molecules on the outside under the currently selected settings.
	<br>		<br><br>
	[[Image:import_project_step_4.png]]		[[Image:import_project_step_4.png]]
	</li>		</li>
	<br>		<br>
	<li>Finally, if "Merge" import type was selected on step 4, several additional options specifying how to deal with missing or overlapping values need to be set. This window also presents a schematic diagram illustrating how the resulting project would look like if the example data shown above would be merged under the currently selected settings.		<li>Finally, if "Merge" import type was selected on step 4, several additional options specifying how to deal with missing or overlapping values need to be set. This window also presents a schematic diagram illustrating how the resulting project would look like if the example data shown above would be merged under the currently selected settings.
	<br>		<br><br>
	[[Image:import_project_step_5.png]]		[[Image:import_project_step_5.png]]
	</li>		</li>
	</ol>		</ol>

Kristina at 14:50, 12 December 2014

2014-12-12T14:50:00Z

@@ Line 1: / Line 1: @@
-[[Image:Spreadsheet_file_menu.png]]
+[[Image:Spreadsheet_file_menu_v2014.png]]
-# '''New''' – Opens a blank spreadsheet.<br><br>
+|}
-# '''New from filtered''' - Transfers the rows visible under current filter conditions to a new spreadsheet project.<br><br>
+</li>
-# '''Open''' - Opens any of the previously saved “Chemical Spreadsheet” (CHS) files.<br><br>
+<br>
-# '''Save''' - Saves the active spreadsheet with its current filename and location on the hard drive.<br><br>
+<li>'''Open''' - Opens any of the previously saved “Chemical Spreadsheet” (CHS) files.<br><br></li>
-# '''Save As''' - Saves a copy of the active spreadsheet under the user-defined filename and location on the hard drive.<br><br>
-# '''Close''' - Closes the active spreadsheet. A message box will prompt the user to save the active project.<br><br>
+<li>
-# '''Import''' - Imports data to the active spreadsheet. The supported file formats include single structure files (CDX, MOL, SK2, and SKC), multiple structures files (SDF, RDF), as well as tab-delimited text (TXT) or comma separated value (CSV) files with chemical structures as SMILES strings. <br> '''NOTE:''' Importing new data to the open spreadsheet will append all the structures from a new data source. All the columns in the original spreadsheet associated with modules available in '''ACD/Percepta''' (i.e., the ones calculated from within the program) will be automatically populated with the calculated corresponding property values for the new appended molecules. <br><!--''See also [[Starting#How to import data into a spreadsheet?|How to import data into a spreadsheet?]]''--><br>
+{|
-# '''Export''' - Allows export of the contents of the current spreadsheet to an SDF, RDF, TXT, CSV, or XLS formats. <br> '''NOTE:''' All the compounds in the active spreadsheet are exported, regardless of any filters applied at the moment of data export making some of the rows invisible.<br />
+|[[Image:File_menu_save.png]]
 <br />

Kristina: Created page with "Image:Spreadsheet_file_menu.png # '''New''' – Opens a blank spreadsheet.

# '''New from filtered''' - Transfers the rows visible under current filter conditions ..."

2012-07-04T13:15:12Z

Created page with "Image:Spreadsheet_file_menu.png # '''New''' – Opens a blank spreadsheet. # '''New from filtered''' - Transfers the rows visible under current filter conditions ..."

New page

[[Image:Spreadsheet_file_menu.png]]

# '''New''' – Opens a blank spreadsheet. 
# '''New from filtered''' - Transfers the rows visible under current filter conditions to a new spreadsheet project. 
# '''Open''' - Opens any of the previously saved “Chemical Spreadsheet” (CHS) files. 
# '''Save''' - Saves the active spreadsheet with its current filename and location on the hard drive. 
# '''Save As''' - Saves a copy of the active spreadsheet under the user-defined filename and location on the hard drive. 
# '''Close''' - Closes the active spreadsheet. A message box will prompt the user to save the active project. 
# '''Import''' - Imports data to the active spreadsheet. The supported file formats include single structure files (CDX, MOL, SK2, and SKC), multiple structures files (SDF, RDF), as well as tab-delimited text (TXT) or comma separated value (CSV) files with chemical structures as SMILES strings. '''NOTE:''' Importing new data to the open spreadsheet will append all the structures from a new data source. All the columns in the original spreadsheet associated with modules available in '''ACD/Percepta''' (i.e., the ones calculated from within the program) will be automatically populated with the calculated corresponding property values for the new appended molecules.  
# '''Export''' - Allows export of the contents of the current spreadsheet to an SDF, RDF, TXT, CSV, or XLS formats. '''NOTE:''' All the compounds in the active spreadsheet are exported, regardless of any filters applied at the moment of data export making some of the rows invisible.

File Menu - Revision history

Kristina: /* Import from Project */

Kristina at 14:50, 12 December 2014

Kristina: Created page with "Image:Spreadsheet_file_menu.png # '''New''' – Opens a blank spreadsheet. # '''New from filtered''' - Transfers the rows visible under current filter conditions ..."

Kristina: Created page with "Image:Spreadsheet_file_menu.png # '''New''' – Opens a blank spreadsheet.

# '''New from filtered''' - Transfers the rows visible under current filter conditions ..."