go to post Doug Strzalko · Apr 17, 2023 Thank You! I'll work on making these changes. As always your assistance is greatly appreciated.
go to post Doug Strzalko · Apr 14, 2023 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 0000202004012020030510000ISC 000145452 0000000020000EA
go to post Doug Strzalko · Sep 21, 2021 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
go to post Doug Strzalko · Sep 20, 2021 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
go to post Doug Strzalko · Sep 20, 2021 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
go to post Doug Strzalko · Sep 17, 2021 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>|
