EDI Question

jberry123

Active Member
Has anyone used a table conversion to convert a EDI file. I am looking at
updating the 832/Pricing file through a table conversion. The format the I
recieve it in is as follows:

N1*BY**91*545045~LIN**VN*1134931*UI*30013111410*ND*00013111410~PID*X*RX***CYKLOKAPR
AMP 100MG/ML 10ML~PO4*1*10*PK~CTP**RES*279~CTP**INV*219.74

Which looks like this when wrapped.

N1*BY**91*545045
LIN**VN*1134931*UI*30013111410*ND*00013111410
PID*X*RX***CYKLOKAPR AMP 100MG/ML 10ML 10
PO4*1*10*PK
CTP**RES*279
CTP**INV*219.74

Is there a way you can do a table conversion over un-wrapped (Example 1) .
I know the '*' seperates the fields, but how do I show that the '~' is the
segment ending field?

If anyone has a better way of doing this I would like to hear. Our company
doesn't have the money at this time to purchase EDI software, so any
information would be great.

We are trying to automate this process as much as possible.

Thanks,
jb





_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.
 

Zoltan_Gyimesi

Legendary Poster
Jimmy,
What is your opinion about to replace tilde "~" caharacters with new-line character(s) before running Table Conversion?

New-line character(s) (LF, CR or CR+LF) and how to replace the easiest way depend on your platform (Operating system, Code Page, etc.)

To automate the replace and TC, you can craete a shell UBE, which calls first the replace function then the Table Conversion.

Could it work for you?
Zoltán
 

jberry123

Active Member
I know I am able to replace the "~" with a new line in Word, But can you
automate that process. I am running B7332 on a AS/400 Platform, service
pack 10_Cache.

Is this the process you are talking about?
1. Would you use a TC with input (MCK.TXT) being the original un-wrapped
and output using a second name MCK2.TXT). (Not sure exactly how to do)

2. Then write another table conversion to update MCK2.TXT to a work file on
the AS/400 (Table name (F55PF832).

3. Then have a UBE to update the F55PF832 to the Cost table.

This seems like alot of steps to take. Please help.

>From: Zoltan_Gyimesi <zoltan.gyimesi@synergon.hu>
>Reply-To: jdeowdev@jdelist.com
>To: jdeowdevml@jdelist.com
>Subject: Re: EDI Question ~~612:625
>Date: Tue, 7 Nov 2000 11:32:29 -0800 (PST)
>
>Jimmy,
>What is your opinion about to replace tilde "~" caharacters with new-line
>character(s) before running Table Conversion?
>
>New-line character(s) (LF, CR or CR+LF) and how to replace the easiest way
>depend on your platform (Operating system, Code Page, etc.)
>
>To automate the replace and TC, you can craete a shell UBE, which calls
>first the replace function then the Table Conversion.
>
>Could it work for you?
>Zoltán
>
>
>--------------------------
>Visit the forum to view this thread at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Number=625
>*************************************************************
>This is the JDEList One World / XE Developers Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.
 

amwalshjde

Well Known Member
jb-

I had to do something similar when dealing with some
lock box type info. What I did was to create a VB
(visual basic program could be RPG, VB, Perl, etc) to
parse the EDI out into a more manageable format. In
effect you need to create you own little translator.
To automate this you have use scheduler program to
call your custom program, then call your UBE. For
example if you are on NT, you can create a .CMD file
that runs the custom program and runs the runube
command.

Just one way of many.

AW


--- jberry123 <jberry123@hotmail.com> wrote:
> Has anyone used a table conversion to convert a EDI
> file. I am looking at
> updating the 832/Pricing file through a table
> conversion. The format the I
> recieve it in is as follows:
>
>
N1*BY**91*545045~LIN**VN*1134931*UI*30013111410*ND*00013111410~PID*X*RX***CYKLOKAPR
>
> AMP 100MG/ML
> 10ML~PO4*1*10*PK~CTP**RES*279~CTP**INV*219.74
>
> Which looks like this when wrapped.
>
> N1*BY**91*545045
> LIN**VN*1134931*UI*30013111410*ND*00013111410
> PID*X*RX***CYKLOKAPR AMP 100MG/ML 10ML 10
> PO4*1*10*PK
> CTP**RES*279
> CTP**INV*219.74
>
> Is there a way you can do a table conversion over
> un-wrapped (Example 1) .
> I know the '*' seperates the fields, but how do I
> show that the '~' is the
> segment ending field?
>
> If anyone has a better way of doing this I would
> like to hear. Our company
> doesn't have the money at this time to purchase EDI
> software, so any
> information would be great.
>
> We are trying to automate this process as much as
> possible.
>
> Thanks,
> jb
>
>
>
>
>
>
_________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
>
> Share information about yourself, create your own
> public profile at
> http://profiles.msn.com.
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=612
>
>
*************************************************************
> This is the JDEList One World / XE Developers
> Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>


__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place.
http://shopping.yahoo.com/
 

Zoltan_Gyimesi

Legendary Poster
Jimmy,
I have thought to use Operating system tools/resources to replace characters which can be called from OneWorld (and from an UBE). It is much more native soulution than replacing in OneWorld.

I amn't experinced using OneWorld on AS400 at all.
I have worked on AS400 using RPG and CL for about 10 month long only many years ago, so unfortunately I have forgotten almost everything.
Further I amn't experienced in EDI processing till now.

Is your input file a real AS400 physical file or file member or is a Client Access file? Where does it reside?

I hope, somebody else can (and will) help you more how to replace character.

Finally here are some suggestion from me:

If your input file has a limited length which will be never exceeded (actual length could be variable but have to be limited) then:

1.) Create a TC1 with flat/text file input MCK.TXT.
2.) Define your input format as a single field enough long to hold your entire input file. Your input will contain one record.

2.) You can write your ER in TC1 breaking the file into separate segments using Length, Substring and Concat string functions and some work variables.

3.) You can issue a Write using User Insert Row system function for each segment in the ER of TC1.

4.) You can direct your output to a text file or to one or more custom OneWorld table in TC1 which will be used in TC2 as input (my suggestion is the custom OW table).

5.) You have the chance in TC1 to make some pre-pocessing on input data making easier the work of TC2 e.g.:
* putting format designator into a separate field
* applying segments with a seqence number to keep the original order
* breaking segments into fields
* etc.

6.) You can create TC2 with input which had been made by TC1.
You can populate any table in TC2 based on the pre-pocessed input.
(Here I amn't sure in EDI processing. Do you have to populate a Z1 file and run a standard OW UBE to upload EDI data or can directly update the target file?)

Suppose: you have TC1 and TC2 to process your input and Rxxxyyy OneWorld UBE to upload your input into OneWorld tables.

Create a control or shell UBE R55xxyyy with a primary section without any businessview, lets name it Control. You can write you ER in the Do Section event of your Control section to call your TC1, TC2 and Rxxxyyy in the appropriate order via Report Interconnections.
Further, you can produce a printed report output from your R55xxyyy shell UBE with a heading, date and time stamps and with more informations for documentation purpose.

You have to run only your shell UBE each time when you want to upload your EDI data because it will manage the others.

Please, let me know whether I could help.
Good luck,
Zoltán
 

got_to_love_jde

Reputable Poster
okay, my 2 cents........Have you looked at buying a translator package like Gentran ? This is all those people do and changes to standards come out on a regular basis so it would be hard for you personally to keep on top of it. i know. i have worked with EDI for about fifteen years and always depended upon Gentran or other translator packages.
dave


NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4
 
Top