Prepare a sample source file
|Top Previous Next|
When preparing a configuration it is best to have access to a sample of at least 2 years of crash data. It is best to have all the date, but 2 years generally makes a reliable configuration possible.
While preparing a configuration, it will often take several attempts to be successful at converting and importing the source data. For this reason, it is best to create a smaller extract of the full sample. This will allow for repeated convert / import tests with the least time spent waiting for the importer.
•Individual XML files, this is simply a matter of zipping a few together into a test zip file.
•A single large XML file, use notepad++ to extract a dozen or so crashes from the larger file into a single smaller one.
•A database query, simply reduce the query to a single or several days worth of data
•CSV or other files that require converting, there are two options:
oEdit the CSV file to only contain a dozen or so records. This can be a little tricky if there are several related files.
oPlan to use the Import - DB to XML queries to limit the converted data with a WHERE clause. After completing the initial import process, remove the WHERE clause to allow for all records to be processed.