Select Records to Extract from QAD EA

To extract the data you need to:

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. You must 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 if records should be appended 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 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 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, the results may include duplicate records. You should sort the data by item ID and ensure there are no duplicates before loading. When duplicates exist, the values from the last record loaded will apply if the load is done with overwrite enabled; otherwise, errors will result from the duplicate records.