CSV Query

This program allows you to process simple database style queries directly on a CSV output report. CSV QUERY will allow you find some information, without needing to import the CSV file into a database. It can also be used to choose which records and columns that are imported into a database. In addition, the csvquery can prepare a list of orders to be processed, delete list of items, or copy a list of items.

The csvquery program takes a CSV file as input, and generates a CSV file as output. It has several commands. Query File Name is a required input file. It is the name of the CSV file that has the data to be processed. CSV Import Report Name is a name of the report you are having created by the query.

You can specify an optional output file. The results of the query are written to this file. If no output file is specified, then the results go to the screen.

Finally,the CSV Query will accept an optional Action command. This optional command specifies what to do with the list of items. It can write the list to the order processing form in the AccuMark. It can delete the list of items, or it can copy the list of items to a new storage area.