Convert STDF To CSV and Other Formats
STDF Converter is an extremely flexible batch STDF converter. It can read one or more STDF files and generate CSV, Excel xlsx or JMP JSL data from the files. The output file can contain parametric, bin summary or test summary (pass-fail by test) data from the files. CSV files can be loaded into Excel and almost every other data analysis tool and database, so STDF Converter lets you get your data into whatever tool you are comfortable using.
STDF QuickChange is published as a gzipped tar file so that it can easily be installed on Linux servers or any personal computer. In the following instructions, the name of the downloaded file will vary slightly, depending on the actual version to be installed.
- Make sure you have Java 1.7 or newer installed and in your execution path. You can download the Java runtime here.
- Download the STDF QuickChange gzipped tar file. Then, on Linux or Mac OS X run gunzip and tar -xf on the downloaded file. On Widows, use 7-zip or an equivalent to extract the files into the directory you choose. For ease of use, we recommend adding the directory into which you untarred the files to your path. We can provide you instructions on adding the directory to your path if you need them.
- Once you have installed the files, you can either build complete calls yourself using the commands described below for maximum flexibility or use the provided examples. For command line transformation of STDF files into other formats, the provided examples are converter.bash and converter.bat, depending on whether you are on Linux/Mac OS X or Microsoft Windows.
Often you can use the supplied data conversion script like this:
converter.bash /tmp/input/test.stdf /tmp/output.csv
This example reads in test.stdf and outputs its parametric data in a csv format.
Complete usage looks like this, with the semicolon(;) characters replaced with colons(:) on Linux and Mac OS X:
java -cp "stdfConverter.jar";"guava-16.0.jar";"commons-cli-1.2.jar";"sqlitejdbc-v056.jar";"gson-2.7.jar" spry.stdf.converter.StdfConverter -parametric -csv -output outfile.csv infile.stdf
-cp "stdfConverter.jar";"guava-16.0.jar";"commons-cli-1.2.jar";"sqlitejdbc-v056.jar"indicates dependencies of the tool. All of these files are included in the install. Replace the ; character with : on Linux or Mac OS X. You should not need to change the rest of this value, unless for some reason you installed different versions of the jar files.
spry.stdf.converter.StdfConverterthis is the name of the executable class inside QuickChange Utilities. You should not need to change this value.
-parametricindicates that the converter should output parametric data to a file
-csvindicates that output files should be in comma separated value format
-outputindicates that the next value is the desired name of the output file
infile.stdfinfile.stdf is the name of the input file. Note that more than one input file can be named, separated by spaces at the end of the options.
- Full list of available options:
- -csv output data in CSV format
- -jsl output data in JMP JSL format
- -xml output STDF records in XML
- -json output STDF records in JSON
- -hardbin output hardware bin summary data
- -help to get this information
- -includepf include pass-fail column for each test in parametric results reports
- -inputdir to read input files from given directory, optionally recursively
- -multi_by_test output data with devices as columns and tests (either PTR or MPR) as rows, essentially reversing rows and columns from -parametric
- -multi_parametric output data from MPR (multiple parametric result) records
- -output output results to file instead of standard out
- -outputdir output results to files in directory, with name derived from input file name and data type
- -parametric output parametric data. This option is on by default
- -recursive read input files from subdirectories of inputdir
- -softbin output software bin summary data
- -split splits output into a number of files having no more than the given # of columns per file. Put the value ### in the output file name to indicate where the file number should go, if not at the end
- -testsummary output test summary data, including limits
- -timestampoutput indicates that output file names should include a timestamp derived from input data
Need Some Help Getting Started?
We know each batch process has unique setup problems, a unique runtime environment and unique output requirements, so we are happy to provide free support to help you try out and deploy STDF QuickChange. Just contact us and we will help you get up and running with STDF Converter.
Interested? Try STDF Converter and the rest of STDF QuickChange for 15 days and see how it helps you analyze your data.
Ready to Buy?
Selecting Buy Now allows you to purchase one or more STDF QuickChange licenses via credit card or PayPal for USD 395 each. If you are interested in purchasing licenses but prefer to use a credit card without paying online, a purchase order or another payment mechanism, let us know by mailing email@example.com or clicking the Contact Us link. We are happy to accommodate any of those mechanisms. You can also contact us about volume license discounts.
For more information, please Contact Us.