I don't know if you've found an answer to this, but here is something that works for us.
If you use something like the "NT server way", your BP will have 2 consecutive Translation services. In the first one, at the N104 element in question, you would have an extended rule that looks something like this (keep in mind that you may have an index on the N104 element): if (#0067 = "NY") | (#0067 = "FL") then update PROCESSDATA set xpathresult="sMapName_FL-NY" where xpath="sMapName"; else update PROCESSDATA set xpathresult="sMapName_other" where xpath="sMapName"; This code puts the appropriate map name into the BP Process Data variable called sMapName. In the second Translation service, the map_name will now need to be set to that variable name. So the second translation's map_name parameter would be "string (/ProcessData/sMapName)". Remember to check the "Use XPath" box for the parameter. Also, the map_name parameter offers you a pick list, but if you click in the pick list text field, you can paste things in (or you can edit the BPML directly). Also, you would obviously need maps called sMapName_other or sMapName_FL-NY, or whatever you want to call them. --- In [email protected], "Vu, Lynn" <[EMAIL PROTECTED]> wrote: > > Thanks you all for your time and suggestion. I might need to go to GIS > support to get the solution from them. > > LV > > > _____ > > From: Leah Halpin [mailto:[EMAIL PROTECTED] > Sent: Friday, August 01, 2008 12:37 PM > To: Vu, Lynn; Allen Hoffman; Vu, Lynn; Brian Lehrhoff; Vu, Lynn; > [email protected] > Subject: Re: [EDI-L] How to translate 850 document into 2 difference file > format > > > Can't you have two different outputs from GIS? If you can, you don't need > multiple maps. Have you looked through your manuals or checked with GIS if > you've got a support contract? They should be able to answer at least the > two map vs two output question without charging you for development work. > > Good Luck, > Leah > > > ----- Original Message ---- > From: "Vu, Lynn" <[EMAIL PROTECTED]> > To: Allen Hoffman <[EMAIL PROTECTED]>; "Vu, Lynn" <[EMAIL PROTECTED]>; Brian > Lehrhoff <[EMAIL PROTECTED]>; "Vu, Lynn" <[EMAIL PROTECTED]>; > [email protected] > Sent: Friday, August 1, 2008 1:02:26 PM > Subject: RE: [EDI-L] How to translate 850 document into 2 difference file > format > > > > Allen, > > Customer send 850 in the same interchange. There is only one 850 X12 with > the same format. I would need to split it into 2 difference formats (2 > maps) depend on ship-to location. There is no option for me to ask them to > separate documents into different interchanges (customer is the boss :) > > Thanks and Regards, > Lynn Vu > EDI Programmer Analyst > Remy International, Inc > Office : (405) 475-9800 Ext. 303 > Mobile: (405) 471-2615 > Email: <mailto:[EMAIL PROTECTED] com <mailto:vu.lynn%40remyinc.com> > > [EMAIL PROTECTED] com <mailto:vu.lynn%40remyinc.com> > > _____ > > From: Allen Hoffman [mailto:[EMAIL PROTECTED] <mailto:ediguy% 40yahoo.com> com] > Sent: Friday, August 01, 2008 11:22 AM > To: Vu, Lynn; Brian Lehrhoff; Vu, Lynn; [EMAIL PROTECTED] > <mailto:EDI-L%40yahoogroups.com> com > Subject: Re: [EDI-L] How to translate 850 document into 2 difference file > format > > Use EXTOL it is the only translator I know of that will invoke different > maps based on the data. > > Before we get too far, are they sending both formats in the same > interchange? Can you ask the partner to separate them into different > interchanges by location and us a different GS01 for the 2 types of POs. > > Allen Hoffman > www.ediguyconsultin g.com <http://g.com> > > ----- Original Message ---- > From: "Vu, Lynn" <[EMAIL PROTECTED] <mailto:lvu%40upc.com> > > To: Brian Lehrhoff <[EMAIL PROTECTED] net <mailto:blehrhof% 40cybernex.net> > >; "Vu, Lynn" <[EMAIL PROTECTED] <mailto:LVu%40upc.com> >; > [EMAIL PROTECTED] com <mailto:EDI-L%40yahoogroups.com> > Sent: Friday, August 1, 2008 12:13:55 PM > Subject: RE: [EDI-L] How to translate 850 document into 2 difference file > format > > Brian, > > I'm looking into your #2 suggestion and trying to figure out how to make it > work? > > Thanks and Regards, > Lynn Vu > EDI Programmer Analyst > Remy International, Inc > Office : (405) 475-9800 Ext. 303 > Mobile: (405) 471-2615 > Email: <mailto:vu.lynn@ remyinc. com <mailto:vu.lynn% 40remyinc. com> > > [EMAIL PROTECTED] com <mailto:vu.lynn% 40remyinc. com> > > _____ > > From: Brian Lehrhoff [mailto:blehrhoff@ yahoo <http://www.yahoo.com/> . com > <mailto:blehrhoff% 40yahoo.com <http://40yahoo.com> > ] > Sent: Friday, August 01, 2008 10:35 AM > To: Vu, Lynn; Brian Lehrhoff; Vu, Lynn; [EMAIL PROTECTED] com > <mailto:EDI- L%40yahoogroups. com> > Subject: Re: [EDI-L] How to translate 850 document into 2 difference file > format > > Two suggestions: > > 1. Try "the Mercator way." Load everything into workspace, and have two > output cards (objects). > 2. Try "the NT server way." Use two maps, create the output from the first > map with the header to call the correct 2nd map. > > Brian Lehrhoff, EA ([EMAIL PROTECTED] <mailto:blehrhof% 40cybernex. net> > net) > Messaging Consultant 201-913-4506 > Upgrade your Quickbooks for 20% off at http://ea.brianlehr > <http://ea.brianlehr> hoff.com <http://hoff.com> > <http://ea.brianlehr hoff.com <http://ea.brianlehrhoff.com> > > Circular 230 Notice is located at http://ea.brianlehr <http://ea.brianlehr> > hoff.com/ <http://hoff.com/> 230notice. > html <http://ea.brianlehr hoff.com/ 230notice. html > <http://ea.brianlehrhoff.com/230notice.html> > > > ----- Original Message ---- > From: "Vu, Lynn" <[EMAIL PROTECTED] <mailto:lvu%40upc.com> <mailto:lvu% 40upc.com > <http://40upc.com> > > > To: Brian Lehrhoff <[EMAIL PROTECTED] net <mailto:blehrhof% 40cybernex. > net> > >; "Vu, Lynn" <[EMAIL PROTECTED] <mailto:LVu%40upc.com> <mailto:LVu% 40upc.com> > >; > [EMAIL PROTECTED] com <mailto:EDI- L%40yahoogroups. com> > Sent: Friday, August 1, 2008 9:21:05 AM > Subject: RE: [EDI-L] How to translate 850 document into 2 difference file > format > > Brian, > > I'm using GIS 4.0. Thx. > > _____ > > From: Brian Lehrhoff [mailto:blehrhoff@ yahoo. com > <mailto:blehrhoff% 40yahoo.com> > <mailto:blehrhoff@ yahoo. com <mailto:blehrhoff% 40yahoo.com> > ] > Sent: Friday, August 01, 2008 7:17 AM > To: lvu93; [EMAIL PROTECTED] com <mailto:EDI- L%40yahoogroups. com> > <mailto:EDI- [EMAIL PROTECTED] com <mailto:EDI- L%40yahoogroups. com> > > Subject: Re: [EDI-L] How to translate 850 document into 2 difference file > format > > in what translator? > > Brian Lehrhoff, EA ([EMAIL PROTECTED] net <mailto:blehrhof% 40cybernex. > net> > <mailto:blehrhof@ cybernex. net <mailto:blehrhof% 40cybernex. net> > ) > Messaging Consultant 201-913-4506 > Upgrade your Quickbooks for 20% off at http://ea.brianlehr > <http://ea.brianlehr> hoff.com > <http://ea.brianlehr hoff.com <http://ea.brianlehrhoff.com> > > <http://ea.brianlehr <http://ea.brianlehr> hoff.com <http://ea.brianlehr > hoff.com <http://ea.brianlehrhoff.com> > > > Circular 230 Notice is located at http://ea.brianlehr <http://ea.brianlehr> > hoff.com/ 230notice. > html <http://ea.brianlehr hoff.com/ 230notice. html > <http://ea.brianlehrhoff.com/230notice.html> > > <http://ea.brianlehr <http://ea.brianlehr> hoff.com/ 230notice. html > <http://ea.brianlehr hoff.com/ 230notice. html > <http://ea.brianlehrhoff.com/230notice.html> > > > > ----- Original Message ---- > From: lvu93 <[EMAIL PROTECTED] <mailto:lvu%40upc.com> <mailto:lvu% 40upc.com> > <mailto:[EMAIL PROTECTED] <mailto:lvu%40upc.com> > <mailto:lvu% 40upc.com> > > > To: [EMAIL PROTECTED] com <mailto:EDI- L%40yahoogroups. com> > <mailto:EDI- [EMAIL PROTECTED] com <mailto:EDI- L%40yahoogroups. com> > > Sent: Thursday, July 31, 2008 10:25:26 PM > Subject: [EDI-L] How to translate 850 document into 2 difference file format > > Hi all, > > Please help! I just got a new requirement from business. I receive > an 850 from the same TP ID. This TP ID have 10 difference ship to > addresses which identified in N1 04. The requirement is if the order > received from these two locations, say, FL and NY, I need to > translate this X12 file into A format and load the order to database. > For the rest of other locations, I need to translete order to B format > and send to end user via email. I don't have problem with translation > or send email. My question is how can I tell Business Process that If > state is NY or FL then Translate the document to format A, Else, > translate document to format B? > Any input is greatly appreciated > > TIA, > LV > > ------------ --------- --------- ------ > > ... > 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 > > (Yahoo <http://www.yahoo. <http://www.yahoo.com/> com/> <http://www.yahoo. > <http://www.yahoo.> <http://www.yahoo. com/ <http://www.yahoo.com/> > > com/> <http://www.yahoo. <http://www.yahoo.> com/ <http://www.yahoo. > <http://www.yahoo.com/> com/> > <http://www.yahoo. <http://www.yahoo.> com/ <http://www.yahoo. com/ > <http://www.yahoo.com/> > > > ! ID required) > > mailto:EDI-L- fullfeatured@ <mailto:EDI- L-fullfeatured% 40yahoogroups. com> > yahoogroups. com > <mailto:EDI- L-fullfeatured@ <mailto:EDI- L-fullfeatured% 40yahoogroups. > com> > yahoogroups. com> > <mailto:EDI- L-fullfeatured@ <mailto:EDI- L-fullfeatured% 40yahoogroups. > com> > yahoogroups. com > <mailto:EDI- L-fullfeatured@ <mailto:EDI- L-fullfeatured% 40yahoogroups. > com> > yahoogroups. com> > > > [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 > > (Yahoo! ID required) > > mailto:EDI-L- fullfeatured@ <mailto:EDI- L-fullfeatured% 40yahoogroups. com> > yahoogroups. com > <mailto:EDI- L-fullfeatured@ <mailto:EDI- L-fullfeatured% 40yahoogroups. > com> > yahoogroups. com> > > [Non-text portions of this message have been removed] > > [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: mailto:[EMAIL PROTECTED] mailto:[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/
