To limit the data extracted during an export, create a simple query of one of these types:
Name/Key query
Date query
A query file follows the same behavior you are exporting. Only columns specified in the header are extracted, in the order specified. Each row specifies a record to extract. To identify the objects to extract, specify names or keys. Wild cards are not supported, so you must specify one record, with the exact name, for each object to extract. For measures, specify a date.
To run name\key queries:
In Microsoft Excel, or another text application, create a CSV text file that contains the Name, Key or ID column of the object to be exported.
Optional: Add a new row for each additional Name in the query.
Note:
Wildcard characters are not supported in a query.
From the Windows main menu, select Start then Run.
The Run dialog box is displayed.
In Open, type cmd, then click OK.
The Command window is displayed.
On the command line, enter:
cdpath to Import.bat.By default, the .bat |.sh files are in:
hps\9.5.0.0\Tools\bin.Enter the import command, using this format:
export behavior filename.csv —q query.csv.
When the processing is complete, a message is displayed.
To run date queries:
In Microsoft Excel, or another text application, create a CSV text file that contains the Action and Date for which you want data to be exported. For example, an action of “V” and a date of 01/01/2006.
Optional: Add a new row for each additional date in the query.
From Windows, select Start, then Run.
The Run dialog box is displayed.
In Open, type cmd, then click OK.
The Command window is displayed.
On the command line, enter cd path to Import.bat|.sh.
By default, the .bat |.sh file is in:
hps\9.5.0.0\Tools\bin.Enter the import command, using this format:
import behavior query.csv [options]
See Behaviors.
When the processing is complete, a message is displayed.