IDEAScripts

Please see this page for instructions on how to install python scripts. 

Copy Header Info

Brian Element
Background

The script will copy the header info from one file to another file.  This can be used when importing an excel file in which the data is over several tabs but the header info is only on the first tab.  The script will take the header info from the first and copy it to the second file.

The script was updated on March 17, 2016.  It now has an option to copy the old header name to the field description so that information is not lost.

Export Delimited File

Brian Element
Background

This script gives additional options for anyone wishing to export an IDEA file in a delimited format.

2015-08-15 - Updated the script so that the if you user select to include field names that they are separated by the selected field separator and not the ",".  Also added code to format numbers, it seems that if you had a number like 12.10 it would be stored in the text file as 12.1, this has been fixed.

Import Multiple Files

Brian Element
Background

This script is now available as a SmartAnalyzer application, it is available through Passport with the Utilities SmartAnalyzer applications.  Please consider purchasing this application as it helps to support this web site.

This script will allow you to select and import multiple files at the same time.

March 16, 2014 - Updated - added an option for delimited files to select the first row as the field names.

April 8, 2014 - Updated - there was a bug in the select files dialog that would not allow you to move a file from the right panel to the left.

Date Extraction

Brian Element
Background

This script extracts a maximum of 24 specified dates entered (Enter Dates button) or loaded from a text file (Load Dates File button).  Days of the week can also be extracted into separate files. Specified dates or days of the week selection can be inverted by checking the "Output all dates NOT selected" box. Dates must be entered using the DDMM format. Text files with dates can be created for subsequent reuse or loading by selecting the Save Button after inputting dates via the Enter Dates button.

Top Records Extraction Exclusion

Brian Element
Background

This script will perform the Top Records Extraction function within IDEA but at the same time it will also creates a second file with all the records that are not part of the Top Records Extractions. After selecting your file and hitting ok you will be taken to the Top Records Extraction dialog where you can enter all the parameters needed for the Top Records Extraction.  The script will then perform the extraction and then do a join to extract all the non selected items.