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 - 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 ...
    • 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 ...
    • Feature - Mass Change Salesman Utility

      Release date: 1/17/2017 A new Mass Change Salesman utility has been added to Global Setup, Utilities, and A/R Utilities. This utility can assist in situations where a salesperson has left the company and their customers are reassigned to a new ...
    • 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 ...
    • Feature - New Option to Create Email Logs with User ID in File Name

      Release date: 01/22/2017 In Elliott V8, if you choose the SMTP interface to send emails, one common complaint from users is that they don't see a list of emails they sent from Elliott in their email outbox. This is because the SMTP interface does not ...