1. Create new project containing demo data

See here for how to create a new project. Choose the project template for IJC Project (local database with demo data). This will create you a new project containing a local database with some sample data that has already been loaded into the database and some grid views and form views generated ready for you to use.

2. Explore the demo data

Go to the projects windows and find the 'Pubchem demo' data tree, and under that find the 'Grid view' view. Double click on this to open it. The grid view will open in the main window. The grid view is IJC's spreadsheet-like view. Try the following with this data:

1. Use the vertical scrollbar to move through the data

2. Move columns to new locations by dragging on the column header

3. Resize columns and rows by dragging on the borders in the column and row headers.

4. Sort the data by right clicking on the column header of a column and choose 'Sort ascending' or 'Sort descending'

5. Run a query on the data by switching to Query mode using the button in the toolbar and then specifying some query terms. For instance search for structures containing pyridine as a substructure and have a MolWeight less than 400. You should get 22 hits.
   Now find the 'Wombat (compound view)' data tree in the projects window, and under that find the 'Wombat compounds' form view. Double click on this to open it. The form view will open in the main window. The form view is IJC's forms tool that allows you to build more detailed reports of the data and is usually used for displaying a record-by-record view of the data. Try the following with this data:

1. Navigate through the records using the navigation tools in the main toolbar. Also try using the Page Up and Page Down keys on the keyboard.

2. Sort the data by selecting a widget on the form (e.g. Mol Weight) and using the 'Sort ascending' or 'Sort descending' buttons in the main toolbar.

3. Run a query on the data by switching to Query mode using the button in the toolbar and then specifying some query terms. For instance search for structures containing pyridine as a substructure and have a MolWeight less than 400. You should get 14 hits.

3. Import your own SD file

Now lets see how you can import your own file and see its contents. Detailed help on file import can be found here , but briefly:

1. Find the localdb schema node in the projects window, right click on it and choose 'File Import...'. The file import wizard will open.

2. Select the SD file you want to import by clicking on the file open button in the top right hand corner. The file will be read and the appropriate settings made. This of course depends on the contents of the file you are importing.

3. Click the 'Next' button to go to the next step.

4. This step lets you fine tune the settings for how each field is to be handled. Lets assume the defaults are OK so click the 'Next' button again.

5. The import will start. When complete click on the 'Finish' button and the imported data will be opened in a grid view.

6. Explore the contents using the grid view.

7. Look at the contents of the projects window to see how your imported file has been incorporated into the localdb schema.
   The success of the import will of course depend on the contents of the file that is being imported. If you have trouble with your file try using a sample file (nci_drugs.sdf, containing approximately 11,000 structures) which is known to import without problems. Download and unzip the file and then import it as described above. The file can be downloaded from here.