TUTORIAL: Exporting Data to Other Applications

  
Previous Top Next

Export Data

Select the "File" menu, then "Export Data".  A submenu then lets you choose to export the "Baseline Data" or the "Applicant Data" from the Campaign Database.  Select the Export option for Applicant Data.  You should still have the Sample Report Database open.  The Selection Window will look like the example below.  Select all of the Reports and Press the "OK" button.

Save Exported Data

After Selecting the Report Data to Export, you will be asked to create a File using the standard Windows Dialog like the example above


USING THE DATA IN OTHER APPLICATIONS

The Hire Success System exports the data in what is commonly called "ASCII DELIMITED" Text files.  It is one of the oldest, and most common forms of data import and export.   Some examples of Applications that will easily import this data include Microsoft Excel and Microsoft Access.  With data imported in other applications, you have the power and capabilities offered by these applications, such as sorting data, doing further analysis or even creating custom reports and comparisons.  The possibilities are endless.


STEPS FOR IMPORTING INTO MICROSOFT EXCEL: graphic

Open Excel, then choose the "File" menu, then "Open".  In the "Files of Type" drop-down menu at the bottom of the Dialog, choose the "Text *.prn, *.txt, *.csv" option.  Navigate to where you saved the Data, select the Hire Success Output file, then click the "Open" button.

Excel Wizard Step 1 of 3: 

Import Step 1

When you see the "Step 1" Wizard screen (like above, the "Delimited" buttons should be checked.  Leave it as-is and press the "Next" button.


Excel Wizard Step 2 of 3:

Import Step 2

On the second screen, be sure and select the "Tab" AND "Comma" check boxes.  You will see a sample of the data in columns in the lower part of the Wizard screen which will confirm the data has been selected properly.  Press the "Next" button.



Excel Wizard step 3 of 3: 

Import Step 3

The only thing to do on the Step 3 screen is press the "FINISH" button.

graphic

The Data will appear in the Spreadsheet so you can further analyze and manipulate the data.

graphic

You will notice that Hire Success creates the first row of data with the Field Names.  This is important when importing data into databases to match the Input Data with other fields that may already exist in the Application.  Some Contact Managers, like "Act", as well as Human Resource Database packages, etc., can match the Report Data with other Company data.  Ask your Database Administrator for more details.


            NEXT:                          TUTORIAL: Miscellaneous Tools and Functions

            PREVIOUS:                  TUTORIAL: Deleting Reports from a Database               


Hire Success is a Registered Trademark of Decision Support Technology, Inc.
and is Registered in the United States Patent and Trademark Office.

Copyright 1999-2008, Decision Support Technology, Inc.  All Rights Reserved.