Importing / Exporting Your Test Data

Importing Files

Select the "Import File" option from the "File Menu" (Quick Key Press CTRL + L),

You may want to merge two or more files within SimplyPats. You may need to do this if the job for a customer has more appliances than your PAT Tester can hold and you have to download 2 or more files.

To import files, first load the first file you downloaded, then click on the "File" menu and instead of clicking on "Open", click on "Import File" and select another file you wish to add to the file you already have loaded. It is a good idea to use the "Save As" option from the "File" menu to save this with a new name. By doing this you will still have your two original files, and the new file wil be a combination of both. Of course, there is nothing to stop you merging as many files as you want, although, remember that SimplyPats has a limit of 20,000 tests in any one file.

Importing And Updating Data

Selecting the "Import And Update" option from the "Records Menu" to update your currently open SimplyPats file with data from another file. You can use this option if you are trying to maintain an up to date master SimplyPats file for a site. It is particularly useful if you are doing 3 monthly retests and wish to update the test records with the new data. See Also Import And Update screen

Opening Native Files Produced By PAT Testers or other PAT Software

You can select various additonal file types to load, these are produced by other PAT Testing Programs or are the native format produced by the PAT tester. These options can be useful if you have switch to using SimplyPats after using a an alternative PAT Testing program.

(Metrel .opt Files - Used by the Metrel PAT Link program - These files can be imported by us, please contact us if you need to convert Metrel .opt files into SimplyPats format.)

To import these files, click on the download button on the toolbar, or select the "Download PAT" option from the "File Menu" (Quick Key Press CTRL + D)

Select which PAT tester you have, and you should see an Import Button for the appropriate native file. For example shown below is the Fluke Download page and the Import button.

Ensure if there are Notes fields, or comments lines in your pat that you have set their use within SimplyPats as you want them. See Using the Notes Fields.

Once you click on the Open button you will be prompted to select the file you wish to import.

Opening inspHire Rental Software Files

Select the "Open File" option from the "File Menu" (Quick Key Press CTRL + O)

From the "Files Of Type" drop down box at the bottom of the open File Screen, select inspHire to SimplyPats Import File.

This will import the inspHire to SimplyPats .csv import files created by the inspHire Rental Software.

See also the inspHire help page for any other notes on using SimplyPats with inspHire

Specific Version Information

Manual Entry Version

In the Manual Entry Version of SimplyPats, the Download PAT option is unavailable as you are not permitted to download from any PAT Testers.

MPAT SUITE (Martindale) Version

The MPAT SUITE (Martindale) Version of SimplyPats, only supports download from the MPATPLUS, with manual entry of Asset and Test Data also supported. You can import MPAT Plus TXT files.

KEWPAT Pro (Kewtech) Version

The KEWPAT Pro (Kewtech) Version of SimplyPats, only supports download from the Kewtech KT74, KT75, KT77 and Robin SmartPat 5000 5500, with manual entry of Asset and Test Data also supported. You can import the SSS files for the KT77, TXT files for the KT74, KT75 and ROB files for the Robin SmartPat.

TRANSMILLE Version

The Transmille Version of SimplyPats, only supports download from the Transmille 6080, 6080 Plus and 6080 A, with manual entry of Asset and Test Data also supported. You can import the Transmille TXT files only.

 

Exporting Files

Select the "Save As " option from the "File Menu" (Quick Key Press F12),

Exporting in CSV Format

You can export your work in .CSV (Comma Separated Variable, readable by Microsoft Excel, Microsoft Access and many other programs.) and MDB format, readable by Microsoft Access. You may want to export your files in CSV format so that you can give the test results to your Customer in a format they can read with a spreadsheet program or database.

To export your file in .CSV, click on the "File" menu and then select "Save As", when the dialogue appears, click on "Save as type" and choose .CSV.

Remember - If you choose to save your work in CSV format, make sure you also save any changes to your file in the normal SimplyPats (.PAT) form. SimplyPats cannot load back .CSV files.

NOTE!

In .CSV (Comma Separated Value) files the first line of the file created contains the field names of the data.


Exporting in MDB Format

To export your file in Microsoft Access .MDB, click on the "File" menu and then select "Save As", when the dialogue appears, click on "Save as type" and choose Microsoft Access (*,mdb).

After you click SAVE on the dialogue you will see the following screen appear as the database is created.

The database will take a few seconds to create dependant on the size of your data file. The database is stored in Microsoft Access 97 format and so is readable by most versions of Microsoft Access. See Also saving your Test Data

Exporting In Other Formats

It is possible to export your test reports in other formats: See Also Print Results

Word - Microsoft Rich Text format (rtf)
 Excel - Microsoft Excel format (xls)
 HTML - Web page format (htm)
 PDF - Adobe Acrobat format (pdf)
 Text - Plain text format (txt)
 Tiff - Tagged Image File format (tif)

Email Results

You can email the currently loaded data file (or selected tests from the current file) by selecting the "Tools Menu" and clicking on the "Email Data" (Quick Key Press CTRL + F4). This option only works if you are using Microsoft Outlook Express or Microsoft Outlook as your default mail program.
See Also Email Results

Note! Emailing from SimplyPats doesn't work with Non Microsoft email programs such as Incredimail etc.

Drag And Drop To Other Programs

Dragging and Dropping appliance information from SimplyPats into other programs. This is something known as OLE (Object Linking and Embedding) and simply means that if more than one program is OLE enabled, you can drag and drop data from one program into another. In SimplyPats, if you select a range of tests you can drag those into an open Microsoft Word (tmp) Document, Excel (tm) Spreadsheet or any other OLE enabled program. See Also Drag And Drop

Return To Contents

(Last Updated 09/10/2012)