Re: This may not a related question to SQR

["PHUNG, BINH" <BPHUNG@FINEHOST.COM>]

can not merge into one file. Must be done individually.
what is the address for the PS Users listserv?
Thank You again
Binh


> -----Original Message-----
> From: Anne-Marie Matula [SMTP:amatula@OIT.UMASS.EDU]
> Sent: Friday, June 23, 2000 8:47 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: This may not a related question to SQR
>
> Sorry for the late delay.  I receive these in digest mode.
>
> Can you merge all you files into one file so you only need to run the main
> sqr (step 1) once?  You can call a batch file within your first sqr to do
> the merge or do it outside the sqr.
>
> Also I might suggest getting on the PS Users listserv - that is dedicated
> to
> PeopleSoft related technical questions.  You may get more ideas for
> resolving this.
>
> Hope that helps,
> Anne-Marie
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Anne-Marie Matula
> Student Information System Project
> Office of Information Technologies
> University of Massachusetts
> 161 Whitmore Administration Building
> Amherst Massachusetts, 01003-8165
> Phone: 413/577-0685
> Fax: 413/545-2150
>
> > Date:    Thu, 22 Jun 2000 09:30:44 -0400
> > From:    "PHUNG, BINH" <BPHUNG@FINEHOST.COM>
> > Subject: Re: This may not a related question to SQR
> >
> > The main.sqr will be repeating the process as many time as there are
> files
> > that it finds.
> > So won't  i just need to schedule the main.sqr in the Process
> > scheduler and
> > have it call the other sqr from it?
> >
> > > -----Original Message-----
> > > From: Anne-Marie Matula [SMTP:amatula@OIT.UMASS.EDU]
> > > Sent: Thursday, June 22, 2000 9:03 AM
> > > To:   SQR-USERS@list.iex.net
> > > Subject:      Re: This may not a related question to SQR
> > >
> > > More info on this:
> > >
> > > Go to the Process Scheduler in PS.  Add a Job Definition that runs the
> 3
> > > processes you mentioned in the correct order.
> > >
> > > Hope that helps... I suspect however things may be complicated than I
> > > infer
> > > from reading your post!  Good luck!
> > >
> > > Have a great day!
> > > Anne-Marie
> > >
> > > > Date:    Wed, 21 Jun 2000 11:38:01 -0700
> > > > From:    "Peter R. Lewandowski" <peter.lewandowski@CSUN.EDU>
> > > > Subject: Re: This may not a related question to SQR.
> > > >
> > > > Did you look into using Process Groups within PeopleSoft?  It
> > > > creates some dependency.
> > > >
> > > > Date sent:              Wed, 21 Jun 2000 14:11:32 -0400
> > > > Send reply to:          sqr-users@list.iex.net
> > > > From:                   "PHUNG, BINH" <BPHUNG@FINEHOST.COM>
> > > > Subject:                This may not a related question to SQR.
> > > > To:                     SQR-USERS@list.iex.net
> > > >
> > > > > I am using PeopleSoft7.52 on NT with SQL7.0.
> > > > > Currently we are using the EDI Manager to input vouchers into
> > > > PeopleSoft.
> > > > > There are three steps:  step1 is an sqr and it reads the Input
> file
> > > and
> > > > > writes it out to an Output file formated for Step 2. Step 2 is
> > > > also an sqr
> > > > > and was developed by PS. It reads the output file from step 1
> > > > and pushes it
> > > > > to the staging table. The third step is a PSJOB class which posts
> or
> > > > > something like that.
> > > > > My question is can i automate these steps to be kicked off from
> one
> > > sqr.
> > > > > Have the sqr find the files to be inputed and pass the file name
> to
> > > the
> > > > > steps. Or do i have to insert the filename into the fields of the
> > > steps?
> > > > > I plan to use the process scheduler to schedule the main sqr.
> > > > > Any hint and ideas would be great.
> > > > > TIA
> > > > > Binh