Automate data transfer from Excel to PF

[Guest.Visitor]

I know you pros are tired of this one but here it goes again. We recieve a Lotus Notes file via email that we put into an Excel file (.csv) on our network. We then do a data transfer to a PF via CA. Then we run a RPG to process the PF. I would like to automate this by putting the Notes file into Excel like we do now, but then run a CLP or RPG to automaticaly tranfer the Excel to the PF and process. First, is this possible? If so, how? We do not have Domino on our AS/400. We are running V4R4 and Windows N/T. Any help would be extremly appreciated.

[Guest.Visitor]

save the .CSV in QDLS and take it from there.

[Guest.Visitor]

I forgot to mention we have a .fdf that we use that goes under the details tab of the data transfer. When I saved the .csv file in QDLS then did a CPYFRMPCD to the pf the data was garbled.

[Guest.Visitor]

If you are on or above V4R2, take a look at CPYFRMIMPF. You will find a great deal of info if you do a search in this forum on CPYFRMIMPF. Mark

[Guest.Visitor]

Thanks Bob and Mark for your responses. The CPYFRMIPF worked with an exception. There are one or two fields that are sometimes left blank, in this case the copy bombs. The ERRLVL parameter is set to *NOMAX. Any other ideas. Below is the command. CPYFRMIMPF FROMSTMF('QDLS/DOMRATE/DOM.CSV') + TOFILE(SAB/TCPIRATE) MBROPT(*REPLACE) + RCDDLM(*LF) ERRRCDOPT(*REPLACE)