How to Find a Record that Does Not Have a Certain Attribute in Export Processor

How to Find a Record that Does Not Have a Certain Attribute in Export Processor

Release Date: 03/21/2024
Version: 8.0 & Up

Q - Just so we're sure of ourselves over here, there is still no way to use Export Processor to find records where an attribute is NOT attached to the record, correct? We're needing to filter this way often now. I searched the support site but couldn't find anything.

A - That is not true. What you can do is in the filter screen. Find the “Attribute Code” under the last row of the table. Below is a sample for the Customer category:


Then use the “NE” (Not Equal) operation to indicate the particular attribute code does not exist as a selection criteria. See sample screen below:


The above sample filter criteria will give you all customers for which the attribute code "XYZ" does not exist.


EMK


    • Related Articles

    • Using the Export Processor to Export Data

      Q: It has been a while since we used the Export Processor to Export Data from Elliott. I remember how to select the category and choose the search data, but I can't remember how to select all the fields that need to be processed for export. Can you ...

    • Export Processor Does Not Find Record Due to Space in Item Number

      Release: 7/2/2021 Version: 7.5 & Up Q - I attempted to run the Exporter on the Sales History TRX looking for sales equal to 9835-GS KIT. It pulled back 0 sales. See sample screen below: Knowing this to be not valid, I then ran the Exporter looking ...

    • Export Processor Limitation on Processing Large Amount of Records

      Release Date: 5/13/2021 Version: 8.0 & Up Q - I exported all invoice header records from our production company using Export Processor. No filters were used. As you can imagine, this took a long time. No errors were encountered while it was ...

    • How to Copy All Export Processor's Templates from One Company to Another

      Release Date: 09/06/2023 Version: 8.0 & Up Q - How do I copy all my export processor's templates from one company to another (e.g., from company 03 to 08)? See sample screen below for all my templates: A - In your example, you can copy the table ...

    • Feature - Equal Sign Support in Export Processor

      Release Date - 1/5/18 When exporting Elliott's alphanumeric fields to CSV through the Export Processor, the leading zeroes will be dropped when the file is opened with Excel. For example, when opening the CSV in Excel, item number 0100 is displayed ...