EDI Flat Files

rgepes

Member
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07FDF.5ABF87B0
Content-Type: text/plain;
charset="iso-8859-1"


List,

We are using OW Xe and have a question. For example, we want to convert a
flat file into F47011 which has 103 fields and the flat file is delimited.
The question is, do you have to supply place holders for the fields that you
are not supplying data for since it is delimited? Does anybody have a
sample flat file that they could forward for us to use that is loaded into
Xe? Not a third party translator.

Thanks,
Rich

perotsystems/AdvanceWatch RichardW.Gepes
email:<mailto:[email protected]> Phone: 810.755.3000 ext. 206


------_=_NextPart_001_01C07FDF.5ABF87B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>EDI Flat Files</TITLE>
</HEAD>
<BODY>





<FONT SIZE=3D2 FACE=3D"Arial">List,</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">We are using OW Xe and have a =
question. For example, we want to convert a flat file into F47011 =
which has 103 fields and the flat file is delimited. The question =
is, do you have to supply place holders for the fields that you are not =
supplying data for since it is delimited? Does anybody have a =
sample flat file that they could forward for us to use that is loaded =
into Xe? Not a third party translator.</FONT></P>



<FONT SIZE=3D2 FACE=3D"Arial">Thanks,

Rich</FONT>
</P>



<FONT COLOR=3D"#800000" SIZE=3D2 FACE=3D"Arial =
Black">perot</FONT><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial =
Black">systems/</FONT><FONT COLOR=3D"#800000" SIZE=3D2 FACE=3D"Arial =
Black">Advance</FONT><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial =
Black">Watch =
</FONT> <FONT =
COLOR=3D"#800000" SIZE=3D2 FACE=3D"Arial Black">Richard</FONT><FONT =
COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial Black">W.Gepes</FONT>


<FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial =
Black">email:</FONT><U><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial =
Black"><<A =
HREF=3D"mailto:[email protected]">mailto:[email protected]</A>></FONT><=
/U> <FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial Black">Phone: =
810.755.3000 ext. 206</FONT> =

</P>

</BODY>
</HTML>
------_=_NextPart_001_01C07FDF.5ABF87B0--
 
Rich,
I do not know, what kind of way do you want to upload but consider the following:
If you plan to use Interoperabilty then it requires to use place holders.
Zoltán


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Yes, you must have place holders in the file, even though it is delimited. For inbound data you can define what character you want to use for the delimiter. This is specified in the processing options for program R47002C, separators tab. Here you define the field delimiter and the text qualifier. The data elements must be enclosed in the text qualifier. For example, we use the '~' for the field delimiter and the '^' for the text qualifier, so if we have an unused character field followed by an unused numeric field it would look like this in the flat file:
^ ^~^0^
You must also setup in the flat file cross reference (program P47002) the location of the flat file on your network. Then run program R47002C (run this locally) and in processing options, tell it the document type that you are going to process (I assume that you are processing 850's if you will be loading the F47011).

Hope this helps,
Mark

B733, Xe, HP9000, NT, Oracle, WTS
 
Back
Top