Feature - Improved Support for Custom DDFs

Feature - Improved Support for Custom DDFs

Release Date: 6/5/2023
Elliott Versions: 8.6 and Higher

Background

Some customers have modified the standard Elliott DDF files to include custom information that is vital to their business.  For example, the gun industry requires an FFL number and date to be associated with each customer record.  In situations like these, Elliott customers have typically replaced the standard DDFs with their custom DDFs in the ...\Bin86\DDF40 folder.

Unfortunately, the Elliott update process for V8.6 and higher sometimes will need to override the DDFs in the ...\Bin86\DDF40 folder (e.g., when a new, standard field is added to a record).  With this update, we are allowing those customers to specify a folder where they can have their DDF files, where Elliott will look for them and where an Elliott update will not disturb them.

Specifying Location of Custom DDFs

In order to specify a location for your custom DDFs, you must manually edit EL860.CFG in the ...\Bin86 folder.  Add the following section and entry:

     [Transaction-DDF]
     Path=<relative or absolute path>

<relative or absolute path> specifies the custom DDF folder, like ".\DDF40\MYDDFS" or "C:\Elliott8\Bin86\DDF40\MYDDFS".

Note:  A relative path is specified relative to <Root>\Bin86.

If this entry is missing, as it will be for most Elliott customers, the DDF files will be used from the ...\Bin86\DDF40 folder.

Elliott Usage of Custom DDFs

The following processes will use custom DDFs when they are available:
  • The Elliott Export Processor
  • Some internal Elliott processes that use generalized File Access
  • DDF2BTR
The following processes will not use custom DDFs:
  • Elliott Web Services
  • PowerSearch
  • Report Desk
Note: You can use SQL functions, like SUBSTRING, to create a "custom" field in your searches and reports.

Other Software
If you use other software (for example a reporting tool like Crystal Reports), they should not point to the ...\Bin86\DDF40 folder directly or indirectly, because that folder can be overridden by an Elliott update.


Programs: NWSMDDFM, DDF2BTR
JEG

    • Related Articles

    • EL860DDF: Updating DDFs in Elliott 8.6

      Date: 6/30/2025 Versions: Elliott v8.6 and Higher Background From time to time, the .DDF files that define the database tables in Elliott need to be updated. For example, when a flag is introduced to enable a new feature, a database table has a new ...
    • A Support Case of Migrating to Different Version of DDF

      Release Date: 4/24/19 Version: All Q - I've been asked to set up UPS Worldship to access customer shipping addresses in Elliott. I've run into a problem mapping City, State, and Zip fields to Elliott. Looks like Elliott concatenates these fields to ...
    • Cannot Create DDFs Due to Metadata Version Mismatch

      Release Date: 11/28/2022 Version: 8.5 or Higher Q - We recently upgraded to Actian PSQL 15. I wanted to create a new ODBC database. So I go to PSQL Control Center, right click on the "Database" node and choose "New" to create the database, but it is ...
    • A Comparison of Elliott 7.5, 8.2, 8.5, 8.6 and 8.6 V2 DDF Files

      Release Date: 11/15/2022 Last Updated: 06/25/2024 Version: 7.5 & Up DDF Files are used to define the PSQL database schema. Generally speaking, we distribute five different types of DDF files for different versions of Elliott releases: 7.5 DDF: These ...
    • Feature - COP Custom Product Structure to Show Price & Cost

      Release Date - 4/13/17 NOTE: The screens for the application were changed in Version 7.58.608/8.28.608. The cost and price screens were combined into one screen. See ...