Copyright: Advanced System Technologies Ltd.


Contents

Introduction

Start Window

Wizard Window 1

Wizard Window 2

Wizard Window 3

Wizard Window 4

Wizard Window 5

Wizard - Run Options Window

Save Templates Window

Main ADAPT/PC-DataScan WindowSelect Files to Analyze Window

Date Formats Window

Scope Window

Command Line Switches


Introduction

What is ADAPT/PC-DataScan?

ADAPT/PC-DataScan is an easy to use program which searches PC, midrange and mainframe databases, spreadsheets and other file types, identifying any data that seem to contain dates which are NOT Year 2000 Ready. The Year 2000 Readiness is determined by a set of user-defined and/or predefined search criteria.

This ensures that real data is factored into compliance checking processes.

Business Benefits

•	Improved Coverage - Most Year 2000 compliance processes have concentrated on structural tests, checking the source code of computer programs and other structures or processes, which may lead to the creation of non-compliant dates. These checks are clearly essential. If used in isolation they are to an extent hypothetical and incomplete since they ignore the end product of these processes - the business data. ADAPT/PC-DataScan therefore compliments these checks and can be used stand-alone or in conjunction with any existing tools.

•	Long Shelf Life - Whether an individual PC user or a major corporation, ADAPT/PC-DataScan Clients find the tool useful throughout the Year 2000 compliance process, from initial impact analysis through ongoing and final compliance verification and beyond. ADAPT/PC-DataScan can also be used to search for other (non-date) values.

•	Regular Health Checks - ADAPT/PC-DataScan can be continually optimized and re-run to check the compliance of new and updated operational systems used together with backups it is useful in providing regular or periodic health checks. This includes an entire drive scan option similar to the approach used by current virus checkers.

•	Easy to Use - ADAPT/PC-DataScan supports Wizard, Advanced and Unattended execution modes. The Wizard guides the user through all set-up and execution steps, accompanied by explanatory text and notes. The Wizard can be used for initial tutorial sessions or for end users uncomfortable with technology or unfamiliar with the tool. In Advanced mode, ADAPT/PC-DataScan provides the user with more rapid access to the search definition facilities. Full Windows context-sensitive help is provided throughout.

•	Open and Scalable - ADAPT/PC-DataScan is usable on all platforms from a single PC to large corporations with multiple mainframe, midrange, mini and PC environments.

•	EDI and External Data Partner Support - Often ignored EDI message data is as critical as that held in mainstream databases. ADAPT/PC-DataScan can be configured to search entire EDI message strings (and, indeed, the other forms of unstructured text and strings frequently used by external data and mailing list providers).

ADAPT/PC-DataScan - Feature Highlights

Extensive, User-Definable Search Criteria

ADAPT/PC-DataScan allows the user to create, store and recall multiple sets of search criteria as search Templates. A sample database is shipped with the product and can be used for tutorial purposes. Templates include user selections for:

•	Databases and spreadsheets to check

•	Predefined date formats to check

•	Additional user defined values to check

•	Further inclusion / exclusion criteria

User Defined Date Format Searches

In addition to many pre-defined date formats, ADAPT/PC-DataScan supports the entry of user defined date formats, catering for system and Client-specific needs. Examples might include 090999, often used in legacy systems to indicate end of file and 999999, frequently used to indicate infinity.

Predefined Date Formats

The user can choose ADAPT/PC-DataScan predefined date formats, each of which may be included or excluded as required, via ADAPT/PC-DataScans Template configuration facilities.

Multiple Execution Modes

Advanced users and system administrators configure ADAPT/PC-DataScan via switches (at both a command line and default file level).

Results Management

Running a search produces a list of records/rows which contain potentially non-compliant dates. Analysis information includes:

•	Number of records/rows searched

•	Ratio of records/rows passing/failing tests

•	Percentage of records searched

•	Minimum/maximum years found

•	Field/column type

•	Date Format believed detected

•	Date last modified

•	File size

The minimum reportable percentage of records containing these invalid dates, together with the minimum two digit value to be considered as a year can be configured within the Template facility. The number of records/rows to be checked per file can be configured via the Template facility, offering control over the trade-off between speed of execution versus depth of coverage. This may be continually fine-tuned to achieve the required balance.

Once ADAPT/PC-DataScan has been used to identify the potential scale of the problem, further support is provided for verification and reporting including:

•	Graphical display of summary information

•	Output to screen, structured text file and comma delimited .CSV file enabling export to EIS / OLAP tools, spreadsheets and word processors for statistical analysis and reporting

•	Copy to clipboard option

•	Built-in record browser for further verification

Why Do I Need to Use ADAPT/PC-DataScan?

The Year 2000 bug, as it is often called, relates to the storage and processing of dates that contain a year expressed with only two characters (e.g. 97). Computer programs that carry out date related calculations (e.g. accounting systems, insurance systems, schedulers, etc.) might produce incorrect results and in severe cases actually fail to function on or even BEFORE January 1, 2000.

To briefly explain why this may happen consider the following:

An accounting system produces a report showing the top 100 customers based on the last five years sales. It does this by taking the current year, subtracting 5 and totaling all invoices with an invoice date whose year is equal to or greater than the calculated year.

Consider the following example that occurs BEFORE January 1, 2000:

CURRENT DATE  = February 15, 97

INVOICE DATE = March 12, 93

Subtracting 93 from 97 would yield a result of 4, within the 5 year limit, causing the invoice to be INCLUDED.

Now consider an example AFTER January 1, 2000:

CURRENT DATE = January 2, 00

INVOICE DATE = December 15, 99

Subtracting 99 from 00 would yield a result of -99!

This would either cause incorrect results or complete program failure.

Computer systems are made up of two main components: programs and files/databases. Programs are used to manipulate the data that is stored in files/databases. Therefore there are two areas to be identified as having a potential problem in the Year 2000 and beyond - programs and data. ADAPT/PC-DataScan can help to identify those potential problems in the actual data stored within your files and databases. Data is the common denominator in computer systems as the results of most computer programs are usually stored within the files/databases for later use. It therefore makes sense to start by trying to locate the files and databases that contain dates with only two character years. ADAPT/PC-DataScan is designed to help you achieve this.

Once you have located the potential problem areas you can use the multitude of information that ADAPT/PC-DataScan provides to decide whether each particular file/database is likely to cause a problem. (For example you may store dates in a particular file that are only used for information and never used in calculations so you may not need to carry out any further work).

What Do I Do When I Find Potential Problems?

First consider the source of the potential problem.

Spreadsheets

You will need to review each spreadsheet separately. If the dates in the spreadsheets cells are not used for calculations and an external program does not reference them, then you may be able to continue using the spreadsheet successfully after January 1, 2000. One option to help confirm this is to take a copy of the spreadsheet and enter some dates in the year 2000 to see what effect they have on the spreadsheet. Remember to try all macros and to check the results of any functions/formulas that may reference the particular cells.

Another potential problem may occur when sharing data with other users who use a different version of the same spreadsheet package or a completely different spreadsheet package. If, for example, you exchange data between Excel and Lotus 123 Release 5 then dates entered as 01/01/00 in Excel will be stored as January 1, 2000 but the same date entered in Lotus 123 will be stored as January 1, 1900 unless entered as 01/01/2000. Therefore, it is important to change the dates in all spreadsheets so that they are formatted as a four character year. Then the changes must be tested to see how they affect any formulas, macros, etc.

Note: If the short date style in windows is set to use a two character year then some dates will only be displayed with a two character year even if they are keyed with four.

You will find many articles explaining how each version of the most common spreadsheet packages are affected on the Internet. It is worth spending some time becoming familiar with this before attempting to address any potential issues.

Databases

Databases can pose more of a problem.

The table below suggests possible actions depending on the type of program that is using the database in question:

Program Type	Possible Action
Off the Shelf Application	Contact your supplier for advice, there may be an upgrade option. Remember that if you upgrade, your data (including backups) may need to be converted.
Off the Shelf with modifications	Contact whoever modified the application for advice. If they are no longer available seek help from a qualified consultant.
In-house developed PC application	A full impact analysis will be required, preferably by the original developers.
The most important thing to do when you have identified all the potential problem areas is to prioritize the work. Many of the systems that have been identified may be less critical to your day to day business operation. If there is a workaround in the event that particular application should, then that application should be put at the back of the queue. Concentrate on those applications that simply MUST be working for your business to survive.


Start Window
The ADAPT/PC-DataScan Start Window

The ADAPT/PC-DataScan startup window has four options: Register, Start Wizard, Advanced and Exit.

If this is the first time you are running ADAPT/PC-DataScan and it is an unregistered copy:

Click on the Register button and continue to the next section titled Register Option.

If you are a New User to ADAPT/PC-DataScan and this is a registered copy:

Click on Start Wizard button and skip to the section titled Wizard Option.

If you are familiar with ADAPT/PC-DataScan and would like to skip the wizard screens and go directly to the ADAPT/PC-DataScan main screen:

Click on the Advanced button and skip to the section titled Advanced Option.

REGISTER Option

The first time ADAPT/PC-DataScan is started the Register button will appear as an option in the startup window. An unlock code obtained from your ADAPT/PC-DataScan supplier when purchasing ADAPT/PC-DataScan licenses must be entered to Register the program.

Wizard Option

START WIZARD	This option is recommended for new users.

The Wizard option will start the ADAPT/PC-DataScan wizard who will guide you through the steps required to run ADAPT/PC-DataScan and analyze your PC or server.

Click on the Start Wizard button to start the wizard.


Register Window

Registering ADAPT/PC-DataScan

From the Register window:

1	Fill in the NAME and REGISTRATION CODE fields.

The information in these fields must match exactly with the name and unlock code obtained from your ADAPT/PC-DataScan supplier.

2	Click the REGISTER button. A thank you message will appear.

3	Click the OK button.

4	The program will close. Restart the newly registered version of ADAPT/PC-DataScan by double clicking on the ADAPT/PC-DataScan icon on your desktop.


Wizard Window 1

The first wizard window introduces the ADAPT/PC-DataScan wizard and allows you to enter information to identify the PC or server to be analyzed.

Unique Name

•	This name is used to identify the computer on the result screens, reports and in the output file. Choosing a unique, meaningful name is important in helping to identify which PC or server the results relate to when analyzing the accumulated output from multiple PCs and servers.

•	The name can also be used in other products to provide a unique key to allow further analysis.

•	The name is used as the name of the output file created by ADAPT/PC-DataScan for displaying the analysis results for this PC or server. This easily identifies the report file for each PC or server within one network directory when analyzing multiple servers and PCs.

Type of Computer

•	As with the identifying name above, the type of computer selected here is written to the ADAPT/PC-DataScan output file and is used to help group similar computer types together. Click on the required option and when selecting Other as the computer type enter a meaningful name such as 'MAINFRAME' or 'AS/400'

Continuing from the Wizard Window 1

Choose one of the following options:

Advanced	Click on the Advanced button to exit the wizard and go directly to the main ADAPT/PC-DataScan window.

Next	Click on the Next button to proceed to the second wizard window.

Finish	Click on the Finish button to exit the wizard and go directly to the main ADAPT/PC-DataScan window keeping any settings entered within the wizard.


Wizard Window 2

The second wizard window allows you to select the type of databases to scan and analyze.

Local PC File

•	Choose Local PC File(s) to scan PC databases on the local PC as well as network drives connected to the PC.

ODBC Data Source

(This option is not available without purchasing a ADAPT/PC-DataScan ODBC license. To obtain the license please see the section on Obtaining the Unlock Code earlier in this manual).

•	Choose ODBC Data Source to scan remote databases connected to the PC via ODBC.

Enter the name of the Data Source in the box provided

Continuing from the Wizard Window 2

Choose one of the following options:

Advanced	Click on the Advanced button to exit the wizard and go directly to the main ADAPT/PC-DataScan window.

Back	Click on the Back button to return to the first wizard window.

Next	Click on the Next button to proceed to the third wizard window.

Finish	Click on the Finish button to exit the wizard and go directly to the main ADAPT/PC-DataScan window keeping any settings entered within the wizard.


Wizard Window 3

The third wizard window allows you to customize your search by selecting drives, directories and file types. It is available only when the Local PC Files(s) option is selected in the second wizard window.

Searching Specific Drives and Directories:

Drives

Selecting a specific drive to search:

1	In the Drives: section - Click on the down arrow to open a drop down list of available drives.

2	Click on the desired drive letter. Directories within that drive will be available in the Directories: section of the window.

Directories

To select specific directories to search:

Selecting a directory:

1	Double click on the directory you wish to select.

All files matching the criteria in the File Types: section within that directory will be listed in the File Name: list section of the window.

Selecting a directory and its subdirectories:

1	Double click on a directory

2	Click on the directories scan button [image] to select a directory including all of its subdirectories.

This option will automatically scan the directory and all of its subdirectories placing the results in the Current Selections: section of the window.

Selecting an entire drive to search:

1	Select the desired drive in the Drives: section of the Window.

2	Double click on the root directory of the drive in the Directories: section of the Window. (For example: C:\ )

3	Click on the directories scan button [image].

This option will automatically scan the drive and all of its subdirectories placing the results in the Current Selections: section of the window.

Searching for Specific Database File Types:

File Types

The File Types: section of the window shows the types of database files that will appear in the File Name: section of the window when the drive and directory are selected. These files are then available to be selected for scanning and analyzing.

Selecting the available file types:

1	Click on the Choose button in the File Types: section:

The Database Types dialog box will appear.

2	Use the check boxes to select or deselect a specific database file type.

3	Or check All File Types to select all files in the directory.

Selecting Available Files to be Analyzed

File Name

The File Name: section of the window shows All files matching the file types in the File Types: section within the selected directory. These files are available to be placed in the Current Selections: section to be analyzed.

Selecting files in the File Name section to be included in Current Selections:

1	Double click on the desired file in the File Name section.

2	Or click once on the desired file in the File Name section and then click the [image] copy selected files button to move the file to Current Selections.

Selecting all the files in the File Name section to be included in Current Selections:

1	Click on the [image] copy all files button in the File Name Section.

All of the files will be moved to Current Selections:

Directory scan button

The directory scan button is used to automatically scan the directory selected in the Directories: section of the window including all of its subdirectories.  All files of the database types included in the File Types: section within those directories will be listed in Current Selections: section. This button can be used to search an entire directory either on the local PC or on a network.

Current Selections List

The Current Selections list shows all files currently selected for analysis. This list will be used to determine which files on the PC/server the program should scan and analyze.

Copying selected files to Current Selections:

The Copy Selected Files button will copy any files that have been selected in the File Name: list box to the Current Selections: list. The button is available when at least one file is clicked on and selected in the File Name: list box.

Copying all files to Current Selections:

The Copy All Files button will copy all files that are displayed in the File Name: list box to the Current Selections: list.

Removing selected files from Current Selections:

The Remove Selected Files button will remove any files that have been selected in Current Selections: list.

1	Click on the files to be removed in the Current Selections: list.

2	Click on the Remove Selected Files button.

The files will be removed from the list.

Remove all files from Current Selections:

The Remove All Files button will remove all files from the Current Selections: list.

Click on the Remove All Files button.

All files from Current Selections: list will be removed.

Only Show First Failure on Each File Option:

This option should be selected if you only wish to show the first failure on each file that is being analyzed. Some files may have many failures but selecting this option allows you to produce a summary list of all files that have a potential problem rather than a detailed list of all rows/cells.

As well as reducing the amount of information that is output, selecting this option will also reduce the amount of time that the analysis will take because as soon as a failure is reported ADAPT/PC-DataScan will skip to the next file.

Minimum File Size

This value can be modified so that only files greater than a certain size are analyzed.

For example you may decide that files of a size less than 10000 bytes would not be seen as critical to the running of the company so should be ignored as part of the initial Year 2000 project.

You may modify this number after a list of files to analyze has been selected as the size will be checked again when the analysis is run and files that do not meet the minimum size will be rejected  (and reported as being so).

A command line switch is also available to set this value when running ADAPT/PC-DataScan in batch or unattended mode. See the Command Line Parameters section.

Continuing from the Wizard Window 3

Choose one of the following options:

Advanced	Click on the Advanced button to exit the wizard and go directly to the main ADAPT/PC-DataScan window.

Back	Click on the Back button to return to the second wizard window.

Next	Click on the Next button to proceed to the fourth wizard window.

Finish	Click on the Finish button to exit the wizard and go directly to the main ADAPT/PC-DataScan window keeping any settings entered within the wizard.


Wizard Window 4

The Fourth Wizard Window allows you to specify which date formats and specific dates you wish to search for.

 Selecting Date Formats to Check (Section 1)

Selecting and Deselecting specific predefined Date Formats:

In Section 1 of the window:

1	Click a check in the check box next to the date format to be searched.

2	To deselect the format click again in the Check box and the check will be removed.

ADAPT/PC-DataScan will search the earlier selected files for all the date formats that are checked.

Selecting All or None of the predefined Date Formats

The All/None Button allows you to either Select All or Select None of the predefined Date Formats available.

1	Click the All button when it is available and all the predefined Date Formats will show a check in the check boxes selecting them. (When all the Date Formats are selected the All button changes to the None Button.)

2	Click the None button when all of the predefined Date Formats are selected and they will be deselected.   (When one or more of the Date Formats are checked the None button becomes the All button.)

Customizing Specific Date Formats  (Section 2)

You may specify specific dates to search for.

This list is used when you are aware of certain dates that have been used within your databases to signify a special meaning. For example 09/09/99 is sometimes used when a date is not known. Similarly 99/99/99 is often used to signify infinity.

Defining customized Date Formats

1	In Section 2 of the window:

2	Click in the text box titled Specific Dates (e.g. 999999)

3	Type the format of the date to be searched in the text box.

4	Click the Add button to add the format to the list.

5	Repeat steps 3 and 4 adding all the Date Formats needed.

You should enter the dates in as many different formats as you think may exist (e.g. 090999, 09/09/99,09.09.99, etc.) to give ADAPT/PC-DataScan the best chance of locating all date possibilities.

Deleting a specific Customized Date Format from the Specific Dates list

1	Click on the Date Format in the Specifics Date list to be deleted.

2	Click on the Delete button underneath the list.

Clearing all Customized Date Formats from the Specific Dates list

1	Click on the clear button to clear the entire specific dates list.

Changing the Scope of the Search (Section 3)

Number of records to check

Use this field to limit the number of records that ADAPT/PC-DataScan will search.

The default number for this field in set to 100. ADAPT/PC-DataScan will search the first 100 records in each table or 100 rows in each spreadsheet.

Changing the Number of Records to Check field

1	Double Click in the text box. This will highlight the default number of 100.

2	Type in the desired amount. This will change the amount.

OR

Click on the All button to the right of the number and all the records or rows will be searched.  Selecting all the records in a large database could cause the search to take a long time.

Minimum Percentage

The value in this field is NOT used when analyzing spreadsheets.

After analyzing a file ADAPT/PC-DataScan will determine what percentage of records/rows failed the test. If that percentage is lower than this number the record/row will not be reported as failing the analysis. When analyzing the data this allows you to report first files that may have many dates and then run another analysis with this set to 1 to report files with any dates at all.

Changing the Minimum Percentage field

1	Double click in the text box. This will highlight the default number of 10.

2	Type in the desired percentage number. The percentage number will change.

Check for Dates Anywhere in Long Strings

Select this option if you wish ADAPT/PC-DataScan to search for dates that may be embedded in text strings. In most databases dates will be held in separate columns/fields so this option would not be required but if you wish to search files that may have dates within a string of text characters this option should be selected.

If you expect EDI messages to be stored within a database or file you would need to select this option. Dates are often embedded within these messages.

Selecting Check for dates anywhere in long strings

1	Click in the Check box next to the Check for dates anywhere in long strings option and a check will appear in the check box. This option is now selected.

2	 To deselect the Check for dates anywhere in long strings click again in the check box and the check will disappear. The option is no longer selected.

Continuing from the Wizard Window 4

Choose one of the following options:

Advanced	Click on the Advanced button to exit the wizard and go directly to the main ADAPT/PC-DataScan window.

Back	Click on the Back button to return to the third wizard window.

Next	Click on the Next button to proceed to the fifth wizard window.


Wizard Run Options
Wizard Run Options window

ADAPT/PC-DataScan wizard is ready to run the analysis. There are three run options available.

Run Option 1:
I want to run the scan now and save my settings

This option allows you to save all of the settings you have just selected using the wizard including:

•	the directories and files to be scanned

•	the file types

•	predefined date formats, specific dates

•	scope of the search

To select this item click on the radio button to the left of the option.

Continue with the section titled Output File.

Run Option 2
I want to run the scan now but do not want to save my settings

This option allows you to run the analysis without saving the settings you have just selected using the wizard. After the analysis has run there is an option to save the settings you have selected under the file menu on the main ADAPT/PC-DataScan screen.

To select this item click on the radio button to the left of the option.

Continue with the section titled Output File.

Run Option 3
I want to run the scan some other time but save my settings now

This option presents you with the Save Template dialog box that allows you to save all of the settings you have just selected using the wizard including:

•	the directories and files to be scanned

•	the file types

•	predefined date formats, specific dates

•	scope of the search

The analysis will not run at this time. The saved settings may be recalled and the analysis run with these settings at a later time on the current PC or another PC/Server.

To select this item click on the radio button to the left of the option.

Continue with the section titled Output File.

Output File

The results of the analysis may be written to a text file. This results file may be an essential tool in later Year 2000 analysis reports or as input in other reporting applications.

•	The default name that the program uses for this output file is the first 8 characters of the Unique Name entered in the first Wizard Window.

•	If the Unique Name was left blank the output name will be adaptpc.dfo.

•	You also have the opportunity at this point to enter any name that would best describe this file for your own purposes.

Changing the default name of the output file

1	Click anywhere within the text area containing the default name of the output file

2	Type in the path and desired name of the output file.

OR

1	Use the Browse button to open the Select output file dialog box to select an existing output file on the PCs local drives or a network drive attached to the PC.

Continuing from the Run Options window

Choose one of the following options to continue:

Advanced	Click on the Advanced button to exit the wizard and go directly to the main ADAPT/PC-DataScan window.

OK	Click on the OK button to continue with the Run Option chosen:

Run Option 1and 3:

The Save Template Window will appear.

Continue with the section titled Save Template window

Run Option 2:

ADAPT/PC-DataScan will start to analyze all of the selected databases, spreadsheets and files using the options set from the ADAPT/PC-DataScan Wizard.

Continue with the section titled Running the Analysis using the Wizard.

Starting the Analysis using the Wizard

ADAPT/PC-DataScan Main Screen will now appear and ADAPT/PC-DataScan will now run the analysis on the files selected with the settings indicated in the Wizard windows.

As tables/files are located that contain non-compliant dates they will appear in the results table. When the analysis is complete ADAPT/PC-DataScan will notify you of the location of the output file.

Click the OK button in this notification window. The Results Summary Screen will then appear.

Aborting the ADAPT/PC-DataScan analysis

The Abort button appears during the ADAPT/PC-DataScan analysis process at the bottom of the ADAPT/PC-DataScan Main Screen. Click on the Abort button to stop the analysis before if finishes analyzing all of the selected files.

After the analysis is aborted ADAPT/PC-DataScan will notify you of the location of the output file. Click the OK button in this notification window.

The Results Summary Screen will then appear showing the results of the analysis up to the point that it was aborted.

Understanding the Analysis

The results of the analysis are reported in the Results Summary Screen, the Results Tabs and the Reports Screen.

See The Analysis Results Chapter later in this manual for a further explanation of these features.

Advanced Option

ADVANCED	Choosing the Advanced option by clicking on the Advanced button in the ADAPT/PC-DataScan start up is recommended for users familiar with ADAPT/PC-DataScan.

The Advanced option will open the ADAPT/PC-DataScan main screen that will allow you to enter the settings needed to run ADAPT/PC-DataScan and analyze your PC or server. These settings are entered from the ADAPT/PC-DataScan main window without the help of the ADAPT/PC-DataScan wizard.


Select Output file dialog box

Drives

Selecting the drive in which to save the output file:

1	In the Drives: section - Click on the down arrow to open a drop down list of available drives.

2	Click on the desired drive letter. Directories within that drive will be available in the Directories: section of the window.

Directories

Selecting the directory in which to save the output file:

Double click on the directory you wish to select.

All output files in that directory will be listed in the File Name: list section.

File Name

Creating a new output file:

Click in the File Name: text box. Replace the * with the name of the new file.

Selecting an existing output file to overwrite:

Click in the File Name: text box. Type the desired file name.

OR

Click on an existing output file in the File Name list.

The file name will appear in the File Name: text box.

Comma Delimited (CSV) File:

The Comma Delimited (CSV) File: section of the window displays the name of the optional comma delimited output file. If this section is blank a comma delimited file has not been specified.

Specifying the name of a comma delimited file to be created from the Select output file window

Click on the CSV File button.

The Select comma delimited file window will appear

Closing the Select output file dialog box

Closing the Select output file dialog box saving your selection:

Click on the OK button to close the Select output file window saving the selection.

Closing the Select output file dialog box canceling your selection:

Click on the Cancel button to close the Select output file window canceling the selected output file.


The Select comma delimited fileThe Select comma delimited file window Window
The Select comma delimited file Window

CSV File:

This section is used to specify whether the results in comma delimited format should be added to or overwrite the existing file specified in the File Name: section of the window.

Overwriting the existing CSV file

Click in the radio button to the left of Overwrite this file in the CSV File: section of the window

Adding the results to the end of an existing CSV file

Click in the radio button to the left of Add to end of this file in the CSV File: section of the window

Drives

Selecting the drive containing the CSV file:

1	In the Drives: section - Click on the down arrow to open a drop down list of available drives.

2	Click on the desired drive letter. Directories within that drive will be available in the Directories: section of the window.

Directories

Selecting the directory containing the CSV file:

Double click on the directory you wish to select.

All CSV files in that directory will be listed in the File Name: list section.

File Name

Selecting an existing CSV file:

Click in the File Name: text box. Type the file name of the existing CSV file.

OR

Click on the existing CSV file in the File Name list.

The file name will appear in the File Name: text box.

Creating a new CSV file:

Click in the File Name: text box. Replace the * with the name of the new file.

Closing the Select comma delimited file window

Closing the Select comma delimited file window saving your selection:

Click on the OK button to close the Select comma delimited file window saving the CSV file with the name and options selected.

Closing the Select comma delimited file window canceling your selection:

Click on the Cancel button to close the Select comma delimited file window canceling the CSV file selection and options.


Save Templatetemplatesaving your setting - wizard Window
Save Template Window

This window is used to save your current ADAPT/PC-DataScan analysis settings for later use. You can select an existing template file, which will be overwritten, or you can create a new file by typing in a new file name.

Drives

Selecting the drive to save the template file:

1	In the Drives: section - Click on the down arrow to open a drop down list of available drives.

2	Click on the desired drive letter. Directories within that drive will be available in the Directories: section of the window.

Directories

Selecting the directory to save the template file:

Double click on the directory you wish to select.

All files in that directory will be listed in the File Name: list section.

File Name

Naming the template file:

1	Click in the File Name: text box. Replace the * with the desired name for the file.

OR

2	Double click on an existing ADAPT/PC-DataScan template file in the file name list. It will appear in the File Name text box and will be overwritten with the new settings.

3	The default file name extension for the template file is DTF

Template Description

The Template Description section of the Save Template dialog box is used to create a description of the settings available in the template file. This optional information is displayed when searching for a saved template. It is also shown at the top the main ADAPT/PC-DataScan screen when using the template.

Typing the Template Description

1	Click in the Template Description: text box.

2	Type in your description of the template file.

Closing the Save Templates Window

Choose one of the following options to continue:

OK	Click on the OK button to save the template with the name and description you created.

Cancel	Click on the Cancel button to cancel the save option.


ADAPT/PC-DataScan Main Screen

The File Menu

Restoring ADAPT/PC-DataScans default settings and creating a new template

New Template

1  Click on File from the Menu bar to open the File Menu

2  Click on New Template

OR	Click on [image] the new template icon from the icon bar

The Warning dialog box will appear asking for confirmation to reset ADAPT/PC-DataScan to the default setting. Click on the Yes button to continue.

New Settings can now be entered to save as a New Template.

Opening an existing ADAPT/PC-DataScan template

Open Template

1  Click on File from the Menu bar to open the File Menu

2  Click on Open Template

OR	Click on [image] the open template icon from the icon bar

The Open Template or Output File dialog box will appear.

The Edit Menu

Copying the analysis results to the windows clipboard

The copy results to clipboard command on the edit menu will copy analysis results to the Windows clipboard. The results can then be pasted to a Windows application that accepts the paste command from the clipboard. This feature allows you to use the results in applications such as Microsoft Excel, Lotus 123 and Microsoft Word.

Copy results to clipboard

1  Click on Edit from the Menu bar to open the Edit Menu

2  Click on Copy results to clipboard

OR	Click on [image] the copy icon from the icon bar

The Window Menu

Starting the wizard

The Start Wizard command in the Window menu will open the first of the wizard windows. The setting needed to run the analysis can then be entered from these wizard windows.

Start Wizard

1  Click on Window from the menu bar to open the Window Menu

2  Click on Start Wizard

OR	Click on [image] the start wizard icon from the icon bar

Selecting specific files to analyze

The Choose Files to Analyze command in the Window menu will allow you to select specific directories or files on a specific drive on the local PC or network the PC is attached to.

Choose Files to Analyze

1  Click on Window from the menu bar to open the Window Menu

2  Click on Choose Files to Analyze

OR	Click on [image] Choose files to analyze icon from the icon bar

The Select Files to Analyze window will appear. For an explanation of the Select Files to analyze window refer to the Select Files to Analyze section of this manual.

Selecting specific date formats to find in the files selected to analyze

The Choose Date Formats to Find command in the Window menu will allow you to select specific predefined dates and specify customized date formats for ADAPT/PC-DataScan to search during the analysis of the files selected.

Choose Date Formats to Find

1  Click on Window from the menu bar to open the Window Menu

2  Click on Choose Date Formats to Find

OR	Click on [image] Choose date formats to find icon from the icon bar

The Date Formats window will appear.

Selecting the file to save the results of the analysis Output File.

The Choose Output File command in the Window menu will allow you to select an existing file or name a new file to store the results of the ADAPT/PC-DataScan analysis.

Choose Output File

1  Click on Window from the menu bar to open the Window menu

2  Click on Choose Output File

OR	Click on [image] Choose Output File icon from the icon bar

The Select output file window will appear.

For an explanation of the Select output file window refer to the section titled Select output file window in the ADAPT/PC-DataScan main Screen fields chapter of this manual.

Selecting the CSV File to save the results as a comma delimited file

The Choose CSV File command in the Window menu will allow you to select an existing file or name a new file to store the results of the ADAPT/PC-DataScan analysis in a comma delimited format. This file can then be used to import to other database applications.

Choose CSV File

1  Click on Window from the menu bar to open the Window menu

2  Click on Choose CSV File

OR	Click on [image] Choose CSV File icon from the icon bar

The Select comma delimited file window will appear.

For an explanation of the Select comma delimited file window refer to the section titled Select comma delimited file window in the ADAPT/PC-DataScan main Screen fields chapter of this manual.

Displaying the Results Summary Window

The Summary command in the Window menu will display the Results Summary window. This window is a summary of the results of the current analysis.

Summary

1  Click on Window from the menu bar to open the Window menu

2  Click on Summary

OR	Click on [image] the Results Summary icon from the icon bar

The Results Summary window will appear.

For a detailed explanation of the Results Summary Window see the Section titled Reports in the manual

Displaying the Product Registration Window

The Product Registration command in the Window menu will display the Product Registration window. If ADAPT/PC-DataScan has not been registered registration may be completed from this window.

Product Registration

1  Click on Window from the menu bar to open the Window menu

2  Click on Product Registration

OR	Click on [image] the Product Registration icon from the icon bar

The Product Registration window will be displayed.

The Reports Menu

The Reports menu contains commands to open the ADAPT/PC-DataScans Report Preview Screen. There are six reports available from the Reports menu:

•	Summary Report

•	Detailed Report

•	Spreadsheet Report

•	Database Summary Report

•	Report of All Files Analyzed

•	Error Report

For a detailed information of the Report Preview screen see the chapter titled Reports in this manual.

Displaying the Report Preview Screens using the Reports Menu

1  Click on Reports from the menu bar to open the Reports Menu

2  Click on the desired report from the list of reports

The Report Preview screen will appear displaying the desired report.

Displaying the Report Preview Screen using the Icon Bar

Click on [image] the Reports icon from the icon bar.

The Reports Preview Screen will appear with the Summary Report displayed. Any of the reports can be displayed from the Reports Screen. For a detailed explanation of the Reports Preview Screen see the chapter titled Reports in this manual.

The Help Menu

Displaying ADAPT/PC-DataScan version information

1  Click on Help from the menu bar to open the Help menu

2  Click on About

The About ADAPT/PC-DataScan  window will appear displaying the version information.

3  Click the OK button to close the About ADAPT/PC-DataScan window.

Opening ADAPT/PC-DataScan help

1  Click on Help from the menu bar to open the Help menu

2  Click on Help

The ADAPT/PC-DataScan Help window will open.

OR	Click on [image] the Help icon from the icon bar

ADAPT/PC-DataScan main screen fields

Name of PC/Server

Unique Name

•	This name is used to identify the computer on the result screens, reports and in the output file. Choosing a unique, meaningful name is important in helping to identify which PC or server the results relate to when analyzing the accumulated output from multiple PCs and servers.

•	The name can also be used in other products to provide a unique 'key' to allow further analysis.

•	The name is used as the name of the output file created by ADAPT/PC-DataScan for displaying the analysis results for this PC or server. This easily identifies the report file for each PC or server within one network directory when analyzing multiple servers and PCs.

Specifying the name of the PC/Server from the main screen

1  Click in the text field titled Name of PC/Server

2  Type the unique name for the PC or Server being analyzed.

Type of Computer

•	As with the identifying name above, the type of computer selected here is written to the ADAPT/PC-DataScan output file and is used to help group similar computer types together.

Specifying the type of computer from the main screen

To analyze a PC:

Click in the radio button labeled PC

To analyze a Server

Click in the radio button labeled Server

To analyze a computer other than a PC or Server:

Click in the radio button labeled Other.

In the text area to the right of Other type a meaningful name to describe the type of computer, such as 'MAINFRAME' or 'AS/400'

Files to analyze:

Use this field to specify the database and spreadsheet files to be analyzed.

Specifying a single database or spreadsheet file to analyze

1  Click in the Files to Analyze: text field

2  Type the full path and file name of the file to analyzed

Specifying multiple database and spreadsheet files to analyze

Click the Browse… button to the right of the Files to Analyze: field

The Select Files to Analyze window will appear

or ODBC Data Source:

Use this field if you wish to search a database that is connected to the PC by ODBC (Open DataBase Connectivity). ODBC data source may include mainframe, mini and some server based databases. If you are searching a standard PC database then leave this field blank.

Specifying the ODBC Data Source:

1  Click in the or ODBC Data Source: text box.

2  Type the name of the ODBC Data Source.

Note:	This option is not available without purchasing a ADAPT/PC-DataScan ODBC license. For information on obtaining a license refer to the section titled Obtaining the Unlock Code in this help file).

Output to:

Use this field to specify the path and name of a text file to be used by ADAPT/PC-DataScan to save the results of the analysis.

Specifying the output file name in the Output to: field

1  Click in the Output to: text field

2  Type the full path and file name of the file to be used by ADAPT/PC-DataScan to save the 	    results of the analysis.

Using the Output to: browse button to specify the output file

Click the Browse… button to the right of the Output to: text field

The Select output file window will appear.

Prompt for user ids / passwords

ADAPT/PC-DataScan uses the Prompt for user id / passwords option to prompt for a user id and/or password whenever it tries to open a secured (password protected) database or spreadsheet. If this option is not selected (the default) then secured databases will NOT be analyzed.

Activating the Prompt for user ids / passwords option

1  Click a check in the check box to the left of Prompt for user ids / passwords.

    A check will appear in the check box activating the option.

2  To deactivate the Prompt for user ids / passwords option click again in the 	    check box and the check will be removed.

Start button

Starting the ADAPT/PC-DataScan analysis

The Start button starts the analysis. ADAPT/PC-DataScan will start to analyze all of the selected databases, spreadsheets and files using the options set from the ADAPT/PC-DataScan main screen.

As tables/files are located that contain non-compliant dates they will appear in the results table. When the analysis is complete ADAPT/PC-DataScan will notify you of the location of the output file. Click the OK button in this notification window. The Results Summary Screen will then appear.

Abort button

Aborting the ADAPT/PC-DataScan analysis

The Abort button appears during the ADAPT/PC-DataScan analysis process. Click on the Abort button to stop the analysis before if finishes analyzing all of the selected files.

After the analysis is aborted ADAPT/PC-DataScan will notify you of the location of the output file. Click the OK button in this notification window. The Results Summary Screen will then appear showing the results of the analysis up to the point that it was aborted.

Exit button

To Exit the ADAPT/PC-DataScan program click on Exit.

Register button

Click on the Register button to display the ADAPT/PC-DataScan Register window.

The Register window can be used to type in the registration name and code (unlock code) to register ADAPT/PC-DataScan.

Note:	For information on obtaining a registration name and code refer to the section titled Obtaining the Unlock Code earlier in this manual.

License button

Click on the License button to view the ADAPT/PC-DataScan License Agreement window.

This window contains the ADAPT/PC-DataScan license agreement. Click on the Agree or Cancel button to close the ADAPT/PC-DataScan License Agreement window.

If you do not agree with the license agreement then you should remove ADAPT/PC-DataScan from all PCs.

Results Tabs

There are five sets of analysis results available from the main screen:

•	Spreadsheets

•	Database Summary

•	Database Details

•	Errors

•	Files Analyzed.

To display any of the five results sets click on the tab corresponding to that set. That set of results will then be displayed on the screen.

Clicking on an entry in these results tabs will display a menu with additional options.

Spreadsheets Tab

The results shown when clicking on the Spreadsheets tab are the spreadsheets that failed the analysis criteria. The cell reference, date format and cell type are included in the results

 Click on an entry in the results and a menu will be displayed.

 Click on the View Spreadsheet in Browser to activate the Spreadsheet browser to browse  the data in that spreadsheet.

OR

Click on the View in Excel with Highlighting to open the spreadsheet in Excel 97 with all of the detected cells highlighted

OR

Click on the View in Excel without Highlighting to open the spreadsheet in Excel 97.

Database Summary Tab

The results shown when clicking on the Database Summary tab are the databases/files that failed the analysis criteria.

Database Details Tab

Displaying Database Details information

Click on the Database Details tab to display an extensive amount of information relating to the databases that failed the analysis criteria:

Displaying the actual Database record

1  Click on an entry in the Database Details results and the Browse Data button 	    becomes available.

2  Click on the Browse Data button to display the entire database record.

OR

Double click on the entry in the Database Details results and the entire database record will be displayed.

Database Details information screen columns

File/Table

The File/Table column displays the name of file/table/spreadsheet that has been reported as failing the analysis settings.

Field/Column

The Field/Column column displays the name of the field/column within the database table, worksheet or file that has been reported as failing the analysis.

Example value

The Example value column displays the last date in the file that matched your analysis criteria. See the Date Format column entry to see which date format this value matches.

Total records failed/searched

The Total records failed/searched column displays first the total number of records/rows that failed the analysis, then the total number of records/rows that were actually analyzed. This is also expressed as a percentage in the Failure Percentage column.

Failure Percentage

The Failure Percentage column displays the number of failed records/rows shown as a percentage of the total actually analyzed. The larger the percentage the more chance there is that the data in this row/column is actually a non-compliant date.

Database/Datasource

When searching a PC or network drive the Database\Datasource column displays the full path to the file that is being reported. When analyzing a database via ODBC the Datasource used is displayed here.

Type

The Type column displays the file type. When searching ODBC databases this entry will always be set to 'ODBC' but for PC/network files the individual type will be displayed.

Minimum Year

The Minimum Year column displays the minimum year that was found when analyzing the data. Together with the Maximum Year displayed in the next column, the minimum year assists in the understanding of the range of dates that are likely to be stored in this file.

Maximum Year

The Maximum Year column displays the maximum year that was found when analyzing the data. Together with the 'Minimum Year' shown in the previous column, the maximum year assists in the understanding of the range of dates that are likely to be stored in this file. The closer that the maximum year is to the end of the century the sooner potential problems might occur in the applications that use this data.

Field/Column Type

The Field/Column Type column displays the type of field/column in which the data is stored. In many databases and spreadsheets a special 'date' type is used to store dates. In this case it may be possible to automatically convert these dates to four character years by changing the windows Short Date Style found in the Regional Settings within the Windows Control Panel. If the type displayed here is not a 'date' type there could be a potential risk of the system failing when it tries to carry out any date calculations unless the applications using this data have been written to specifically handle dates in the next century.

Date Format

The Date Format column is the format of date that is thought to be stored within this field/column. ADAPT/PC-DataScan compares the data against its list of known formats such as MM/DD/YY (Two character month/Day/Two character year, e.g. '052697'), YYMMM (e.g. '97Aug') and YY (e.g. '97') and decides the most likely format of date stored in this field/column.

Date Last Modified

The Date Last Modified column displays the last time that the data within this database, spreadsheet or file was modified This one piece of information is the most helpful item in determining which databases, spreadsheets or files need to be addressed first. If this date is many months or even years prior to the current date then the data may not be used anymore and may not need to be checked any further. On the other hand if this date is very close to the current date then there is a higher chance that the database, spreadsheet or file is currently being used.

File Size in Bytes

The File Size in Bytes column displays total size of the file in bytes. If the size of the file is small then the amount of data stored in the file is also small. Therefore the changes required by the file could probably be accomplished quickly. If the size of file is large there may be a vast amount of data. The data would most likely need converting if the application using this data was identified as requiring modifications.

Date Table Created

The Date Table Created column displays the date the table within the database was created. It serves to gauge how old the application may be. This information is only available for directly supported databases and spreadsheets (e.g. Access, dBASE, etc.).

Date Table Design Last Modified

The data in the Date Table Design Last Modified column is only available for directly supported databases and spreadsheets (e.g. Access, dBASE, etc.). The date displayed here identifies when the design of the table within the database was last modified. It serves to gauge when modifications were last made to the design of the system processing this data. If this date is fairly recent then it may be that modifications are already being carried out to address the problem. It is important to note that when creating and modifying spreadsheets this date may be modified. Therefore this information is only really effective when analyzing databases.

Errors Tab

Clicking the Errors Tab displays a list of the files that could not be analyzed. The error and a possible explanation of why the error occurred is available with the file name.

Some databases and spreadsheet may be secured by a password. In order for ADAPT/PC-DataScan to analyze these files the security would need to be removed temporarily. If ADAPT/PC-DataScan is still unable to open a particular file the file should be checked manually using the application that generated the file.

Files Analyzed

Clicking on the Files Analyzed tab displays a list of all the files analyzed by ADAPT/PC-DataScan. This list includes all files regardless of whether they passed or failed the analysis criteria.


Results Summary WindowResults Summary Window
Results Summary Window

The Results Summary window is the first window to appear after ADAPT/PC-DataScan executes and finishes analyzing the files selected.

Identity: section

The identity section of the Results Summary window displays the Unique Name chosen for this analysis. When printing and using this summary for Year 2000 reporting this name identifies the analysis.

The date and time that the analysis was executed is displayed on the right of the Identity: section.

The Table Section of the Results Summary Window

The Results Summary divides the files searched into 3 types: databases, spreadsheets and other files. The chart then summarizes each type of file showing the number of files searched, the total passed and the total failed for each of the three types.

Total Searched Column

The Total Searched column displays the total number of database tables searched, total number of Spreadsheets searched and total number of other files searched.

Total Passed Column

The Total Passed column displays by row the number of database tables, spreadsheets and other files that were found to have no dates matching the date formats selected for the analysis.

Total Failed Column

The Total Failed column displays by row the number of database tables, number of spreadsheet and number of other files that the analysis found to have dates that match the date formats selected for the analysis.

The Chart Section of the Results Summary Window

The summary results are displayed using pie charts divided by the file type: database tables, spreadsheets and other files. A pie chart for each type of file displays the percentage of files passed and failed for that file type.

Files That Could Not Be Opened

This shows the total number of files that could not be opened by the analysis.

Possible reasons to not allowing a file to be opened may include:

•	corrupt databases

•	password protected databases/spreadsheets.

A detailed list of the files is written to the main ADAPT/PC-DataScan screen and to the text output file. These files should be checked manually by using the relevant program that created them.

Results Summary Print button

Click on the Print button to print the Results Summary.

Closing the Results Summary Window

Click on the OK button to close the Results Summary window and return to the ADAPT/PC-DataScan main screen.


ReportReportreport preview screen Preview ScreenReport Preview ScreenResults Summary Window
Report Preview Screen

From the Reports Preview screen hard copies reports of the analysis results may be printed.

Changing the type of report to be printed in the Report Preview Screen

1	In the Report Type: section

2	Click on the down arrow on the right of the Report Type section to open the drop down lists of reports available.

3	Click on the desired report from the drop down list.

The desired report will then be displayed.

Copying the current report to the Windows clipboard

Click on [image] the Copy to the clipboard icon to copy the current report to the Windows clipboard. The report can now be pasted in any Windows application compatible with the Windows clipboard copy and paste option.

Specifying the amount of lines to be printed per page

1	In the Lines Per Page: section

2	Double click in the text box. This will highlight the default amount of 62 lines.

3	Type in the desired number of lines replacing the default amount.

This number should be modified according to the printer being used. The number entered here will be stored and recalled whenever you use ADAPT/PC-DataScan.

Changing printer settings

Click on the Printer Setup button to make changes to your printer setting. The settings available will depend on the printer being used.

Printing the report

Click on the Print button to print to the default printer.

Closing the Report Preview screen

Click on the Cancel button to close the Report Preview screen and return to the ADAPT/PC-DataScans main screen.


Command Line SwitchesReport Preview ScreenResults Summary Window
Command Line Switches

ADAPT/PC-DataScan can be configured to run in different modes based on parameters entered when running the program. These optional parameters can be used for a wide range of configurations from running a completely unattended analysis to forcing the use of a specific template.

To use a command line parameter type in the relevant option after the adaptpc.exe. A switches file can be created to include all of the switches to be executed. This file named SWITCHES.DFS will run when executing ADAPT/PC-DataScan causing the parameters to be applied (see example below).

Commands (Switches)

Command	Effect
/AUTORUN	Causes ADAPT/PC-DataScan to automatically execute using either the default settings or the overrides supplied using the other parameters.
/DRIVE n | ALL | LOCAL | REMOTE  (where n =drive letter)	Drive(s) to be analyzed. Specify one of the following: • a single drive letter • ALL to perform an analysis of all non-removable drives • LOCAL to analyze only local fixed disk drives • REMOTE to analyze only network drives. ALL, LOCAL and REMOTE must be specified in conjunction with /AUTORUN.
/PATH \xxxxxx\xxxxx	Parent directory from which to begin the search including all subdirectories. ADAPT/PC-DataScan then searchs for all file types selected, from this path and below.
/NAME name | #PROMPT	Replace name with the unique name for the PC/server or use PC/server or use #PROMPT to allow ADAPT/PC-DataScan to prompt for the unique name (useful if using the /AUTORUN option).
/TEMPLATE n:\xxxxxxx\template.dtf	Specify the path and name of a template to be used. The template will be loaded immediately. If you use the /AUTORUN option the list of files to analyze will be rebuilt AFTER the template is loaded.
/CSVFILE n:\xxxxx\xxxxx.csv	This parameter causes ADAPT/PC-DataScan to write the results to a comma delimited (CSV) file as well as the standard text file. Indicate the drive path and name of the file (n:\xxxxx\xxxxx.csv). After this is run on multiple PCs the CSV files may be combined to create a singlce CSV and imported into another application or database.
/CSVAPPEND	Include this parameter if you wish the output to be appended to the CSV file defined in the /CSVFILE parameter instead of overwriting the existing results.
/Q	Quiet mode - No screens will be displayed during the analysis. You must also select /AUTORUN to use this switch.
/NOSUMMARY	Do not show the summary screen after execution. This is useful when you are running ADAPT/PC-DataScan on a PC with little memory or if you are executing ADAPT/PC-DataScan directly from a CD. The summary information will still be written to the output file and the comma delimited file (if the /CSVFILE option is selected).
/OUTPUT_FILE n:\xxxxx\xxxxxx.txt	The path and name of the file you wish the ADAPT/PC-DataScan output to be written to. Usually this defaults to the directory that ADAPT/PC-DataScan is being executed from and the file name is the first 8 characters of the PC name entered.
/LISTLINES nnnnn	Sets the Maximum List Entries number (see Main Screen).
/FIRSTONLY	Sets the Only Show First Failure on Each File setting (see Wizard Screen 3 and Date Formats Screen).
/MINSIZE nnnnn	Minimum size of files to analyze (see Wizard Screen 3 and Date Formats Screen).
/RESTART	Specifying this parameter will force ADAPT/PC-DataScan to restart after the file that it was last analyzing. A file called restart.txt is written to the same directory as the program is installed into and should be deleted when starting a new analysis which includes the /RESTART parameter.
Specifying Default Parameters in the SWITCHES.DFS File

As well as entering parameters when executing ADAPT/PC-DataScan it is also possible to supply a set of default parameters in a file named SWITCHES.DFS.

This is very useful if you wish ADAPT/PC-DataScan to automatically run as part of a users log-in script.

By installing ADAPT/PC-DataScan on the network and creating a template and/or switches file it is possible to configure ADAPT/PC-DataScan to run automatically with almost any combination of settings and for the results to be written to a network directory for analysis by a Year 2000 project team.

That team can then use ADAPT-PC/Manager to import and track each PCs status.

If you place a file called SWITCHES.DFS in the same directory as the ADAPT/PC-DataScan executable (adaptpc.exe) then any commands within the file will be used as a default.

You may then specify additional commands or overiding commands using the method specified in the previous section.

To create a default SWITCHES.DFS file use Notepad and enter the switches (e.g. /AUTORUN /CSVFILE c:\temp\results.csv) and then save the file as SWITCHES.DFS in the same directory that you installed ADAPT/PC-DataScan into.

Now, when you run ADAPT/PC-DataScan the switches will be used as if you entered them directly after the adaptpc.exe.

The following example parameters would run ADAPT/PC-DataScan in automatic mode using an existing template and append the results to a comma delimited file on a network drive:

/AUTORUN /DRIVE c /NAME #PROMPT /TEMPLATE w:\\templates\default.dtf /CSVFILE w:\\results\default.csv /CSVAPPEND


Select Files to Analyze WindowReport Preview ScreenResults Summary Window
Select Files to Analyze Window

Selecting files from specific drives and directories:

Drives

Selecting the drive containing the files to analyze:

1	In the Drives: section - Click on the down arrow to open a drop down list of available drives.

2	Click on the desired drive letter. Directories within that drive will be available in the Directories: section of the window.

Directories

Selecting the directory containing the files to analyze:

Double click on the directory you wish to select from the Directories: list.

All files matching the criteria in the File Types: section within that directory will be listed in the File Name: list section of the window.

Selecting a directory and its subdirectories containing the files to analyze:

1	Double click on a directory in the Directories: list

2	Click on the directories scan button [image] to select the directory including all of its subdirectories.

This option will automatically scan the selected directory and all of its subdirectories placing the files matching the criteria in the File Types: section in the Current Selections: section of the window.

Selecting an entire drive containing the files to analyze:

1	Select the desired drive in the Drives: section of the Window.

2	Double click on the root directory of the drive in the Directories: section of the Window. (For example: C:\ )

3	Click on the directories scan button [image].

This option will automatically scan the drive and all of its subdirectories placing the files matching the criteria in the File Types: section in the Current Selections: section of the window.

Selecting specific database file types to analyze:

File Types

The File Types: section of the window shows the types of files that will appear in the File Name: section of the window when the drive and directory are selected. These files are then available to be selected for scanning and analyzing.

Selecting the available file types:

1	Click on the Choose button in the File Types: section:

The File Types dialog box will appear.

2	Use the check boxes to select or deselect a specific file type.

3	Or check All File Types to select all files in the directory.

4	Click the OK button to close the File Types dialog box.

Selecting specific files from the available files to be analyzed

File Name

The File Name: section of the window shows all files matching the file types in the File Types: section within the selected directory. These files are available to be placed in the Current Selections: section to be analyzed.

Selecting files in the File Name section to be included in Current Selections:

1	Double click on the desired file in the File Name section.

2	Or click once on the desired file in the File Name section and then click the [image] copy selected files button to move the file to Current Selections.

Selecting all the files in the File Name section to be included in Current Selections:

Click on the [image] copy all files button in the File Name Section.

All of the files will be moved to Current Selections:

Directory scan button

The directory scan button is used to automatically scan the directory selected in the Directories: section of the window including all of its subdirectories.  All files of the database types included in the File Types: section within those directories will be listed in Current Selections: section. This button can be used to search an entire directory either on the local PC or on a network.

Current Selections List

The Current Selections list shows all files currently selected for analysis. ADAPT/PC-DataScan will use this list to determine which files on the PC or server the program should scan and analyze.

Copying selected files to Current Selections:

The Copy Selected Files button will copy any files that have been selected in the File Name: list box to the Current Selections: list. The button is available when at least one file is clicked on and selected in the File Name: list box.

Copying all files to Current Selections:

The Copy All Files button will copy all files that are displayed in the File Name: list box to the Current Selections: list.

Removing selected files from Current Selections:

The Remove Selected Files button will remove any files that have been selected in Current Selections: list.

1	Click on the files to be removed in the Current Selections: list.

2	Click on the Remove Selected Files button.

The files will be removed from the list.

Remove all files from Current Selections:

The Remove All Files button will remove all files from the Current Selections: list.

Click on the Remove All Files button.

All files from Current Selections: list will be removed.

Closing the Select Files to Analyze window saving your selection:

Click on the OK button to close the Select Files to Analyze window saving the selections.

Closing the Select Files to Analyze window canceling your selection:

Click on the Cancel button to close the Select Files to Analyze window canceling the selections.


Date Formats WindowReport Preview ScreenResults Summary Window
Date Formats Window

Selecting Date Formats to Check

Selecting and Deselecting specific predefined Date Formats:

1	Click a check in the check box next to the date format to be searched.

2	To deselect the format click again in the Check box and the check will be removed.

ADAPT/PC-DataScan will search the earlier selected files for all the date formats that are checked.

Selecting All or None of the predefined Date Formats

The All/None Button allows you to either Select All or Select None of the predefined Date Formats available.

1	Click the All button when it is available and all the predefined Date Formats will show a check in the check boxes selecting them. (When all the Date Formats are selected the All button changes to the None Button.)

2	Click the None button when all of the predefined Date Formats are selected and they will be deselected. (When one or more of the Date Formats are checked the None button becomes the All button.)

Customizing Specific Date Formats

You may specify specific date formats to be searched.

This list is used when you are aware of certain dates that have been used within your databases to signify a special meaning. For example 09/09/99 is sometimes used when a date is not known. Similarly 99/99/99 is often used to signify infinity.

Defining customized date formats

1	Click in the text box titled Specific Dates (e.g. 999999)

2	Type the format of the date to be searched in the text box.

3	Click the Add button to add the format to the list.

4	Repeat steps 2 and 3 adding all the Date Formats needed.

You should enter the dates in as many different formats as you think may exist (e.g. 090999, 09/09/99,09.09.99, etc.) to give ADAPT/PC-DataScan the best chance of locating all date possibilities.

Deleting a specific customized date format from the Specific Dates list

1	Click on the Date Format in the Specifics Date list to be deleted.

2	Click on the Delete button underneath the list.

Clearing all customized date formats from the Specific Dates list

Click on the Clear button to clear the entire specific dates list.

Closing the Date Formats window

Closing the Date Formats window saving your selections:

Click on the OK button to close the Date Formats window saving the selected options.

Closing the Select Files to Analyze window canceling your selection:

Click on the Cancel button to close the Date Formats window canceling the selected options.


Wizard Window 5

The fifth wizard window allows you to select whether to analyze additional structures as well as the data including, spreadsheet macros and Microsoft VBA (Visual Basic for Applications).

Analyze Spreadsheet Formulas and Lotus 123 Macros

Select this option if you wish to analyze formulas within both Excel and Lotus 123 spreadsheets and also Lotus 123 macros.

Click the Configure button to modify the related settings including the date functions that you wish to search for.

Please note that audit must be installed to analyze Lotus 123 formulas.

Audit is a feature which is installed with Lotus 123 but it is possible to choose to not install this when the initial install of Lotus 123 is carried out.

If when running the analysis you receive a message saying that Audit is not installed you should use the custom install option from the Lotus 123 disks/CD and choose to install Audit.

Search for Dates Embedded Formulas/Macros

As well as searching for date functions you may also search for actual dates that have been keyed in as part of a formula or macro.

For example a formula of =DAYS360(01/01/97) includes an embedded date, 01/01/97 which would be reported if this option was chosen.

Search for Excel and Access VBA (Visual Basic for Applications)

Select this option if you wish to analyze Microsoft Excel and Access code.

The last few versions of Microsoft products use a language called VBA to provide programming capabilities in Excel and Access.

When creating a macro in Excel or adding event functions in Access the code is stored as VBA.

By selecting this option you can search for the use of date related (and other) functions that have been used.

Click the Configure button to modify the related settings including the date functions that you wish to search for.

By selecting the Search for Dates Embedded in VBA option you can also search for actual dates that have been entered as part of a VBA function (see below).

Search for Dates Embedded VBA

As well as searching for date functions you may also search for actual dates that have been keyed in as part of VBA code.

For example a function of =DAYS360(01/01/97) includes an embedded date, 01/01/97 which would be reported if this option was chosen.

Analyze Access forms and reports for input masks / output formats

Selecting this option will allow input masks that force a two character year to be located within MS Access forms as well as output formats that force a two character year to be displayed on both MS Access forms and reports.

Select Configure to modify the default input masks and output formats that will be searched for.

Continuing from the Wizard Window 5

Choose one of the following options:

Advanced	Click on the Advanced button to exit the wizard and go directly to the main ADAPT/PC-DataScan window.

Back	Click on the Back button to return to the fourth wizard window.

Finish	Click on the finish button to complete the set-up of your ADAPT/PC-DataScan settings and continue with the Run options.


Scope Window

The scope window allows you to modify settings that will change the way the analysis will be performed:

Changing the Scope of the Search

Number of records to check

Use this field to limit the number of records that ADAPT/PC-DataScan will search.

The default for this field in set to 100.

ADAPT/PC-DataScan will search the first 100 records in each table or 100 rows in each spreadsheet.

Changing the Number of records to check: field

1	Double Click in the text box. This will highlight the default amount of 100.

2	Type in the desired amount. This will change the amount.

3	OR

4	Click on the All button to the right of the amount and all the records or rows will be searched.  Selecting all the records in a large database could cause the search to take a long time.

From/To Year:

These fields are used to help ADAPT/PC-DataScan identify whether a piece of data contains a two character year.

The default range is 00 to 99 so any two character number will be reported as being a two character year if the rest of the data matches a selected date format.

If you know that your files do not hold historical data before say 1980 and you have no data in the next century then you should modify these values to make the analysis more accurate.

ADAPT/PC-DataScan will be more accurate if the from year is as high as possible as some data may contain numbers that could be considered a valid date (e.g. 100575). By setting this field to 80 for example, the previous example would be ignored.

Changing the From Year: field

1	Double Click in the text box. This will highlight the default number of 00.

2	Type in the desired number. The number will change.

Changing the To Year: field

3	Double Click in the text box. This will highlight the default number of 99.

4	Type in the desired number. The number will change.

Minimum Percentage

The value in this field is NOT used when analyzing spreadsheets.

After analyzing a file ADAPT/PC-DataScan will determine what percentage of records/rows failed the test. If that percentage is lower than this number the record/row will not be reported as failing the analysis.

When analyzing the data this allows you to report first files that may have many dates and then run another analysis with this set to 1 to report files with any dates at all.

Changing the Minimum Percentage field

1	Double click in the text box. This will highlight the default number of 10.

2	Type in the desired percentage number. The percentage number will change.

Check for Dates Anywhere in Long Strings

Select this option if you wish ADAPT/PC-DataScan to search for dates that may be embedded in text strings.

In most databases dates will be held in separate columns/fields so this option would not be required but if you wish to search files that may have dates within a string of text characters this option should be selected.

If you expect EDI messages to be stored within a database or file you would need to select this option. Dates are often embedded within these messages.

Selecting Check for dates anywhere in long strings

1	Click in the Check box next to the Check for dates anywhere in long strings option and a check will appear in the check box. This option is now selected.

2	 To deselect the Check for dates anywhere in long strings click again in the check box and the check will disappear. The option is no longer selected.

Ignore ZIP Codes

Select this option to allow field/columns with the word ZIP in them to be ignored. Many ZIP codes could be misinterpreted as being dates (e.g. 92021 - 1 February 92). By selecting this option a field/column labeled XZIPCOD, for example, would be bypassed.

Selecting Ignore Zip Codes

1	Click in the Check box next to the Ignore ZIP Codes option and a check will appear in the check box. This option is now selected.

2	 To deselect the Ignore Zip Codes click again in the check box and the check will disappear. The option is no longer selected.

Ignore Others

Use this option to enter additional field/column names that should be bypassed during the analysis. This is useful when you know that any field/column containing certain characters (e.g. ORD#) will never contain dates.

Selecting this option will display the Exclusions Window

Only Show First Failure on Each File Option:

This option should be selected if you only wish to show the first failure on each file that is being analyzed. Some files may have many failures but selecting this option allows you to produce a summary list of all files that have a potential problem rather than a detailed list of all rows/cells.

As well as reducing the amount of information that is output, selecting this option will also reduce the amount of time that the analysis will take because as soon as a failure is reported ADAPT/PC-DataScan will skip to the next file.

Show ALL Date Type Columns/Cells

Date data can be stored in many different column/cell types including: text, numeric and date.

If you are interested in finding those database tables and spreadsheets that have data type columns/cells in them, regardless of the value, then select this option.

Excluding Data Types

Date data can be stored in many different column/cell types including: text, numeric and date.

You may choose data types that you DO NOT wish to search by selecting the relevant entry within the Exclude the following data types box.

For example if you only wish to search for dates with two character years that have been stored in text type columns/cells then select Date, Numeric and Currency to be excluded.


Exclusions Window

This window allows you to add directories, files ,tables and columns/fields that you wish to be excluded from the analysis.

You can either add entries manually from this screen or click on an entry in the results where you will be presented with a menu that allows you to add the relevant entry to the exclusion list.

NOTE: When entering a directory name it must INCLUDE the drive (e.g. c:\samples)