Feature - Equal Sign Support in Export Processor

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 as 100 because the leading zero is dropped. This can be addressed by placing an equal sign before the first quote when the CSV file is created. For example, item 0100 would normally be exported as "0100." With the equal sign added, it now exports as ="0100." This forces Excel to use the values within the quotes without dropping the leading zeroes.

This feature addresses this issue. A new option has been added to the Export Processor to allow the user to choose which field should be exported with an equal sign. This feature can be enabled and disabled by pressing the right mouse button when highlighting a selected field in the list view. 



A new option 'Export with "="..." is available. Once chosen, an equal sign is placed in front of the field name to indicate that it will be exported with an equal sign.

Here is an example of the exported file in Excel using the new equal sign option.



Notice that the formula shows the equal sign before the first quote. Also, notice that the leading zeroes in the customer number field are still present.

Programs Modified: NWSMMSEM
CLS


    • Related Articles

    • Feature - Toggle Equal Sign Export in User Defined CSV Export Report

      Release Date: 03/14/2025 Version: 8.5 & up Added an F5 option to I/M, Report, Reorder Advice/User Def CSV, Print, User Defined CSV Export and field 7, "Item Has Attribute" to toggle the value of Export Equal Sign between Y, N, and blank. Blank is the ...

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

    • Avalara Attribute Support

      Release Date: 4/28/23 Updated: 4/25/25 Version: 8.6 and Above For Elliott to work with the Avalara Sales Tax Interface, there are additional data to be stored on the Elliott side. Our implementation chooses to store these data in the following ...

    • BM1601 Bill of Material Feature/Option Configuration Inquiry

      BM1601 Bill of Material Feature/Option Configuration Inquiry ← Bill of Material / Work Order Plus Feature/Option Configuration Inquiry Application Overview The Feature/Option Configuration Inquiry application provides an easy way to display various ...