Steve.Ela |
Member |
|
|
|
|
None Specified |
|
Wednesday, March 14, 2018 |
Tuesday, May 29, 2018 5:24:11 PM |
10 [0.06% of all post / 0.00 posts per day] |
|
That was what I was hoping. Encountered an error. I’ll need to find out where it’s actually coming from
|
We are using MapForce to process 837 EDI files. But have run into an issue. We have a few clients that use | for a separator, and most use *
Is there a way to pull that from the document, or pass it into mapforce from SQL at runtime?
MapForce 2018 Enterprise, exporting to C#
|
I see. I was under Node Functions, not Sequence Functions. Will try that.
|
I have data from the original document coming into the SQL Where, and if it matches, I am getting the result. When I tried the Substitute, I got the following error.
ERROR G702: Algorithm construction: Internal error: Invalid cast generated.
I assume the If/Else is expecting a simple True/False for the bool.
|
OK, I am getting close. I am using the SQL Where object to limit down to the exact field I need. However, if there is no value in the table for that line, I need to pass the existing value from the document.
I was going to use an If/Else, but I am not certain how to determine the number of results returned from the SQL Where object.
Is that possible?
|
When MapForce is writing from the source document to the destination document, is it a line by line, with the looping? If it is a straight bulk copy of data, then it would not work to intercept specific lines.
|
Hi folks.
I am loading an 837 document, and making a copy of it for an export file (EDI -> EDI) I need to update specific information during this copy (prices mainly).
I have a SQL view that has all the information I need, MRN, Visit and LX# to locate the specific charge line.
My question, how should the SQL view and EDI document be linked so I can properly update each price as it is written to the export document?
I was working on the assumption I could use the current MRN/Visit/LX and get the related information in the view, and insert the new value instead of the existing one. That has not been the case.
|
Thanks for the reply. I may not have it set up properly.
for this line
LIN**N4*00527172874~
I get
N400527172874
I set up a Variable, Simple, String and filtered it down to the LIN segment
(sorry, I referenced wrong segment in OP)
|
MapForce newbie here.
I need to save off the SV2 segment (and others) in an 837. I have the mappings for all the fields I need, but I need the entire SV2 line as a string so I can save it.
I am sure it is obvious, but I haven't found it yet.
This entire string so I can save it.
SV2*0636*HC>J2270*75.38*UN*2~
Any help would be appreciated.
|
|