Composite Routes

[Quinlan Shanley]

I am doing some consulting for a company. They are using a shipping software that will generate an EDI document (X12 standard) for me. This software will only write to one network folder location for all outgoing documents (all trading partners). All of the file name have similar file names that cannot be change in the software (a head ache). 

Here is an example of a couple days of communication for 210s: 

• Monday output files
• TP1
• 210.0008432.dat
• 210.0008433.dat
• TP2
• 210.0008434.dat
• Tuesday output files
• TP1
• 210.0008436.dat
• TP2
• 210.0008435.dat

The only way to know what files go where is to crack open the file and look at the ISA/GS partner IDs. I've been looking at the documentation (composite routes) for answers on how to handle this. My understanding of composite routes tells me I could take multiple routes (pointing to different network folder) and send them to one Trading Partner. Can this also work the other way around? I can easily create a small python program to do this for me, but I'd much rather learn to use BOTS to accomplish this. It would help if someone could point me to the section of the documentation that denotes how to handle this. Thank you guys.

[henk-jan ebbers]

On 09/18/2012 02:25 PM, Quinlan Shanley wrote:
> I am doing some consulting for a company. They are using a shipping software that will generate an EDI document (X12 standard) for me. This software will only write to one network folder location
> for all outgoing documents (all trading partners). All of the file name have similar file names that cannot be change in the software (a head ache).
>
> Here is an example of a couple days of communication for 210s:
>

> * Monday output files
> o TP1
> + 210.0008432.dat
> + 210.0008433.dat
> o TP2
> + 210.0008434.dat
> * Tuesday output files
> o TP1
> + 210.0008436.dat
> o TP2
> + 210.0008435.dat

>
> The only way to know what files go where is to crack open the file and look at the ISA/GS partner IDs.

I guess that is not what you want?

> I've been looking at the documentation (composite routes) for answers on how to handle this. My understanding of composite routes tells me I could take multiple routes (pointing to different network
> folder) and send them to one Trading Partner. Can this also work the other way around? I can easily create a small python program to do this for me, but I'd much rather learn to use BOTS to
> accomplish this. It would help if someone could point me to the section of the documentation that denotes how to handle this. Thank you guys.

maybe this is what you are looking for:
http://code.google.com/p/bots/wiki/RoutesComposite
look to end of page.
composite route can have multiple out-channels. You could filter on to-partner


kind regards,
henk-jan

[Quinlan Shanley]

Yes, this is what I am looking for. I have the filter setup in the route. There is an In and Out channel for the route. The PartnerID matches the receiver ID in the EDI document. I have one file going through, but it gets stuck. It looks like it doesn't have a ToChannel when I put the filter on. The ToChannel is specified in the route.

If I have to break up the routes, how do I specify which routes the document will take?

I don't see a plugin for this. I'll create one after I get it working.

State	Re*	Route	Date/time	#in	InEditype	InMessagetype	FromChannel	FromPartner	ToChannel	ToPartner	OutEditype	OutMessagetype	InFile	OutFile	Error	MappingScript	FromMail	ToMail
	Stuck		zz_wurthadams_x12_210_004010_ae	2012-09-19 06:46:02	1	x12	210003050	zz_wurthadams_x12_210_003050_in	*		RLX0018	x12	210004010	\\hotline-fs4\c$\testediout\210.000021461.dat			210003050to210004010wurthadams

Date/time	2012-09-19 06:46:02
State	Done
Route	zz_wurthadams_x12_210_004010_ae

	Phase	State	Channel	Editype	Messagetype	FromPartner	ToPartner	Reference	Test	File	#mes	Date/time	Error	FromMail	ToMail	Charset	Contenttype	Alt	Mapping
in	FileReceive	Done	zz_wurthadams_x12_210_003050_in							\\hotline-fs4\c$\testediout\210.000021461.dat	1	2012-09-19 06:46:02				us-ascii	text/plain
	RawInfile	Done	zz_wurthadams_x12_210_003050_in							4295	1	2012-09-19 06:46:02				us-ascii	text/plain
	Infile	Done	zz_wurthadams_x12_210_003050_in	x12	x12					4295	1	2012-09-19 06:46:02				us-ascii	text/plain
	Translate	Done	zz_wurthadams_x12_210_003050_in	x12	x12					4295	1	2012-09-19 06:46:02				us-ascii	text/plain
	Parsed	Done	zz_wurthadams_x12_210_003050_in	x12	x12					4295	1	2012-09-19 06:46:02				us-ascii	text/plain
	Splitup	Done	zz_wurthadams_x12_210_003050_in	x12	210003050	HLNF	RLX0018	000000001	T	4295	1	2012-09-19 06:46:02				us-ascii	application/X12
	Translated	Done	zz_wurthadams_x12_210_003050_in	x12	210004010	HTXP	RLX0018	228	T	4302	1	2012-09-19 06:46:02				us-ascii	application/X12		210003050to210004010wurthadams
	Merged	Stuck		x12	210004010	HTXP	RLX0018	28	T	4304	1	2012-09-19 06:46:02				us-ascii	application/X12

[henk-jan ebbers]

hi Quinlan,

the file is stuck because it is notpicked up by an outchannel.
this is probably because the filter is not right.
what filter are you using in the route?


henk-jan

On 09/19/2012 02:17 PM, Quinlan Shanley wrote:
> Yes, this is what I am looking for. I have the filter setup in the route. There is an In and Out channel for the route. The PartnerID matches the receiver ID in the EDI document. I have one file
> going through, but it gets stuck. It looks like it doesn't have a ToChannel when I put the filter on. The ToChannel is specified in the route.
>
> If I have to break up the routes, how do I specify which routes the document will take?
>
> I don't see a plugin for this. I'll create one after I get it working.
>
>
> State Re* Route Date/time #in InEditype InMessagetype FromChannel FromPartner ToChannel ToPartner OutEditype OutMessagetype InFile OutFile Error MappingScript FromMail ToMail
>
> Stuck zz_wurthadams_x12_210_004010_ae 2012-09-19 06:46:02 1 x12 210003050 zz_wurthadams_x12_210_003050_in *

> RLX0018 x12 210004010 \\hotline-fs4\c$\testediout\210.000021461.dat <http://192.168.1.120:8080/filer/?action=this&idta=4294>

>
> 210003050to210004010wurthadams
>
>
>
>
> Date/time 2012-09-19 06:46:02
> State Done
> Route zz_wurthadams_x12_210_004010_ae
>
>
> Phase State Channel Editype Messagetype FromPartner ToPartner Reference Test File #mes Date/time Error FromMail ToMail Charset Contenttype Alt Mapping
> in FileReceive Done zz_wurthadams_x12_210_003050_in
>
>
>
>
>

> \\hotline-fs4\c$\testediout\210.000021461.dat <http://192.168.1.120:8080/filer/?action=this&idta=4294> 1 2012-09-19 06:46:02

>
>
> us-ascii text/plain
>
>
> RawInfile Done zz_wurthadams_x12_210_003050_in
>
>
>
>
>

> 4295 <http://192.168.1.120:8080/filer/?action=this&idta=4295> 1 2012-09-19 06:46:02

>
>
> us-ascii text/plain
>
>
> Infile Done zz_wurthadams_x12_210_003050_in x12 x12
>
>
>

> 4295 <http://192.168.1.120:8080/filer/?action=this&idta=4297> 1 2012-09-19 06:46:02

>
>
> us-ascii text/plain
>
>
> Translate Done zz_wurthadams_x12_210_003050_in x12 x12
>
>
>

> 4295 <http://192.168.1.120:8080/filer/?action=this&idta=4298> 1 2012-09-19 06:46:02

>
>
> us-ascii text/plain
>
>
> Parsed Done zz_wurthadams_x12_210_003050_in x12 x12
>
>
>

> 4295 <http://192.168.1.120:8080/filer/?action=this&idta=4300> 1 2012-09-19 06:46:02
>
>
> us-ascii text/plain
>
>
> Splitup Done zz_wurthadams_x12_210_003050_in x12 210003050 HLNF RLX0018 000000001 T 4295 <http://192.168.1.120:8080/filer/?action=this&idta=4301> 1 2012-09-19 06:46:02
>
>
> us-ascii application/X12
>
>
> Translated Done zz_wurthadams_x12_210_003050_in x12 210004010 HTXP RLX0018 228 T 4302 <http://192.168.1.120:8080/filer/?action=this&idta=4302> 1 2012-09-19 06:46:02

>
>
> us-ascii application/X12
> 210003050to210004010wurthadams
>
> Merged Stuck

> x12 210004010 HTXP RLX0018 28 T 4304 <http://192.168.1.120:8080/filer/?action=this&idta=4304> 1 2012-09-19 06:46:02

>
>
> us-ascii application/X12
>
>
>
>
>
> On Tuesday, September 18, 2012 7:53:19 AM UTC-5, eppye wrote:
>
>
> On 09/18/2012 02:25 PM, Quinlan Shanley wrote:
> > I am doing some consulting for a company. They are using a shipping software that will generate an EDI document (X12 standard) for me. This software will only write to one network folder location
> > for all outgoing documents (all trading partners). All of the file name have similar file names that cannot be change in the software (a head ache).
> >
> > Here is an example of a couple days of communication for 210s:
> >
> > * Monday output files
> > o TP1
> > + 210.0008432.dat
> > + 210.0008433.dat
> > o TP2
> > + 210.0008434.dat
> > * Tuesday output files
> > o TP1
> > + 210.0008436.dat
> > o TP2
> > + 210.0008435.dat
> >
> > The only way to know what files go where is to crack open the file and look at the ISA/GS partner IDs.
> I guess that is not what you want?
> > I've been looking at the documentation (composite routes) for answers on how to handle this. My understanding of composite routes tells me I could take multiple routes (pointing to different
> network
> > folder) and send them to one Trading Partner. Can this also work the other way around? I can easily create a small python program to do this for me, but I'd much rather learn to use BOTS to
> > accomplish this. It would help if someone could point me to the section of the documentation that denotes how to handle this. Thank you guys.
> maybe this is what you are looking for:

> http://code.google.com/p/bots/wiki/RoutesComposite <http://code.google.com/p/bots/wiki/RoutesComposite>

[Quinlan Shanley]

I've attached screenshots.

[Quinlan Shanley]

In the mapping script I change the from partner field. It changes from HLNF to HTXP. Not sure if this would be relevant though because the route does not filter the from partner.

[henk-jan ebbers]

hi Quinlan,

strange, just tested this over here, and it does work (version 2.2.1, but think this has not changed for some while)

henk-jan

On 09/19/2012 03:15 PM, Quinlan Shanley wrote:
> I've attached screenshots.

[Quinlan Shanley]

My BOTS version says 2.2.0. I didn't realize there was an update. I'll install 2.2.1 and see if this fixes the issue.

[Quinlan Shanley]

I do not see a plugin for upgrading to 2.2.1. Will I need to completely uninstall to do this?

[henk-jan ebbers]

there is: http://sourceforge.net/projects/bots/files/bots%20open%20source%20edi%20software/2.2.1/

btw, think this will solve your problem indeed.

kind regards,
henk-jan

[Quinlan Shanley]

Excellent, thanks for the help. I'll let you know what happens with it.

[Quinlan Shanley]

Upgrading did resolve the issue. Thank you again for your help.

On Wednesday, September 19, 2012 10:04:25 AM UTC-5, eppye wrote: