Bryan Burns wrote on 27/06/2007 09:31:11:
I've been asked to automate the manual process of uploading a file
and I'd like some suggestions.
The current process is to
1. open a Microsoft Outlook email
2. open the Excel CSV spreadsheet attachment that's part of the email
3. alter the spreadsheet by adding a column and filling the column
with a distributor ID
4. upload the CSV file data to the iSeries using a saved Client
Access Transfer function
Is there a third party application that can perform 1, 2 and 3? Can
item 4 be performed with a CLP?
I'm not sure about how to address 1, but if you can find a way to get the
CSV file on to the IFS, then you could address 2-4 fairly easily.
1. Open the CSV file in an RPG program.
2. Read the first line variable.
3. Extract each field by reading character by character until you find a
comma.
4. Assign the extracted info to the appropriate database field.
5. Assign the distributor ID based on your rules used in your step 3
6. Repeat 3-5 for each line in the CSV.
If you need more information on accessing stream files from RPG, there has
been much discussion of this in the archives for the RPG list. The
archive server is down today so if it is time sensitive, you could repost
and we can give you some links.
HTH,
Adam
Attention:
The information contained in this message and or attachments is
intended only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient is
prohibited. If you received this message in error, please contact the sender
and
delete the material from any system and destroy any copies. Thank you for your
time and consideration.
Attention:
Le contenu de ce message et(ou) les fichiers ci-joints s?adressent
exclusivement à la personne ou -entité à laquelle ils sont destinés. Ils
peuvent
contenir de l?information confidentielle, protégée et(ou) classifiée. Il est
strictement interdit à toute personne ou entité autre que le(la) destinataire
prévu(e) de ce message d?examiner, de réviser, de retransmettre ou de diffuser
cette information, de prendre une quelconque action en fonction ou sur la base
de celle-ci, ou d?en faire tout autre usage. Si vous avez reçu ce message par
erreur, veuillez communiquer avec l?expéditeur(trice), supprimer ce message et
les fichiers ci-inclus de tout système, et en détruire toutes copies, qu?elles
soient électroniques ou imprimées. Nous vous remercions de votre entière
collaboration.
midrange.com
