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

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

    • Elliott SMTP Email Settings for Outlook 365 or Hosted Email Solutions

      Release Date: 1/19/2018 Revision Date: 9/26/2022 Version: 8.0 & Up Introduction Starting with Elliott V8, we support both SMTP and MAPI interfaces for sending emails. MAPI is the old email interface method, which we find more and more difficult to ...

    • 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 - Add Serial Number to Mass Billing CSV Import

      Release Date - 6/18/18 This feature allows the user to specify serial numbers when using the Mass Billing application and choosing the CSV Import option. The serial number is supported in column E of the CSV file: The application will test for the ...

    • Feature - Added a Generic Utility to Mass Update Customer by CSV

      Release Date: 9/26/18 Last Updated: 3/20/24 Added a generic utility to Mass Update Customer by CSV. Access to the new utility is found in two places: In AR: A/R-> Util-Setup-> Customer/eContact Import-> Update Salesman Utility has been changed to ...