Home - Technology Design Limited



[pic]

Report Generation Software

|Author: |Dave Quayle |

|Date: |7th December 2011 |

Contents

1. Introduction 3

1.1. Components used to Generate Reports 3

1.1.1. Log File 3

1.1.2. Scan Files 3

1.1.3. Template File 3

1.1.4. Translator File 3

2. Getting Started 4

2.1. Setting up the log file 4

2.2. Collect some data 5

2.3. Templates and Translator files 6

2.4. Generating a Report 8

3. Creating and Amending Template Files 9

3.1. Example of how to create a template 9

3.1.1. The Header 9

3.1.2. The Scan Data 10

4. Mapping the Data 11

5. Transferring files to a Desktop PC 16

6. Appendix 1 18

7. Appendix 2 19

8. Appendix 3 20

9. Appendix 4 21

Introduction

This document is an introduction on how to use the TDScan reporting software. The reporting software allows the operator to summarise TOFD and Strip Scan files that have been analysed, in a tabular format.

1 Components used to Generate Reports

To generate a report, a number of different components are required:

1 Log File

Every time a TOFD or Strip Scan is done, an entry is added to a log file. When a report is run, it asks for a log file. The contents of this file tell the reporting software which scan files to look at.

2 Scan Files

To generate a report, one or more scan files are required. These files should have been analysed, and any defects marked.

3 Template File

A template file is a Rich Text document that governs how the final output should be formatted. This template can be edited in WordPad (which is built in to Windows) or any other word processing package that can save files in the RTF format (e.g. Word).

4 Translator File

This file links data in the scan files to places on the template file. The TDScan software provides a mechanism to edit this file.

Getting Started

For this example a TOFD report will be created. However, the same principals apply to the Strip Scan reporting software (but only automatic, and not manually added defects are reported).

The first part of the process is to configure the TDScan software to collect TOFD data (include setting up the Text Headers and fields). This process is beyond the scope of this document.

1 Setting up the log file

To make it easier to move the files to another machine (either for analysis, archiving or to run the reports) it is recommended that a new folder is created for each job, and the log file and the scan files are contained in that folder. To achieve this, perform the following steps:

1. From the main menu, select “Setup”, followed by “Report Setup”.

2. Click on “Tofd Reports” from the left hand pane. Click on the Browse button to the right of this pane.

3. This will show the windows file window. [pic] Navigate to a suitable location and right click with the mouse. Select New, then Folder and create a new folder (in my example I have called it TofdTest).

4. Open the folder by double clicking it and enter a suitable name for the log file. This should be something meaningful – I have used the name TofdReportDemo. Press the Save button.

5. A message box will appear asking the operator if they would like to update the Auto File Name folder[pic]Press the Yes button. This will configure the software to save the scan files in to the same directory as the log file.

6. Another window will then prompt the operator to enter a base file name. [pic]

7. Type in a suitable name. This name will automatically set the names of the scan files. For example: TofdDemo_000.scn, TofdDemo_001.scn etc.

8. Press OK on the filename window, then OK on the Configure reports window. The log file and scan files are now set to go in to the same folder.

2 Collect some data

The next part of the process is to collect some TOFD scan data and marking up one or more defects. Doing this is beyond the scope of this document. For demonstration purposes I have performed 4 scans and marked up two imaginary defects in one of the scan files:

[pic]

3 Templates and Translator files

On the TDScan software CD, there are some demonstration report template and translator files. Later sections of this document will describe how to create your own templates – but for this demonstration, the templates from the CD will suffice.

Copy the folder “Report Templates” from the CD to a suitable location on your machine.

Using the report setup screen, expand the “TOFD Reports” option, then the “Daily Activity Report” option and highlight the “Fist Page(Mandatory) option. The screen should look like this:

[pic]

In the Template File box press the Browse button and find the template, as copied from the CD:

[pic]

Select “Daily Log Sheet.rtf” and press Open.

Locate the translator file from the same location and press open. The Report Setup screen should now look something like this:

[pic]

Press Ok to configure the report software, then repeat this process for the Inspection Report.

4 Generating a Report

To generate a report, perform the following steps:

1. Select File, then Tofd reports from the main menu [pic]

2. In the Daily Activity Log Report section, press “Generate”. This will open a windows file browser. Select the log file (as created in Section 2.1

3. Press the Browse button in the Daily Overview section, and navigate to the log file (as configured in section 2.1) and press Open.

4. After a short while the process will complete.

5. Tick “Include scans with no defects” in the Inspection Report box. Press Generate, and select the log file when the browser window opens and click the Open button.

6. Using windows explorer, navigate to the folder used to store the log file and scan files. It should look something like this: [pic]

7. The daily log sheet and inspection report can be viewed and printed using WordPad, or any other word processing package that is capable of reading rtf files (e.g. Microsoft Word).

Creating and Amending Template Files

The template file is used to set the appearance of the report. It can contain a table, different fonts and even graphics and logos. To generate a report you need at least one template file. However, the software allows you to specify two, one for the first page and one for subsequent pages. This is useful if you wish to have the header information and a few lines of data on the first page, and just data on subsequent pages.

There are two types of data that can be incorporated in to a report:

- Header Data – which comes from information in the file. This includes header text, page numbers comments etc.

- Scan Data – this comes from defects that have been marked up in the file (or automatically generated in the case of strip scan).

Appendix 1 contains a list of all the data that can currently be mapped.

A template can be created or amended using WordPad. Every time you want to include some header data, use the ^ symbol followed by a three digit number. E.g. ^003.

Scan data is represented the $ symbol followed by the row as a 2 digit number then column as a 2 digit number. So, $0203 would represent the data for row 2, column 3.

1 Example of how to create a template

1 The Header

If I wanted to create a header for an inspection report, it may look something like this:

|^001 |^002 |^003 |^004 |^005 |^006 |

|^007 |^008 |^009 |^010 |^011 |^012 |

|^013 |^014 |^015 |^016 |Scan Date: |^017 |

The bold numbers preceded by the ^ will become the title. The non-bold numbers will form the data.

2 The Scan Data

Similarly, I would then need to add the scan data. I could add something like:

|X (mm) |Y(mm) |Result |

|Start |End |

|PAGE_MAX |Last Page of the report |

|COMMENT |Comment – comes from the text tab on Hardware Setup |

|FILE_NAME |Name of the File |

|SCAN_DATE |Date the scan took place |

|SCAN_TIME |Time the Scan took place |

|CUR_DATE |Current Date |

|CUR_TIME |Current Time |

|FLASH_SERIAL_NO |Serial Number of equipment that performed the scan |

|SCAN_MIN_X |Scan start position(x) (TOFD only) |

|SCAN_MAX_X |Scan end position(x) (TOFD only) |

|SCAN_MIN_Y |Scan start position(y) (TOFD only) |

|SCAN_MAX_Y |Scan end position(y) (TOFD only) |

|PCS |Probe Separation (TOFD only) |

|PRB_ANG |Probe Angle (TOFD only) |

|PRB_SNO |Probe Serial Number (TOFD only) |

|PRB_CRYSTAL_DIA |Probe Crystal Diameter (TOFD only) |

|SPECIMEN_DEPTH |Specimen Depth (TOFD only) |

|PRB_FREQ |Probe Frequency (TOFD only) |

|LAST_CAL_FILE |Last Calibration File (TOFD only) |

|CAL_BLOCK_TYPE |Calibration block type (TOFD only) |

|CAL_BLOCK_REF |The calibration block ref (TOFD only) |

|HDR_xxx |Text Field Names – text tab on Config |

|TXT_xxx |Contents of the text fields – text tab on Hardware Setup |

|INDIC_X |Indication Location (x) |

|INDIC_Y |Indication Location (y) |

|INDIC_Z |Indication Location (z) |

|INDIC_LEN |Indication Length |

|INDIC_AMP |Indication Amplitude |

|INDIC_ZONE |Indication Zone |

|INDIC_X_IF_ACC |Indication Acceptable |

|INDIC_X_IF_NACC |Indication not Acceptable |

|WELD_STATUS |Number of indications in a file |

|TOFD_DEF_X1 |Defect start position (TOFD only) |

|TOFD_DEF_X2 |Defect end position (TOFD only) |

|TOFD_DEF_LEN |Defect length (TOFD only) |

|TOFD_DEF_TOP |Defect top (TOFD only) |

|TOFD_DEF_BOT |Defect bottom (TOFD only) |

|TOFD_DEF_HT |Defect height (TOFD only) |

|TOFD_DEF_CLASS |Defect classification (TOFD only) |

|TOFD_DEF_STATUS |Defect status (TOFD only) |

|TOFD_DEF_COMM |Defect Comment (TOFD only) |

|TOFD_DEF_NO |Defect Number (TOFD only) |

| | |

Appendix 2

Template used in worked examples:

TD Inspections Limited

|^001 |^002 |^003 |^004 |^005 |^006 |

|^007 |^008 |^009 |^010 |^011 |^012 |

|^013 |^014 |^015 |^016 |Scan Date: |^017 |

|X (mm) |Y(mm) |Result |

|Start |End |Length |Start |End |Length |

|Location |X1 |Ref |1234 |Operator |DQ |

|Probe |P12797 |Couplant |Water |Scan Date: | 7 - December - 2011|

|X (mm) |Y(mm) |Result |

|Start |End |Length |

|Scan files |ϖ1 or more files required ϖmust have been analysed | |

|Template file |ϖgoverns final output ϖmust be in RTF format | |

|Translator file |links scan file data to places in report | |

1. The Basic Process

[pic]

2. Setup Log File

[pic]

3. [pic][pic]

-----------------------

TD

TD

TD

TD

Collect Data

Set up

Log File

Create

Template

Map Data

Transfer Scan Files from

Acquisition

Unit to PC

Generate Report

Setup

Report Setup

ToFD Reports

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download