|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
RE: Cleo 3780 & Sterling
This is what happens when you use a LF for a segment terminator and
then send the file through some type of communications software or
operating system that adds LF's (Blocks the data). It is pretty much
useless. ( I have hand edited many a file this way)
Another place to look is in the cleo conversation tables (files) when
characters are converted from EBCDIC to ASCII. they sometimes get changed
to <CR><LF> which will cause this condition.
The file Ebcascii.ovr (see partial example below), contains the conversions
that are used when converting. Notice that some characters
are converted to 13,10 <CR><LF>
Also there is an ASCIIEBC.OVR file too. (UNIX and NT)
0x03 13,10
0x05 9
0x07 127
0x0b 11
0x0c 12
0x0d 13
0x0e 14
0x0f 15
0x10 16
0x11 17
0x12 18
0x13 19
0x15 13,10
0x16 8
0x18 24
0x19 25
0x1c 28
0x1d 29
0x1e 13,10
0x1f 13,10
0x25 10
0x26 13,10
0x27 27
0x2d 5
0x2e 6
Dave Foster
Trinary Systems Inc.
-----Original Message-----
From: Alex Short [mailto:
Sent: Tuesday, July 09, 2002 3:32 PM
To: Legge Rich-WLRL04
Cc:
Subject: RE: [EDI-L] Cleo 3780 & Sterling
Actually this is not the case. I wish it had ~'s in it and \n's as it
would be a simple task of s/~/\n :)
Here's what i downloaded as a test 850 from Sterling this morning,
removing my id and replacing with HI and MYID
:)
Hopefully this email won't entirely butcher where the line breaks are, but
there are no ~'s seperating the segments as there were when communicating
with WalMart, instead line breaks are used to end segments but also within
a segment. When viewing the raw file that was received there is a line
break after 104 (the time field of the ISA), another after the > ending
the ISA segment, one at the end of the GS segment, one after ST* (mid ST)
and again after the 850*0002. It becomes a supreme hassle to parse, as
s/\s//g would also not help us in breaking up the file to be parsed.
Alex
ISA*00* *00* *ZZ*LYOUNGTEST *HI*MYID *020709*104
8*U*00200*000000001*0*P*>
GS*PO*LYOUNGTEST*MYID*020709*1048*2*X*003020
ST*
850*0002
BEG*00*NE*101*1001*911221*0001*AC
> Alex,
>
> Once you have determined that the file has both "\n" and "~", yes we have
> this scenario, then you have to remove the "\n" before you run your
reports.
> Keep in mind that once you remove the "\n" some of your reporting tools
may
> not work if they are sensitive to the length of each record. Additionally
> you will not be able to use "vi" to view the "wrapped" file.
>
> We run a Unix script to remove the new line, then to replace the segment
> terminator with new lines. This gives us nice clean "unwrapped" data.
>
> Good luck,
> Rich
> 815-884-0789
>
>
> -----Original Message-----
> From: Alex Short [mailto:
> Sent: Tuesday, July 09, 2002 11:29 AM
> To:
> Subject: RE: [EDI-L] Cleo 3780 & Sterling
>
>
> Thanks for the help guys, i was able to connect and download a test 850
> from Sterling this morning using the Cleo 3780 software. Little secret i
> had to figure out was that BATCHID = 'Your password'.
>
> Now i got this godaweful 850 in 3020 format (i'm used to 4030 and 4010),
> however when connecting directly to Walmart, i receive the file and its
> all one long line, seperated by ~, ie. ISA*00* *00* *01*THEIRID
>
> *02*OURID *DATE*TIME*X*0000*00000001*0*P*>~GS*PO etc. When i connect to
> another partner, they use line breaks between each, so ISA->P*> is one one
> line, line break, then GS*PO etc.
>
> With their test file, it seems to end lines whenever it pleases, where ISA
> may have a line break that cuts it in two and everything after half of the
> time is after the line break. I do various reports on these raw files
> that requires at least some consistancy, be it a seperator such as ~, or a
> line break between ISA and GS header, but not lien break mid ISA header!
>
> Anyone run into this and how did you deal with it, is this perhaps
> something that will only occur on the test order?
>
> Advice would be appreciated.
>
> Alex
>
> >
> >
> > Carl,
> > Didn't Sterling rename Supertracs to Connect:Direct ?
> >
> > Regards,
> >
> > David Frenkel
> > Business Development
> > GEFEG USA
> > Global Leader in Ecommerce Tools
> > www.gefeg.com
> > 425-260-5030
> >
> > -----Original Message-----
> > From: Carl Galgano [mailto:
> > Sent: Friday, July 05, 2002 5:58 AM
> > To: 'Alex Short';
> > Subject: RE: [EDI-L] Cleo 3780 & Sterling
> >
> > Alex:
> > Sterling uses Supertracs on their side for communications. You
> > basically send a $$ADD card to send data or a $$REQ card to receive
> > data. You should be able to take any other retailers script that also
> > uses Supertrac and modify it, inserting the correct logon info. Off the
> > top of my head Walmart uses Supertracs.... Are you doing EDI with them?
> > cjg
> >
> > Carl J. Galgano
> > EDI Consulting Services, Inc.
> > 550 Kennesaw Avenue, Suite 800
> > Marietta, GA 30060
> > (770) 422-2995 - voice
> > (419) 730-8212 - fax
> > mailto:
> > http://www.ediconsulting.com
> > AS400 EDI, Networking, E-Commerce and Communications Consulting and
> > Implementation
> > http://www.icecreamovernight.com
> > Premium Ice Cream Brands shipped Overnight
> >
> > "You ain't gonna learn what you don't want to know" - rw
> >
> > -----Original Message-----
> > From: Alex Short [mailto:
> > Sent: Thursday, July 04, 2002 4:11 PM
> > To:
> > Subject: [EDI-L] Cleo 3780 & Sterling
> >
> >
> > Has anyone have much experience with using Cleo 3780 & Sterling? I'd
> > like
> > to connect to them using the program, and with some retailers, they have
> >
> > provided connection scripts for the various settings and login
> > procedures
> > and wonder if there was one floating around for Sterling's Network.
> >
> > Thanks
> >
> > Alex
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Message Identifiers: <SALES>, <JOBS>,
> > <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at:
> > http://groups.yahoo.com/group/EDI-L
> >
> >
> > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Message Identifiers: <SALES>, <JOBS>,
> > <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at:
> > http://groups.yahoo.com/group/EDI-L
> >
> >
> > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Message Identifiers: <SALES>, <JOBS>,
> > <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at:
> > http://groups.yahoo.com/group/EDI-L
> >
> >
> > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> >
> > Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
> <OFF-TOPIC>
> > Access the list online at: http://groups.yahoo.com/group/EDI-L
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
>
> Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
> <OFF-TOPIC>
> Access the list online at: http://groups.yahoo.com/group/EDI-L
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
To unsubscribe from this group, send an email to:
Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
<OFF-TOPIC>
Access the list online at: http://groups.yahoo.com/group/EDI-L
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
