241 UCC Filing Extract

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.

Back to Utilities Menu

LeasePak  Documentation Suite

©  by NetSol Technologies Inc. All rights reserved.

The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.

Your document is loading...

This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.

If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.

If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.

If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.