All
Accepted answers
Doug Strzalko · Sep 17, 2021 go to post

To use a complex record map I will need to have the source file format to be modified to something like this, correct?

PID|<PID-3>|<PID-5>|<PID-7>|<PID-8>|<PID-19>|

PV1|<PV1-19>|

OBR|<OBR-3>|<OBR-4>|<OBR-7>|<OBR-16>|<OBR-22>|<OBR-25>|

OBX|<OBX-2>|<OBX-3>|<OBX-5>|<OBX-6>|<OBX-7>|<OBX-8>|<OBX-11>|

OBX|<OBX-2>|<OBX-3>|<OBX-5>|<OBX-6>|<OBX-7>|<OBX-8>|<OBX-11>|

OBX|<OBX-2>|<OBX-3>|<OBX-5>|<OBX-6>|<OBX-7>|<OBX-8>|<OBX-11>|

Doug Strzalko · Sep 20, 2021 go to post

Hi Jeff,

Good to hear from you :)

I updated my record map and data transformation but when I tried to process a message I received the following errors

I must be missing something because when I created my data transformation and selected my record map as the Source Class it won't allow me to define a Source Document Type.

Thanks

Doug Strzalko · Sep 20, 2021 go to post

Thanks Jeff,

it looks like it parsing the OBX fields now

Now I need to figure out why it's not hitting the rule with my data transformation

Doug Strzalko · Sep 21, 2021 go to post

Hi Jeff,

I just to let you know after I updated the rule and corrected a type-o in the transformation :) I was able to get the OBX data to populate the correct OBX fields

Thanks again for all of your help.

Doug

Doug Strzalko · Apr 14, 2023 go to post

Hi Jeff

Thank you for your help, it’s always good to hear from you and your help is always appreciated.

Unfortunately, when I provided a copy of the output to the vendor they indicated that the spec I was provided was out of date and the new spec calls for a fixed length file. However, some of the fields need to be zero filed and other filed with spaces.

Example the second field in each line the file is location, that field length is five characters but left justified, in another example the quantity field is a total of 13 characters the first 9 are the whole number and the last 4 are decimal

10000ISC  00002020040120200305
10000ISC  000145452                    0000000020000EA

Doug Strzalko · Apr 17, 2023 go to post

Thank You! I'll work on making these changes. As always your assistance is greatly appreciated.