Feature - ASCII File Filter Condition in Mass Email and Export Processor

Feature - ASCII File Filter Condition in Mass Email and Export Processor

Release Date: 1/31/19

This feature allows the user to specify an ASCII file to use as the filter condition when running Mass Email or the Export Processor application. New selection criteria has been added to the Filter tab. Users must choose if they will use the standard filter conditions or if they would like to use an ASCII file with selected keys for the selection criteria.



The default behavior is to use the standard filter criteria. When this option is chosen, the user will not have access to the File field or the Browse Button in the Selected File group.

If the Use Selected File option is chosen, users will have access to the Selected File group but access will be restricted in the Filter group.



Pressing the information button in the Selected File group displays information about the file layout.



Each line of the ASCII text file specified should contain a key value that corresponds to the table chosen on the category screen. For example, if the Customer category is chosen the file should contain a list of customer numbers. There should be one customer number per line:

000100
001300
501000
ABC123

When this file is processed using the Mass Email application, the application will verify that the customer number is on file. It will also verify that an eContact exists for the customer with an email address specified. The results returned in the processing window will be determined based on this criteria.

When this file is processed using the Export Processor application, the application will verify that the customer number is on file. The results returned in the processing window will be determined based on this criteria.

Programs Modified: NWSMMSEM.GDF, NWSMMSEM, SYMSEMTP.FD
New Copybook: NWMEHELP.GDF
CLS



    • Related Articles

    • Feature - Support 12 Months History in Export Processor

      Release Date - 7/13/17 Note: This feature is only available in version 8.2 and above. The Export Processer now supports the 12 Month History Summary file for the following tables and values: Customers: Total sales for the customer by period Total ...

    • 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 ...

    • How Do I Give Someone Access to Export Processor?

      Q - How do I give someone access to Export Processor? A - There are two levels to this question: How to give a user access to Export Processor; How to give a user access to each specific "Group of Records" in Export Processor. How to Give a User ...

    • 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 ...

    • 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 ...