Look into Stylus Studio Enterprise Not free but Cheap it comes with data
direct which will allow you to connect to the iseries
http://www.stylusstudio.com/
If you come up with a semi-automated solution that you like and you want
to fully automate you can package as Java and Install on the i-series
(an oversimplification but doable)
Mike
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
rpg400-l-request@xxxxxxxxxxxx
Sent: Monday, July 14, 2008 12:12 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RPG400-L Digest, Vol 7, Issue 631
Send RPG400-L mailing list submissions to
rpg400-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/rpg400-l
or, via email, send a message with subject or body 'help' to
rpg400-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
rpg400-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific than
"Re: Contents of RPG400-L digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. Help - EDI with small company (Eileen Keck)
2. RE: Help - EDI with small company (Phil Kestenbaum)
3. Re: Help - EDI with small company (William Hofmann)
4. Re: Help - EDI with small company (rob@xxxxxxxxx)
5. RE: Help - EDI with small company (Duane Kehoe)
6. Re: Help - EDI with small company (Aaron Bartell)
7. Re: Help - EDI with small company (David Gibbs)
8. Re: Help - EDI with small company (Bill Wragg)
9. Re: Help - EDI with small company (Eileen Keck)
10. RE: Help - EDI with small company (Eileen Keck)
----------------------------------------------------------------------
message: 1
date: Mon, 14 Jul 2008 11:26:43 -0400
from: "Eileen Keck" <eileenk@xxxxxxxxxxx>
subject: Help - EDI with small company
Hi
I am working with a small company that has to handle 850, 997 and 856
documents. We can retreive them in XML, CSV or EDI formats. I need to
find a very inexpensive(freeware) translator or be able to translate
from the XML or CSV to the i-series from a shared folder.
I can handle it once it is on the i-series or what ever you want to call
it these days:)
thanks,
Eileen Keck
BlueStar Systems
------------------------------
message: 2
date: Mon, 14 Jul 2008 11:34:23 -0400
from: "Phil Kestenbaum" <pkestenbaum@xxxxxxxxxxx>
subject: RE: Help - EDI with small company
Maybe you can use Scott Klement's HTTPAPI program that parse's the XML.
This might be all that you need.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Eileen Keck
Sent: Monday, July 14, 2008 11:27 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Help - EDI with small company
Hi
I am working with a small company that has to handle 850, 997 and 856
documents. We can retreive them in XML, CSV or EDI formats. I need to
find a very inexpensive(freeware) translator or be able to translate
from the XML or CSV to the i-series from a shared folder.
I can handle it once it is on the i-series or what ever you want to call
it these days:)
thanks,
Eileen Keck
BlueStar Systems
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
This message contains information proprietary to our company. It is
intended to be read only by the individual or entity named above or
their designee.
Any distribution of this message or the information contained herein
without written permission from our company is strictly prohibited. If
the reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is
strictly prohibited. If you have received this communication in error,
please notify us immediately by e-mail, and delete the original message.
------------------------------
message: 3
date: Mon, 14 Jul 2008 08:40:36 -0700 (PDT)
from: William Hofmann <hofhaus1@xxxxxxxxxxxxx>
subject: Re: Help - EDI with small company
One way is to FTP the file over. If the file sits in a specific folder
on the network then a CL program can go out and retirieve it and bring
it in to the iSeries using FTP.
Another way is to set up an ODBC connection, there are many tools that
can move data either way over ODBC such as SQL server or maybe even
Micrsoft Access. The ODBC drivers come free with client access then you
can use any ODBC compliant application.
I would recommend saving the file as tab delimited. Comma delimited
text files will get confused if any of the text values conatin commas.
Hope this helps
William Hofmann
Eileen Keck <eileenk@xxxxxxxxxxx> wrote:
Hi
I am working with a small company that has to handle 850, 997 and 856
documents. We can retreive them in XML, CSV or EDI formats. I need to
find a
very inexpensive(freeware) translator or be able to translate from the
XML
or CSV to the i-series from a shared folder.
I can handle it once it is on the i-series or what ever you want to call
it
these days:)
thanks,
Eileen Keck
BlueStar Systems
midrange.com
