PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Blended File Definitions  (Read 1090 times)

James Zukowski

  • Diamond Member
  • *****
  • Posts: 297
    • View Profile
Blended File Definitions
« on: July 30, 2020, 11:21:43 AM »
We're going through the process of upgrading our legacy system to modern times. WAY back, there was a field count limit to files, and we've still got a number of "master files" that are split between 2 or 3 actual files with similar names. We're defining each of these in the Nomads Data Dictionary.

When we do get to the point of being able to combine the component files into a single master file record, is there a way within Nomads to blend the files? E.g., Copy the primary Customer Master record to a new file, then add the fields from the secondary (and tertiary, etc.) file to the end of the new file. I know the fields can be copied out to the Global Dictionary and back in, but is there some other method that could preserve the field sequencing so we can minimize the manual intervention?

Thanks for your thoughts!
James Zukowski
Sr. Developer - J&E

BRAND>SAFWAY
Brand Industrial Services

Thomas Bock

  • Diamond Member
  • *****
  • Posts: 177
    • View Profile
Re: Blended File Definitions
« Reply #1 on: July 31, 2020, 02:02:58 AM »
Take a look at "Utilities / Import Dictionary".
It adds the fields of the selected file description to your current description. Afterwards you just need to delete the doubled fieldnames.

James Zukowski

  • Diamond Member
  • *****
  • Posts: 297
    • View Profile
Re: Blended File Definitions
« Reply #2 on: July 31, 2020, 09:39:23 AM »
That's exactly what I was looking for.
Thank you!
James Zukowski
Sr. Developer - J&E

BRAND>SAFWAY
Brand Industrial Services