Exporting Item Records Using the Job System

To export Item records using the Job system, set up an Export – Data job as described in Managing Jobs in the Administration Module. Set it up as follows:

  1. Specify the basic Job information in the General Info tab.
  2. Click Next or select the Data Source tab.
  3. If you have saved any searches, select one of them by clicking Saved Searches>Items>search_name. Otherwise, click New Search>Items>search_type. The following search types are available:
    • Items
    • Items by Site
    • Item Stats by Site
    • Items by Catalog
    • Items Images
    • Items Categories
    • Items Price Points
    • Items Vendor
    • Items Association
    • Items Catalog
  4. Add a data field or Attribute to the search criteria by doing the following:
    1. Select Field or Attribute from the first drop-down list. (Attribute is only available for search types where Attributes apply.)
    2. Select a specific field or Attribute from the second drop-down list. The specific fields or Attributes available depend on the search type.
    3. Click Add to add the selected field or Attribute to the search criteria. Click Add All to add all fields or Attributes to the search criteria.
    4. In the Condition section, select an operator from the drop-down list and enter a term in the text field. Available operators include (see the Conditional Search Functions Table for more information):
      • None
      • =
      • <>
      • LIKE
      • NOT LIKE
      • <
      • <=
      • >
      • >=
      • IS NULL
      • IS NOT NULL
      • IN
      • NOT IN
      • BETWEEN
    5. Check the Output box to include the selected field/ Attribute in the data export. If the box isn't checked, then the field/ Attribute is still used to search but isn't included in the data. By default, this box is checked.
    6. The output data fields appear and exported in the order they appear in this list. Use the red up and down arrow icons to move a field/ Attribute up or down in the list.
    7. Repeat the selection procedure to add more fields and/ or Attributes to the search/ output.
  5. Click Preview Data to see a preview of the search results. A maximum of 15 rows appear.
  6. Click Next or select the Map tab.
  7. Click Auto Map to generate a set of data field mappings. Or, create all the mappings manually.
  8. Follow these steps to map a data field:
    1. Enter a name for the output field in the text box and click Add. The field is added to the list.
    2. Select a source field from the drop-down list.
    3. Set a fixed value for the field by entering a value in the Fixed Value field. Then every exported data record has this value in this field instead of a value from the Data Source.
    4. Click Set to apply the map.
    5. The output data fields is exported in the order they appear in this list. Use the red up and down arrow icons to move a field up or down in the list.
    6. Repeat the selection procedure to add more fields to the output.
  9. Click Next or select the Data Sink tab.
  10. Select an output format from the Data Sink Location drop-down list. The following formats are available:
    • None
    • Attachment
    • FTP
    • SFTP
    • HTTP
    • Email
    • Database (not used for Data Sinks)
  11. Select a filename type from the Filename drop-down list. The following types are available:
    • UniqueID (Order Management generates the actual filename)
    • TimeStamp (Order Management generates the actual filename)
    • Custom (A text field is presented to specify the filename. Include the file extension; for example, “.csv”)
  12. Check a box in the Compression section to cause the file to be compressed using the selected protocol. By default, no box is checked.
  13. Select a file format from the Format drop-down list. The following formats are available:
    • CSV
    • XML
    • Dataset
  14. Click Next or select the Review tab.
  15. Click Submit Job for Processing to submit the job.