Select Records to Extract from QAD EA

To extract the data:

1	Choose the domain containing the items you want to load.

2	Enter the item attribute to use for selecting records in the first query field. The choices are item number, customer item number, customer number, product line, item type, status, site, group, promotion group, division, and date added.

3	Choose an operator from the list: =, <>, <, <=, >, >=

4	Enter the value you want to match on, such as type = FG. Determine these values from QAD EA, since your input is not validated on the Catalog Load screen.

5	Select a command to continue or end the current query.

6	Indicate whether to append records to an existing spreadsheet.

•	When this check box is selected, the records that match the specified selection criteria are added to the bottom of the last set of records you extracted. You can use this feature to build a master list based on several different queries.

•	When this check box is not selected, a new CSV file is created. If you have not loaded the previously extracted values into QAD CSS, they are overwritten. Use this feature for a new query or when you want to discard the results of a query because they are not what you expected.

Note: If you want to maintain the query results, save the files—in CSV format—in a work area with unique names before executing a new query.

7	Click Extract QAD EA Records. The system extracts records based on the query you have created and displays them in an Excel spreadsheet named Items.cvs.

8	Save this spreadsheet with a unique name to a local drive or your network file share. If you are working with multiple files, include a date and time stamp to ensure file uniqueness, such as FGTypeItems92004.cvs.

Note: If you execute multiple queries and append the data, chaces are that the results include duplicate records. Sort the data by item ID and make sure that there are no duplicates before loading. If duplicates exist, when the load is done with overwrite enabled, the system applies the values from the last record loaded; otherwise, errors result from the duplicate records.