Jump to content


- - - - -

Execute a proiv function as cron


19 replies to this topic

#1 Guest_David Taugher_*

Guest_David Taugher_*
  • Guests

Posted 16 May 2002 - 04:50 PM

Hi All,

Is it possible to execute proiv via unix on a schedule? Although on the top of my head this is not possible, but who knows? Because we have a proiv report that we want to run on a daily basis by itself. And we are hoping that writing a sql script version isn't the only option.

Thanks in advance!

Dave

#2 Rick San Soucie

Rick San Soucie

    Member

  • Members
  • PipPip
  • 36 posts
  • Gender:Male
  • Location:Dallas, United States

Posted 16 May 2002 - 05:05 PM

There are several ways to do this. How you do it depends on the data that needs to be passed into the report function: if static, it is quite easy. If it needs to change, i.e., date ranges, it gets more complicated, but is certainly doable.

Describe the type of report and parameters needed to run it.

#3 Guest_David Taugher_*

Guest_David Taugher_*
  • Guests

Posted 16 May 2002 - 05:30 PM

Hi Rick,

The parameters being passed are:
CCN = '1' (STATIC)
SALES_CCN = '1'(STATIC)
FROM_GROUP = ''(BLANK AS DEFAULT - CAN BE STATIC)
TO_GROUP = ''(BLANK AS DEFAULT - CAN BE STATIC)
FROM_DATE = ALWAYS THE FIRST DAY OF THE CURRENT MONTH
TO_DATE = CURRENT DATE
OK CONFIRMATION

Thanks for the quick response! I appreciate it.

Dave

#4 Guest_Joseph V.G. Orendain_*

Guest_Joseph V.G. Orendain_*
  • Guests

Posted 16 May 2002 - 08:13 PM

what you can do is use the XFER command to transfer these parameters to your report. First of, you need to create an operator that allows transparent login and then attach your function in the logon link of the operator. Make sure to set the @LFUNCT of the last function to be executed to 'OFF' so it exits normally. Other option is, you can use an existing operator ID that has accessed to the report and then feed in the keystrokes that you will do just like doing it online....


sample script for the second type will be :


PRO SYS MDC > logfile <<- !

...specify here the steps you're gonna do...eg. set printer, call report function and then enter data,etc

!

exit


Hope this helps.

Joseph

#5 Guest_David Taugher_*

Guest_David Taugher_*
  • Guests

Posted 17 May 2002 - 03:13 PM

Hi Joseph,

Thanks for your response. I found your suggestion simpler and I think it's what I really want to know.


Cheers!

#6 Guest_Joseph V.G. Orendain_*

Guest_Joseph V.G. Orendain_*
  • Guests

Posted 17 May 2002 - 06:20 PM

No problemo!

Glad I could help!

#7 Guest_David Taugher_*

Guest_David Taugher_*
  • Guests

Posted 29 May 2002 - 06:31 PM

Joseph,

How can you bypass the proiv gui?

Thanks!

Dave

#8 Guest_Joseph V.G. Orendain_*

Guest_Joseph V.G. Orendain_*
  • Guests

Posted 29 May 2002 - 06:38 PM

we either set the PROTERM variable to DECVT100 or blank. that is the only setting I see different from our online script.

Joseph

#9 Guest_David Taugher_*

Guest_David Taugher_*
  • Guests

Posted 29 May 2002 - 07:43 PM

Joseph,

Is there a need for the operator to have a unix id? Would you mind sending me a sample script that you use? That is if you don't mind.

Thanks!

Dave

#10 Guest_Joseph V.G. Orendain_*

Guest_Joseph V.G. Orendain_*
  • Guests

Posted 29 May 2002 - 08:04 PM

Since you will be running it using cron, the unix id will be root. let me check some script and I will send it to you...what is your email address?

Joseph

#11 Guest_David Taugher_*

Guest_David Taugher_*
  • Guests

Posted 29 May 2002 - 08:31 PM

Thanks Joseph, my e-mail add is dtaugher@labelad.com

#12 Guest_David Taugher_*

Guest_David Taugher_*
  • Guests

Posted 31 May 2002 - 12:35 PM

Is there anyway I can bypass this message:

GUI START
! P

This problem only happen if your path for PRODATA and PROPATH is the production.

Thanks!

#13 Bryan Thompson

Bryan Thompson

    Member

  • Members
  • PipPip
  • 20 posts
  • Gender:Male
  • Location:Harrisburg, Pennsylvania

Posted 03 June 2002 - 12:58 PM

Thats probably happening because your PROTERM variable is set to GUICLR.. set it to either blank or DECVT100 and that should solve the problem

Bryan

#14 Guest_David Taugher_*

Guest_David Taugher_*
  • Guests

Posted 03 June 2002 - 02:37 PM

Thanks Bryan! I didn't want to set my PROTERM to anything before because it might have effect globally to all users. But now I tried it and it did work with DECVT100.
There is another problem though in setting the font when I use the 'mailx -s' in unix. Is there a way I can set the font to say 'courier new' before mailing?

Dave

#15 Bryan Thompson

Bryan Thompson

    Member

  • Members
  • PipPip
  • 20 posts
  • Gender:Male
  • Location:Harrisburg, Pennsylvania

Posted 03 June 2002 - 03:42 PM

I don't know of any way to do that in mailx.. If its important than I would probably create the mail as an html page and change the fonts in there. Its probably the long way around, I would imagine that there is a way to change the fonts for mailx but I couldn't tell you what that is off the top of my head...


Bryan



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users