LeasePak Utilities

241 UCC Filing

Utility UCC Filing will extract all the new booked leases from leasepak for the given dates and portfolio by customizable stored procedures and then transforms the extracted booked leases into an XML file. This utility will run on the basis of customizable stored procedures and XSL files as per the user requirements. The stored procedures will accept the following input parameters:

• Booking Date Start: Lease booking start date must be equal or less than the lease's booking date.
• Booking Date End: Must be equal or greater than the lease's booking date.
• Portfolio: A portfolio number which indicates all portfolios.

Note: User must enter valid date range for booked leases prior to the day the utility is being run.

The extract will run only once a day at a time of bookings. For missed days, users can run the extracts any day in the past.

User will have to create a new XSL file or update the existing one as per the users requirements and place it in the $uprg directory. Moreover, to populate AccountID, UserID, email, name, and phone number the user must modify the newly created XSL file.

Users can write their own scripts to automate the processing of this utility. The scripts should be scheduled to run the utility every day.

Here is an example of a possible scheduled script to run the utility on daily basis:

		#!/bin/sh 
		ENVNAME=$1 
		PWD_USER=$2 
		if [ "$ENVNAME" = "" ]; then 
		echo "Error: $Usage $0 environment [user-passwd]" 
		exit 1 
		fi 
		if [ "$PWD_USER" = "" ]; then 
		printf "Password: " 
		read PWD_USER 
		fi 
		if [ "$PWD_USER" = "" ]; then 
		echo "Password required" 
		525220 UCC Filing Extract Page 9 of 21 525220_Spec_Rev_C.doc Confidential 
		exit 1 
		fi 
		if [ ! -d $top/env/$ENVNAME ]; then 
		echo "$ENVNAME environment does not exist" 
		exit 1 
		fi 
		. $top/env/$ENVNAME/etc/.lpprofile 
		$uexe/lpadriver.exe /util ### << EOF 
		Y 
		$PWD_USER 
		Y 
		Y 
		EOF 
		exit 0 

Users will run this utility from command line same as other Leasepak Utilities.

This utility option will process the customizable stored procedure, <insert stored procedure name here>, to extract data for all

leases booked into a given portfolio for a given date. 

Do you wish to continue (Y/N)? 

Enter 'Y' or 'y' to proceed. The program displays:

Client Password?

Enter correct LeasePak client string password to proceed. The program displays:

Do you wish to run for all portfolios (Y/N), <Return>, to exit?

Enter 'Y' or 'y' to proceed if information of booked leases of all portfolios is required. The program will skip the next step and will proceed with the other one. If the booked leases of a specific portfolio are required than enter 'N' or 'n' to proceed. The program displays:

Enter the portfolio, <Return>, to exit: 

Enter a valid portfolio number. The program displays:

Do you wish to run for booking dates equal to <yesterday>, (Y/N), <Return>, to exit?

Enter 'Y' or 'y' to proceed. The program displays:

Enter a start date (YYMMDD) prior to today's date for the booking date range or <Return>, to exit:

Enter lease start date in YYMMDD format. The program displays:

Enter an end date (YYMMDD) prior to today's date and on or after the start date for the booking date range or <Return>,to exit:

Enter lease end date in YYMMDD format. Date range should be within the lease start date and the lease end date prior to today's date.