Will,
You say the source is a SQL query, is BCH01 an element in the query, or is it a target element in X12 output? If it is the latter, it probably won't work because BCH01 may not be available to the translator. Assuming this is your issue, my suggestion would be when you populate BCH01, also populate a variable v_BCH01 with the same value, but initializing it to something other than "01". Then set your condition to v_BCH01 <> "01". I think that will work better for you. Art (who has made every mistake at least once in Delta mapping.) From: [email protected] [mailto:[email protected]] On Behalf Of Kenoyer, Ben Sent: Wednesday, March 06, 2013 8:10 AM To: 'bigwillyv'; [email protected] Subject: RE: [EDI-L] Softshare Delta 5.0 Mapping Question Source=MS SQL DB, Target= EDI 860 v4010 Will: 1) If you are new to Liaison Delta, you may also benefit from seeking out the Yahoo discussion group specifically created for that ("EDI_Softshare"). The members of that group may be able to provide more specific advice on your application. Some of the members of that group are also members here, but you may find better feedback there. 2) As an effort toward advice to your problem: You may have a problem with the source node of your rules. Try setting a breakpoint on one of your rules before the BCH01, and then "step" through the subsequent rules. You may find that the source nodes of your rules are attempting to run the DTM rule before the BCH segment-which would always give you a negative result for your conditional check (BCH01 = '01'). Using the "step through" approach should also allow you to check the snapshot values of your elements, variables, and database records as you work through one rule in your map at a time. This is a great advantage of this software over some others. If you have to, you may need to create that breakpoint even higher in your ruleset so that you can be sure to see in what order your map is attempting to fire all of the rules which could be affecting your conditional check. Good luck! ~Ben Kenoyer From: [email protected] <mailto:EDI-L%40yahoogroups.com> [mailto:[email protected] <mailto:EDI-L%40yahoogroups.com> ] On Behalf Of bigwillyv Sent: Thursday, February 28, 2013 9:12 AM To: [email protected] <mailto:EDI-L%40yahoogroups.com> Subject: [EDI-L] Softshare Delta 5.0 Mapping Question Source=MS SQL DB, Target= EDI 860 v4010 All, I am completely new to Liaison Delta(fka Softshare Delta). I've worked in Gentran, eVision, and Altova. My question pertains to the conditions and expressions. I created a standard 860 EDI map which derives it's data from an MS SQL database table. I have a condition set on the DTM object which states: BCH01<>"01". In pseudocode, the logic is basically,"Run the rule to create the DTM segment so long as BCH01 IS NOT equal to "01". IF BCH01 = "01" skip creating this segment. The problem is, the map never creates a DTM segment when BCH01 = "04" which is exactly when it should. I have checked the table to ensure that there were values to be placed in the DTM segment and there are. Ostensibly, everything in the table is in place for a DTM and its elements and the condition on the DTM is set correctly, as far as I can tell. I modeled it based on information found on page 311 of the Liaison Delta Reference Manual. I know a lot of other information is lacking here but I simply cannot upload the map, models, or paste a screen shot of the rules. Any help, tips, or direction is appreciated here. Again, I am completely new to Liaison Delta. Thanks! Will [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
